Share Violation when Importing from Excel

[jmueller]

Can anyone tell me how I can import data from an excel file that is currently open?

 

[Mike Lewis]

jmueller,

Try enabling Workbook Sharing (from the Tools menu in Excel).

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[jmueller]

Thanks Mike. Sharing the workbook works but unfortunately, I can't share the workbook because doing so causes a bunch of macros to error out because certain features aren't available in a shared workbook.

Any other ideas? Anybody?

 

[DSummZZZ]

How about if you were to either save or export it to another file, then do your import?



-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[jmueller]

Can I perform a SAVE AS from foxpro?

 

[wgcs]

Why does the Excel spreadsheet have to be open at the same time as you are importing into VFP?

 

[jmueller]

Slight misunderstanding there... the spreadsheet doesn't have to be open, it just always is and i'm simply trying to Import or Append From this spreadsheet but can't because I get a sharing violation. Can ya help me???

 

[banswara]

Try oWorkBook.SaveAs()?