Hi,
I have data in excel. I can convert the data into CSV format and read the data from DS Job. A macro is being called in the excel. When DS job runs, excel macro should execute along with the job on the data and write the data to output (text) file.
Can anybody let me know how to call an excel macro from a DS Job?
Thanks..
How to call excel macro
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can it be made an "auto run" macro that runs when the workbook is opened? Can you invoke a macro as if it were a stored procedure? Just ideas - no idea if they will work.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.