oExcel.Workbooks("C:\report\res.xls").SaveAs("C:\Test1.xls")
oExcel.Workbooks(("C:\Test1.xls")).Save()
oExcel.Workbooks(("C:\Test1.xls")).Close()
or
oExcel.Workbooks(("C:\report\res.xls")).Close(SaveChanges:=True, "C:\Test1.xls")
i tired to use above 2 statements but unfortunately SaveAs...
The issues is
Common Language Runtime Debugging service is the error dialog name
Application has generated an exception that could not be handled -- is the message
can any one throw ight on this...
Can some one please point out me the exact function i can use to convert GMT time to LMT (Local Mean Time) in .NET in below list
I have less time, if some one points me ,it would be gr8
getTime Method | getTimezoneOffset Method | getUTCDate Method | getUTCDay Method | getUTCFullYear Method |...
Exception from HResult:0x800A03EC.
is getting thrown when ever i am trying to save excel using command
oSheet.SaveAs("C:\sss.xls",Excel.XlFileFormat.xlWorkbookNormal)
where i added "Microsoft Office 11.0 Object Library" and "Microsoft Office 10.0 object library"
i am using MS-office...
Can you please be more clear on this front.
I want to create 'n' sheets with in one workbook, depending upon bussiness logic and user input 'n' will be decided..
is there any way to get this 'RPC' problem down... Please suggest me in this regard
I am using a function to add excelsheet to excelbook (passing excelbook object as reference). (For dynalic insertion of excel sheets in book , i am updating iNumber)
Public Function AddExcelSheet( ByRef Xlb As Object, Optional ByVal sWorkBookName As String = "") As Object
Dim Xlsw As...
I already had code that uses Office references .
References added were
1.Microsoft ActiveX Data Objects 2.7 Library
2.Microsoft Office 10.0 Object library
3.....
My code is working well with Microsoft office 2000 (i am using excel application) but when i tried to run on office 2003, excel...
Can any one provide sample code
to run application from both command line prompt and from UI
to explain in simple.......
say i have a form with 3 text boxes with displays sum of values(of 2 text boxes when clicked on Add button (in 3rd text box)..
also i can provide data in xml file...
I have developed a small VB.NET application which browse and selects SQL Profiler log file and generated some report in excel
When i tired to run on win 2000 , it's working with out any issues
when i tired to run on win 2003 server , its give exception as:
"An unhandled exception has...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.