From time to time I get excel files that have what seems to be 10,000 styles embedded in it. I’ve found the more styles the slower Excel works and in some cases errors actually occur. Just recently I wasn’t able to apply a style at all – even through I had 1000’s available in the selector.
I found this tool that clears all of these styles back to the basics. Once I ran this tool I had no more issues with the spreadsheet. Enjoy.
Create A Single PDF File Per Record Report Using VBA & MS Access
This one was a tricky request. What I had was a recordset from a query in MS Access. I needed to create a report where when printed it would create one PDF file per record. MS Access has the...
Use this bit of VBA to create a list of Excel sheet name. - EASY Just add this code in VBA to the ThisWorkbook node and press F5 Sub ListSheetNamesInNewWorkbook() Dim objNewWorkbook As...