dtime

  1. P

    Auto-Save issue

    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")...
  2. A

    Copying data from one column to another at periodic interval

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

    Taking a data from a cell & keep displaying in subsequent rows in a column?

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

    Macro - Save specific open wrksheet with a varying file name

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

    Help with Autosave macro when multiple workbooks open

    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 +...
  6. M

    Macro pauses when is not the Active window???

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

    cell data capture

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

    Code not working - autosave copy

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

    Run time error 1004 - Method 'OnTime' of object'_Application' failed.

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

    Subscript Out of Range Error

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

    VBA to turn off web query connection

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

    workbook close on timer - query

    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've detected that you are using an adblocker.

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.
Go back
Back
Top