View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mattkahne@yahoo.com is offline
external usenet poster
 
Posts: 6
Default Excel 2002/Windows XP - PageSetup error

Hi Jim,

To answer your questions:

-No chart sheets in the workbook, just spreadsheets.

-It's not quite a simple string as it does include some formatting and
a call to a function that retrieves the user's network ID (can be found
by googling "fOSUserName", that's how I found it a couple of years
ago).

If this is important I can post the details (the fOSUserName function,
and the exact string I'm setting the header to) from the office
tomorrow as I don't have them handy here at home. However, among the
things I tested when I was able to use the machine where the error
occurred was replacing the header text with a simple string, and the
same error occurred when the VBA code tried to set the RightHeader.

For what it's worth I was also able to test using my own ID and another
employee's ID (I have write access on the directory where the workbook
is housed, most other users have read-only access because they're not
saving the workbook, just using the spreadsheets, printing, and
closing). Again, no effect -- a computer generating the error for one
user ID generated it for both, and a computer not generating the error
was fine for both IDs.

Basically, I'm putting the individual user's network ID in the print
header because there are many people using these spreadsheets and they
sometimes have trouble separating out their own printouts when several
pile up on the printer.

Thanks for your consideration!

Matt