How to export records to excel?

[hannlapp]

Hi.

I have a macro which exports my records to excel and to My documents.

But I would like to put the excel file allways in different places, depending on the user account.

How can I tell to macro that I want my records for instance to "MyServer\SharedFolder\%username%"


Hanski

 

[CBrighton]

OutputTo is the command used in a macro or VBA to save the objects as files (reports to rtf / pdf, queries to xls / csv, etc). The 4th variable is used to define the folder & file name.

http://msdn.microsoft.com/en-us/library/aa220433(v=office.11).aspx

 

[hannlapp]

Thanks a lot! It works fine!


Hanski