PDA

View Full Version : [SLEEPER:] Ignore library path



chooriang
11-15-2019, 11:09 AM
Excel MAC VBA.

Thisworkbook.Path return "/Users/Sam/Library/Containers/com.microsoft.Excel/Data/Downloads/iZICHT 15-11 v2"
instead of "/Users/Sam/Downloads/iZICHT 15-11 v2/".

How to work around this?
I want it return "/Users/Sam/Downloads/iZICHT 15-11 v2/"

Bob Phillips
11-15-2019, 12:16 PM
Downloads is just an alias for a real path.

Why do you need it like that?

chooriang
11-15-2019, 07:05 PM
Mac VBA unable to create a file copy if use "/Users/Sam/Library/Containers/com.microsoft.Excel/Data/Downloads/iZICHT 15-11 v2"

Bob Phillips
11-17-2019, 05:33 AM
Mac VBA unable to create a file copy if use "/Users/Sam/Library/Containers/com.microsoft.Excel/Data/Downloads/iZICHT 15-11 v2"

Really? I haven't used a Mac in a while, so I can't really help any further.