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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.