Search results for query: *

Thanks Dave for your help. I am actually looking for fiscal week and not just week number which I can get the value on the fly. Oracle query is Select to_char(Sysdate,ww) from dual; I think i can get the value by executing the proc and receiving the value in macro. Can you pls tell me whether...

Yes Dave, I am trying the same. I want to get week value on the fly only. Is it possible in macro to read parameter value from some text file. I am still thinking to avoid array and hardcode the values. Instead looking for a solution which is more dynamic. Can you pls send looping code in...

Thanks Dave ! I think static array will not help as the second parameter is changing every week. Its like for 50 Vendors I have to create reports every week.So for each report the parameters will be the vendor code and the week number.Hence I cannot set the values in static array as week number...

Thanks Starg! Adding .MCX worked.

I am trying to run impromptu macro from command line using the steps below: 1. In the task bar, click Start, and click Run. 2. Browse for the file and click OK to return to the Run dialog box or type the fully qualified file name in the Open or Run box. 3. Type - m with the fully qualified file...

I have to automate creation of imr reports which takes two parameters and this has to run every week. I know macros can help in automating the creation of imr reports. But I have to create 50 reports (50 different parameters have to be passed) every week. I intend to use unix shell script which...