View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edgar[_2_] Edgar[_2_] is offline
external usenet poster
 
Posts: 31
Default Help with Logon Information

Hello,

I need help with this.
When I try to open an Intranet WebPage as a workbook (With a macro), it
prompts me with a Logon account dialog box to provide UserId and password. I
provide the information and the macro runs ok. and opens the workbook.
Whats the string to already insert the userid and password, cause in
Workbooks.Open(FileName, UpdateLinks, ReadOnly, Format, Password,
WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable,
Notify, Converter, AddToMru, Local, CorruptLoad), there is no way to do it.

Maybe a Server connection string or a Ftp string. I don't know how to do it.

If anybody can help on this, I 'll be very apprecciated
--
Edgar Rey