VBA
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 [...]
Batch printing in MS Excel
By admin at 7 April, 2009, 2:06 pm
I had to print loads of charts from excel files. All at once! Rather than starting printing one by one I started looking for software to do the job for me. I found some really nice featured software but they came with hefty price tags (not less than 100 bucks). At last I found just [...]
Read More >>Free Excel add-in The Duplicate Master
By admin at 18 November, 2008, 4:26 pm
David Brett (a.k.a. brettjd) wrote an excellent utility for removing duplicates within Excel. But as his original web site is gone people are deprived from using the great free utility.
The add-in works in MS Excel 2003 and 2007. It was originally distributed through the site – http://members.iinet.net.au/~brettdj which is offline these days.
You can however download [...]
