workbook open

  1. D

    Re-opening a *.xltm file - name sequentially changes by +1 every time it's opened?

    Hi Folks, I've created a multi-macro excel model that I've saved as a *.xltm file i.e., so that the users cannot damage the original file. As hoped, when opened the file becomes filename1 instead of filename.xltm. I can account for this in my vba code by referring to the workbook as...
  2. M

    File on LAN

    Greetings everyone. I am hoping that someone out there can point me in the right direction for the problem Im facing. I am attempting to automate a file which is stored on the LAN in office. The file will throw up a userform when opened. The user will fill up the various fields and hit Ok...
  3. R

    Open & Paste in Different files

    Hello everyone. I created a code that allows me to replicate the weekly information written in one file on multiple others. I update the information the information in the master file, and then it opens the correct file for each customer, pastes, saves and goes on to the next customer. It is...
  4. M

    workbook_open stopped working

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello everybody, I recently run into a problem with workbook_open. The code has been successfully running for years. Now if I open the file nothing happens. Or almost...
  5. A

    Workbook_Open Sub editing wrong sheet

    I am using this script to add Dates and a time stamp to the Sheet specified in the Script. It works, but it is also adding the Date and Time to a completely different worksheet. The name is not even close. I have to use this Format because Wonderware Historian uses this format to pull data...
  6. N

    Hiding Rows With past Dates Automatically When Opening the Workbook

    Hi all, I want to hide rows based on a timestamp in column A. If the timestamp is a day old, hide the row. The code below used to work great but I just updated the workbook and the problem is that the code is only working for one of the worksheets (past date rows are hidden), while the other 4...
  7. tljenkin

    VBA code

    Hi All, I am trying to compile a simple code to check ... 1) if a file is open, 2) if it is, run the rest of the code, 3) if it is not, open the file and run the code 4) if nothing is selected at 3), show an error message to that effect and close sub Please see code below and help me...
  8. J

    Auto run Macro on Startup Conflict

    This is my first time posting on the forum, so I want to go ahead and thank you all for the support that you have given me so far. I am very new to VBA & Macros, so if my question seems silly, I apologize. I have tried researching this, but I cannot find an answer. Here is what I have: I am...
  9. D

    Opening Another Workbook

    Hello! I'm fairly new to VBA coding (and this site), and I'm having a little problem that I'm hoping someone can help me with. I'm trying to get my workbook to open up a second workbook that is saved on the user's desktop and copy information into that second workbook. I found code in a...
  10. andrewb90

    Call a Workbook open procedure

    Hello all, I have a workbook open procedure that runs when the user opens the workbook (obviously). The code is looking for a validation code depending on the current date. The user has the open of entering the code into the sheet and then I would like to run a macro to check if that is a...
  11. C

    Updating Links, Ignore workbooks that are open

    Hello all. In my workbook i have a button to update the workbook which i will press several times whilst it is open as the files regally change. It all works well unless i have one of the workbooks open. Is there a way for vba to check to see if the workbook is open, if so then it will skip the...
  12. J

    VBA xlCalculationManual trips error when called App_WorkbookOpen

    I am trying to change the application settings to xlCalculationManual when opening up a workbook. However, this code throws an error if a workbook is already set to xlCalculationManual (Error: Method 'Calculation' of object'_Application' failed). It does not throw the error if the setting is...
  13. W

    Workbook open and executing two different macro excel files

    I have two excel files that run macros upon opening. I have an additional "dummy" excel file with the following codes: Private Sub Workbook_Open() If InStr(1, ThisWorkbook.Name, "NoRun") > 0 Then Range("C6").Select 'Do nothing so the macro won't run...
  14. J

    Edit Code that runs on Workbook open and closes active workbook

    Hello, I have made a code that will run when opened via task scheduler. I have trusted the workbook so it doesnt prompt me for macro. My workbook open event calls the macro. After macro is complete, it closes the workbook containing the VBA. Without blocking macro's or untrusting the folder...
  15. F

    run macro after open workbook

    hi, In module called "total_measures" I have simply code: Sub count_total_measures()Dim wb As Workbook Dim ws As Worksheet Set wb = ActiveWorkbook Set ws = wb.Worksheets("row_data") Dim x_row_data, i, count_measure As Long x_row_data = ws.Cells(Rows.Count, "A").End(xlUp).Row count_measure = 0...
  16. S

    workbook_open() not firing with application.quit

    I hope someone can help me with this one. Here goes. I am having a problem around the workbook_open event. First let me explain what I am trying to achieve. Basically, I want to start logging the execution of about 30 scheduled tasks which open various workbooks (which perform different...
  17. A

    Activate sheet on workbook open

    Could someone please advise me on how to activate a particular sheet as part of the workbook_open event. At the moment it doesn't matter how I try to code it I get Run-time error '1004': Select method of Worksheet class failed. I have tried: Sheets("Sheetname").Activate...
  18. K

    Personal.XLSB is opened instead of New blank workbook

    Hi, ever since I added a macro to my personal workbook everytime I open excel by clicking on the excel 2010 icon the Personal.XLSB is opened instead of New blank workbook. I deleted the module but it didn't solve the problem can you please help. Thanks, somone
  19. T

    User Form Name

    I changed a user form name and now the user form will not start when I open the workbook. I use the "Workbook Open" event in the "Thios Workbook" section viz: Private Sub Workbook_Open() fm_flange_1.Show End Sub The new user form name is fm_flange_1. What do I need to do to get this to work...
  20. melewie

    Textbox populate

    Hi all, I have a textbox (active x) on a worksheet I want this to be populate by a range (Country_RNG) when the workbook opens Private Sub Workbook_Open() Sheets("Front Page").Select Country_CBX.List = Range("Country_RNG").Value End Sub This is on the 'This worksheet' object. Im getting...

Some videos you may like

This Week's Hot Topics

Top