How to open a changing file (weekly)

example code:

Set wbopen = Workbooks.Open _
("\\It-data-share\ENGINEERING\Projects\MOI Projects\xMOI PROJECT GENERAL FOLDER\ROHN ARABIA PROJECT MANAGER MASTER SITE LIST - 9-12-2012.xlsm")

that 9-12-2012 after "LIST -" is changable.
and the date for is d-mm-yyyy

that file is need to be open week using my macro that gets some of the data insde.

is there anyway to call that file name even if it is changable weekly ??

thanks,

fucell

thank you for your suggestion sir, but unfortunately, im not the only one whos updating it so we agreed that we should put a date on the last section of a file name which - dd-mm-yyyy. is there anyway to call that file name even if it changeable weekly?

thank you

thanks you mrice ^__^

but im having a problem... i cant call or use the function. this is my whole code can you check please... i put them in one module.

if you can see, im assuming that "FileName" was already stored the current filename of the excel file.. am i doing right ?

Please Login or Register  to view this content.

thanks in advance.

thank you mRice!! it works.. thank you so much!