Re: $$Excel-Macros$$ vba code help for the open file location

2016-01-08 Thread Paul Schreiner
I'm "slightly" confused by your example. For your records: | A | B | C | | apr | C:\Users\pwloo\Desktop\break\goal\apr\2F6KB026 | 2F6KB026 | Is the value in column "B" a folder? or a filename with path?Is the value in column "C" a FILE that just happens to be the same name as the last folder nam

$$Excel-Macros$$ vba code help for the open file location

2016-01-07 Thread Kat
Hi all, I was wondering how could I make the open folder button for file name column instead of file location path column? For instance, from the picture below, when I point my cursor to C:\Users\maggie\Desktop\coke\diet\apr\2F6KB026 and click open file button, it will open the file 2F6KB026