About Us

Thank you, it worked fine.

Regards
Jean Simon.

"Dave Peterson" wrote:

This is a VBA procedure.

Since you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Short course:

Open your workbook.
Hit alt-f11 to get to the VBE (where macros/UDF's live)
hit ctrl-R to view the project explorer
Find your workbook.
should look like: VBAProject (yourfilename.xls)

right click on the project name
Insert, then Module
You should see the code window pop up on the right hand side

Paste the code in there.

Now go back to excel and test it out via:

tools|macro|macros...
select the macro and click run.

======
You could even show the forms toolbar and put a button on the worksheet. Then
assign this macro to that button to let you just click a button to run it.

Jean Simon wrote:

Hi Rowan,

Thanks. I feel very stupid, because I don't know what to do next.
Is this something that I need to put in vba ? How do I invoke this
subroutine.

Thanks and regards
Jean Simon

"Rowan" wrote:

Maybe something like this:

Sub Refr()
Dim QT As QueryTable
For Each QT In ActiveSheet.QueryTables
QT.Refresh
Next QT
End Sub

Hope this helps
Rowan

"Jean Simon" wrote:

Hi,

In excel, there is a nice feture that allow to insert table from different
web pages. Is there a way to update at once all tables coming from web sites
without using data menu then refresh data for each table ? I have an excel
sheet that links 50 tables....

Thanks and regards
Jean Simon

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
updating pivot table to include additional rows	Ellen	Excel Discussion (Misc queries)	8	July 15th 08 01:33 PM
Pivot Table not Updating	Ranelle	Excel Worksheet Functions	0	June 13th 05 05:13 PM
Updating a league table.	Matt Porter	Excel Worksheet Functions	0	May 9th 05 06:41 PM
Automatically print all page contents in pivot table.	David P	Excel Worksheet Functions	0	February 21st 05 05:57 PM
Can I setup a league table that automatically updates itself?	sd8974	Excel Discussion (Misc queries)	0	February 4th 05 01:15 PM

Menu

About Us