dougvcd

i have written a small prog that works ok in excelvb
can it be converted to run from standalone vb
i presume it would run better i dont know i am newbie
but what the prog does
lets you select data from sheet 1 and puts it in sheet 2
but to achive this you
have to open excel put on sheet 1
then open the vbeditor and run
then close editor
and then ope sheet 2
to see results
like i say works
but is there a better way

i will atach prog if anyone wants to look and see
cheers

mark007

It won't really run better in VB as a separate Vb app would have to automate Excel from a different process which would be slower.

However you could compile to COM in VB. This would be marginally quicker. For what you are doing there is no need for this though. the main issue appears to be having to go to the VBE. This is not necessary. Instaed go to tools/macro/macros.. it will have a little triangle play symbol next to it. Select the macro from the list and click play.

To improve this further goto:

customise/toolbars

add a macro button to one of your toolbars (or create a new one altogether if you want!). Then right click on it and select 'assign macro'. Select your macro and close the customise window.

The macro will then run on clicking this button.

italkid

Or put a command button on the sheet...

dougvcd

at the moment when the prog starts it reads data from excel sheet1
would it be poss to have an input box which then puts the data into list box and the copies to sheet2
just thought it might be easier for my son to use if instead of looking for 1 number in the list if he put the number in then excel finds it
many thanks
ps
thanks for all the help so far from you all
Doug uk

italkid

As Mark007 mentioned there is really no need to make it that complicated
for what you want to do.
Why this longwinded workeround ?
Use the listbox as it is now or you could insert an extra column in sheet1
in which you could enter for instance an "x" to select DaBird,and when
you have selected all the birds you want push a button to copy the
data of the selected birds...