VBA & BCA - where the files are stored

[Guest_imported]

we create CSV files using VBA macros in the report. the files are generated in the local folders on the desktop. what happens when this report is refreshed and the macro is run using BCA? where would be the file generated? is there any way we can direct this file to some other file server?

thanks,
lekha.

 

[promero]

If the BCA server has the proper privileges (consult Administrators), you can save the file to any local or remote folder. Simply specify the full path when tou create the file.