Macro - Output To

[Pookey]

I created a macro to "Output To" an excel spreadsheet which works. My
question is, since the database is on our company server and other people
will probably use this macro, how do I create a path where the newly created
Excel spreadsheet will copy to that particular person's computer or copy to a
folder on the server where the database is?

 

[Qian Han]

Dear all,

Just wondering if anybody here knows about "VBA converter pack"? My Excel
kept asking for a vba converter when I am trying to open an old excel file
with macro in it. Excel 2003 doesn't have such a problem. I searched many
forums but seems nobody has a clue. I hope somebody here can help me out.

Thanks!