Refresh Excel through Access Macro (1 Viewer)

[QueryStumped]

Love this website full of great information... I am trying to update an Excel spreadsheet through an Access Macro that is saved on a Shared Drive. As of now in the macro I have ImportExportSpresdsheet, but it doesn’t override the last spreadsheet. It’s creating a new tab on the spreadsheet, and it’s showing not formatted. What am I doing wrong?

 

[isladogs]

You can't directly update a linked spreadsheet from Access though there are ways around that restriction.
However as I don't use macros, I can't tell you whether macros can be used for that purpose.
Suggest using VBA code

 

[QueryStumped]

You can't directly update a linked spreadsheet from Access though there are ways around that restriction

It’s not linked. It’s just sitting out on the shared drive I have the command ImportExportSpreadsheet to Export information to the named Excel file. Just need it to refresh the information when needed via macro in access

 

[isladogs]

I added to my last post before you replied

 

[QueryStumped]

Sorry... I can read code, but don’t know how to write it or where to put it for it to work :{