RE: $$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path?

2012-05-09 Thread Rajan_Verma
@googlegroups.com] On Behalf Of Tony Wu Sent: 08 May 2012 1:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path? Hello, I have a file which will grab lots data from another file called data-source file

Re: $$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path?

2012-05-07 Thread Tony Wu
Hello, I have a file which will grab lots data from another file called data-source file, the data-source will change name depends on date and comments, e.g. DS-0507.xls or DS-0507 with comments.xls ..., since the file name is not consistent, I will have to change my formula every time. Theref