ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

The built-in help

You can find a lot of information about the use of an application and programming by using the application's built-in help features. Today the built-in help is the primary source of information about most applications. The answer to most of the questions I receive about Excel could have been found by looking in the built-in help.

When you encounter a problem you can start searching in the built-in help to see if you find a suitable solution. If you don't find a solution to your problem you can try to search at different websites. It is also possible to search for solutions in the different newsgroups. Mailinglist archives can also be searched if you still haven't found a solutions to your problem.

 

Document last updated 2000-05-16 12:45:37      Printerfriendly version

User comments:
Ole P. from Norway wrote (2004-11-03 08:55:04 CET):
Re: Need Save Help
There is no built-in event in Excel that can trigger a macro after a save is complete. You can use the Workbook_BeforeSave eventmacro to accomplish what you want, e.g. by cancelling the save process and replace it with your own saving procedure (put this code in the ThisWorkbook module):

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True ' aborts the saving process
RunMyCustomSavingProcedure ' start your own saving procedure
End Sub

You can also make Excel run a macro after the save is complete like this (put this code in the ThisWorkbook module):

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.OnTime Now + TimeValue("00:00:02"), "MacroToRunAfterSaveIsComplete", , True
End Sub
Kevin from Sacramento, CA wrote (2004-11-03 01:15:50 CET):
Need Save Help
Each time a user saves my Excel file, either through the file save icon or SaveAS, I need a macro to automatically run at the conclusion of the save.

Any way to do this?
Ole P. from Norway wrote (2004-07-28 01:54:34 CET):
Re: Password.zip
When the un-zipped file is properly opened you should find a new menu item in Excel named EDC where you will find menu items that displays help about this tool.
If the EDC menu is missing, you probably haven't enabled macros to run.
Steve Rakoz from Mark, IL USA wrote (2004-07-27 21:28:20 CET):
Password.zip
I unzipped and put the xla into my excel, but what does the addin do. Where is some documentation?

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2024    Ole P. Erlandsen   All rights reserved
E-mail Contact Address