Good Day Experts,
Here my situation :
I have a dahsboard that retrieve data from 3 other excel files. The other excel files have a VBAProject password protected on, so cannot copy the sql macro. So what I would like to do is the following:
From the Dashboard file, run a macro which will:
- Open an excel data file in background, execute in background the macro to refresh their data and this for the 3 data files I need.
MyDashboard will open :
DataRefesh1, run macro DataRefresh1.xlsm'!Sheet9.ConnectSqlServer
DataRefesh2, run macro DataRefresh2.xlsm'!Sheet20.ConnectSqlServer
DataRefesh3, run macro DataRefresh3.xlsm'!Sheet3.ConnectSqlServer
Is this possible?