U_Shrestha
07-04-2008, 11:50 AM
Hi,
I have a Folder named "EDIT-692", inside that folder there is one file named "EDIT-692-Project.xls" and a folder named "FilesDump". The "FilesDump" Folder would have several .xls files. One such file name is "FG.xls".
Objective: I want to be able to open all the files, (e.g. "FG.xls" from "EDIT-692-Project.xls". I would be copying the main folder "EDIT-692 in a flash drive, a CD as well as upload it in website. I am having problem creating that link from a macro that adjusts automatically.
Can someone please help? I have attached a sample sheet. Thanks.
I have a Folder named "EDIT-692", inside that folder there is one file named "EDIT-692-Project.xls" and a folder named "FilesDump". The "FilesDump" Folder would have several .xls files. One such file name is "FG.xls".
Objective: I want to be able to open all the files, (e.g. "FG.xls" from "EDIT-692-Project.xls". I would be copying the main folder "EDIT-692 in a flash drive, a CD as well as upload it in website. I am having problem creating that link from a macro that adjusts automatically.
Can someone please help? I have attached a sample sheet. Thanks.