Search found 79 matches

by winstein
Thu Jan 31, 2019 3:01 am
Forum: General Discussion
Topic: SFTP in Macro Scheduler
Replies: 2
Views: 468

SFTP in Macro Scheduler

In Macro Scheduler, there are functions for FTP based on what I have seen in the help file. Does Macro Scheduler support SFTP? If so, are there any differences between both FTP and SFTP in terms of how the code is written?

Thank you for reading.
by winstein
Wed Jun 06, 2018 8:06 am
Forum: Technical / Scripting
Topic: How to Remove AutoLogon User
Replies: 1
Views: 341

How to Remove AutoLogon User

I have installed the AutoLogon function to test the functionality, but now I want to remove the user since when I sign into the PC the default user is this AutoLogon user. How do I do that?

Thank you for reading.
by winstein
Tue Sep 26, 2017 10:04 am
Forum: Beginners
Topic: Using two Excel Book Handles at once
Replies: 2
Views: 1348

Re: Using two Excel Book Handles at once

Never mind, I found out the problem just now: it's the fact that the Excel is considered "unactivated", which means that when I open Excel, there would be a pop up stating to activate it.
by winstein
Mon Sep 25, 2017 10:42 am
Forum: Beginners
Topic: Using two Excel Book Handles at once
Replies: 2
Views: 1348

Using two Excel Book Handles at once

I am currently using two Excel workbook at once, but I ran into a problem: after I opened a second workbook, whenever I want to retrieve or write data on the first workbook, I got the error that the "Call was rejected by callee". Even if I closed the second workbook, I still cannot read/write data o...
by winstein
Fri Aug 18, 2017 7:47 am
Forum: Beginners
Topic: Check if Excel Sheet Exists
Replies: 2
Views: 1217

Check if Excel Sheet Exists

I am experiencing a problem now. I followed the code from a previous thread (Verify Excel Sheet), but I could get the results to return "True" if the Excel sheet exists. Is there anything that I have missed out in the code? (Ignore the MonthNumber function, because it will be used in another part of...
by winstein
Fri Aug 18, 2017 7:38 am
Forum: Beginners
Topic: Task Scheduler EXE without user login
Replies: 2
Views: 1130

Re: Task Scheduler EXE without user login

OK, got it. I am planning to compile another program to log into the server for the sole purpose of allowing the inside macro to run.
by winstein
Tue Aug 15, 2017 5:36 am
Forum: Beginners
Topic: Task Scheduler EXE without user login
Replies: 2
Views: 1130

Task Scheduler EXE without user login

There is a program that I have made that involves opening a designated program and then using keyboard commands on it, but the program is meant to run as a task in Task Scheduler. However, based on my testing, I found out that it will not run when the option "run whether user is logged on or not" wi...
by winstein
Wed Aug 02, 2017 10:46 am
Forum: Beginners
Topic: Determine if a file is open
Replies: 3
Views: 1591

Determine if a file is open

There is a certain application that I would like to check on whether the file is open. Basically the macro requires that this application is open before I do anything. Otherwise, I would put the message that the program is not open. What is the best way to approach this problem? Thank you for reading.
by winstein
Tue Jul 25, 2017 8:48 am
Forum: Beginners
Topic: Executing Macro Commands in Remote Desktop
Replies: 2
Views: 1619

Executing Macro Commands in Remote Desktop

Something I have recently found out is, when accessing Remote Desktop (RD), some of the commands are executed on the PC that is used to access the RD, but not within the RD itself. This means that commands like WaitWindowOpen or WaitWindowClosed will not work within the confines of the RD, even thou...
by winstein
Sun Jun 11, 2017 7:55 pm
Forum: Beginners
Topic: Get File List, including files in subfolders
Replies: 1
Views: 1470

Get File List, including files in subfolders

The GetFileList function is useful for getting the list of files within a particular folder, but what I want to do currently is to also look for certain files in sub-folders, so for example, I want to look for all PNG files in a designated folder and any folders within the folder. What is the best w...
by winstein
Fri May 19, 2017 11:41 am
Forum: Beginners
Topic: Attaching Image to Clipboard
Replies: 1
Views: 1339

Attaching Image to Clipboard

Is there any way to attach an image to the clipboard? Specifically, am I able to attach the filepath of the image into the clipboard so that I can paste it, such as in Paint?

Thanks for reading.
by winstein
Mon Apr 03, 2017 10:22 am
Forum: Beginners
Topic: Using IfDirExists or other Dir functions on Shared Folders
Replies: 1
Views: 1246

Using IfDirExists or other Dir functions on Shared Folders

When I tested the IfDirExists function on a shared folder path, like this: IfDirExists>\\192.168.1.0 MessageModal>I can access this server EndIf It will return the True indicator, even though the directory doesn't exist for the user. Is there a way to determine of a certain shared folder directory i...
by winstein
Tue Jan 24, 2017 7:42 am
Forum: Beginners
Topic: SQL DBExec - No Error Message Prompt
Replies: 1
Views: 1655

SQL DBExec - No Error Message Prompt

If I run a DBExec, and in the event that the SQL script has an error, how do I disable the error message so that the script can run till the end? The script is intended to be run at an interval, and there might be an event where an SQL data error could occur. Problem is, I don't want the error messa...
by winstein
Wed Aug 10, 2016 10:43 am
Forum: Beginners
Topic: Separate Command on New Line
Replies: 2
Views: 3768

Separate Command on New Line

When I want to separate a string by the amount of lines it has, what is the best way to do it? Currently, Separate is based on delimiters to determine the separation, but as far as I know, it's based on the character, which means that it's difficult to properly use a new line character. Thanks for r...
by winstein
Wed Aug 10, 2016 10:33 am
Forum: General Discussion
Topic: Separate Command on New Line
Replies: 1
Views: 2843

Separate Command on New Line

When I want to separate a string by the amount of lines it has, what is the best way to do it? Currently, Separate is based on delimiters to determine the separation, but as far as I know, it's based on the character, which means that it's difficult to properly use a new line character. Thanks for r...