vba code to refresh data from OneStream

Dancarro

Board Regular
Joined
Feb 23, 2013
Messages
54
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
 

Forum statistics

Threads
1,077,827
Messages
5,336,616
Members
399,093
Latest member
chado4250

Some videos you may like

This Week's Hot Topics

Top