Click to See Complete Forum and Search --> : opening .XLS file in vb


August 20th, 1999, 03:00 AM
hi

i want to know that how can i open a spcified Excel file(.XLS) in VB application and also i should be able to edit .XLS sheet and print it and then back to VB application

thanks

KfR
August 20th, 1999, 04:27 AM
Hello !

In your project, you can reference :
Microsoft Excel x.0 Object Library
So when you'll Dim a New variable, there'll be new choices :
Excel.Application, Excel.WorkSheet, ...
And i saw that the Excel.WorkSheet object as a PrintOut method !!

I hope it will help you !
For more help, see the VBAXLx.HLP in your Office directory (where x is the version number of Excel).
If not installed, you can find it on the Office CD !