Pat_The_Bat
Board Regular
- Joined
- Jul 12, 2018
- Messages
- 83
Our IT department just migrated all of our data to a SPS and then I have a mapped local drive that references that location. Every Client Wkbk I open has a user authentication dialogue that's called on opening the workbook. Every time I go to open a Wkbk, I get a run time error.
At first I thought it was my code, but then when I saved a copy locally and opened without issue I realized that it must be the SPS. I started researching this and sure enough it appears to be pretty widely known that you macros don't work on SPS.
I saw some documentation that suggests changing a setting to open in IE explorer, but that's not going to work in this application. I need to be able to open those Excel Workbooks locally on my computer (By clicking on the file in the mapped windows drive) and have the Macros run effectively.
Anyone know how to resolve this problem?
At first I thought it was my code, but then when I saved a copy locally and opened without issue I realized that it must be the SPS. I started researching this and sure enough it appears to be pretty widely known that you macros don't work on SPS.
I saw some documentation that suggests changing a setting to open in IE explorer, but that's not going to work in this application. I need to be able to open those Excel Workbooks locally on my computer (By clicking on the file in the mapped windows drive) and have the Macros run effectively.
Anyone know how to resolve this problem?