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?

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.

-----Original Message-----
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?
.

Thanks!

" wrote:

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.

-----Original Message-----
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?
.

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

On Tue, 8 Feb 2005 12:53:01 -0800,
wrote:

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.

-----Original Message-----
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?
.