Where can I get all Excel Properties at a Glance

HCL Domino Domino Forum
1

Hi

Can any one tell me where should I get all the properties of Excel to print report in Excel ?

What is the Page Setup Property to change the Percentage to fit in the Paper by compression 75%.

I will be very much obliged for your reply.

Thanking you,

With regards.

Ranjit Kumar Sen.

2

Subject: Where can I get all Excel Properties at a Glance

  • Open up Excel* Select ‘Tools’ from the top menu bar, then select ‘Macro’ and then ‘Visual Basic Editor’

  • When the Visual Basic Editor has opened select ‘Help’ from the top menu bar then select ‘Microsoft Visual Basic Help’

  • From the list of Help options select ‘Microsoft Excel Visual Basic Reference’

From there you can view the Excel Objects, Methods & Properties.

Alex

3

Subject: RE: Where can I get all Excel Properties at a Glance

I do what Alex suggested except that when the Visual Basic Editor is open I press F2 (View → Object Browser) which allows you to er, browser all the different Office Objects.

If you select an object/method/property and press F1 the Office Help will open.

Frunobulax

4

Subject: Where can I get all Excel Properties at a Glance

Hi Alex & Frunobulax

Many many thanks for your help.

Ranjit Kumar Sen.