Transferspreadsheet import conflict

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I am using a DoCmd.Transferspreadsheet to import from an open excel
spreadsheet. I am encountering a conflict when its open by a different user.

If its the same user, I am able to import the excel spreadsheet into a table.

Can someone help me to Transferspreadsheet from an open excel spreadsheet
(from a different user) ??? Access 2000-2003, XP Pro OS.

Thank You,

G
 
Can someone help me to Transferspreadsheet from an open excel spreadsheet
(from a different user) ???
Click to expand...

No, because the spreadsheet is (of necessity!) locked by the other user.
Access would have no way to detect if the other user were in the process of
actively changing its contents.
 
Not even as a snap shot with Read-Only ???

If I was to use excel command directly, do you think that should work???

Thank You,


G
 
Back
Top