Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sendkeys, sending variable
Trying to use a find dialog to do a generic screen scrape, but when I try to
pass beta as a string, I get an error "invalid procedure or call". I also tried "" & beta and a few other configurations. How can I accomplish this? Thank you. Dim beta As String beta = "ext.(" & Format(Month(Date), "00") & "-" & Format(Day(Date), "00") & "- " & Format(Year(Date), "0000") AppActivate "FIND", False SendKeys beta, True |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sendkeys, sending variable
Brent,
Not sure how a screen scrape involves a certain word. What is "FIND" ? If it is not another application's title then this will not work. Check the help for AppActivate. Do you mean to use the EditFind functionality ? Is so, record a macro whilst performing a search to get the code. NickHK "Brent" wrote in message ... Trying to use a find dialog to do a generic screen scrape, but when I try to pass beta as a string, I get an error "invalid procedure or call". I also tried "" & beta and a few other configurations. How can I accomplish this? Thank you. Dim beta As String beta = "ext.(" & Format(Month(Date), "00") & "-" & Format(Day(Date), "00") & "- " & Format(Year(Date), "0000") AppActivate "FIND", False SendKeys beta, True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SendKeys variable | Excel Programming | |||
SendKeys Help | Excel Programming | |||
Sending Variable Via E-Mail | Excel Programming | |||
Sending variable data to a web site to be computed then brought back to Excel | Excel Programming | |||
Sendkeys | Excel Programming |