I have inharited a folder that cannot be changed. the folder name contains spaces in it (e.g. "I:\PARTS LIB FOR Solid Edge\Vendors\..."). I get an error of Unknown variable name: PARTS when I am trying to call my VBA code in the folders within this root. My current workaround is just placing my VBA code in "I:\VBA\...". I have tried putting single and double quoats around the file path. Is there anything I can do to make this work so I don't have to put all my code in the VBA folder, placeing the code with the parts instead?
I might try to create a subroutine instead of a function,
within the Sub define a variable "Path"
Set Path = "I:\PARTS LIB FOR Solid Edge\Vendors\..."
then in your equation call "PATH"
have not tested but seems like a logical way to eliminate the spaces throwing error