vba code to refresh data from OneStream

[Dancarro]

Hi,

I have a user that logs into OneStream and gets all his data in Excel but he has several files, but I need to refresh all these files through a macro. The problem is how to I do this?

I tried the following macro but it doesn't work:
For Each cnct In ThisWorkbook.Connections
Select case cnct.type
case xlconnectiontypeodbc
cnct.ODBCConnection.BackgroundQuery = False
case xlconnectiontypeoledb
cnct.OledbConnection.BackgroundQuery = False
end select
Next cnct

Any suggestions, many thanks for your help

Regards,
Dan

 

[amartin575]

Hi,

I have a user that logs into OneStream and gets all his data in Excel but he has several files, but I need to refresh all these files through a macro. The problem is how to I do this?

I tried the following macro but it doesn't work:
For Each cnct In ThisWorkbook.Connections
Select case cnct.type
case xlconnectiontypeodbc
cnct.ODBCConnection.BackgroundQuery = False
case xlconnectiontypeoledb
cnct.OledbConnection.BackgroundQuery = False
end select
Next cnct

Any suggestions, many thanks for your help

Regards,
Dan

No one answered? I have the same question.