2 Messages
Digest #4352
Messages
Mon Jul 2, 2018 11:44 am (PDT) . Posted by:
JCHyjun
Randy,
Thank you for your help.
Small Macro:
ChDir "C:\SMF_AddIN"
Workbooks.Open(Filename:="C:\ SMFAddIN\RCH_Stock_Market_ Functions.xla"). _
RunAutoMacros Which:=xlAutoOpen
Application.Run "smfForceRecalculation"
Windows("YOUR_FILE_MANE.xlsm" ).Activate
solved the problem.
JCH
Thank you for your help.
Small Macro:
ChDir "C:\
Workbooks.Open(
RunAutoMacros Which:=xlAutoOpen
Application.
Windows("
solved the problem.
JCH
Mon Jul 2, 2018 11:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure why you needed to create another macro to call that macro. You can
just run the macro as-is. I have it assigned to a button, but it's also on
the EXCEL context menu.
On Mon, Jul 2, 2018 at 11:43 AM, jchyjun@
...
wrote:
>
> Small Macro:
>
> ChDir "C:\SMF_AddIN"
> Workbooks.Open(Filename:="C:\ SMFAddIN\RCH_Stock_Market_
> Functions.xla"). _
> RunAutoMacros Which:=xlAutoOpen
> Application.Run "smfForceRecalculation"
>
> Windows("YOUR_FILE_MANE.xlsm" ).Activate
>
> solved the problem.
>
>
>
just run the macro as-is. I have it assigned to a button, but it's also on
the EXCEL context menu.
On Mon, Jul 2, 2018 at 11:43 AM, jchyjun@
...
wrote:
>
> Small Macro:
>
> ChDir "C:\
> Workbooks.Open(
> Functions.xla"
> RunAutoMacros Which:=xlAutoOpen
> Application.
>
> Windows("
>
> solved the problem.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar