View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default What are the System Tables named "Print Area" & "Print Titles"?

Print_Area and Print_Titles can be set by the user manually using Page Setup
under the file menu.

The are found as defined names (insert=Name=Define).

They are not defined by default that I am aware of. The MySheetName is not
a defined name - it may just be displayed as a table of the used range for
the sheet.

--
Regards,
Tom Ogilvy



"dan" wrote in message
...
I Have an excel 2000 Sheet which I need to connect to
through ODBC and read data.
The only way I can see the sheet is when choosing system
tables.
Also there are three system tables which are all the same
sheet:
1. Mysheetname
2. Mysheetname$Print_Area
3. Mysheetname$print_titles

Can anyone explain how are these other sheets generated?

Thanks,
Dan.