Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: chip70 garza
  Where is chip70 garza?
 Laredo
 Texas - United States
 chip70 garza
 To: Yash KOthari
  Where is Yash KOthari?
 Naperville
 Illinois - United States
 Yash KOthari
 Tags
Subject: RE: Insert new row on refresh in Excel
Thread ID: 29241 Message ID: 56752 # Views: 1 # Ratings: 0
Version: Not Applicable Category: Microsoft Office Automation
Date: Tuesday, November 30, 2004 2:17:50 AM         
   


> I am importing single record data into excel from a web query. It automatically refreshes every 5 mins as required.
>
> I would like to retain the old data and insert new record for every refresh...
>
> What is best way to achieve this...( nor do I know the worst way....)..
>
> Please suggest and thanks in advance..
>
> YK
>
>
>
>
> 21th century educated is one who can learn, unlearn and relearn.


Chip70,
oExcelObject = CREATEOBJECT('Excel.Application')
oExcelObject.Rows("1:1").Select
oExcelObject.Rows("1:1").Insert


ENTIRE THREAD

Insert new row on refresh in Excel Posted by Yash KOthari @ 9/12/2003 10:31:06 PM
RE: Insert new row on refresh in Excel Posted by chip70 garza @ 11/30/2004 2:17:50 AM