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
Printable View
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
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 !