Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

How to auto update a jpg file in Excel


  • Please log in to reply
No replies to this topic

#1 safi

safi

  • Members
  • 23 posts
  • OFFLINE
  •  
  • Local time:12:02 AM

Posted 30 April 2014 - 08:21 AM

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. :whistle:

 

Tq.

 

 



BC AdBot (Login to Remove)

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users