![]() This script successfully launches excel, opens the specified workbook, and selects the specified worksheet. ObjXl.Goto ObjWb.Sheets("XYZ").Range("A1") Set objXl = CreateObject("Excel.Application") ![]() ' Opens Excel workbook "Workbook.xlsm" to worksheet "XYZ" ![]() So, I woite the following VB script: ' File: test.vbs I'd like to create Visual Basic script vbscript (a file on my Windows desktop) that launches Microsoft Excel, opens the macro-enabled Excel workbook file "Workbook.xlsm", and selects/activates the worksheet "XYZ" within that workbook. Working on a Windows 7 Enterprise 圆4 host with 64-bit Microsoft Office Professional Plus 2016 installed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |