The following code: Dim objshell As Object Set objshell = CreateObject("Shell.Application") objshell.Open "http://www.google.com/" runs fine in most machines in my office, but a few machines display the error message: "Application not found" on executing line 3. There is no difference in the configuration of all machines, as all of them are installed with Win XP and Office XP. Suggestions to solve the issue would be most appreciated.
Robot, I would try to compare references enabled between machines, in the VBA Editor menu Tools/References... > The following code: > > Dim objshell As Object > Set objshell = CreateObject("Shell.Application") > objshell.Open "http://www.google.com/" > > runs fine in most machines in my office, but a few machines display the > error message: > "Application not found" on executing line 3. > > There is no difference in the configuration of all machines, as all of them > are installed with Win XP and Office XP. > > Suggestions to solve the issue would be most appreciated. > > > -- Russ drsmN0SPAMikleAThotmailD0Tcom.INVALID
Hi Russ, I compared the enabled references and could find no difference. "Russ" <drsN0SPAMmikle@hotmailD0Tcom.INVALID> ???????:C34F86D1.1EAFC%drsN0SPAMmikle@hotmailD0Tcom.INVALID... > Robot, > I would try to compare references enabled between machines, in the VBA > Editor menu Tools/References... > >> The following code: >> >> Dim objshell As Object >> Set objshell = CreateObject("Shell.Application") >> objshell.Open "http://www.google.com/" >> >> runs fine in most machines in my office, but a few machines display the >> error message: >> "Application not found" on executing line 3. >> >> There is no difference in the configuration of all machines, as all of >> them >> are installed with Win XP and Office XP. >> >> Suggestions to solve the issue would be most appreciated. >> >> >> > > -- > Russ > > drsmN0SPAMikleAThotmailD0Tcom.INVALID >
Robot, It is as if there is no application associated with opening a webpage on those machines. What happens if you type that url into Windows Explorer (not Internet Explorer)? > Hi Russ, > > I compared the enabled references and could find no difference. > > "Russ" <drsN0SPAMmikle@hotmailD0Tcom.INVALID> > ???????:C34F86D1.1EAFC%drsN0SPAMmikle@hotmailD0Tcom.INVALID... >> Robot, >> I would try to compare references enabled between machines, in the VBA >> Editor menu Tools/References... >> >>> The following code: >>> >>> Dim objshell As Object >>> Set objshell = CreateObject("Shell.Application") >>> objshell.Open "http://www.google.com/" >>> >>> runs fine in most machines in my office, but a few machines display the >>> error message: >>> "Application not found" on executing line 3. >>> >>> There is no difference in the configuration of all machines, as all of >>> them >>> are installed with Win XP and Office XP. >>> >>> Suggestions to solve the issue would be most appreciated. >>> >>> >>> >> >> -- >> Russ >> >> drsmN0SPAMikleAThotmailD0Tcom.INVALID >> > > -- Russ drsmN0SPAMikleAThotmailD0Tcom.INVALID
