Hey all,
Thanks in advance for the replies.
What I am trying to do is EXPORT a query to an Excel Workbook which is read only and I need the data to land in a specific sheet in the excel workbook.
I have tried transferspreadsheet vbcode etc. but nothing works quite right and the fact the spreadsheet is Read Only does not help.
The Name of the Query is "Accrual"
The Name and location of the Excel Spreadsheet is "c:\register.xls"
The Sheet inside the workbook is called "data".
I need the data to land in the "data" sheet over the top of the previous data and not create a new sheet or mess with the forumales that are linked to the "data" sheet.
if someone could write me some code I would appreciate the help so much!
Thanks!