LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
KBL KBL is offline
external usenet poster
 
Posts: 3
Default (possibly) simple question about web controls

please pardon my newbishness... this is probably just something extremely
simple, but i've had NO luck finding out how to do this...

i've written code basically to have excel log into a website i use for my
job and do this and that... but the part where i'm getting stumped is when i
have excel use the code:



With appIE
sURL = "https://www.thewebsiteimaccessing.com/thereportineed"
.Navigate sURL
call ReadyWait 'waits for page to load
.Document.all("firstcriteriafield ").Value = "12"
.Document.all("secondcriteriafield").Value = "26"
.Document.all("thirdcriteriafield").Value = "8"

'******************
'Here is where I need the correct code to have
'it select multiple options from the criteria listbox
'******************

With .Document.all("fourthcriteriafield")
.Value = "41"
.Value = "177"
.value = "178"
End With

.Document.all("btnRetrieve").Click

End With



if i've not managed to make my request clear... basically, i'm trying to
find the code that will mimic ctrl+click in a multi-select listbox.

any help?





--
Oh, the creative possibilities! ^_^
 
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
Question Involving COUNTIF and Possibly DCOUNTA Roger Govier[_3_] Excel Worksheet Functions 0 July 31st 07 06:32 PM
Question Involving COUNTIF and Possibly DCOUNTA PCLIVE Excel Worksheet Functions 0 July 31st 07 06:31 PM
Question Involving COUNTIF and Possibly DCOUNTA T. Valko Excel Worksheet Functions 0 July 31st 07 06:28 PM
Possibly a loaded question, but I think mileslit Excel Discussion (Misc queries) 1 September 10th 05 01:18 AM
Learning Macros and ActiveX controls...have a simple question... bizechick Excel Programming 1 November 12th 04 06:45 PM


All times are GMT +1. The time now is 06:59 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"