workbook open

Hi I'm looking for a vba code to monitor the time spent since the workbook was opened. I want to track the time from opening the sheet till it was closed and create a log for such event.

What could be reason/s for workbook not opening on first attempt. Tried double click and right-click Open. Files are on local drive, not server. Using Office 365.

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...

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...

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...

<!--[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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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