Daily posts of Excel tips…and other stuff
Archive for the ‘Workbook Object’ Category.
Hi Everyone.
Although I have already reported this as a KB article sometime ago, I decided it to be useful to post this here too:
Sometimes Excel VBA behaves unexpectedly. Here is an example:
You are running code that is meant to open one or more files using the Workbooks.Open command. As soon as you hold down the [...]
Events are a powerful aspect of Excel programming. They enable you to make your application respond to user actions such as entering data into cells or clicking the print button.
If your application uses events, you will probably also need to be able to control whether or not an event executes its code or not (e.g. [...]
Sharing workbooks in Excel seems to be a disaster, at least to me. Yet the fact that so many people have problems with it must mean that they use it. Attempting to change a shared workbook in code will often cause the code to fail. So, like with protection, you have to [...]
To open files that belong to an application other than Excel, you can automate the other application. If you just want to open them, however, the FollowHyperlink method of the Workbook object is a better choice. Way less overhead. FollowHyperlink isn't just for HTML files, it works with any file. It [...]
