Archive for August, 2009
Excel Filename – Copy sheets to new file
By admin at 30 August, 2009, 6:50 pm
In the previous post I posted a code to copy data and remove all external references and save as a new file. But for a simple case, I was trying to save a sheet – as it is – as a new file.
But, typical to a copy-paste code; a strange error occurred while I tried [...]
Excel VBA – Copy worksheets and save as a new file
By admin at 28 August, 2009, 1:41 pm
If you copy data from one sheet to another the formula refer back to the original sheet. Doing a ‘past special’ and copying only the data can do the trick. But if you need to do such operations for a large number of sheets a VBA macro can be handy:
Sub CopyPasteSave()
Dim [...]
