|
Subject:
|
Pictures in Automation of Excel
|
|
Posted By:
|
gardengirl447
|
Post Date:
|
9/29/2005 12:24:23 PM
|
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???
|
|
Reply By:
|
gardengirl447
|
Reply Date:
|
10/4/2005 6:15:08 AM
|
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.
|
