auto_open

EXAMPLE CODE NOT REAL: Private Sub Auto_Open() If ( Activeworkbook.isNewDocuement() == false ) then Goto :EOF End If ' [code example] ' [code example] ' [code example] :EOF End Sub I have a macro that runs each time excel open which works great but now I want it...

Hi there. I have an Excel "Blank Rate request Form" that enters today's date in one cell and the identified user in another cell. It is housed on a shared drive (R:) for others to use. If anyone opens that folder and opens the Excel the above macro works fine. Sub Auto_open()...

I put the following code in (the macro area of) Sheet 2 Sub Auto_Open() Sheets("Home").Activate MsgBox "Welcome " End Sub However, nothing happens when I click into Sheet 2.

Hi, I have an Auto_Open macro that cleans up data before allowing the user to begin. This only takes around 8 seconds, but I wanted to put a message asking the user to please wait a moment while we tidy things up. What I found is that when I start my Auto_Open macro with MsgBox("Please wait a...

Hello, I pasted some of my code into a workbook that I am working on and it generated alot of weird "Automation Errors" that I am not familiar with. This code used Auto_open() and when I get the Automation error the debugger highlighted another piece of code that that I coppied from the...

Hello! I have created an Auto_Open Macro with about 5 call macros within it. at the end it saves the file as todays date. I need the new file to no longer Auto_Open, however I still would like to have access to the macros. Is there a way to delete only the Auto_Open Macro in the new file, or...

Hello everyone, Thank you in advanced for your help. I would like to have a macro run when a workbook is opened but only if the current date of a cell doesn't match up with the system date. What I have Private Sub Auto_Open() Application.ScreenUpdating = False...

Over several years, I have been creating and updating an elaborate spreadsheet using VBA and XLM 4 macros. It all works fine. You may wonder why I still use XLM 4 type macros - and my reply is to admit that my detailed experience of VBA is very, very limited and since the XLM macro operates...

I have created an excel spreadsheet that updates with production data every 3 seconds and part of the macro changes the format of the file to be full screen because it is displayed on a giant TV monitor in our production office...my issue is that once this file is opened on a computer if you...

So I had a colleague ask me to come help him with some code that was firing when he closed a workbook that he inheritted. The first thing that struck me as odd was that is was a .xlsx, not a .xlsm. Ipso fatso: no VBA code in the book anywhere. First I had him check...

I am trying to use Excel as an interface between CSV files & Word using the 2003 version, the function of Excel being to properly format the data before import into Word. If anybody can suggest a simpler way, I would be happy to try. The process is as follows: - CSV files are updated every...

Hello - I am looking for assistance with my Auto_Open macro. Currently it forces the workbook closed after a designated expiration date. I'm trying to alter it so that users have read-only access to the workbook after it expires, rather than forcing it closed. Any suggestions would be greatly...

I have a file that generates a report automatic using the Auto_Open macro and the scheduler .. at 6 am the file open and imports data from other files and generates report, then, the report is auto save as a file with at date code added. Problem ... when the file is rename it still contain the...

I have a macro that successfully creates a menu. However, it appears as if the menu is deleted right after it is created. Does Excel load the excel11.xlb after the auto_open macros run? Any suggestions on how I can create menu items at start-up. Thanks - VBADJ

I keep reading that auto_open is not a preferred, modern method and that it is retained for backwards compatibility purposes only. But auto_open is the only way I've found (so far) to trigger an XL event when a module opens in my application. I have an application where the event detection...