Transferspreadsheet import conflict

[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

 

[John W. Vinson]

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

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.

 

[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

 

[John W. Vinson]

Not even as a snap shot with Read-Only ???

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

I'm not sure. I'd suggest asking in an Excel forum.