Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 28th 04, 05:46 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 56
Default Shell command stopped working: is it part of Excel 95 , or Windows?

Hi - we are testing a product on a variety of platfoms, including an
Excel version 7.0 (95) version. On machine A , running Windows XP, it
works fine. On Machine B also under XP, nothing happens when we call
the Shell, so we probably need to reinstall something.

But is that Excel 95, or Windows XP ?

TIA _ Charles

  #2   Report Post  
Old April 28th 04, 06:17 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 244
Default Shell command stopped working: is it part of Excel 95 , or Windows?

Did you check to see if there is a reference to The Shell object library

----- Charles Jordan wrote: ----

Hi - we are testing a product on a variety of platfoms, including a
Excel version 7.0 (95) version. On machine A , running Windows XP, i
works fine. On Machine B also under XP, nothing happens when we cal
the Shell, so we probably need to reinstall something

But is that Excel 95, or Windows XP

TIA _ Charle

  #3   Report Post  
Old April 28th 04, 06:44 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default Shell command stopped working: is it part of Excel 95 , or Windows?

Shell is part of VBA.

I don't know what object library Chris is talking about. Perhaps he could
elaborate.


I suspect you have error suppression in place and whatever you are shelling
to doesn't exist or isn't accessible on the machine where the failure
occurs.
--
Regards,
Tom Ogilvy

"Charles Jordan" wrote in message
om...
Hi - we are testing a product on a variety of platfoms, including an
Excel version 7.0 (95) version. On machine A , running Windows XP, it
works fine. On Machine B also under XP, nothing happens when we call
the Shell, so we probably need to reinstall something.

But is that Excel 95, or Windows XP ?

TIA _ Charles



  #4   Report Post  
Old April 28th 04, 07:06 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 244
Default Shell command stopped working: is it part of Excel 95 , or Windows?

I was referring to the Microsoft Shell Controls and Automation
  #5   Report Post  
Old April 28th 04, 08:51 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default Shell command stopped working: is it part of Excel 95 , or Windows?

Shell is a native command to VBA/VB

It is possible they are using that library, but seems unlikely. One never
knows. Seems if that were the case, rather than nothing happens, they would
get a missing library error message.

--
Regards,
Tom Ogilvy

"chris" wrote in message
...
I was referring to the Microsoft Shell Controls and Automation





  #6   Report Post  
Old April 29th 04, 11:58 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 56
Default Shell command stopped working: is it part of Excel 95 , or Windows?

"Tom Ogilvy" wrote in message ...
Shell is a native command to VBA/VB

It is possible they are using that library, but seems unlikely. One never
knows. Seems if that were the case, rather than nothing happens, they would
get a missing library error message.


Tom thanks.
On machine A, it works under XP with no references to any library set
up .
On machine B, (again, XP, no references), it bombs with "Invalid
procedure call" at the line containing the Shell command. The .htm
file IS there, in the correct folder.

Where please can I find the setting or switch for "error suppression
in place " ?? We've not heard of it.

Our code is below this. Any more ideas ? Personally, I suspect that
the Excel 95 installation may have been corrupted, so if I reinstall
XL 95, have I then got to also reinstall Excel 2003 ? (which we need
on the same machine)

Thanks Charles

Sub NewOpenHTM()
Dim XX As Long
On Error Resume Next

Range("URL").Value = Range("Rootpath").Value & MyHtmpath & "\"
& ChosenHTMtext & ""

If Range("VersionNo").Value < 8 Then 'Excel version number
XX = Shell("start " & Range("URL").Value, 2)
MsgBox XX
Exit Sub
Else
ActiveDialog.Focus =
ActiveDialog.Buttons("ForwardButton").Name
Application.Run "V9addin.xla!GetTheHtm"
Exit Sub
End If
End Sub
'-----------------------------------
  #7   Report Post  
Old May 1st 04, 05:02 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 56
Default Shell command stopped working: is it part of Excel 95 , or Windows?

(Charles Jordan) wrote in message . com...
"Tom Ogilvy" wrote in message ...
Shell is a native command to VBA/VB

It is possible they are using that library, but seems unlikely. One never
knows. Seems if that were the case, rather than nothing happens, they would
get a missing library error message.


Tom thanks.
On machine A, it works under XP with no references to any library set
up .
On machine B, (again, XP, no references), it bombs with "Invalid
procedure call" at the line containing the Shell command. The .htm
file IS there, in the correct folder.

Where please can I find the setting or switch for "error suppression
in place " ?? We've not heard of it.

Our code is below this. Any more ideas ? Personally, I suspect that
the Excel 95 installation may have been corrupted, so if I reinstall
XL 95, have I then got to also reinstall Excel 2003 ? (which we need
on the same machine)

Thanks Charles

Sub NewOpenHTM()
Dim XX As Long
On Error Resume Next

Range("URL").Value = Range("Rootpath").Value & MyHtmpath & "\"
& ChosenHTMtext & ""

If Range("VersionNo").Value < 8 Then 'Excel version number
XX = Shell("start " & Range("URL").Value, 2)
MsgBox XX
Exit Sub
Else
ActiveDialog.Focus =
ActiveDialog.Buttons("ForwardButton").Name
Application.Run "V9addin.xla!GetTheHtm"
Exit Sub
End If
End Sub
'-----------------------------------



Tom Ogilvy - I don't know if you are on line, but

(1) will I do any harm if I reinstall Excel 95 on top of Excel 2003 ?

(2) Do we need any references to a library as Chris has suggested ?

Thanks - Charles
  #8   Report Post  
Old May 1st 04, 03:54 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default Shell command stopped working: is it part of Excel 95 , or Windows?

If Range("VersionNo").Value < 8 Then 'Excel version number
XX = Shell("start " & Range("URL").Value, 2)
MsgBox XX
Exit Sub
Else

Would require that you have an application associated with the extension of
your file spec in Range("URL")

If not, then start wouldn't know what application to start. If that is the
case, it has nothing to do with reinstalling xl95

You don't need any libraries beyond VBA to sue the Shell command.

You said nothing happens. In my test:

Sub Tester9()
XX = Shell("start myfile.yyy", 2)
MsgBox XX

End Sub

Msgbox comes up with a number, but no application is started. I don't know
if that is what you are getting. (there is no application associated with
..yyy).

When multiple copies of Excel are installed, it is recommended by microsoft
that they be installed from oldest to newest. I can't tell you whether it
would be problematic to reinstall xl95, but I don't see any reason to do it.

--
Regards,
Tom Ogilvy



"Charles Jordan" wrote in message
om...
(Charles Jordan) wrote in message

. com...
"Tom Ogilvy" wrote in message

...
Shell is a native command to VBA/VB

It is possible they are using that library, but seems unlikely. One

never
knows. Seems if that were the case, rather than nothing happens, they

would
get a missing library error message.


Tom thanks.
On machine A, it works under XP with no references to any library set
up .
On machine B, (again, XP, no references), it bombs with "Invalid
procedure call" at the line containing the Shell command. The .htm
file IS there, in the correct folder.

Where please can I find the setting or switch for "error suppression
in place " ?? We've not heard of it.

Our code is below this. Any more ideas ? Personally, I suspect that
the Excel 95 installation may have been corrupted, so if I reinstall
XL 95, have I then got to also reinstall Excel 2003 ? (which we need
on the same machine)

Thanks Charles

Sub NewOpenHTM()
Dim XX As Long
On Error Resume Next

Range("URL").Value = Range("Rootpath").Value & MyHtmpath & "\"
& ChosenHTMtext & ""

If Range("VersionNo").Value < 8 Then 'Excel version number
XX = Shell("start " & Range("URL").Value, 2)
MsgBox XX
Exit Sub
Else
ActiveDialog.Focus =
ActiveDialog.Buttons("ForwardButton").Name
Application.Run "V9addin.xla!GetTheHtm"
Exit Sub
End If
End Sub
'-----------------------------------



Tom Ogilvy - I don't know if you are on line, but

(1) will I do any harm if I reinstall Excel 95 on top of Excel 2003 ?

(2) Do we need any references to a library as Chris has suggested ?

Thanks - Charles



  #9   Report Post  
Old May 4th 04, 06:39 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 56
Default Shell command stopped working: is it part of Excel 95 , or Windows?

"Tom Ogilvy" wrote in message ...
If Range("VersionNo").Value < 8 Then 'Excel version number
MsgBox XX

Exit Sub
Else

Would require that you have an application associated with the extension of
your file spec in Range("URL")

If not, then start wouldn't know what application to start. If that is the
case, it has nothing to do with reinstalling xl95

You don't need any libraries beyond VBA to sue the Shell command.

You said nothing happens. In my test:

Sub Tester9()
XX = Shell("start myfile.yyy", 2)
MsgBox XX

End Sub

Msgbox comes up with a number, but no application is started. I don't know
if that is what you are getting. (there is no application associated with
.yyy).

When multiple copies of Excel are installed, it is recommended by microsoft
that they be installed from oldest to newest. I can't tell you whether it
would be problematic to reinstall xl95, but I don't see any reason to do it.

--
Regards,
Tom Ogilvy


Tom thanks -
XX = Shell("start " & Range("URL").Value, 2)

Range("URL").value reads C:\Data\Htm\Chapter4Text.htm, and it all
fires up just fine with that code on Machine A so either we are
missing a library reference, or the XL95 installation is corrupted,
hnce my suggestion of reinstalling. But please could you let us
whether the above *code* looks OK ? and if not what extra should it
contain ?

Thanks Charles







"Charles Jordan" wrote in message
om...
(Charles Jordan) wrote in message

. com...
"Tom Ogilvy" wrote in message

...
Shell is a native command to VBA/VB

It is possible they are using that library, but seems unlikely. One

never
knows. Seems if that were the case, rather than nothing happens, they

would
get a missing library error message.

Tom thanks.
On machine A, it works under XP with no references to any library set
up .
On machine B, (again, XP, no references), it bombs with "Invalid
procedure call" at the line containing the Shell command. The .htm
file IS there, in the correct folder.

Where please can I find the setting or switch for "error suppression
in place " ?? We've not heard of it.

Our code is below this. Any more ideas ? Personally, I suspect that
the Excel 95 installation may have been corrupted, so if I reinstall
XL 95, have I then got to also reinstall Excel 2003 ? (which we need
on the same machine)

Thanks Charles

Sub NewOpenHTM()
Dim XX As Long
On Error Resume Next

Range("URL").Value = Range("Rootpath").Value & MyHtmpath & "\"
& ChosenHTMtext & ""

If Range("VersionNo").Value < 8 Then 'Excel version number
XX = Shell("start " & Range("URL").Value, 2)
MsgBox XX
Exit Sub
Else
ActiveDialog.Focus =
ActiveDialog.Buttons("ForwardButton").Name
Application.Run "V9addin.xla!GetTheHtm"
Exit Sub
End If
End Sub
'-----------------------------------



Tom Ogilvy - I don't know if you are on line, but

(1) will I do any harm if I reinstall Excel 95 on top of Excel 2003 ?

(2) Do we need any references to a library as Chris has suggested ?

Thanks - Charles

  #10   Report Post  
Old May 4th 04, 06:39 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2003
Posts: 56
Default Shell command stopped working: is it part of Excel 95 , or Windows?

"Tom Ogilvy" wrote in message ...
If Range("VersionNo").Value < 8 Then 'Excel version number
MsgBox XX

Exit Sub
Else

Would require that you have an application associated with the extension of
your file spec in Range("URL")

If not, then start wouldn't know what application to start. If that is the
case, it has nothing to do with reinstalling xl95

You don't need any libraries beyond VBA to sue the Shell command.

You said nothing happens. In my test:

Sub Tester9()
XX = Shell("start myfile.yyy", 2)
MsgBox XX

End Sub

Msgbox comes up with a number, but no application is started. I don't know
if that is what you are getting. (there is no application associated with
.yyy).

When multiple copies of Excel are installed, it is recommended by microsoft
that they be installed from oldest to newest. I can't tell you whether it
would be problematic to reinstall xl95, but I don't see any reason to do it.

--
Regards,
Tom Ogilvy


Tom thanks -
XX = Shell("start " & Range("URL").Value, 2)

Range("URL").value reads C:\Data\Htm\Chapter4Text.htm, and it all
fires up just fine with that code on Machine A so either we are
missing a library reference, or the XL95 installation is corrupted,
hnce my suggestion of reinstalling. But please could you let us
whether the above *code* looks OK ? and if not what extra should it
contain ?

Thanks Charles







"Charles Jordan" wrote in message
om...
(Charles Jordan) wrote in message

. com...
"Tom Ogilvy" wrote in message

...
Shell is a native command to VBA/VB

It is possible they are using that library, but seems unlikely. One

never
knows. Seems if that were the case, rather than nothing happens, they

would
get a missing library error message.

Tom thanks.
On machine A, it works under XP with no references to any library set
up .
On machine B, (again, XP, no references), it bombs with "Invalid
procedure call" at the line containing the Shell command. The .htm
file IS there, in the correct folder.

Where please can I find the setting or switch for "error suppression
in place " ?? We've not heard of it.

Our code is below this. Any more ideas ? Personally, I suspect that
the Excel 95 installation may have been corrupted, so if I reinstall
XL 95, have I then got to also reinstall Excel 2003 ? (which we need
on the same machine)

Thanks Charles

Sub NewOpenHTM()
Dim XX As Long
On Error Resume Next

Range("URL").Value = Range("Rootpath").Value & MyHtmpath & "\"
& ChosenHTMtext & ""

If Range("VersionNo").Value < 8 Then 'Excel version number
XX = Shell("start " & Range("URL").Value, 2)
MsgBox XX
Exit Sub
Else
ActiveDialog.Focus =
ActiveDialog.Buttons("ForwardButton").Name
Application.Run "V9addin.xla!GetTheHtm"
Exit Sub
End If
End Sub
'-----------------------------------



Tom Ogilvy - I don't know if you are on line, but

(1) will I do any harm if I reinstall Excel 95 on top of Excel 2003 ?

(2) Do we need any references to a library as Chris has suggested ?

Thanks - Charles



Reply
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
Excel Files Stopped working in windows 7 vamsi Excel Discussion (Misc queries) 0 February 24th 10 06:46 AM
xp shell command using vba Sudhendra Excel Programming 2 February 16th 04 06:56 AM
Writing Command Shell (stdOut) to Excel Cells Ryan Waltz Excel Programming 0 January 28th 04 11:52 PM
WindowStyle not working in shell command KLC Excel Programming 1 November 10th 03 11:10 PM
SHELL command Robin Clay[_3_] Excel Programming 3 October 17th 03 02:50 PM


All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017