topic Re: Set Date Value in a Variable VBScrpit in QlikView

Set Date Value in a Variable VBScrpit

Fri, 02 Dec 2011 17:46:05 GMT

How to turn this command in vbscript?

let vDate = Date(Now(), 'YYMMDD');

Set Date Value in a Variable VBScrpit

Fri, 02 Dec 2011 18:29:21 GMT

does anyone know? I need to finish the script today: (

Re: Set Date Value in a Variable VBScrpit

Fri, 02 Dec 2011 18:51:46 GMT

try with something like this:

sub X

v = ActiveDocument.Evaluate("=date(today(),'DD/MM/YYYY')")

ActiveDocument.Variables("vDate").SetContent v, true

end sub

then add action external to execute macro X

Hope this help you

Set Date Value in a Variable VBScrpit

Fri, 02 Dec 2011 19:51:48 GMT

this line.....

ActiveDocument.Variables("vDate").SetContent v, true

has some error is not working ...

Set Date Value in a Variable VBScrpit

Miguel_Angel_Baeyens — Fri, 02 Dec 2011 19:53:10 GMT

Hi,

Did you create the variable in the document? Settings menu, Variable Overview.

Regards,

Miguel

Set Date Value in a Variable VBScrpit

Fri, 02 Dec 2011 20:08:06 GMT

like this

v = today()

Re: Set Date Value in a Variable VBScrpit

Miguel_Angel_Baeyens — Fri, 02 Dec 2011 23:55:02 GMT

Hi,

ActiveDocument.Variables("vDate")

Refers to an actual variable that has to be created before getting a value. Go to the Settings menu, Variable Overview and Add a new one and call it vDate. Then the macro will work.

Regards,

Miguel

Re: Set Date Value in a Variable VBScrpit

Sat, 03 Dec 2011 00:37:38 GMT

it worked ....

How do I get the value of this variable and saved a excel document?

i try this

XLDoc.SaveAs "c:\Qlikview\Claro"&vDate&".xls"

Re: Set Date Value in a Variable VBScrpit

Sat, 03 Dec 2011 09:45:37 GMT

You have to get the variable value, so use:

XLDoc.SaveAs "c:\Qlikview\Claro"& ActiveDocument.Variables("vDate").GetContent.String &".xls"

Regards

Re: Set Date Value in a Variable VBScrpit

Sat, 03 Dec 2011 10:50:31 GMT

Excel displays an error .... like this

Excel can not access the file 'C: \ QlikView \ Claro03 \ 12 \ D5680000'. There are several possible reasons

Re: Set Date Value in a Variable VBScrpit

Miguel_Angel_Baeyens — Sat, 03 Dec 2011 11:35:42 GMT

Leo,

It's not a QlikView issue, is a basic operating system issue: paths in Windows cannot have special characters as "/" or "\". As simple as that. So change your variable format in the macro

v = ActiveDocument.Evaluate("=date(today(),'YYYYMMDD')")
ActiveDocument.Variables("vDate").SetContent v, true

Then save the file as you are already doing. The file name will look like "Claro20111203.xls" which is perfectly readable by the filesystem

Hope that helps.

Miguel

Re: Set Date Value in a Variable VBScrpit

Sat, 03 Dec 2011 11:48:04 GMT

Do you have Requested Module Security set to "System Access" and Current Local security set to "Allow System Access" ?

If so, add other variable call vDate2 and assign value: =date(vDate,'YYMMDD')

Then in your macro use:

vFile = ActiveDocument.Variables("vDate2").GetContent.String

XLDoc.SaveAs "c:\Qlikview\Claro"& vFile &".xls"

Hope this can help you.