troubleshooting Question

MSAccess - accessing XLS cells remotely?

Avatar of markp99
markp99 asked on
Microsoft AccessVisual Basic ClassicMicrosoft Excel
2 Comments1 Solution302 ViewsLast Modified:
I have an app that uses a TransferSpreadsheet routine to import an XLS sheet into a table.

I'd like to be able to INSPECT the file before the import action commences to be sure I have the correct file and correct data within the file.

I can do this reliably by inspecting 2 cells  A1 and A3 (XLS report header information, from a 3rd party app).  

Note:  I ignore the report header lines as follows, capturing just he column headers & data.

DoCmd.TransferSpreadsheet , , "Purchase Orders", strInputFileName, True, "a5:Az65500"


Is it possible to INSPECT the XLS file remotely to check the value of those two cells??

Example:  If <filename>:cell (A3) = "06YEX" then do stuff...else err msg....


Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros