How to pass xlVeryHidden command to excel? 1

[ctbaker]

We have the two normal commands for making a sheet visible and hidden in VoxPro:

XLApp.ActiveSheet.Visible = .F. <- Make it hidden
XLApp.ActiveSheet.Visible = .T. <- Visible

But there is also the Visual Basic command (coded in Excel) you can use of:

Sheets(&quot;Sheet1&quot.Visible = xlVeryHidden

How do we pass this in FoxPro?

Thanks,
Chad

 

[Mike Gagnon]

ctbaker

o=CREATEOBJECT(&quot;excel.application&quot
oA= o.ActiveSheet
oA= o.Workbooks.Add()
oa1 = oA.ActiveSheet
oa1.Visible = 2 && xlSheetVeryHidden


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Chad,

In general, if you want to know the value of a built-in VBA constant like xlVeryHidden, open the VBA class-browser and do a search for the constant in question. When you find it, hightlight it and read the value from the bottom of the window.

As Mike G has already pointed out, in this case you would see that xlVeryHidden is equal to 2.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[ctbaker]

Thanks Mike and Mike!!

Both your responses were very helpful!