Output To Excel

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

 

[NetworkTrade]

if you set up that path using the browse experience starting at the highest
level, network neighborhood, and then drilling down level by level - it will
be accurate for all....

 

[Pookey]

I was hoping to avoid doing that. I really wanted the output to take place
"behind the scenes" without having to open up the browse. If having to open
this up is the only way, let me know. Thanks.

 

[NetworkTrade]

I don't understand or maybe you didn't understand me.... the path in the
macro is set - there is no dynamic browsing experience for the user. I
thought you asked about how to have a path there that will work for all. My
advice is that you, the developer, be sure to put in the path starting at the
highest level - and that path should work for all users.

 

[Pookey]

I'm not exactly sure what you're talking about. Please explain.....