dtime

Hello, I have an issue with my auto-save macro on every 2minutes. It was working ok for couple of days, but now it is behaving odd. Macro is as follows (in Module1): Public dTime As DateSub MyMacro() Dim fPath As String Application.DisplayAlerts = False dTime = Now + TimeValue("00:02:00")...

Hi... I have data in column(A) which get updated after a minute. Values in this column(A) are derived values. What I want is , that data from column (A) will get copied to column(B) after minute and after 2 min, updated value in column(A) should get copied in column(C) and so forth. I have...

I want to sample a variable data in a cell say C3 & to display that data after every 1 second (Means sampling rate is 1 Hz) into the rows (one after one) in a column say D. To explain, after starting up the Macro, value of C3 should display in D1 and after 1 second updated value of C3 should...

Hello Everyone, Hopefully this is an easy fix. I have a large file that I backup every 30 minutes due to it corrupting frequently. I have created a macro to save a new version of the file with a variable name (based on date and time) as follow: "YYYY-MM-DD-HH-MM_FileName.xlsm". It works out...

Hi, i have the following code which works great with just the one open workbook. But it runs into problems if other excel workbooks are open Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnTime dTime, "autoSave", False End Sub Private Sub Workbook_Open() dTime = Now +...

Hi All! I hope someone can please help me? I've got a very simple vba macro but it pauses when the window/sheet is not the active sheet??? Once I return to the Sheet where the macro is running it starts again??? I need to run this macro in the background so I can work on other excel workbooks...

I have a workbook that captures certain data throughout the day. I'd like to capture the data in cells a1 and b1 on sheet 5 every minute starting at 09:30:00 am and ending at 16:00:00 pm for purposes of creating a daily chart. This data can be posted in cells c1:c?? and d1:d??. I currently run...

So I've been trying to put together some code that AutoSaves any and all open documents into a single folder every 5 minutes (code is set to 10 seconds for testing purposes). Saves as original filename + date and as extension xlsx. I can get it to run manually but not automatically. Below is...

Hi, please can someone help me? I keep getting the following error: Run time error 1004 - Method 'OnTime' of object'_Application' failed. It keeps popping up quite often but from different situations on my file but it doesn't always happen when i repeat a certain situation. Here is all the...

Was hoping you could help this VB beginner. Keep getting '9' Subscript Out of Range error. Debug brings me to this: lastrow = Sheets("DB").Range("A356000").End(xlUp).Row + 1 The Range is dynamic and I am think my line code is off since I am trying to set some sort of range. Help please...

HI, This runs a macro every 5 minutes in order to .SaveCopyAs. The master file conducts a power query from web every 1 minute. I .SaveCopyAs to another file name/location every 5 minutes. Obviously, it saves an actual copy of the master file, including the webconnection (which is set to run...

Hi all, I am using this code in a workbook to activate a timer when it is opened, then after 15 minutes make it close and save changes. my question is, if I have this workbook open, then open another the timer seems to activate on that one too, then as a iswitch between it starts the timer...