Hi....Need one help

Sanket80

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

albertw

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

Sanket80

Hi

Is there any way by which this objective can be achieved

hi

sounds more like VBA to me...

Nov 15 '06 #3

albertw

Hi

Is there any way by which this objective can be achieved

do you have any code so far ?

Nov 15 '06 #4

Sanket80

Hi

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

Regards

Nov 15 '06 #5

Sanket80

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