View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Keith is offline
external usenet poster
 
Posts: 262
Default FollowHyperlink Method

I am using the following code to open a webpage from a macro in excel

ActiveWorkbook.FollowHyperlink Address:="http://testserver/test.aspx",
ExtraInfo:="ID=1", Method:=msoMethodPost, NewWindow:=False

This code works fine when the workbook is opened within excel, however when
the workbook is opened within an Internet Explorer Window the aspx page does
not receive any post data and the page REQUEST_METHOD is set to GET.

I can use the following successfully but I really would like to hide the
parameter string from the user.

ActiveWorkbook.FollowHyperlink Address:="http://testserver/test.aspx?ID=1",
NewWindow:=False

Is there any way getting this functionality working within IE?