This sub will open the specified file type from the specified directory and sace them as excel files. A file open dialog box will ask the user to select a file from the folder where the original files are kept. Then an output folder name will be asked and this folder should exist otherwise it […]
Continue readingI found this on microsoft’s website. I didn’t know that I can use MID function on the LHS and converting string to ASCII will speed up the process. Cool!! “The following points provide suggestions for ways to enhance the performance of string operations: Minimize concatenation operations when you can. You can use the Mid function […]
Continue readingPMT function has various uses; if you go to Excel help you?ll see its uses. I am using it to calculate monthly payment I have to do pay off credit card debt. If you also want to do that please follow these steps: 1. Type this A1=Card Name, B1=Balance, C1=Years, D1= Interest rate, E1=Monthly Payment, […]
Continue readingThis Procedure will ask for a file name to the user, will check if the file is open and if it’s not open it will open the file otherwise give a message to the user. Public Sub IsWorkbookOpen()Dim Wb As Workbook, wkbk As Variant‘get the dialog box to open the filewkbk = Application.GetOpenFilename(“Excel Files,*.xls”)If wkbk […]
Continue readingOne more tutorial for VBA beginners. It’s really great, you’d be amazed by the power of VBA and it is very easy to learn. So why wait? start programming right now Super-Easy Guide to the Microsoft Office Excel 2003 Object Model Summary: Learn how easy it is to use the Excel object model to customize […]
Continue reading