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?
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.