Queries in a Macro

[Matt]

I have about 100 append queries and I wanted to put them in a macro. The only way I can think of doing that is to tile the windows vertically and then select and drag each append query one by one into the macro.

Is there an easier way of doing this? Any way of selecting more than one query to drag into a macro

Thanks in advance
Matt

 

[Steve Schapel]

Matt,

No shortcut way of doing this that I know of.

Wow! 100 Append Queries in the one macro... that's amazing! What's
that all about?

 

[Matt]

Hi Steve

Thanks for the reply. I didn't think there was any other way either, but I'll admit that's something I'd like to see Microsoft add in the future. Just the ability to select more than one query to drag into a macro would be nice

As for the append queries, it's a bunch of individual Excel worksheets that are being linked and then appended into a master table. I'm sure there's a better way, but I haven't found it yet

Thanks for your help

Matt