Refresh Modified Query From Same Sheet

Posted to microsoft.public.excel.programming

Abdul[_6_] Abdul[_6_] is offline

external usenet poster

Posts: 8

Refresh Modified Query From Same Sheet

Hi All,

How can I refresh a (modified thru code based on value
from sheet1) query from another sheet from the workbook?

I want to have the code for .Connection = ???? to
represent activeworkbook sheeets("Temp 1")

With Sheets("TempData").Range("a1").QueryTable
.Connection = ????
.CommandText = myCmd
.Refresh BackgroundQuery:=False
End With

thanks All

Abdul

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I 'Enable Automatic Refresh' for Query Refresh by default	Anand Deshpande	Setting up and Configuration of Excel	0	December 10th 06 04:47 AM
Query parameter "refresh when value changes" doesn't refresh - why	Texas_Toast	Excel Discussion (Misc queries)	0	January 4th 06 03:32 PM
Query Refresh-Enable Automatic Refresh Dialogue Box	Terri	Excel Discussion (Misc queries)	0	May 6th 05 08:21 PM
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False)	Anant[_2_]	Excel Programming	1	August 6th 03 04:22 AM
Web Query fail to Refresh All but individual refresh is ok	Karyn Mak	Excel Programming	2	July 17th 03 09:30 AM

All times are GMT +1. The time now is 12:19 AM.

Menu

About Us