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!

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

Export the data to a specific sheet in Excel

Status
Not open for further replies.

Devaki

Programmer
May 23, 2001
58
US
Hi,
How do i export the data to a specific sheet in Excel from VB.I can export it to an excel .
How do i take it to a specific Sheet in the excel
Thanks
Devaki
 
I think what you mean is this...

[WorkBook1].[Sheet2].[B3]

That will send data to cell B3 of Sheet2 Craig, mailto:sander@cogeco.ca
"Procrastination is the art of keeping up with yesterday."
I hope my post was helpful!!!
 
Hi,
I am using a simple code as below
Open "c:\Epi.Xls" For Output As #1
Then everytime i use a print #1 and get the data to the excel from my grid that has the value.
Now i think i need to use it as an excel object. Could you please provide me a sample code to do this.

Thanks for the help
Devaki
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top