Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Question about Excel


  • Please log in to reply

#1
mlgrier3

mlgrier3

    Member

  • Member
  • PipPip
  • 21 posts
I have two seperate programs running, one is a data acquisition and the other is a printing program. The acquisition program creates a head file that in turns creates an Excel file, and the printing program prints this excel file each time it is created. Is there a way that I can set a print area for the entire Excel program versus just one spreadsheet at a time? I am running Office 2003. Thank you.
  • 0

Advertisements


#2
Boostman

Boostman

    Member

  • Member
  • PipPip
  • 34 posts
On your acquistion program does the data vary at all? Meaning do the cells change in amount.

I think what you are trying to do is automatically only print the cells with data in them, correct? I am not 100% sure if there is a way to make an automatic area selection to print. If this was something you wanted to do manually you could do the foloowing:

File->Page Setup->Sheet->Print Area

Specify Cell Range

Example:

A1:L37 - Would print all data in those cells only.

You could also use the "Print selected area" option when you go to print, but I don't think you want to do that each time.

This is all I have for now, but it gets the ball rolling at least.

Edited by Boostman, 11 October 2005 - 02:04 PM.

  • 0

#3
mlgrier3

mlgrier3

    Member

  • Topic Starter
  • Member
  • PipPip
  • 21 posts
Thank you for responding so quickly. The number of cells doesn't ever vary, what I am trying to do is stop column A from printing ever. It runs in the background so manually setting the print area won't work as it can' be accessed every time. Any other ideas would be greatly appreciated.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP