Refresh Excel through Access Macro (1 Viewer)

QueryStumped

Registered User.
Local time
Yesterday, 22:32
Joined
Mar 22, 2017
Messages
48
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

CID Moderator
Staff member
Local time
Today, 03:32
Joined
Jan 14, 2017
Messages
13,215
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

Registered User.
Local time
Yesterday, 22:32
Joined
Mar 22, 2017
Messages
48
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

CID Moderator
Staff member
Local time
Today, 03:32
Joined
Jan 14, 2017
Messages
13,215
I added to my last post before you replied
 

QueryStumped

Registered User.
Local time
Yesterday, 22:32
Joined
Mar 22, 2017
Messages
48
Sorry... I can read code, but don’t know how to write it or where to put it for it to work :{
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom