VBA beginner: how to run VBA code independently of Access

[Dan Hicks]

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?

[Larry Linson]

Re: VBA beginner: how to run VBA code independently of Access

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" <danhicksjobs@h otmail.com> wrote in message
news:e457dca6.0 404110607.623c3 804@posting.goo gle.com...[color=blue]
> 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?[/color]

[PC Datasheet]

Re: VBA beginner: how to run VBA code independently of Access

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
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Dan Hicks" <danhicksjobs@h otmail.com> wrote in message
news:e457dca6.0 404110607.623c3 804@posting.goo gle.com...[color=blue]
> 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?[/color]

[david epsom dot com dot au]

Re: VBA beginner: how to run VBA code independently of Access

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)