Hi, I’m using a simple notepad .vbs macro to refresh all spreadsheets in the folder which is scheduled to refresh twice a day by task scheduler.
The data source of the report is SQL server and hence I’ll have to leave OLE DB refresh option enabled to make sure the data remains up-to-date.
When a colleague of mine open the report today, he clicked on enable content and SQL server login window popped up on the screen.
I need to send the report out once every week to internal & external people once it gets refreshed by the task scheduler.
How can I disable external connection in the report for other users without using macro?
Is there any vbs coding for the notepad that can only activate SQL external connection just before a refresh command and once the refresh is completed it saves, closes and leaves the spreadsheet with disable external connection so other user don’t see SQL server Login pop up on their screen?
I am new to VBA so if above option not possible, any other alternative method will be hugely appreciated.
Thank you.
The data source of the report is SQL server and hence I’ll have to leave OLE DB refresh option enabled to make sure the data remains up-to-date.
When a colleague of mine open the report today, he clicked on enable content and SQL server login window popped up on the screen.
I need to send the report out once every week to internal & external people once it gets refreshed by the task scheduler.
How can I disable external connection in the report for other users without using macro?
Is there any vbs coding for the notepad that can only activate SQL external connection just before a refresh command and once the refresh is completed it saves, closes and leaves the spreadsheet with disable external connection so other user don’t see SQL server Login pop up on their screen?
I am new to VBA so if above option not possible, any other alternative method will be hugely appreciated.
Thank you.
