VBA - Visual Basic for Applications
In case you need the temp directory on a Windows machine in VBA, the following method might do the trick for you.
It looks up the TMP or TEMP system environment variable.
- Hits: 3032
Saving an Excel workbook is a rather simple task. However you have to regard many things in IO operations, which can go wrong.
Therefore it is always good to add some extra exception handling for IO operations that are likely to fail.
Hence, although saving a workbook requires only one line of code I use below method for saving workbooks.
- Hits: 2965
In one of my projects I had to read all worksheet names from several Excel files.
Here is the code for getting all worksheet names from a closed or already opened Excel file.
Referenced Functions can be found below.
Getting all sheet names from a workbook
Getting an opened Excel workbook
- Hits: 3018
Excel VBA Article Count: 30
This category will hold articles regarding developement in Excel VBA. It will serve as a wiki and an Excel VBA Framework for myself.
Some development tasks reoccur for every customer. Since I am a lazy bum it will be nice to have a central source where I can reuse source code from.
MS Office and VBA Article Count: 11
This category holds articles regarding general things in MS Office VBA independent from the MS Office application.
Power Point VBA Article Count: 1
Page 13 of 17