inserting data into an excel sheet which is open
I have an application in that the forms are excel sheets with some menu bar.
I want to insert data into that excel sheet.
when ever we select some option in the application then excel sheet will open.
i need to insert data into that excel sheet while running the scrip.
can any body please help in this issue.
excel is already in open condition. no need to create or open excel.
Re: inserting data into an excel sheet which is op
You can try using Excel automation
get an excel object using something like this
Set MyXL = GetObject(, "Excel.Application")
Re: inserting data into an excel sheet which is open
There is a topic called "QTP Keyword driven Frame work excel formula" and in that thread look at post #367456. There is an attachment there that I uploaded which has a few vbs functions for reading and writing to excel spread sheets.
I am still just learning this stuff so it may not be the best methods but they seem to work well for me.
hope this helps