workbook_open

Hi all, I am trying to add a code so that when a user opens his/her workbook he/she gets a message with the number of records opened 30 days or more with a close date. The open date is in column C and the close date is in column AA. I tried the following (which is not working): Private Sub...

I have some code I placed in the Sub Workbook_Open in an xlsm file which is placed in XLSTART folder. The code executes properly when Excel is opened. Problem. If any code is in the Sub Workbook_Open, and the user double clicks an Excel Workbook and Excel is CLOSED, the workbook will open, the...

I'm getting a "method worksheets of object_global failed" error when a macro is called from the Workbook_Open event. What really confuses me is that the wc_user_update macro runs fine when it is not called from the workbook_open event. Also, when I comment out the password protection in the...

Hi there Excel Masters, My file contains a function to Delete & replace itself for its latest version. This function can be accessed by a button on one of the sheets; or everytime I open the workbook. This function works perfectly if I trigger it from the button on the sheets, but if it is...

Hi All! This forum has been awesome for getting me started on VBA, I'm not a programmer and I had to pick this up now because the company that I'm working for has a really outdated system and we have to do a lot of Excel manipulation to get the files the way we need them. I appreciate any help...

Hi Guys, I have another question for you after you've helped me so much with other things. I have a spreadsheet 'Training Compliancy.xls' that takes data from a cell in another spreadsheet in the same folder called 'Training Monitoring.xls' I have been using this code to open 'Training...

I am creating a UserForm to get macro running options from the user. The Workbook__Open calls the macro which shows the UserForm right after the variables are defined. Is there a way to avoid the compile error? 07.15.2013-14.15.54 - Bermex's library

When i open a xls file in excel2010 i have 65536 rows. After SaveAs xlsm there still are 65536 rows After closing and reopening the file, the 1000000 rows appear. Do i have to re-open the file? Why: We use different EXCEL versions. The advanced users have EXCEL 2010. Our mainframe starts...

Help. all of a sudden whenever I add code in the workbook_open sub and save the file, all of my code is deleted. I can add the other non-workbook_open code back save and reopen the file and all is good. as soon as i put code back in the workbook_open, it all gone again!

Hi All, I hope you can save me today. I am trying to run http://www.ozgrid.com/Excel/run-macro-on-time.htm in excel 07 but I can't seem to make it work and I am ready to cry. In Thisworkbook code I have the following: Private Sub Workbook_Open() Application.OnTime...

Hello all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> i wrote some code that runs in the "Workbook_Open" subroutine.<o:p></o:p> My problem is that the "Workbook_Open" subroutine RUNS TWICE<o:p></o:p> When i open the excel file.<o:p></o:p>...

I have MSOffice 2007 installed with latest patches. Previously, even with Excel 2000 on same machine this behavior occurred. Situation: to isolate using the simplest of examples... a blank XLS (97-2003 format) sheet - no formulas or formatting, and no fancy VBA code. VBAProject code...

I often make templates of forms for weekly, bi-weekly, monthly, etc., forms for others to use and I tell them to be sure to use Save As... with a new name in order to keep the original form intact. We do not have a common location for templates here. I have tried a Workbook_open() macro to give...

I am not a programmer but. I have built a sub that prompts the user for a folder then opens every workbook in the folder 1 at a time to get stats on the contents of each workbook. Worked like a dam until I ran into an unexpected bug. Some of the users built on open events in their workbooks. ...

I am calling a .bat file from a Java script using the Runtime.getRuntime().exec(execFile) command. The .bat file contains a line that starts Excel using a shortcut that also opens my workbook. However, when the workbook is open the workbook_open event does not run. When running the .bat file...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am creating a document in excel 2003 that will be shared by many people. I want it to always open on the first sheet, but cannot guarantee that it will always be saved there. Is there any...

Hi, My workbooks contains 2 worksheets with data and autofilters on for each column in use. When my workbook opens I am trying to reset the autofilters of each worksheet in the workbook and to filter the data according to one criteria in one column. This is what I have that works to reset each...