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 [...]
Read More >>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 NewName As [...]
Read More >>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
Update: Duplicate master V2.16 (Download link). (04/08/10) David Brett (a.k.a. brettjd) wrote an excellent utility for removing duplicates within Excel. But as his original web site is gone offline, people are deprived from using the great utility. The add-in works in MS Excel 2003 and 2007. It was originally distributed through the site – http://members.iinet.net.au/~brettdj [...]
Read More >>
