Solved

Excel with macros printing blank sheet and corrupts display

Posted on 2002-07-01
8
273 Views
Last Modified: 2008-02-20
Hi Everyone

This ones strange and we can only make this happen on one machine (unfortunately the machine is the MD's Dell Inspiron 8000)

We have a form we all fill in once a month which has 2 macros on it, 1 for printing (which seems a bit pointless) and 1 that clears the form.

We have used this form on Win95/98/ME & 2000
the laptop is running WinME
Office 97 is the package used and excel 97 is the ONLY application showing this problem.

Whether the form is blank or filled out, when you try and print it its prints a blank page, and recreates parts of the document in varying sizes all over the page, very strange corruption.

This happens even with the backup copy of the file that I keep remotely.
We have virus scanned and cant seem to find anything wrong.

Sometimes when the print request is run (especially from the print preview page) the spreadsheet crashes excel, but without any error code.

I hope this is something simple
We have re-installed office twice to try and fix the problem.
All that is left is a repair or reinstall of the o/s

Please help
BOFH
0
Comment
Question by:BOFH
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 7122375
Hi BOFH, have you tried the sheet with macro's on another machine?

if that works ok then a bit of a hassle would be to run through the macro just to see what it does

you say it is pointless but can you print the form noraml from the normal print menu?

HAGD:O)Bruintje
0
 
LVL 1

Author Comment

by:BOFH
ID: 7123477
Hiya Bruintje
Thanks for the reply,

There are quite a few users @ work that use the form
it has been working fine on his machine until today

Any ideas?
What I meant by pointless macros was the clearing the form well maybe ok, but printing with a macro doesnt seem to have any point as the sheet is relatively simple

BOFH
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7123696
can you print it just by choosing file | print? or was there a change in printer drivers or something else switched on that pc. as it sounds this should almost be the reason, but it always is very difficult to trace that back

since we know some things for sure
-the code has been working
-the code is still working on other machines
-and suddenly it stops working

-or the system is just tired
-or there as a change in the setup(can be anything)

so now we only have to know if we can print the form normally from file | print to be sure if it's in the code or in the print action
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 1

Author Comment

by:BOFH
ID: 7124382
Hiya Bruintje
Thanks for the reply

Unfortunately we cannot get it to print on that machine in any way that is available.

All other applications print fine.
No change has been made to the printer config in several months now.

I was wondering if there were any settings in excel that could cause this to happen, I have a feeling something may have accidentally been set.

BOFH
0
 

Expert Comment

by:thewesties
ID: 7160618
Hi BOFH,
  May sound trivial, but make sure it is not defaulting to print selection.  If this happens it will print that cell only.  If that cell happens to be blank, it will print a blank sheet.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7262102
Hello BOFH any progress here?
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7295831
Hello BOFH

this question is open for more then 2 months
time to clean up
if not stated otherwise

my recom will be
-PAQ and no refund
-this will be finalized by an EE Moderator
-with no further update (28.09.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
posted by ToolzEE v1.0
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 7329078
Per recommendation, points NOT refunded and question closed.

Netminder
CS Moderator
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question