cancel
Showing results for 
Search instead for 
Did you mean: 

Executing a Macro from BODS

ugjust
Explorer
0 Kudos
392

We have an BODS Job that loads data from various Excel files into a Oracle table. The problem that we have is that we need to reformat the Excel files before we load them, but we cannot do this manually so we created a macro to do this for us. We have installed Excel on the Jobserver and created a .bat file. The problem that we have is that when we execute the .bat file in BODS it hangs and nothing happens. We think the problem is that Excel is waiting for us to confirm something. Does anyone have an idea ?

BODS version 14.2.14

Regards Ulrike

View Entire Topic
MarcusZwirner
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Ulrike,

are you able to run the batch script with your DS user manually (outside of DS) to check, if the setting really applies to your DS user?

Best regards

Marcus