View Full Version : Script not working after moving data to SharePoint
DaRichMan
08-08-2022, 02:58 AM
All our data has been moved to SharePoint. In al lot of Excel files the following code is used
30034
But now that the data is on SharePoint, this no longer works.
Any help is appreciated
You use a redundant function to get the same result as
Thisworkbook.path
what is the result of
Msgbox Thisworkbook.path
zie: https://www.snb-vba.eu/VBA_Bestanden.html#L_1.8
DaRichMan
08-12-2022, 03:06 AM
Msgbox Thisworkbook.path
Dan komt er een message met het pad in SharePoint
MsgBox CreateObject("scripting.filesystemobject").GetParentFolderName(ThisWorkbook.FullName)
of
MsgBox CreateObject("scripting.filesystemobject").GetParentFolderName(ThisWorkbook.path)
DaRichMan
08-15-2022, 03:19 AM
MsgBox CreateObject("scripting.filesystemobject").GetParentFolderName(ThisWorkbook.FullName)
Displays the current folder
MsgBox CreateObject("scripting.filesystemobject").GetParentFolderName(ThisWorkbook.path)
Returns the subfolder
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.