Using Macro Scheduler with Microsoft Terminal Server

Tony Montgomery · Post by **Tony Montgomery** » Mon Nov 24, 2003 5:45 pm

I am a new user using the trial period for testing. I am able to accomplish most of the tasks that I am able to script but have following problem.

I am coping data from Excel into varibles then trying to send these varibles to an application running in a Microsoft Terminal Server environment.

I can open the TS window but Macro Scheduler will not write the data to the window fields. I receive no error msg.

How can I get Scheduler to write data to the TS application. Macro Scheduler is installed on the remote PC NOT on the server.

Tony

Lumumba · Post by **Lumumba** » Mon Nov 24, 2003 7:35 pm

Switch the TS console window to full screen (I guess the keys used for that are: CTRL+ALT+Break) and have another try.

If you have the permission to connect via TS you should have any kind of permission to work directly on the shared drive! So, write your Excel variables to an INI file on the remote box. eg. --> \\Server\SharedDrive\ExcelVars.ini

MacroScheduler should read it "localy" after the host has set the trigger (VarSet) to YES.

ExcelVars.ini

[Status]
VarSet=YES

[MyExcelVars]
A=
B=
C=

Yes I've done it! My 1st Linux posting