Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help export "NEW" data from a Refresh WEB data Call

Status
Not open for further replies.
YogiBear79

YogiBear79

Technical User
Sep 20, 2001
2
0
0
US
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
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
284
strongm
strongm
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
195
linuxguyEastCoast
linuxguyEastCoast
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
159
Andrzejek
Andrzejek
monyi
  • Locked
  • Question
Extracting Data from XML Node
Replies
0
Views
92
monyi
monyi
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
218
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top