Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On sites requiring a login, I've just used the Data New Web Query
process to login to the site manually. Once I've done that, the functions work fine. You may need to run the smfForceRecalculation macro once after loggin in, to empty out the saved web pages area. So far, I've only run into one site that required frequent logins. Most, I've done the login process once and been able to simply open my spreadsheets that access the site without needed to do it again. I decided not to add login processing to the add-in. Just as a general rule, I know I'm not fond of entering username and password into open spreadsheets or formulas that might be shared in one way or another. The manual login process still leaves YOU in control of the login process, not the add-in. And, like I said, since most require it only once, I haven't found it to be burdensome. On Jun 14, 4:21 pm, Maxi wrote: I installed the add-in and the RCHGetTableCell function is working fine.... beyond my imagination that even this can be done. However, it does not satisfy my criteria. When I type =RCHGetTableCell("http://mywebsite.com/page1.htm", 1,"Report Owner:"), it gives me "Error" because it will not go that page without proper authentication. In order to go to page1.htm, you have to get authenticated by thehttp://mywebsite.com/using a valid username and password. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IE Integration | Excel Programming | |||
IE integration | Excel Programming | |||
numerical integration | Excel Discussion (Misc queries) | |||
Outlook Integration | Excel Discussion (Misc queries) | |||
Maths-Integration | Excel Programming |