Excel constant values 
Author Message
 Excel constant values

Does anyone know how to get the actual definitions of the Microsoft Excel
constants?

Example:

I want powerbuilder to update an excel spreadsheet behind the scenes via
OLE automation, but I have to make the application and worksheets visible
to do it. To get around this, I want to minimize Excel:

iole_excel.application.windowstate = xlMinimized

The only problem is that I don't know what the value of xlMinimized is.

Any help would be appreciated.

Sean



Wed, 18 Jun 1902 08:00:00 GMT  
 Excel constant values

I'm not a PowerBuilder person but in VB the way to allow access to these
constants is to reference the library:

 which shows up in the reference dialog as

     Microsoft Excel 5.0 Object Library

and is the file named

    XL5EN.OLB

Even though I'm using Excel 7.0a it shows up as a 5.0 library.  Is there a
similar reference mechanism in
PowerBuilder?



Quote:
> Does anyone know how to get the actual definitions of the Microsoft Excel
> constants?

> Example:

> I want powerbuilder to update an excel spreadsheet behind the scenes via
> OLE automation, but I have to make the application and worksheets visible
> to do it. To get around this, I want to minimize Excel:

> iole_excel.application.windowstate = xlMinimized

> The only problem is that I don't know what the value of xlMinimized is.

> Any help would be appreciated.

> Sean




Wed, 18 Jun 1902 08:00:00 GMT  
 Excel constant values

I have a file called XLCONST.XLS that lists all the numerical values of
the intricis constants of Excel. If I remember right, i downloaded it
from Microsoft's site.

Martin Daoust

Quote:

> Does anyone know how to get the actual definitions of the Microsoft Excel
> constants?

> Example:

> I want powerbuilder to update an excel spreadsheet behind the scenes via
> OLE automation, but I have to make the application and worksheets visible
> to do it. To get around this, I want to minimize Excel:

> iole_excel.application.windowstate = xlMinimized

> The only problem is that I don't know what the value of xlMinimized is.

> Any help would be appreciated.

> Sean




Wed, 18 Jun 1902 08:00:00 GMT  
 Excel constant values



<< Does anyone know how to get the actual definitions of the Microsoft
Excel
constants? >>

Hi Sean,

The way I get these values is by getting into Excel, insert a module,
press Ctrl+G to bring up the debug window and in the Instant Pane type
in

?xlMinimized

In this case it returns

-4140

Not a sophisticated approach, but it works<g>,

Hope this helps,

John Green
Sydney
Australia



Wed, 18 Jun 1902 08:00:00 GMT  
 Excel constant values

Quote:

> Does anyone know how to get the actual definitions of the Microsoft Excel
> constants?
> Any help would be appreciated.

If you only need a few of the constants, use the MsgBox function to tell
you what the numeric value of them are, like this:

    MsgBox xlMinimized

This will show you that xlMinimized is -4140.

Stan Scott
Senior Manager
KPMG Peat Marwick



Wed, 18 Jun 1902 08:00:00 GMT  
 Excel constant values

Quote:

> Does anyone know how to get the actual definitions of the Microsoft Excel
> constants?
> Example:
> I want powerbuilder to update an excel spreadsheet behind the scenes via
> OLE automation, but I have to make the application and worksheets visible
> to do it. To get around this, I want to minimize Excel:
> iole_excel.application.windowstate = xlMinimized
> The only problem is that I don't know what the value of xlMinimized is.

And nor do you need to know. I know nada about powerbuilder but I imagine
that if it's capable of 'attaching' references to excel objects, then, as
the excel constants are included in that set of interface definitions,
there should be no problem.

Quote:
> Any help would be appreciated.
> Sean


--

Vox (0|+44)1642 216 200  }*|*{  *o|o*  }o|o{ Zetland Buildings, Exchange Square
Fax (0|+44)1642 216 201    o      o      *   Middlesbrough, Cleveland.  TS1 1DE
--------- "Estimate how many people in the UK can make this estimate" ---------


Wed, 18 Jun 1902 08:00:00 GMT  
 Excel constant values

Not sure what you mean by "definition", but download we0993.exe from
Microsoft;s FTP site.  It has a self expanding file that contains a
.bas and .xls with details of the excel constants.

ftp://ftp.microsoft.com/softlib/MSLFILES/we0993.exe

Unfortunately, the file has not been updated for Excel 97's updated
constants...(Hint Hint Microsoft...)

On Tue, 25 Feb 1997 09:03:35 +0000, Paul Sampson

Quote:


>> Does anyone know how to get the actual definitions of the Microsoft Excel
>> constants?

>> Example:

>> I want powerbuilder to update an excel spreadsheet behind the scenes via
>> OLE automation, but I have to make the application and worksheets visible
>> to do it. To get around this, I want to minimize Excel:

>> iole_excel.application.windowstate = xlMinimized

>> The only problem is that I don't know what the value of xlMinimized is.

>And nor do you need to know. I know nada about powerbuilder but I imagine
>that if it's capable of 'attaching' references to excel objects, then, as
>the excel constants are included in that set of interface definitions,
>there should be no problem.

>> Any help would be appreciated.

>> Sean

>--

>Vox (0|+44)1642 216 200  }*|*{  *o|o*  }o|o{ Zetland Buildings, Exchange Square
>Fax (0|+44)1642 216 201    o      o      *   Middlesbrough, Cleveland.  TS1 1DE
>--------- "Estimate how many people in the UK can make this estimate" ---------



Wed, 18 Jun 1902 08:00:00 GMT  
 Excel constant values

Quote:


> > Does anyone know how to get the actual definitions of the Microsoft Excel
> > constants?

> > Example:

> > I want powerbuilder to update an excel spreadsheet behind the scenes via
> > OLE automation, but I have to make the application and worksheets visible
> > to do it. To get around this, I want to minimize Excel:

> > iole_excel.application.windowstate = xlMinimized

> > The only problem is that I don't know what the value of xlMinimized is.

> And nor do you need to know. I know nada about powerbuilder but I imagine
> that if it's capable of 'attaching' references to excel objects, then, as
> the excel constants are included in that set of interface definitions,
> there should be no problem.

> > Any help would be appreciated.

> > Sean

> --

> Vox (0|+44)1642 216 200  }*|*{  *o|o*  }o|o{ Zetland Buildings, Exchange Square
> Fax (0|+44)1642 216 201    o      o      *   Middlesbrough, Cleveland.  TS1 1DE
> --------- "Estimate how many people in the UK can make this estimate" ---------

Use the object browser on Excel - Microsoft Excel 5.0 Object Library.
Select Constants and the one you want tp look at. The value will be at
the bottom of the window


Wed, 18 Jun 1902 08:00:00 GMT  
 Excel constant values

Quote:



> > > Does anyone know how to get the actual definitions of the Microsoft Excel
> > > constants?

> > > Example:

> > > I want powerbuilder to update an excel spreadsheet behind the scenes via
> > > OLE automation, but I have to make the application and worksheets visible
> > > to do it. To get around this, I want to minimize Excel:

Well, you can send the same keystrokes you would use in Excel using the
SendKeys statement. Works with most Windows applications.

eric

 "....and sometimes there are good days"  %)



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 9 post ] 

 Relevant Pages 

1. Excel constant values

2. Value of vertical alignment constants for Excel 97

3. Value of vertical alignment constants for Excel 97

4. constant value e - were to find and use in excel

5. Need values for Excel Constants -- quickly!

6. Getting Name value when value is a constant

7. excel.h or file listing excel constants

8. Get str constant to constant

9. Constants value ( xlVertical)

10. Constant's Value


 
Powered by phpBB® Forum Software © phpBB Group