Pulling Excel Cell Information via Dynamic URL

[brenthardy]

Good day!

I have an Access database (CCR.mdb) in which one of the columns ([URL]) is a hyperlink to an Excel form specific to that record. I am wanting to write code that will access the hyperlinked .xsl file and pull the value of cell B24 into the database. I then want to append this value to [Copy of Master Table].

This will need to be done on a large number of files (3000+) and continue to pull and update the values on new records going forward, so importing each excel file as a table really isn't an option.

I would like to do this without opening the actual Excel file if possible.




So far I have identified the following elements that the code will need to accomplish, but I have no idea how to implement them:

• Recognize [Copy of Master Table]![URL] as the dynamic file location
  tbl(Copy of Master Table)!URL
• Look up the value of (Change Information)!B24 at the dynamic file location
• Append the value to [Copy of Master Table]![Implementation Date]

Can anybody provide assistance? My knowledge of VBA is very limited.

[June7]

Here is a thread the discusses transferring data between Access and Excel http://forums.aspfree.com/microsoft-...el-414974.html