Hi
I am attempting to write values into excel and this error message comes along pointing to the line of code:-
Dim xlApp As New Excel.Application
Please help!
Printable View
Hi
I am attempting to write values into excel and this error message comes along pointing to the line of code:-
Dim xlApp As New Excel.Application
Please help!
try this...
'create and object (Excel SpreadSheet)
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")