Recent content by ActualHealth

I'm able to make it work with the code from you and Ken's examples. I noticed that the cell I want to get value from actually locates in the same range for all the Excel workbook right now, so I was able to simplyfly the code a little bit which probably also made it easier for me. I'll still...

This is great. I'll try to get the code which works in Excel first, and ask for help here. Thanks so much!

Thanks for the reply. There are actually about 40 Excel workbooks which I need to read the value from, and each workbook has different owner. So it's probably not possible to make any change to the Excel workbooks for this purpose. However, the cell I need to read the value from is always in...

One other question, if the range for the data varies between different workbook and I need to search for the string data field which should always be right next to the data field I need to get with certain keyword, and then I'll be able to locate the cell reference. Is there anyway to do it with...

Thanks for confirming it. It looks like that Ken's example could be a good solution for this case then.

haha, thanks! I'm happy that I had the keyword in my id, and so am able to get reply this soon. I was looking at the 'DoCmd.TransferSpreadsheet acImport' method, and it seems that this one does not require opening the workbook prior to get data from it. Is it true?

My original post actually has the links to both the other thread in this forum with similar question and also to the website which has the article on Excel importing topic. However, I was told that I can not post any link here yet. Sorry about any inconvenience.

I need to read one cell data on one specific worksheet from each of all the Excel workbooks saved in one same folder, and write the data into a table in the Access file. The Access file table has only two columns: the first column has the string to use as indicator on which workbook to read the...