Windows 10: Task Scheduler with Windows OLE Excel

Hi,


I got the code block in Perl below. I can run via Command and get the output result.

When I add a Task Scheduler via my Remote Desktop machine and I'm not getting any result.

I have Administrator on this system and below is my setting.


I did some search and folks said that these 2 folders need to create. I went ahead and create if it doesn't exist, it exists now but the script still doesn't output result.



C:\Windows\System32\config\systemprofile\Desktop

C:\Windows\SysWOW64\config\systemprofile\Desktop


I trigger the task manual and no result either. Any one has a solution for this?










use strict;

use warnings;

use Win32::OLE;

use Win32::OLE qwin with;

use Win32::OLE::Const 'Microsoft Excel';



my $rand = intrand1000;

my $output_file = "C:\\JSL\\test_".$rand.".xls";



my $EXCEL = Win32::OLE->new"Excel.Application","Quit";

$EXCEL->{"Visible"} = 1;

$EXCEL->{DisplayAlerts}= 0;

my $Workbook = $EXCEL -> Workbooks -> Add;

my $sheet = $Workbook -> Worksheets1;

$sheet->Range"A1"->{Value} = $rand;

$Workbook -> SaveAs$output_file;

$Workbook -> Save;

$EXCEL->Quit;


my $jmp = Win32::OLE->new'JMP.Application';

$jmp->{'Visible'}= 1;


my $dt = $jmp->NewDataTable"test_jmp.jmp";

my $col = $dt->NewColumn"Col1", 1, 0, 8;

$dt->Save"C:\\JSL\\test.jmp";

$jmp->Quit;


Win32::OLE->FreeUnusedLibraries;

:)

 

[SOLVED] Schedule Tasks not able to open excel file

When I setup a scheduled task within window 7, it works fine and open an excel file, but when I do the same setting under window 10, it can open excel application, but not able to open excel file.

I have double checked on both PC and confirm those scheduled settings are correct.

Does anyone have any suggestions on what wrong setting is?

Thanks in advance for any suggestions

Original post for Excel Forum:

https://answers.microsoft.com/en-us...cel-file/73bec2ad-e3e9-43c6-bfb0-985c1645a9d3

 

Window's Task Scheduler Not Running

Hi,

To assist you better, kindly provide us more details by answering the following questions:

• Have you tried recreating the task? If so, are you getting the same issue?
• Have you tried creating a new task?

Meanwhile, we suggest that you ensure that the Task Scheduler is running. You can verify if the service is running by following these steps:

• Press Windows key + R on your keyboard.
• Type services.msc and hit Enter.
• Under Services (Local), make sure that the Task Scheduler service's status is
  Started or Enabled.

Should you need further assistance, feel free to get back to us.

 

[SOLVED] Schedule Tasks not able to open excel file

Could you please describe more on how to check the right?

Scheduled task is run under user account on both window 7 & 10.

The schedule setting under window 10 is same as under window 7, under window 7, schedule task can be run without any problem, but under window 10, it only open excel application and fail to open file.

Do you have any suggestions on what wrong it is?

Thank you very much for any suggestions (^v^)