I ran a stored procedure to create a recordset and now I wanted to quickly transfer the result set of the query to an Excel report format which is the format of choice requested by the user. I am using Excel 2002. I encountered a Runtime Error as follows:
Do you know how I can resolve this ?
.Cells(2, 1).CopyFromRecordset rstQueryFS
.Columns(15).NumberFormat = "000-00-0000"
.Columns(18).NumberFormat = "#0.000"
.Columns(24).NumberFormat = "@"
I get a run time error as follows:
Run-time error '-2147319779(8002801d')
of object 'Range' failed