I currently have an Excel 2000 spread sheet running VBA in the background which updates the data on the screen every 15 seconds from a MSSql 2000 database over a TCP/IP network. Everything is working fine. I have now been requested to insert a picture along side the data currently displayed on the screen. The problem is that there are 3,004 possible jpg pictures I must be able to access and display. I was thinking of storing the pictures locally on the PC and retrieving and displaying the picture necessary based on the jpg filename sent to the PC by MSSql. I was wondering if anyone has done anything like this before or could offer any advice on how to proceed with this project. How do you get Excel to open a jpg picture file from the local hard drive based on the filename. Any comments or suggestions will be appreciated. Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
GeDisplay pictures with Excel 2000, need help and direction
- Thread starter vamoose
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Solved