how to check document variable 1

[Ajaygupta]

Hi

please help me

problem- In one report I have created a variable -lastdayofmonth. I want to check this variable using macro. condition is " if lastdayofmonth=systemdate then msgbox "Please take a backup" or please save into xls file.
so that user can have a xls file every month for making the MIS reports for management.

rgs

ajay

 

[Sridharan]

Hi digatal1234,

Do you want to just display a messagebox based on the createdvariable????? Would help us to provide solutions if you can provide more details!!

Regards,
Sridharan

 

[Ajaygupta]

Dear Sridharan
I want to write a macro, in which I want to put condtion that for that-

I have createed one variable- let say x ( lastdayof month) in report itself

user is refreshing every day this report. throuhg macro I want to check if sysdate= x then data will automatic export in txt file.

rgs

 

[Sridharan]

Is that a report level variable or universe object????

 

[Ajaygupta]

sridharan

this a report level varibale

rgs

 

[Sridharan]

To access Document Variable in SDK use this..

Dim Variable as DocumentVariable
Dim Var as Variant

Set Variable = ThisDocument.DocumentVariables("Your Variable Name")
Var = Variable.Values(boUniqueValues)

MsgBox "Value Of The Variable : " & Var(1)

Hope you got some idea. Use that to do some If Then Else and take appropriate action.

Need more help, Drop a note.

Regards,
Sri

 

[Ajaygupta]

Hi,
Sridharan

thanks a ton,

hope you will also support me in future also.


rgs