Tom, Thank You for the code. its pretty impressive...
Hope you dont mind helping me with another detail to my question.....
The way i have my files set up are as follows:
I have a total of 3 files (2 excel files and 1 running powerpoint file).
File 1: this file allows people to insert their message or image. (can be opened or closed by the user with no interrruption to file 3)
File 2: this file is always open, and is basically a link file that updates links from Excel file 1.
File 3: Powerpoint file that is in presentation mode and always open. This files gets it data from File 2. (The reason i created file 2, is becasue its always open and doesnt interrupt File 3 when updating links.
What im looking for is a macro between Files 1 and 2, where the user can input images or messages into the charts tab in File 1, then when they hit Save, it sends the image or message to File 2. File 2 then grabs the image or message from File 1, and inserts it into its charts sheet. Then, File 3 grabs the image from File 2 and presents it on the powerpoint slide show. I dont want to open new powerpoint presentations, but rather would like to assign a certain powerpoint slide within File 3 where the image or message will show up, based on File 1 inputs and File 2 updates.
If you can figure that out, you have solved my problem. Ive been able to acheive this with basic data and linked charts, but not with images...
I would be very grateful if you could lead me in the right direction...
Hope you dont mind helping me with another detail to my question.....
The way i have my files set up are as follows:
I have a total of 3 files (2 excel files and 1 running powerpoint file).
File 1: this file allows people to insert their message or image. (can be opened or closed by the user with no interrruption to file 3)
File 2: this file is always open, and is basically a link file that updates links from Excel file 1.
File 3: Powerpoint file that is in presentation mode and always open. This files gets it data from File 2. (The reason i created file 2, is becasue its always open and doesnt interrupt File 3 when updating links.
What im looking for is a macro between Files 1 and 2, where the user can input images or messages into the charts tab in File 1, then when they hit Save, it sends the image or message to File 2. File 2 then grabs the image or message from File 1, and inserts it into its charts sheet. Then, File 3 grabs the image from File 2 and presents it on the powerpoint slide show. I dont want to open new powerpoint presentations, but rather would like to assign a certain powerpoint slide within File 3 where the image or message will show up, based on File 1 inputs and File 2 updates.
If you can figure that out, you have solved my problem. Ive been able to acheive this with basic data and linked charts, but not with images...
I would be very grateful if you could lead me in the right direction...
