By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

VBA beginner: how to run VBA code independently of Access

P: n/a
Hi,

I wrote this test code as part of a module I created for the Northwind
database. However, I was only using this as a test platform. My goal
was to write a program that would take records from SQL server and
import them into the outlook address book. It worked, great.
Now I'd like to run this VBA code independent of the Northwind
database. Understand that I don't have the first idea of what program
I can use to run this VBA code as a standalone module. I'd also like
the program to be able to run on its own power, on a schedule, without
me telling it to run everytime.
Any ideas?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You must run Access' VBA from an Access database, and, for what you want to
do, that may be pretty high overhead -- but if that isn't an issue, read
ahead. You could write similar code in the separate ("classic") VB 6 product
that would have a much smaller footprint. In either case, there is a way to
have particular code run at startup. You'll need to use the Windows
scheduler, or a third-party scheduler, to initiate execution of your
application on a particular schedule.

Other products support VBA, but you wouldn't be any better off running it
from Excel, or Word, or one of the other software packages where it can run.
VBA does not have an option for a compiled, standalone execution.

Larry Linson
Microsoft Access MVP

"Dan Hicks" <da**********@hotmail.com> wrote in message
news:e4**************************@posting.google.c om...
Hi,

I wrote this test code as part of a module I created for the Northwind
database. However, I was only using this as a test platform. My goal
was to write a program that would take records from SQL server and
import them into the outlook address book. It worked, great.
Now I'd like to run this VBA code independent of the Northwind
database. Understand that I don't have the first idea of what program
I can use to run this VBA code as a standalone module. I'd also like
the program to be able to run on its own power, on a schedule, without
me telling it to run everytime.
Any ideas?

Nov 12 '05 #2

P: n/a
Outlook has VBA just like Access so why not run your codefrom Outlook rather
than Access. Trying to use Access just makes Access a "middleman" to your
application and makes it less efficient. There are two benefits to using
Outlook:
1. users without Access will be able to use your app;ication
2. Outlook has as part of its VBA a reminder system that you can program to
pop-up on a schedule. You can use this feature to run your program on a
schedule.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Dan Hicks" <da**********@hotmail.com> wrote in message
news:e4**************************@posting.google.c om...
Hi,

I wrote this test code as part of a module I created for the Northwind
database. However, I was only using this as a test platform. My goal
was to write a program that would take records from SQL server and
import them into the outlook address book. It worked, great.
Now I'd like to run this VBA code independent of the Northwind
database. Understand that I don't have the first idea of what program
I can use to run this VBA code as a standalone module. I'd also like
the program to be able to run on its own power, on a schedule, without
me telling it to run everytime.
Any ideas?

Nov 12 '05 #3

P: n/a
And the general solution for running code without VB6 or Outlook
or Access or Excel is to use VBS (vb script).

VBA is part of office: VBS is part of Windows.

(david)
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.