LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 122
Default browser integration

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IE Integration [email protected] Excel Programming 0 April 24th 07 07:15 PM
IE integration [email protected] Excel Programming 0 April 24th 07 05:40 PM
numerical integration integreat Excel Discussion (Misc queries) 4 May 12th 06 02:40 AM
Outlook Integration Bdavis Excel Discussion (Misc queries) 0 April 14th 05 05:02 PM
Maths-Integration cigarette Excel Programming 4 July 27th 04 08:25 AM


All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"