I have some excel workbooks with VBA to amongst other things run code “onopen event” to open a workbook with a database I use for data validation. I have been asked to upload these to sharepoint but how do I get the code to open the documents in excel rather than a web page, and how do I find the filepath to the actual excel document, rather than a path to a web page, so I can modify the filepath I set up to try it out.
Change this, which is the filepath I used to set it all up
To (this is just an example)
I can manually open each file in the app on sharepoint and my data validation will work.
Can anybody please tell me if this is actually achievable
Many thanks
Gary
Change this, which is the filepath I used to set it all up
VBA Code:
Set WB = Workbooks.Open("C:\Users\Gary Baker\Documents\Lion Engineering\W4G\W4G\Operational Data\_Databases\Customer List.xlsx", True, True)
Code:
Set WB = Workbooks.Open("Sharepoint:\Documents \Operational Data\_Databases\Customer List.xlsx", True, True)
Can anybody please tell me if this is actually achievable
Many thanks
Gary