Automate the push of Workbooks (Help)

[Former Member]

Hi BW Experts, please let me know a some clue/ solution on how to automate the push of workbook after refresh to the folder on the web. work book has 3 Queries in it. I am in bw 3.1 , I am not sure if Reporting agent can do this or WAD, please specify quick steps to do this. please help on this

Soniya Kapoor

[Former Member · Accepted solution]

See beautiful code by Gopi in the link below:

Assign points if useful,

Xibi

[Former Member · Accepted solution]

Hi Please help me, I want to know if This code can push my workbook to specified folder on server and also refresh it, if yes where exactly i should insert this code, I have a workbook " sales product" Since I can schedule the task to open the workbook by windows scheduler it will open the workbook, please help me now how this code will help to refresh the workbook and push it to specified folder when windows scheduler open the workbook. please tell me should i go workbook and design mode editor VB green pen icon and insert the code there. or where can I insert this code. please help me.

Soniya

[Former Member · Accepted solution]

I saw that Gopi is helping you in the other thread.

In order to insert the code Gopi posted you need to open the weokbook and click on Alt+F11.

Then click on "This Workbook" and paste the code in the editor and click save.

Then save the Excel file and close it.

Then open it and click on enable macros (if prompted).

It should run for you

[Former Member · Accepted solution]

I inserted the code in editor for workbook and close the editor, then i schedule the workbook with windows scheduler it did not connect to bw server , can u please specify the system number where i can find that in my system display if u can check urs and get me the steps to find the system number then i will try again to schedule and see if it connect to bw system

thanks

soniya

[Former Member · Accepted solution]

Hi Gopi I got the system Number its "00" for Dev BUT NOW WINDOWS SCHEDULER Cannot start the workbook it gives error "could not start"

please test the code and let me know if it can work

thanks

Soniya

[Former Member · Accepted solution]

Hi Gopi, I have my email here, I will be thankful if you can test the code and let me know if it will work at my email : soniyakv@hotmail.com

also i can send you my workbook if you can verify if i did right.

step1. i open the workbook and go VB editor and just paste the code.

Step 2 save the workbook and come out of VB

Step 3 Schedule the Workbook by windows scheduler

Step4 : Work book did not ran or connect to bw system

please reply me soon

thanks

Soniya

[Former Member · Accepted solution]

Hi Soniya,

Glad to know that you got the Windows Scheduler to work. I think I suggested that a couple of months ago. Sorry to see that you are still having problems, though.

See the other thread for suggestion on how to determine Server and System information.

You might want to also see this thread:

Once you get the workbook to refresh, your next probem will be how to push the results. Here is a link that might help:

And, finally, when all is working, you will also want to log off. See if this link is helpful:

Good luck. I want to hear when you are successful!

- Pete

[Former Member · Accepted solution]

Hi Soniya,

I am responding to the question in the other thread ...

The code that you posted had some problems with it. I will e-mail some additional instructions.

- Pete