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

[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...

[Sanket80]

Hi

Is there any way by which this objective can be achieved

hi

sounds more like VBA to me...

[albertw]

Hi

Is there any way by which this objective can be achieved

do you have any code so far ?

[Sanket80]

Hi

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

Regards

[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.ht ml

Regards