Transferspreadsheet import conflict

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
 
J

John W. Vinson

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.
 
G

Gary

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
 
Top