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?
.
|