heffrey45
09-23-2005, 03:57 PM
Hi all I was wondering how to use an excel sheet to insert logos like home and away logos. I have got it working where I can insert a number and it will put it into the correct tab field but I dont know how (or if) I can do this with images (logos). Does anyone out there do this? Can anyone help? Thanks
biancabeck
09-23-2005, 07:07 PM
You can link to images by using the same technique you used for the text. In the Excel spreadsheet you have to enter the whole path of the image into a cell(i.e. i:\Football\HomeTeam\LogoLarge.jpg), and don't forget the file extension. In Lyric select the image that you want to be updateable, right click and select 2D Object Properties. In this window you will see a DB Link button like the one you used in the templates. From here on you know what to do. It is now the same as the text. NOTE: Remember to define a name for the column with the images in the Excel file and make sure that the images will always be in the file path entered into the spreadsheet!
Good Luck.