View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Laurent Laurent is offline
external usenet poster
 
Posts: 16
Default pick up a value in MOSS 2007 with a macro inExcel 2007

Hi Joel,
unfortunatly it s not working... I can open a webquery and give the address.
than I ma chosing the yellow arrow corresponding to the column I m Looking
for and than nothing except e text in Excel ( in German... : IndexMit
UMSCHALT+EINGABETASTE öffnen Sie das Menü (neues Fenster). )
means something like "IndexMit shift + enter open the menu ( new window ))

I do not know what can I do ?..

BEst regards


"Joel" wrote:

Not all webpages support webqueries. but if yours does then do the following
from the worksheet (record a macro if you need one).

Data - Import External Data - New Webquery

Then put the URL in the address box of the query and press GO. If your page
support a query the press the Arrow with the yellow background for the table
you want the data. Next press the Import Button.