All Forums  Origin Forum  Origin Forum  Refer to a workbook by folder+long name ?

Note: Only the poster of this message, and the Moderator can edit the message.

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Forum: Origin Forum Subject: Message: * HTML is OFF * Forum Code is ON Smilies Hello, in each folder that I run my code I would like to be able to refer to a workbook via the "long name", as opposed the unique "short name" (the long name is the same in each folder of the project and it will make my life a lot easier and the code more useful). All the commands (activate window, get column range, etc, etc) are based on the short name because it is unique for the entire project, I get that. But is there any way you can use the long name + folder name instead, such as: [folder2/longname]Sheet1!Col(A) Otherwise for each folder (hundredths of them) I have to manually find the short name (which are e.g. shortname1, shortname2, shortname3 etc but not in order) to pass it as a variable, so it can recognise the workbooks I need, and this will be very time consuming.. Apologies if I have missed this in the documentation.   Check here to subscribe to this topic.