Button Action

[joebuck0220]

Is there a way to make a button open up an excel document and make it go to a certain page? Please any info will help!

[joebuck0220]

thanx that helps

[Worm]

Try this:


--Create a ExcleApp object
oExcelApp=luacom.CreateObject("Excel.Application")
--Create a Document Object
oXLS=luacom.CreateObject("Excel.Document")

--Make the ExcelApp visible
oExcelApp.Visible = true;

--Open Excel Document
oXLS=oExcelApp.Workbooks:Open(_SourceFolder.."\\MyExcelWorkBook.xls")

--Select the WorkBook
oExcelApp.WorkBooks( nil, 1).Activate(nil)

--Jump to the Worksheet
oExcelApp.ActiveWorkbook.Sheets(nil,"Sheet Name").Select(nil)

[Worm]

Why, Thank You... I think!?

:p :D :)

You're just too bad ass, Worm...



...just too bad ass