Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you clear the "print titles" field in page setup? Wordnewby Excel Discussion (Misc queries) 2 September 17th 08 07:25 PM
"Print titles must be contiguos and complete rows or columns?" Juan Diaz L Excel Discussion (Misc queries) 1 January 24th 08 04:47 PM
Why is the "zoom" option grayed out in "print preview?" sschreiber Excel Discussion (Misc queries) 0 November 29th 07 04:42 PM
In Excel 2003 is there a way to prevent "Save As" and "Print"? lucky2000 Excel Discussion (Misc queries) 3 April 26th 07 02:49 PM
My "Print Titles" option is grayed out. Vegas Rigger Excel Discussion (Misc queries) 1 April 23rd 06 04:42 AM


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"