Please Help

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
jlab13
Newbie
Posts: 5
Joined: Fri Apr 11, 2003 12:17 am

Please Help

Post by jlab13 » Fri Nov 21, 2003 12:26 am

I am running Win XP pro SP1, and Macro Scheduler 7.2.043

I am having a problem with the program all of the sudden. I have a basic Excel Spreadsheet which I have always accessed daily via a Hoy Key. Now it crashes the whole msched.exe. The only way I can get it back up is by rebooting. It won't even shut down via the Task Mngr.
The code is basic as follows:
Run Program>C:\Documents and Settings\John LaBriola\My Documents\PBook.xls

I've been running this program for many months problem free. I tried installing this latest version, but doesn't seem to have fixed the prob.

I haven't installed any software, or made any changes to my OS in several weeks. Any suggestions?

Only seems to happen w/.xls and .doc files. txt files work fine. The .xls and .doc files in question work fine on their own, prob just occurs through Msched.

Thanks in advance!

User avatar
support
Automation Wizard
Posts: 1450
Joined: Sat Oct 19, 2002 4:38 pm
Location: London
Contact:

Post by support » Fri Nov 21, 2003 11:54 am

Hi,

This doesn't explain why it used to work, but you're using the wrong command. If you want to open a file using it's file association then you should use ExecuteFile:

ExecuteFile>blablabla.xls

Using Run Program you would need to do:

Run Program>c:\blabla\excel.exe c:\blabla\my.xls

i.e with Run Program you should specify the executable with the filename on the command line. I'd go for the ExecuteFile method assuming your file associations are intact.
MJT Net Support
[email protected]

Guest

Post by Guest » Fri Nov 21, 2003 4:45 pm

sorry I screwed up the original msg. I am actually using the ExecuteFile command. The RunProgram command that I copied and pasted was just from me trying it out to see if it would work.

The ExecuteFile cmd is the line that is giving me the problem:


ExecuteFile>C:\Documents and Settings\John\Desktop\Test.xls

Thanks for any ideas.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts