I have a macro that uses send to to email a report to various people in excel format. It works fine. The problem is when I use it on my computer (Windows XP), the file type choice for Excel is "Microsoft Excel 5-7" but on my main users' computers (Windows 2000), it fails unless I manually change it to the excel file choice on their computer "MicrosoftExcelBiff8(*.xls)".
How can I get it to just understand that Excel is Excel and not have to manually update my macro each time a new version comes out.
Thank you!
How can I get it to just understand that Excel is Excel and not have to manually update my macro each time a new version comes out.
Thank you!
