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.
Search found 84 matches
- Wed Mar 23, 2016 4:21 am
- Forum: Beginners
- Topic: Getting Value in Excel Cell instead of Formula
- Replies: 2
- Views: 4929
- Mon Mar 21, 2016 7:03 am
- Forum: Beginners
- Topic: Getting Value in Excel Cell instead of Formula
- Replies: 2
- Views: 4929
Getting Value in Excel Cell instead of Formula
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.
Thanks for reading.
- Mon Mar 21, 2016 7:02 am
- Forum: Technical / Scripting
- Topic: Entering Date Correctly in Excel
- Replies: 1
- Views: 2428
Entering Date Correctly in Excel
(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...
- Tue Feb 16, 2016 11:55 am
- Forum: Beginners
- Topic: Entering Date Correctly in Excel
- Replies: 1
- Views: 3431
Entering Date Correctly in Excel
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...
- Tue Dec 22, 2015 9:16 am
- Forum: Beginners
- Topic: Reverse Wait Screen Image
- Replies: 2
- Views: 3584
Reverse Wait Screen Image
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...
- Tue Dec 22, 2015 9:14 am
- Forum: Beginners
- Topic: Mail Merge to save each file separately
- Replies: 2
- Views: 3532
Re: Mail Merge to save each file separately
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 ...
- Wed Dec 16, 2015 10:10 am
- Forum: Beginners
- Topic: Mail Merge to save each file separately
- Replies: 2
- Views: 3532
Mail Merge to save each file separately
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.
Thanks for reading.
- Thu Dec 03, 2015 9:08 am
- Forum: Beginners
- Topic: Trigger Program on Certain Occasions
- Replies: 1
- Views: 2742
Trigger Program on Certain Occasions
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...
- Tue Dec 01, 2015 5:22 am
- Forum: Beginners
- Topic: Retrieving Files from the Internet
- Replies: 2
- Views: 3638
Re: Retrieving Files from the Internet
That function does what I wanted it to do.
Thank you!
Thank you!
- Mon Nov 30, 2015 2:58 am
- Forum: Beginners
- Topic: Retrieving Files from the Internet
- Replies: 2
- Views: 3638
Retrieving Files from the Internet
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...
- Mon Aug 03, 2015 2:02 am
- Forum: Beginners
- Topic: Renaming a Folder
- Replies: 2
- Views: 3825
Renaming a Folder
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...
- Mon Aug 03, 2015 1:59 am
- Forum: Beginners
- Topic: Running an SQL Script
- Replies: 4
- Views: 4569
Re: Running an SQL Script
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...
- Thu Jul 16, 2015 8:20 am
- Forum: Beginners
- Topic: Running an SQL Script
- Replies: 4
- Views: 4569
Running an SQL Script
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...
- Tue Jul 22, 2014 8:18 am
- Forum: Beginners
- Topic: Parameters with Macro Application
- Replies: 3
- Views: 4507
Re: Parameters with Macro Application
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?
- Tue Jul 22, 2014 8:04 am
- Forum: Beginners
- Topic: Returning Day of Week based on Date
- Replies: 3
- Views: 4284
Re: Returning Day of Week based on Date
Ah, I see. Thank you for your advice.