Attach a web query inside a file

[laticsforlife]

I have a spreadsheet saved on a work server (so has a strange drive letter or location)

and on the same server I have a saved web query that I have linked to the file so when it is opened it runds the query (by macro) and pulls the data.

But that means I cannot send the file out to the ouside world as the reference to the web query would not relate.

Is there a VBA way of actually having the web query inside of that particular file rather than saved seperately?

 

[laticsforlife]

I think I've partially found an answer, but the layout is a bit harder to understand.

In my macro it says

ActiveSheet.QueryTables.Add(Connection:="FINDER;\\myserver\FF\tfflist.iqy"

and I think I need to replace the FINDER part with a url, but the syntax is beating me.

The webpage wont alter so any examples provided can simply use www.bing.com as an example.

Any help greatly appreciated.

 

[John_w]

Create a web query with the macro recording running to generate the VBA code which will show you the necessary syntax.