YogiBear79
Technical User
I'm using the "Get External Data" Feature of Excel 2000 to import a table from the web. I store the table in an Excel spreadsheet, copy & modify it's contents in another then import the results into an Access Database. My question is this:
I want to use the "Refresh Data" feature to import from the web any updates to the table. How can I copy ONLY these cells into another spreadsheet for formatting? Keep in mind I do all of this from Access, I call Excel and run it in the background unseen by the user.
What I'm looking for is some Excel VBA code that will only grab the new data for me.
TIA
I want to use the "Refresh Data" feature to import from the web any updates to the table. How can I copy ONLY these cells into another spreadsheet for formatting? Keep in mind I do all of this from Access, I call Excel and run it in the background unseen by the user.
What I'm looking for is some Excel VBA code that will only grab the new data for me.
TIA