Macro to Log On to TM1

[egiannaros]

I have a macro that runs on the second to last business day of each month. The macro pulls down data from two of our TM1 cubes and does a variance check to make sure everything is in sync. The macro works great using Private Sub Workbook_Open() and it is coupled with windows task scheduler.

My issue is that the TM1 server goes down around midnight every night and is reloaded. This is an automated process.

So I need some VBA code to add to the very begining of my macro so I am logged back onto the server (otherwise I can't pull down any data). Is anyone familiar with how to do this or does anyone have any ideas?? I have already tried using the macro recorder with no luck.

Thanks in advance.