Godders199
Active Member
- Joined
- Mar 2, 2017
- Messages
- 313
- Office Version
- 2013
Hello, i have a workbook, that i want to share, currently it has two tables within it. The tables are refreshed through VBA from a sharepoint connection.
I am aware how to convert the Tables to Ranges which will allow me to Share, but this removes the connection I have.
Is there away of maintaining the connection through VBA, for example when the workbook is opened, and refreshed it creates the connection and refreshes the data, before convering the table to a range.
Part of me is thinking there will be a conflict , as the workbook will open as a shared document and then try and add a table ...
I might be making this far to complicated, but i cant find a way to maintain the connection, have looked through the options and there does not appear to be any tick boxes.
Any help would be appreciated.
I am aware how to convert the Tables to Ranges which will allow me to Share, but this removes the connection I have.
Is there away of maintaining the connection through VBA, for example when the workbook is opened, and refreshed it creates the connection and refreshes the data, before convering the table to a range.
Part of me is thinking there will be a conflict , as the workbook will open as a shared document and then try and add a table ...
I might be making this far to complicated, but i cant find a way to maintain the connection, have looked through the options and there does not appear to be any tick boxes.
Any help would be appreciated.