How can I ask a question that can't be described in a single sentence?
This is about running Firefox from within Excel 2000 using VBA coding.
I can open a website with Firefox using Excel 2000 VBA with the Shell "C:\Program Files\Mozilla Firefox\firefox.exe " & "http:\\www.website.com", vbMaximizedFocus statement. I can then manually press the Tab key several times to get to the Username and Password boxes. However if I use the SendKeys "{TAB}" statement instead, then I get "permission denied" error message. Any suggestions?
This is about running Firefox from within Excel 2000 using VBA coding.
I can open a website with Firefox using Excel 2000 VBA with the Shell "C:\Program Files\Mozilla Firefox\firefox.exe " & "http:\\www.website.com", vbMaximizedFocus statement. I can then manually press the Tab key several times to get to the Username and Password boxes. However if I use the SendKeys "{TAB}" statement instead, then I get "permission denied" error message. Any suggestions?
所有回复 (1)
I did find this http://vb.mvps.org/samples/SendInput/ via the Microsoft forum: http://social.msdn.microsoft.com/Foru.../vb6-sendkeys-doesnt-work?forum=windowsgeneraldevelopmentissues
Did this help?