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

Hi....Need one help

P: 19
Hi

I am using MS Access and have some queries written in it (About 10)
I want to write a macro using VB in such a way so that each time when I run the macro, the system shall execute the queries one by one and print the output of each result in seperate excel files.
Can somebody please help me in writing such a macro....M very new to VB

Regards
Nov 15 '06 #1
Share this Question
Share on Google+
5 Replies


100+
P: 267
Hi

I am using MS Access and have some queries written in it (About 10)
I want to write a macro using VB in such a way so that each time when I run the macro, the system shall execute the queries one by one and print the output of each result in seperate excel files.
Can somebody please help me in writing such a macro....M very new to VB

Regards
hi

sounds more like VBA to me...
Nov 15 '06 #2

P: 19
Hi

Is there any way by which this objective can be achieved


hi

sounds more like VBA to me...
Nov 15 '06 #3

100+
P: 267
Hi

Is there any way by which this objective can be achieved
do you have any code so far ?
Nov 15 '06 #4

P: 19
Hi

No .....I just started to work on this project

Regards
Nov 15 '06 #5

P: 19
Hi

I think u can get help from the following link
Since I am very new to this .....its bit confusing for me to understand

http://www.thescripts.com/forum/thread530866.html

Regards
Nov 15 '06 #6

Post your reply

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