G
Guest
How can I import data from a Web page that has a security login? (I know how to use Web Queries - they work on web pages that doesn't require password login)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
jaf
Hi Aura,
Record a macro while accessing the secure page and you will see that Excel
creates a field for the password.
--
John
johnf 202 at hotmail dot com
| How can I import data from a Web page that has a security login? (I know
how to use Web Queries - they work on web pages that doesn't require
password login)
Record a macro while accessing the secure page and you will see that Excel
creates a field for the password.
--
John
johnf 202 at hotmail dot com
| How can I import data from a Web page that has a security login? (I know
how to use Web Queries - they work on web pages that doesn't require
password login)
D
Don Guillett
xphome& xl2002. I just tried recording a macro while using data>create web
query>giving my user name and password. When I tried to do it from the macro
it failed. On pressing the IMPORT key, "unable to open" message. Here are
the only fields created.
..Name = "BkMainMenu"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
query>giving my user name and password. When I tried to do it from the macro
it failed. On pressing the IMPORT key, "unable to open" message. Here are
the only fields created.
..Name = "BkMainMenu"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
J
jaf
http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&selm=VA.000003bc.09855b3f@mars
--
John
johnf 202 at hotmail dot com
| xphome& xl2002. I just tried recording a macro while using data>create web
| query>giving my user name and password. When I tried to do it from the
macro
| it failed. On pressing the IMPORT key, "unable to open" message. Here are
| the only fields created.
|
| .Name = "BkMainMenu"
| .FieldNames = True
| .RowNumbers = False
| .FillAdjacentFormulas = False
| .PreserveFormatting = True
| .RefreshOnFileOpen = False
| .BackgroundQuery = True
| .RefreshStyle = xlInsertDeleteCells
| .SavePassword = False
| .SaveData = True
| .AdjustColumnWidth = True
| .RefreshPeriod = 0
| .WebSelectionType = xlEntirePage
| .WebFormatting = xlWebFormattingNone
| .WebPreFormattedTextToColumns = True
| .WebConsecutiveDelimitersAsOne = True
| .WebSingleBlockTextImport = False
| .WebDisableDateRecognition = False
| .WebDisableRedirections = False
| .Refresh BackgroundQuery:=False
|
|
| --
| Don Guillett
| SalesAid Software
| (e-mail address removed)
| | > Hi Aura,
| > Record a macro while accessing the secure page and you will see that
Excel
| > creates a field for the password.
| >
| >
| >
| > --
| > John
| > johnf 202 at hotmail dot com
| >
| >
| > | > | How can I import data from a Web page that has a security login? (I
know
| > how to use Web Queries - they work on web pages that doesn't require
| > password login)
| >
| >
|
|
--
John
johnf 202 at hotmail dot com
| xphome& xl2002. I just tried recording a macro while using data>create web
| query>giving my user name and password. When I tried to do it from the
macro
| it failed. On pressing the IMPORT key, "unable to open" message. Here are
| the only fields created.
|
| .Name = "BkMainMenu"
| .FieldNames = True
| .RowNumbers = False
| .FillAdjacentFormulas = False
| .PreserveFormatting = True
| .RefreshOnFileOpen = False
| .BackgroundQuery = True
| .RefreshStyle = xlInsertDeleteCells
| .SavePassword = False
| .SaveData = True
| .AdjustColumnWidth = True
| .RefreshPeriod = 0
| .WebSelectionType = xlEntirePage
| .WebFormatting = xlWebFormattingNone
| .WebPreFormattedTextToColumns = True
| .WebConsecutiveDelimitersAsOne = True
| .WebSingleBlockTextImport = False
| .WebDisableDateRecognition = False
| .WebDisableRedirections = False
| .Refresh BackgroundQuery:=False
|
|
| --
| Don Guillett
| SalesAid Software
| (e-mail address removed)
| | > Hi Aura,
| > Record a macro while accessing the secure page and you will see that
Excel
| > creates a field for the password.
| >
| >
| >
| > --
| > John
| > johnf 202 at hotmail dot com
| >
| >
| > | > | How can I import data from a Web page that has a security login? (I
know
| > how to use Web Queries - they work on web pages that doesn't require
| > password login)
| >
| >
|
|
D
Don Guillett
Nope. Maybe with
http but it didn't work with https
http but it didn't work with https