?
Solved

Excel with macros printing blank sheet and corrupts display

Posted on 2002-07-01
8
Medium Priority
?
279 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
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

599 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