I have few reports which via Macros, dynamically creates and transfers folders/sub-folders and corresponding xls on LAN Location based on data available.
Ex. If 2 country codes say UK, USA are there and further city codes like NYK, LON, WSH etc are there then using Macro (scheduled in 6.5) it will create/modify folders with same names and transfer Country/city filtered data xls to corresponding folders. Also, if year changes say 2010 then automatically a new folder ‘2010’ will be created and then again subfolders.
How can I replace this Report (with Macro) in XI to work the same way it used to be in 6.5 ie- without using Macros how can I achieve this functionality using Publisher?
If you need further details then please do let me know.
Thanks! But looking at the topic you mentioned it doesn’t seem to solve my issue.
In our company we have been advised to totally get rid of Macros.
I have been told there is an alternative way of achieving this via Publisher but things are going blank for me.
Could you please suggest any alternative ways of what I need?
I haven’t had a whole lot of experience with Publisher, but I’m pretty sure that it won’t create dynamic directories for you. Only other option I can think of is to write a script and schedule it as a program object. But of course that’s custom coding, which it sounds like you are trying to avoid.
(BOB member since 2008-10-07)
(BOB member since 2002-08-29)