I am looking for a way to make this code get the .jpg "front.jpg" of any folder the workbook may be in, the workbook will be moved from folder to folder and it needs to get the .jpg of the new folder when the workbook is moved. the "front.jpg" name will stay the same always, but the workbook location will not be in the same place, but the "front.jpg" will always be in the same folder as the workbook.
Example: every time we start a new job we take a folder with the blank workbook and and other files from the new job and name the folder and workbook with the clients name. we place a .jpg picture of the "front" of the new job and place it in the newly named folder with the workbook and files. I have this macro that inserts the "front.jpg" picture on the new workbook but the path to the new .jpg needs to be changed each time on the macro. this is not practicle to do each new job. is there a way to have the path be set to the folder the workbook is in and not from the root path of the computer? like this( \\A New folder\FRONT.jpg")
I also need the macro to unprotect the workbook run macro then protect workbook. ( I know I ask for a lot )
Thanks to all who look into this for me!
Please Login or Register to view this content.