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