I am creating an excel file from access and I need to insert a picture on the worksheet "A1".

I have the .bmp stored as a OLE object in my globals table but if I have to I will include the necessary picture file in the folder that holds my app and reference the path.

Any ideas???

Ok I found a way to pull the picture into my header in excel thru access vba, the picture must be in the folder with the app.
Only problem is "Filename" does not seem to be supported by Excel 2000...(working on this solution now)

Public gstrPicPath As String
gstrPicPath = Application.CurrentProject.Path
.LeftHeaderPicture.Filename = (gstrPicPath) & "\name of gif "
.LeftHeader = "&G"

I am still in search of a better way (OF COURSE)!! I would really like to extract the OLE Object from the DB so I dont have to worry about transporting gif files.

I have a very large excel database of properties I own and properties i want to buy. The program a ton of VB routines and that calculate property values, financials, etc. The properties are defind as A,B,C,D,ETC. wereas Cel A1 = A will equal a specific property that is translated to all the program menus in the program. Example:
on sheet 12 Cel A1 = A; B1 is the Directry Path for the picture of that house (7 Pictures). On my Cover letter I have property data and Smartart captions. currently, I haveto click on the caption and insert the picture manualy. How can i make this Automated? When Cel A1=A that picture is in my caption.
Thank you very much for any help