MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 348
- Office Version
- 2013
- Platform
- Windows
I am using Microsoft Office Professional Plus 2013.
Daily I update data in an Excel sheet which shows up in a range of cells from which I daily copy as a picture.
Then I open a Word document and paste said picture. Then I save the picture as a jpg in a folder from which I can retrieve said image to populate a desktop Photo Frame as depicted in this website: Only Freeware software for your desktop
The item I am referring to on their website is titled “Free Photo Frame” which is installed and working fine.
What I want to do in Excel is where the range of cells displays the daily updated data then one-time use Excel’s Camera, place the Camera Snapshot on the same sheet and then copy that Camera Snapshot developed image into Word.
Then daily as the data updates in Excel, the range of cells displaying that data update thereby updating the Camera Snapshot developed image in the Excel sheet and in the Word document from which I then save as picture a daily jpg image to explorer folder from which I can then apply the updated image to the desktop photo frame.
I realize this involves 2 additional software besides Excel, but it seems to me that the place to start is what is the correct thing to do in Excel to get the ball rolling in the right direction.
I guess the bottom-line question is can an image in Word be linked to an image in Excel such that the image in Word updates when changes occur to the image in Excel.
Any help or suggestions will be much appreciated.
Daily I update data in an Excel sheet which shows up in a range of cells from which I daily copy as a picture.
Then I open a Word document and paste said picture. Then I save the picture as a jpg in a folder from which I can retrieve said image to populate a desktop Photo Frame as depicted in this website: Only Freeware software for your desktop
The item I am referring to on their website is titled “Free Photo Frame” which is installed and working fine.
What I want to do in Excel is where the range of cells displays the daily updated data then one-time use Excel’s Camera, place the Camera Snapshot on the same sheet and then copy that Camera Snapshot developed image into Word.
Then daily as the data updates in Excel, the range of cells displaying that data update thereby updating the Camera Snapshot developed image in the Excel sheet and in the Word document from which I then save as picture a daily jpg image to explorer folder from which I can then apply the updated image to the desktop photo frame.
I realize this involves 2 additional software besides Excel, but it seems to me that the place to start is what is the correct thing to do in Excel to get the ball rolling in the right direction.
I guess the bottom-line question is can an image in Word be linked to an image in Excel such that the image in Word updates when changes occur to the image in Excel.
Any help or suggestions will be much appreciated.
