PrintArea and PrintTitles for sheets with spaces in name

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
GenasysCarl
Posts: 11
Joined: Mon Jan 09, 2017 6:15 am

PrintArea and PrintTitles for sheets with spaces in name

Post by GenasysCarl »

Hi,

This code fails when trying to set print areas or repeating rows on sheets with spaces in the names.

Code: Select all

Sheet.PrintSettings.PrintArea(1, 1, 2, 2);
If the sheet name is "Client Information", I get an error saying E4016: Uknown sheet name "Information"

Is there another way to set internal names where I can specify the sheet name with single quotes to fix this?

Regards,
Carl
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: PrintArea and PrintTitles for sheets with spaces in name

Post by larsa »

Hello

This is fixed in update 6.00.01
Lars Arvidsson, Axolot Data
Post Reply