Refreashing queries in multiple spreasheets

Giganews Newsgroups
Subject: Refreashing queries in multiple spreasheets
Posted by:  Hru48 (Hru48.278ewm_1146660003.3231@excelforum-nospam.com)
Date: Wed, 3 May 2006

Hey all,

I have 14 folders in a directory each of which contain 10 spreadsheets
with a query on sheet 1 which needs to be refreashed every month.

I need your help to figure out a macro which will open each folder in
turn and then open each spreadsheet in turn refreash the macro and then
close down the sheet and folder.

Even if you could tell me how to refreash the queries in every
spreadsheet in one folder without having to to do it manually would be
a big help.

Cheers

Hayley

--
Hru48
------------------------------------------------------------------------
Hru48's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=24895
View this thread:http://www.excelforum.com/showthread.php?threadid=538419

Replies