469,315 Members | 1,548 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,315 developers. It's quick & easy.

Custom Macros

Is it possible to write custom macros in Access, or are you only able to
use the ones they allow? If so, how do you go about accessing the
Editor.

One more question, what is a good source to learn how to write a macro
that exports certain data from Access into Excel, then formats it. I
have queries written in Access and a macro that exports it to Excel, but
then you have to format it everytime so it looks like a blance sheet.
Is there an easy way so the data exported always goes into an Excel
template or something like that?

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
2 1530
"Josh E" wrote
Is it possible to write custom macros in
Access, or are you only able to use the
ones they allow? If so, how do you go
about accessing the Editor.

One more question, what is a good source
to learn how to write a macro that exports
certain data from Access into Excel, then
formats it. I have queries written in Access
and a macro that exports it to Excel, but
then you have to format it everytime so it
looks like a blance sheet. Is there an easy
way so the data exported always goes into
an Excel template or something like that?


What you describe can be done with Visual Basic for Applications (VBA) code,
but, in Access, that isn't considered a "macro" -- macros and VBA are
different features. In fact, someone skilled in VBA can do a great deal more
than can be accomplished with macros.

I'd suggest you go browse at a nearby well-stocked bookstore for self-study
books -- many of them have beginning, intermediate, and advanced topics on
VBA. There are also some very useful on-line courses at
http://office.microsoft.com, but, sad to say, none really go far enough to
cover VBA. I like John Viescas' _Access 2003 Inside Out_ from Microsoft
Press, Roger Jenkins' _Special Edition Using Access <version>_, and any
Access book of which Ken Getz is the author or co-author.

Follow some of the links from http://www.mvps.org/access, or the Resources
section of http://ntaccess.tripod.com, or Jeff (The Access Junkie) Conrad's
very helpful site at
http://home.bendbroadband.com/conrad...essjunkie.html.

Larry Linson
Microsoft Access MVP


Nov 13 '05 #2
Thanks for the tips. I will check them out.

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jared | last post: by
4 posts views Thread by Robert Frunzke | last post: by
2 posts views Thread by rickholt | last post: by
27 posts views Thread by Wayne | last post: by
18 posts views Thread by smnoff | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.