Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some variables on my sheet which I want to use in my VBScript. How can I go about doing this?
Thanks,
T.
You can access a particular variable like this:
Set Test = Activedocument.Variables("Test") | |
MsgBox Test.GetContent.String |
Check out API guide to access variables into Macro.
You can access a particular variable like this:
Set Test = Activedocument.Variables("Test") | |
MsgBox Test.GetContent.String |
Hi Petter,
Is there a way to get the dimension that is being used as an axis in a chart? E.g. if I had Date as one of my dimensions could I swap that dimension with the other dimension i.e. swapping the X with the Y axis.
Thanks,
T
You still want to do this in a macro right?
Yeah ideally, currently what I have is a chart where the dimensions are defined by the user by using conditional expressions however I'm finding that sometimes the chart may look better if the axis are swapped. I currently have a button that does not trigger anything but I was thinking that it can be used to call a VBA module that swaps the axis.
Thanks,
T