I have a two-part payroll process where employee data is exported from an Access utility to an Excel file, whereupon the user runs an Excel macro of mine to put the data into the format required by the mainframe payroll program.
In the newest version -- and the company has just gone to Office 2010 -- the Access programmer creates a temp file in Excel and uses that as a base to create a second file opened for the user. The user runs my macro, which assembles the data the mainframe program wants and copies it to the clipboard, ready to be pasted into the mainframe program. Then the user chooses the next employee and the process is repeated.
Excel 2010, however, is now stopping in its tracks with the message that the "temp.xls" file exists and does the user want to overwrite it?
I think the most practical approach is for me to add a line to my macro to delete "temp.xls" once it's no longer needed, but I can't find the code to do it. Since the process uses the same file name over and over, I should be able to keep the whole process invisible to the user.