I have a table with a column of month end dates. I also have an .xls file for each of those dates. Those files are right now identical except for the file name which is based on the month end date, i.e., R1000_20101231.xls. I need to write the date into a single cell on each excel spreadsheet. I have used DoCmd.TransferSpreadsheet acExport before to take an entire query and write it to a spreadsheet but is there a way to write a single record to a single excel cell, i.e., cell A2?
Thanks for any help!