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.
Getting Value in Excel Cell instead of Formula
Moderators: Dorian (MJT support), JRL
-
Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: Getting Value in Excel Cell instead of Formula
Hi,
What method are you using to retrieve data from Excel? Using the built in XLGetCell function the value is returned, not the formula, so I guess you must be using some other method? Maybe share your code.
What method are you using to retrieve data from Excel? Using the built in XLGetCell function the value is returned, not the formula, so I guess you must be using some other method? Maybe share your code.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
Re: Getting Value in Excel Cell instead of Formula
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.
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.
PPQ
