Re: Method 'Filename' of object 'graphic' failed Runtime Error -2147417851(80010105)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm not sure this is the best newsgroup for this, probably an Excel group
would be better, but the first thing that comes to my mind when I see
".PageSetup" is to make sure that you've got a printer selected, and that
it's not doing anything "odd" at the time (i.e., it's not paused, offline,
etc.), and that it's a "real" printer, as opposed to something like a FAX
printer or PDF capture utility or anything similar.

Usually having no default printer is the only real cause for concern, but
I've seen the occasional oddity like the above error with some printer
drivers, most especially the "fake" printers.



Rob

"Greg" <gregp25@xxxxxxxxxxx> wrote in message
news:1152805298.250199.287130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Getting this error randomly. Here is the code.

With xlWB.Active***.PageSetup.RightFooterPicture
.Filename = "N:\GMCC\GMCCA\Common\GMCCA
GUI\Graphics\att_horiz_color_sml.jpg"
.Height = 100
.Width = 75
.Contrast = 0.5
.CropBottom = -5.4
.CropLeft = -5.5
.CropRight = -5.4
.CropTop = 5.6
' Enable the image to show up in the right footer.
End With
xlWB.Active***.PageSetup.RightFooter = "&G"



.

Quantcast