I'm trying to open the UserForm1 of an excel macro through batch file. I'm able to open that but excel is also getting opened along with that. I want only UserForm1 to be opened not the excel. Below is my approach :
I have written a macros to open the UserForm1
Sub open_form()
UserForm1.Show
End Sub
In batch File:
@echo off
cd "c:\Test\"
openFormTest.xlsm
By the above approach, When I'm running the batch file both UserForm1 and excel are getting open, but I want to open only UserForm1. Kindly help me out