Hi again,
i have a small issue with an excel workbook I am creating using access vba. It all works greate until i try to save the excel file using ' Excel_Workbook.Save '. it does try to save the file but it also comes up with the compatibilty checker saying that a table format may not be saved with the file. this is not a problem with the missing format, but i would like it to continue to save the file without any intervention from the user.
i know this is because of the different version of office on the various pc's we have that this can be used on.
can i save the file without the checking compatibility? do i just pick the most compatible file version and change the above to Excel_Workbook.SaveAs ?