Mac Excel 2001 and PageSetup.PaperSize = xlPaperLetter
 

I have a macro that works fine on Excel for Windows for me but when
another person runs it on her Mac with Mac Excel 2001, it returns a
VBA error on <worksheet.PageSetup.PaperSize - xlPaperLetter.

I had her record going into Page Setup and send me the file with the
recorded macro, but the list of recorded PageSetup properties does not
include PaperSize or anything similar.

Is that normal for Mac Excel 2001? Or could this be caused by a
printer driver issue?

In print preview on her computer, the print dimensions seem too tall
and skinny, as if it were trying to print to legal size paper. But
both Excel and her printer driver show letter size paper.


Any suggestions?


Thanks,


Greg

Mac Excel 2001 and PageSetup.PaperSize = xlPaperLetter
 

Greg,
My xl97 help file says PaperSize is Windows only.
While my xl2003 and xl2007 help files omit that part.

Why not have her check the Mac help file?
You will probably have to resort to 'On error resume next' or Conditional Compile...there is a Mac
constant.
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(free and commercial excel programs)



"Greg Lovern"
wrote in message
...
I have a macro that works fine on Excel for Windows for me but when
another person runs it on her Mac with Mac Excel 2001, it returns a
VBA error on <worksheet.PageSetup.PaperSize - xlPaperLetter.

I had her record going into Page Setup and send me the file with the
recorded macro, but the list of recorded PageSetup properties does not
include PaperSize or anything similar.

Is that normal for Mac Excel 2001? Or could this be caused by a
printer driver issue?

In print preview on her computer, the print dimensions seem too tall
and skinny, as if it were trying to print to legal size paper. But
both Excel and her printer driver show letter size paper.


Any suggestions?


Thanks,


Greg