Problems Printing a Linked Word document
I am having trouble printing a word document that has linked excel tables in
it. When I print the document, some of the linked excel tables get skewed
and distorted. However, they look normal on screen.
What causes this?
How can I fix it?
...Print a Variable
I have a routine programmed in the a footer section of my report.
I have a variable
Dim CurrentClient as string
CurrentClient = "[Client]"
I would like to be able to print the variable currentClient in the footer on
I tried in the control source =[CurrentClient]
Does not work
Any help would be appreciated
You will probably need a simple public function that returns the variable like:
Public Function GetCurClient() as String
You can then set a control source to the function.
Dua...picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles
and if I move the handles some, the picture will show up. However, it
will not show up in print preview at all or page break preview. I can
open the same file on another computer and it will show up fine.
Any help would be appreciated.
Tools -> Options ->General
Do you have "Show All" selected for Objects?
> I have a picture that is in an Excel worksheet. I can see the handles
> and if I move the handles some, the picture will show up. However, it
> will...Size of the 'References:' header
Is there a way to not add message ids to the 'References' header item when
replying to messages, or, at least, when it grows too big ? My ISP SMTP
gateway refuses to relay mails when header lines are too long.
Exchange 2007 SP1
...Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the
slide and when I try to format it it is impossible to get it back to the same
pic I am attempting to add. If I am trying to add a pic I might only get a
nose or a blade of grass instead of the original picture from "My Pictures".
Reduce the zoom to 10%. Coul be a too large image
"PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le
message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com...
> When I add a pic from "My pictures" t...Embedded pictures
I noticed that the when we set the picture property of a button or another
control as embedded, it takes a lot of place.
Is there an explication that show why the Access file encrease in size by
more than the picture size (even if it is a bitmap, a format that is normaly
An mdb without picture would take 4 MB
the same file with pictures would increase to 40 MB with only 400 KB of
pictures. In JPEG format.
Is it because Access uses a non efficient compression to include the image
Thank you in advance for any suggestion!
PS: I know that I can set the pictur...print macro
I have a workbook that has around 18 worksheets in it. Is there a macro
when clicking on the print button that only the pages with data entered
Right now I have to print each page one at a time or print the whole
workbook even though some sheets don't have data entered.
Sheets that have NO data do not print. Try this for testing
For i = 1 To Sheets.Count
Microsoft MVP Excel
"David" <email@example.com> wrote in message ...Printing 3Dchart with pics& texture
I have created a 3D chart. I formatted the area of the
walls to have a fill effect of a picture (~500k). On the
floor, I formatted the area fill with a canned texture of
The chart looks great on the screen and in print preview
but when sent to an HP 4500 color laser or an HP Business
Inkjet 2250 the walls and floor are just unorganized
blotches of color. All other parts of the chart are
fine. Is there a setting or other factor I'm missing?
...Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000
or Outlook 97. I'm using XP Home.
Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service
Scott Atkins MCSE, MCSA
Partner Technical Lead - Outlook
Microsoft Technical Support
for Platforms and Business Applications
>Subject: Pictures don't...Printing full calendar contents
Sorry, bit of a general user question but any ideas much appreciated.
To print all of the details from a particular event, one has to open up (or
select) that event. However, does anyone know how to print out all details
for ALL events in a particualr week or month?
...picture in picture
Have to digital pictures & would like to put a couple of people on one
picture into the other picture. How do i do this? Anyone got any ideas? TIA
"ted medin" <firstname.lastname@example.org> wrote in message
> Have to digital pictures & would like to put a couple of people on one
> picture into the other picture. How do i do this? Anyone got any ideas?
Well not with Vista. You need a Graphic editing application.
The Gimp may be able to do this. (It's free, Open Source but is a bit tricky
yo get to lear...How to print J8676-12 Avery CD labels in Word 2007?
Word 2007 has J8676-12 Avery CD labels in its label tab but when I select it
the template does not appear. How can I solve the problem?
I see Avery J8676 (not sure where you're getting 12--there are only two per
sheet). Are you clicking New Document? Do you have table gridlines
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"gilleswda" <email@example.com> wrote in message
...FRx 6.5 print issues
One of my users is having intermittent print errors. When the user goes to
print a generated report, the print spooler on our W2K server hangs and all
printing stops. A server event is created stating that a VBScript error has
occured from this user's system. I simply restart the print spooler and
everything is fine. No other users (6 others) are experiencing this problem.
This particular user is running Win XP with MS Office 2003. These problems
are random and may go days without problems. Other days, I might have to
restart the spooler 4-5 times.
...Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see
the frame. The same thing when I load a publisher file created by someone
else. All the inserted pictures does not show. View>pictures is set to
Any suggestions for a solution?
Read the third FAQ here
Mary Sauer MSFT MVP
"Thor" <Thor@discussions.microsoft.com> wrote in messag...Print folding/cutting lines
I'm just creatinng a flyer in publisher which will be the size of a with
compliments slip (3 per A4 page). Once printed I will want to cut them into
equal sizes. I believe I am able to print a small "cut line" so I know
exactly where to cut. Can anyone tell me how this is done?
There is line art that is a dotted line with scissors.
MVP Microsoft [Publisher]
How to ask a question
"Gerald" <Gerald@discussions.microsoft.com> wrote in message
news:789D311C-0F91-40D2-B20...maintaing headers in sort
I am trying to maintain a header of two lines whilst still being able t
sort the contents - freezing and/or locking do not work as they seem t
prevent the use of sort.
Message posted from http://www.ExcelForum.com
Select all the cells you want to use in the sort -- that is, simply exclude
the 2 rows you don't want sorted.
"kww >" wrote:
> I am trying to maintain a header of two lines whilst still being able to
> sort the contents - freezing and/or locking do not work as they seem to
> prevent the use of sort.
> Any ideas?
Appreciate some help here and thanks in advance.
I link my pictures to the following folders
C:\Documents and Settings\MyName\Desktop\Picture.jpg
C:\Documents and Settings\MyName\My Documents\Picture.bmp
If Me!pic1a = "X" Then
Forms!startpg!fmpPic!Img.Picture = ""
Forms!startpg!fmpPic!Img.Picture = Me!pic1a
It works on my PC but when I copied the program to another PC, it does not
This is because of "MyName" and the other PC has a different name. Is there
a way to ignore "MyName" for any PCs
"ChoonBoy&quo...Printing Web Pages: I want what I see
There are some web sites in which you do want to print background colors and
images. Even when the option in Internet Options "Print background colors
and images" is checked, it does not always print some of these parts the way
they look on the screen. Is there a way to basically tell Internet Explorer
8 to print a page exactly the way it is on the screen (including any CSS
styling, backgrounds, etc.)? I don't care if text wraps because the paper is
not as wide as the screen, but that is different from not printing a
background color or image at all. Thanks.
N...Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again
a picture. Some of these will have 8 to 10 pictures with text under each
picture. But when I send it out it is received with all of the text in a
group and the pictures are all sent as attachments. How do I get my e-mails
to send the pictures and text the way I receive them? Thanks for any help
you can give me. Bob
Complete newbie so please bear with me.
Basically I've been given a worksheet that uses columns A to BT and although
the columns are quite narrow, ie a lot have a single value in them, when I
try and print this doc in 0.5 margins A4 landscape using the format 1 page
wide and 2 tall I get all of the data, but its far too small to read.
I'm not bothered if the rows go on multiple pages, current worksheet uses 83
rows, but I need all my columns to show.
What the problem seems to be is that the scaling options in Excel are
proportional so when I state 1 page across it doesn...Picture in header
How do I get a picture in the header?
This was added in xl2002.
File|Page setup|header/footer tab|custom header
There's an icon that looks like a picture near the far right.
> How do I get a picture in the header?
If you are using a version of Excel before 2002 then check out:
for a workaround.
"Dave Peterson" wrote:
> This was added in xl2002.
> File|Page setup|header/footer tab|custom header
> There's an icon that looks lik...publisher 2002 and printing
i want to print an 8 page booklet on 11x17 paper. when i go to print preview and view pages 1&8 they print out justfine. when i select pages 2&7 and hit print , pages 1&8 print out. i have a hp1220c printer, unfortunately at this time hp doesnt have a driver for xp for the toolbox. when i had publisher 98 and the hp toolbox i could print this very easily. i also cannot change the order pages to print, the toobar icon in print preview, says change orderof pages, when i click on it nothing can be changed on the window that opens other than the 3 formats that are allowable. Help...Can pictures be centered in a picture frame in a catalog?
I have created a catalog for items we sell. I have added the pictures to the
catalog through the Excel worksheet. When the worksheet is imported, all of
the pictures left-justify in the picture frame. Can this be centered?
...Create picture catalog from current product codes
Any one who knows how to create a catalog of pictures in a=20
spreadsheet, from a list of product codes, that=20
automatically adds the pictures from a specific product=20
code list and creates links from the product code to the=20
specific cell in which the picture is positioned.
Merge Pictures and Words - Oh My!, by Cindy Meister, creates a catalog from text wording and external pictures from an Excel
database. [photos, photographs] http://www.computorcompanion.com/LMMArticle.asp?ID=126
Also see extracting JPG / GIF files from an Excel document (charts).
htt...attaching pictures as an icon
Hi I am trying to save memory in an excel report and I
wish to include a picture in this report as an icon that
shows the picture when selected.
If you're going to try to save memory in the workbook, then it sounds like the
big picture will be outside excel (a common LAN folder???).
If yes, then maybe you could create thumbnails of each of your pictures (using
????) and then add a hyperlink to each thumbnail.
The hyperlink would use whatever program is associated with the extension to
open the big picture--outside of excel completely.
(I don't know how you'd include the big p...