You can open an excel file from a batch script and run a macro whenever the excel file is opened, but whatever you are trying to do will probably be done better if it is not done with a macro
Use a VBS script to open an instance of excel and then you can load the file and run the macro/function you're interested in. This should offer you all the control you need from what you have described.
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = true
xlApp.Application.Workbooks.Open ("C:\folders\file name.xlsm")
xlApp.Application.Run ("'file name.xlsm'!MacroName")
Bookmark topics by just clicking on bookmark icon.
Connect to personal services for more relevant search results across services.