473,320 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Hourly VB Macro

I need to write a VB Macro that will run automatically every hour. Any ideas? Is this possible?
Nov 8 '07 #1
4 2534
Killer42
8,435 Expert 8TB
I need to write a VB Macro that will run automatically every hour. Any ideas? Is this possible?
What do you mean exactly by a "VB macro"? Are we talking about the macro processing built into one of the MS Office products? (If so, which one?) Or getting Windows to run a VBScript, or an actual standalone Visual Basic program, or what? And what version of VB / VBA / VBScript?

Generally speaking, I'd say you probably should use the Windows task scheduling functionality to set this up, rather than expecting the "macro" to magically start itself up every hour. But without knowing more about the situation it's hard to advise.
Nov 9 '07 #2
What do you mean exactly by a "VB macro"? Are we talking about the macro processing built into one of the MS Office products? (If so, which one?) Or getting Windows to run a VBScript, or an actual standalone Visual Basic program, or what? And what version of VB / VBA / VBScript?

Generally speaking, I'd say you probably should use the Windows task scheduling functionality to set this up, rather than expecting the "macro" to magically start itself up every hour. But without knowing more about the situation it's hard to advise.
I'm using VB 6.5 with Excel to hit a webpage. I need to download the data on the webpage every hour. I have a VB Macro that will download the data. It is triggered by a mouse click. What I need to do is have the macro exacute every hour and down load the data in a different destination range. I have never used Windows task scheduling. Where do I find it?
Nov 9 '07 #3
Killer42
8,435 Expert 8TB
I'm using VB 6.5 with Excel to hit a webpage. I need to download the data on the webpage every hour. I have a VB Macro that will download the data. It is triggered by a mouse click. What I need to do is have the macro exacute every hour and down load the data in a different destination range. I have never used Windows task scheduling. Where do I find it?
Go to Windows' Control Panel and open "Scheduled tasks".

I you set that up to open your worksheet once an hour, then you can set the macro to run when the worksheet is opened.
Nov 12 '07 #4
Killer42
8,435 Expert 8TB
Go to Windows' Control Panel ...
Another option might be to have your macro use the OnTime method to tell Excel/VBA to run it again in an hour. See the documentation for details, or try our search box, as I'm sure it has been mentioned before.
Nov 12 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Philip D Heady | last post by:
I'm in need of a good PHP programmer to help me with my lodgings website asap. Someone who can work on it during the day for a few hrs while I'm at work would be great. Prefer they live in USA...
699
by: mike420 | last post by:
I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro...
5
by: Anthony | last post by:
First time here so please bear with me. Set up a DTS package to export data to an excel sheet on an hourly basis. Problem is, it keeps appending to the same excel sheet. Any idea how to...
3
by: Brett | last post by:
For those of you working hourly, are you paid time and a half for anything over 40 hours? Say you are making $50/hour. Once you go over 40, your rate goes up to $75. If so, do you find it...
7
by: Compliance | last post by:
Apologies for the simplicity of the question, but it reflects my capabilities! I have the following sample fields coming from different tables: Location TimeDate (timestamp) Data I need to...
13
by: danceli | last post by:
I have two servers, using SQL server 2000. I was asked for implementing hourly Backup 3 databases in one server and restore those databases to another server. Could anyone give me the detailed...
4
by: MPD | last post by:
Hi How can I create a job in sql agent to create a new snapshot every hour? I have, for eg a T-SQL that does it manually. create database Snapshotter_snap_20070418_1821 on ( name =...
9
by: tommo5 | last post by:
Please help! im new to SQL and im finding a way of calculating an hourly avg difficult. This is what i have so far for all the data for the week - but i want an hourly avg instead of every second...
0
by: tommo5 | last post by:
Please help! im new to SQL and im finding a way of calculating an hourly avg difficult. This is what i have so far for all the data for the week - but i want an hourly avg instead of every second...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.