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. > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
