Ian creating spreadsheets in SAS which is still creating the spreadsheets as xls. I have Excel 2010 on my machine now.
I have a macro which is formatting the spreadsheets. Each time it saves I get the "incompatible message" attached. Is there someway to code in VB so the process keeps going without manual response or to eliminate the message?
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…