Running Macro and save using variable value 1

[Ajaygupta]

Hi

I am refresing one report use using sysdate as variable x, and exporting into text file. I want when ever report refresh it should save the <x>.txt, where x = now()

rgs

 

[skrandel]

You'll have to write a VBA macro to do this.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[Ajaygupta]

skrandel

hi,

I have doing all this by using macro.
dim x
x=now()

i am call after refresh event. then i am calling
call activedocument.exportastext(.................)
but the problem in exportastext properties the file same should be string. how I can save as varival(x).


rgs

 

[tonymccallion]

Hi,

Try:
Dim x As String
x = CStr(Now())

Tony

 

[Sridharan]

Look here thread393-770325 for the thread you started for the same question and response has been given there.

Sri