Run macro in new workbook

B

BobP

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?
 
G

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.
 
B

BobP

Thanks!

[email protected] said:
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.
Click to expand...
 
G

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
 
Top