View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
chandlm[_6_] chandlm[_6_] is offline
external usenet poster
 
Posts: 1
Default Opening excel spreadsheet from within a VBscript

DISCO.

Try

Set xl = CreateObject("Excel.application")

xl.Application.Workbooks.Open "yourworkbookpath\yourworkbook.xls"
xl.Application.Visible = True
xl.Application.run "'yourworkbookname.xls'!macronametorun"

Set xl = Nothing


This should do exactly what you need.

HTH


---
Message posted from http://www.ExcelForum.com/