I already tried that but it does not work. Does someone have another suggestion ? I know you can do it as I have already seen it.
On Jun 8, 6:20 pm, zheng yu <vincent2...@gmail.com> wrote: > You can simply use "record macro" and do all the process through,then you > get it in VBA. You can see the VBA code in VBE editor > > > > On Mon, Jun 8, 2009 at 2:36 PM, Philippe <lamy.phili...@gmail.com> wrote: > > > Hi, > > > here is my problem. I would like to click on a button in my worksheet > > and doing so opening a web query window with a given address. The aim > > is not to retrieve data but just to open the web querry window > > (without going to Data/Import External Data/New web query ... > > The button is there. It is just that I cannot find the Vba formula to > > open the window without importing any data. And I am not interested in > > opening my hyperlink in IE. > > > Thanks for your help.- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
