Run macro in new workbook

[Guest]

I have a programe that exports a csv file and names it dumporders.csv. I
would like to be able to run a macro to format this data. How can I import a
macro into this file without having to recreate it every time?

 

[Guest]

hi,
open the vb editor(alt+F11)
on the left right click the module you want to export then
click export. a save dailog box will apear. give it a name.
it will export as a .bas file extention. remember where
you put it.
open the other file. open the vb editor. on the left right
click the project name. click import. a dialog box will
come up. select the macro you just downloaded. click
import.

 

[Guest]

Thanks!

hi,
open the vb editor(alt+F11)
on the left right click the module you want to export then
click export. a save dailog box will apear. give it a name.
it will export as a .bas file extention. remember where
you put it.
open the other file. open the vb editor. on the left right
click the project name. click import. a dialog box will
come up. select the macro you just downloaded. click
import.

 

[Gord Dibben]

Why not have the macro in your Personal.xls and run it from there on the
active file?

No need to have it in each workbook AFAICS.


Gord Dibben Excel MVP