From Access Export Excel to Desktop

[AirDavidADP]

I have a database that has been split. The tables are in a network shared folder and the front end forms & queries are in a file saved in a SharePoint Folder. Everyone is able to save and update the data in the db but I am not able to get any of the excel files to save to each person desktop. Was using a button that ran a macro using the "RunSaveImportExport" command (C:\Users\environ("username")\Desktop\Proj_in_Red_ Export.xlsx"). Thank for all for your help. David

[twinnyfo]

AirDavidADP,

First, I would recommend doing what you are doing in VBA, as it will allow you to use variables more easily.

What you are looking for is to set up a variable in VBA to store the Username:

strUserName = Environ("username")

Then the Export string becomes:

strExport = "C:\Users\" & strUserName & "\Desktop\Proj_in_Red_ Export.xlsx"

This is a basic outline and not the complete code, but htis should point you in the right direction.

Please let us know if you have any additional questions we can work through with this.