Where can I learn about windows, pallets, etc for scripting?

[Bill Weylock]

I¹m trying to use QuicKeys to recreate a few macros, and I am bumping into
fine points about window control.

I know this has to be incredibly basic, but what are the differences among
windows, sheets, palettes, etc? Is there a tech doc someone can link me to?

Or just shoot me?

Thanks!


Best,

Bill
Imac 2.8Ghz -10.5.1
Office 2008/2003 - Windows XP Pro SP2

 

[JE McGimpsey]

I¹m trying to use QuicKeys to recreate a few macros, and I am bumping into
fine points about window control.

I know this has to be incredibly basic, but what are the differences among
windows, sheets, palettes, etc? Is there a tech doc someone can link me to?

Or just shoot me?

Not sure what you're doing with QuicKeys, but on a Document Object Model
(DOM) level:

Window: Child object of Application, and member of Application's
Windows Collection. A workbook has a Windows Collection as well, that
contains the windows for that workbook. Windows contain scrollbars and
captions, and control certain preferences, such as gridlines, freeze
panes, splits, outlines, selected sheets, display zeros, etc.


Workbook: Also a child object of Application, and member of
Application's Workbooks Collection. A workbook contains worksheets,
chart sheets, macro sheets, vbprojects, etc., and contains
workbook-level collections such as Names, styles, colors, WebOptions
and document properties. Workbook-level methods include Open, Close,
PrintOut, Protect, Save, Follow Hyperlink, New Window, etc.
Workbook-level properties include date system, activesheet, activechart,
precision as displayed, protect workbook, etc.

Worksheet: A child object of Workbook, belongs to the workbook's
Worksheets collection. A worksheet contains ranges, rows, columns, page
breaks, Names, Page Setup objects, hyperlinks, Pivot Tables, Chart
objects, comment objects, autofilter objects, shape objects, list
objects, etc. Worksheet-level methods include Calculate, Copy, Delete,
Paste, Move, PrintOut, Protect, Select, etc. Properties include used
range, visible, display page breaks, circular reference, etc.

Palettes: Palette's in the DOM exist as Command Bars (toolbars) but
have fewer features - they're not customizable, though you can change
their visible, top, left, height and width properties.

 

[Bill Weylock]

JE -

Thanks!

The question was at least marginally off-topic, which is what threw you.

I was asking about the MacOS interface rather than Excel. So sorry I put you
to that trouble, but I do think it moves me ahead and certainly adds to my
general knowledge. Thanks!


Best,


- Bill



Not sure what you're doing with QuicKeys, but on a Document Object Model
(DOM) level:

Window: Child object of Application, and member of Application's
Windows Collection. A workbook has a Windows Collection as well, that
contains the windows for that workbook. Windows contain scrollbars and
captions, and control certain preferences, such as gridlines, freeze
panes, splits, outlines, selected sheets, display zeros, etc.


Workbook: Also a child object of Application, and member of
Application's Workbooks Collection. A workbook contains worksheets,
chart sheets, macro sheets, vbprojects, etc., and contains
workbook-level collections such as Names, styles, colors, WebOptions
and document properties. Workbook-level methods include Open, Close,
PrintOut, Protect, Save, Follow Hyperlink, New Window, etc.
Workbook-level properties include date system, activesheet, activechart,
precision as displayed, protect workbook, etc.

Worksheet: A child object of Workbook, belongs to the workbook's
Worksheets collection. A worksheet contains ranges, rows, columns, page
breaks, Names, Page Setup objects, hyperlinks, Pivot Tables, Chart
objects, comment objects, autofilter objects, shape objects, list
objects, etc. Worksheet-level methods include Calculate, Copy, Delete,
Paste, Move, PrintOut, Protect, Select, etc. Properties include used
range, visible, display page breaks, circular reference, etc.

Palettes: Palette's in the DOM exist as Command Bars (toolbars) but
have fewer features - they're not customizable, though you can change
their visible, top, left, height and width properties.[/QUOTE]

Best,

Bill
Imac 2.8Ghz -10.5.1
Office 2008/2003 - Windows XP Pro SP2

 

[Daiya Mitchell]

Hi Bill,

I'm working on some simple scripts to set the window size, view and zoom
in one click. Would that be useful? Word scripts, rather than OS ones.

Daiya

 

[Bill Weylock]

It would be brilliant, Daiya!

I was going to teach myself Applescript, which is not a good use of my time
or the planet¹s resources.

You may recall from other posts that my main agenda is to recreate the
wonderful ³Arrange All Vertically² macro that I believe one of you wrote
(Clive? John?).

Is that what you¹re doing???


Best,


- Bill

 

[Daiya Mitchell]

Hi Bill,

I'm trying to use this situation to force myself to learn AppleScript.

Arrange All Vertically is *way* *way* beyond my capabilities (but I
tried to drop a hint in some more skilled quarters). But it wasn't
perfect for me anyhow--two windows was perfect, but if I used it with
more than two windows open, they came out more narrow than I preferred.

So far I've arrived at a one-click script to set my preferred size,
view, and zoom. Since my preferred is just enough to show two docs side
by side, this lets me set the size on one, set the size on the other,
then move one to the right (which is what I did half the time anyhow).
If you want a copy, email me privately, as the script is still
experimental--you should be able to decode my address.

Daiya