opening a file With Excel libraries

[JoeSmoe55]

Hello,

I am sorry to ask this with out looking further. I am trying to do this quick so I would really appreciate your help. I am needing to open a file ( given a filename) in excel through the use of it's libraries. I can't see anything on Application that looks as simple as open file. I am using this facility from Access VBA if that changes anything. Also, Is it easy to access the data in each cell. At this time I only need to read the data not change it. Also, the basic need is to import the data, is there an easier way? Thanks for your help.

Joe

 

[PHV]

Have a look at the Open method of the Excel.Workbooks object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

OOps, hit submit too fast.
You may consider the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JoeSmoe55]

Thanks for the fast reply but I don't know how to retrieve the data I just opened up - I am looking but a little more help would be wonderfully. Thank you very very much. Sorry to be demanding - I do appreciate it.

Joe