Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have problems with macro getting QV stuck (CTRL+ALT+DEL) ... while I get any answer or possible diagnoses about this... I'm trying to kill all macros at least behind buttons. I cannot change the button text but I can use two buttons one of which desappears alternatively.
In one case I have to assign to a variable a "formula" that in VBScript was like this:
oggiVar.SetContent "=MonthEnd(MakeDate(%Year,%Month))", true
If I try to do that with a string "xxx" using the Set Variable Action of the button it doesn't work (the variable is displayed as a text with the " only before ??)
If I try to do it omitting the quoting the expression is calculated beforehand so that it doesn't change with the %Year %Month variables later on (the variable is displayed as a fixed date).
How do you state that the function has to be taken LITERALLY?
Thanks Flavio
SIMPLER THAN I THOUGHT... tried this and it works?
Any better way - i.e. more explicit?
=Capitalize('=MonthEnd(MakeDate(%Year,%Month))')
SIMPLER THAN I THOUGHT... tried this and it works?
Any better way - i.e. more explicit?
=Capitalize('=MonthEnd(MakeDate(%Year,%Month))')