Challenge: Excel file has password protected and no one know what the password is. Solution: After searching the net, here is the solution. Thanks to http://www.theofficeexperts.com/VBASamples/Excel02.htm Create a backup file. Note: This routine provides a password to unprotect your worksheet. However, it may not give you the original password that was used. Open the workbook [...]
Challenge: Client raised the issue that everytime he’s printing this Excel workbook into PDF using CutePDF, turns out that is only few sheet that he can print. Where is the rest? Solution: Reducing the number of sheet didn’t work. Moving around the sheet didn’t work either. Almost give up, finally the client is finding the [...]