Queries in a Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
Back
Top