I just only a regular excel user, hope U all can understand my question.
Every end of month I need to make a image snapshot from a charting system and save it to a jpg file format by overwriting the previous jpg file. Then I insert the jpg picture file (embedded) into a booksheet.
1st - it just only 20 jpgs snapshots task and need to insert to 20 booksheets but now its grew to 50 and growing.
Is there anyway that I can auotomate the jpg file insert task into the booksheet. Some sort like paste a photo link once in the booksheet and leave it for the jpg file update via file overwrite.
I tried the hyperlink - it just popup the jpg photo via photo viewer and it needs to click to view. I want something similar like paste link - > external jgp file paste link to Excel. Everytime the jpg file being overwrite, the picture view in the excel also changed. No needs for me to insert.
I had thought about to macro the picture insert (embedded) task but I know nothing about macro.