View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Stone Frank Stone is offline
external usenet poster
 
Posts: 134
Default Run a macro in a workbook through VB6

hi,
If the macro is in the current WB then
toolsMacrosmacrorun should do it. you will be prompted
of the perameters.
If the macro is to be run on another WB then code must be
add to open the other workbook.
ChDir "C:\dir1"
Workbooks.Open Filename:="C:\Dir1\file2.xls"
or if open to activate the file.
Windows("file2.xls").Activate

-----Original Message-----
What is the proper syntax to run a macro which has
parameters in a specified workbook?
.