J
jayray
I have a logo in .bmp format and I've been able to insert it into a
footer in a model I have. Once it's inserted, I can send out the file
to others, even though technically the file path to that logo in the
format is a subdirectory in my computer. The logo is now embedded in
the model. I'm using Excel 2003.
My problem is this: As part of the printing sequence, I've set it so
that the model inserts a new worksheet, and then the ranges that I
want to print are copied onto this new worksheet. (This has to do with
multiple ranges set by a macro to different scenario settings and
wanting up to 154 reports all to come out as one print job.) The
problem is that when the model is used by other users, as the macro
formats each new worksheet for the printing, it gets stuck with trying
to find the logo, the master of which is of course on my machine, not
of their machine.
Any ideas of how I can put insert a bmp footer on the fly in Excel? Do
I have to send out the bmp file as a separate file with the model?
Thanks for any ideas.
footer in a model I have. Once it's inserted, I can send out the file
to others, even though technically the file path to that logo in the
format is a subdirectory in my computer. The logo is now embedded in
the model. I'm using Excel 2003.
My problem is this: As part of the printing sequence, I've set it so
that the model inserts a new worksheet, and then the ranges that I
want to print are copied onto this new worksheet. (This has to do with
multiple ranges set by a macro to different scenario settings and
wanting up to 154 reports all to come out as one print job.) The
problem is that when the model is used by other users, as the macro
formats each new worksheet for the printing, it gets stuck with trying
to find the logo, the master of which is of course on my machine, not
of their machine.
Any ideas of how I can put insert a bmp footer on the fly in Excel? Do
I have to send out the bmp file as a separate file with the model?
Thanks for any ideas.