Hello,
I am new to vba progeamming.
I am looking for a vba macro preferably in excel. It should pick up a file name (e.g.example)from one of the cells in the excel file add .pps extension and then look for example.pps file in subfolders on shared drive (L:\). If it finds the file then it should open it and if it doesn't then message "file not found". Your help is appreciated.
Thanks
I am new to vba progeamming.
I am looking for a vba macro preferably in excel. It should pick up a file name (e.g.example)from one of the cells in the excel file add .pps extension and then look for example.pps file in subfolders on shared drive (L:\). If it finds the file then it should open it and if it doesn't then message "file not found". Your help is appreciated.
Thanks
