According to my colleague, the cell returns the value instead of the formula. Meaning, I can't quite show you the code.

I am not sure why it happened, but if I were to speculate, the cell might be highlighted beforehand, showing the formula instead of the value.

My colleague is facing this problem. In Excel, certain cells might have formulas, which will in turn display the true value. How do you make it so that Macro Scheduler retrieves the cell value instead of the formula?

Thanks for reading.

(Topic previously found in the Beginners section) When I used the XLSetCell function to enter a date, if that Day and Month are both 12 or less, the system has a tendency to interpret my dates as Month/Day/Year format instead of the Day/Month/Year format. This is in spite of cell format being in the...

When I used the XLSetCell function to enter a date, if that Day and Month are both 12 or less, the system has a tendency to interpret my dates as Month/Day/Year format instead of the Day/Month/Year format. This is in spite of cell format being in the D/M/Y format. Here's a sample code (make sure the...

I want to be able to continue a program if a certain image is lost on the screen. With WaitScreenImage, the program will continue only after the image is found on the screen, but I want to perform a command where the program only continues if the image is gone. To be specific, I want to continue the...

Never mind about this one, I think. Basically what I wanted to do is to save each Mail Merge document separately into files, but I guess I could find a way to do it if it's possible. Not sure you know what Mail Merge is, but it's basically combining the information in a Word Document file with data ...

Mail Merge's function allows us to use an Excel file to insert date into a template, so I am wondering: what is the best way to save each record into different individual Word files?

Thanks for reading.

The script in which I will compile into a program will need to be run when a new file is added to a folder. Is there a way to do this? To put it this way, I want to run the program so that as soon as one file is generated, the existence of that file will in turn make this executable work. Thanks for...

That function does what I wanted it to do.

Thank you!

One of the Macros I worked on requires that I use a certain type of file in order to operate, but right now my colleague has this idea of retrieving said file on the internet, so used a website where a file is to be downloaded when you entered this link. Of course, it doesn't work because the ReadFi...

Two things: 1) In Macro Scheduler, there is a function called RenameFile, which is for, as it says, renaming a file. My question is, is there an equivalent function for renaming a folder? If yes, what's the function called? 2) When I copied a folder using CopyFolder, is there a way to rename the fol...

What I am attempting to do is that basically, I have an SQL file that I want to run in Macro Scheduler, but when I convert the file's contents into a Macro Scheduler script to run this file, there were some problems that prevented it from being run fully. Essentially what I want to do is: 1) Have an...

What I want to do currently, is to use DBExec to run a script from another file. I did use the ReadFile command to do it, since that's one way in extracting data. The problem is, as I have encountered, when comments are added into the mix. Essentially, based on my observation, comments are not skipp...

I saw that link, and then I also tried to enter parameters into an executable file (that is compiled). It works from what I see, but one thing I would like to know is, in case a certain parameter is omitted, how do I give it a default setting?

Ah, I see. Thank you for your advice.