Hi,
I am ultimately trying to automate/schedule a data retrieval from Essbase.
I started with a macro that works perfectly. Sample code:
Sheets("Sheet1").Select
range("B1:b1").Select
ActiveCell = j
application.Run macro:="EssMenuVRetrieve"
This macro will run in about 0.5 seconds and retrieves the data perfectly.
Next I wrote a .bat and vbScript file to automate the process. but this will not work.
Everything runs fine up until the EssMenuVRetrieve line of code. I know this because I put in sample code before and after to write some text to two cells for testing purposes.
When I run the batch file, it calls the macro as I want, executes the code upto EssMenueVRetrieve and then just hangs infinitely. No data comes back. And no code after it gets executed.
Please help as this will be a great benefit to me and I cannot understand the issue going from a working macro to a not working vbscript.
Thanks
Eddie
I am ultimately trying to automate/schedule a data retrieval from Essbase.
I started with a macro that works perfectly. Sample code:
Sheets("Sheet1").Select
range("B1:b1").Select
ActiveCell = j
application.Run macro:="EssMenuVRetrieve"
This macro will run in about 0.5 seconds and retrieves the data perfectly.
Next I wrote a .bat and vbScript file to automate the process. but this will not work.
Everything runs fine up until the EssMenuVRetrieve line of code. I know this because I put in sample code before and after to write some text to two cells for testing purposes.
When I run the batch file, it calls the macro as I want, executes the code upto EssMenueVRetrieve and then just hangs infinitely. No data comes back. And no code after it gets executed.
Please help as this will be a great benefit to me and I cannot understand the issue going from a working macro to a not working vbscript.
Thanks
Eddie
