• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 684
  • Last Modified:

Convert Excel 2003 file to PDF with Acrobat Pro 6.0 - No gridlines appearing on PDF

The machine is running windows XP professional, SP2 and has Microsoft Office 2003 installed.  For PDF functionality the machine has Adobe Acrobat Pro 6.0.  Upon converting to PDF from Microsoft Excel the resulting PDF does not show any gridlines.  I have fully removed Acrobat, restarted and reinstalled to no avail.

I have tried all of the steps in: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23619813.html  and no luck.  Including checking the excel settings (Printing the file does display the gridlines, so there is some hangup occurring in Acrobat).
0
amshaffer
Asked:
amshaffer
  • 4
  • 3
2 Solutions
 
sjl1986Commented:
I use"Primo PDF" from www.filehippo.com. It's a free program which prints files to PDFs. It will set up another printer which you can print to as you would print to a physical printer. It should look the same as a hard copy.
0
 
amshafferAuthor Commented:
An alternate application is fine, such as Primo or CutePDF, but I'd like the application to provide a button in excel which will handle the conversion process for the user.

If there is a way to create a custom toolbar button in excel which can be told "Print using the PrimoPDF Printer", that would be great.  I haven't found any information on how this is done, though.
0
 
sjl1986Commented:
I'm unable to find a free program that will do what you want with an added toolbar/button. Here's a link to a page stating how to completely remove Adobe in case your previous uninstall left anything behind that is still hindering you from printing correctly.

http://www.adesblog.com/2009/01/27/removing-adobe-acrobat-installation-files/

Try completely uninstalling using this link. Be sure to reboot the computer before reinstalling the program. If that doesn't work you might try searching google for an alternate PDF creator that allows integrated toolbars with Microsoft Office.
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
amshafferAuthor Commented:
I ended up creating a macro to use the CutePDF converter printer and then assigned this macro to a button I created.

Thanks for pointing me in the direction of a 3rd party PDF Printer, I was completely ignoring that as being a possible solution.
0
 
amshafferAuthor Commented:
See the comment from myself below regarding my solution with combining the 3rd party PDF Printer and Excel Macros/Buttons.
0
 
sjl1986Commented:
Not a problem. I have never used Macros much. Would you care to share what you created? I'm in a 200+ user environment and would love to have something like that to pass out to my users.

If you would share you can contact me at "lowthers (at) appling-hospital.org".

Thanks!
0
 
amshafferAuthor Commented:
That email bounced!  You can just send me a message at my EE name at gmail dot com, I'd be more than happy to show what I did.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now