Opening Workbook Using Notepad (VBA)

[MistakesWereMade]

I currently open a workbook using code written on a notepad file. However, the userform that pops up has disabled features it seems... For one, my userform has a combobox that allows me to open other excel files when selected, but when using the notepad, this feature is disabled. Instead, I must manually reveal the workbook that I would like hidden, after which the userform opened file will then pop up. It seems like the notepad suppresses all excel files from opening when I would like for the active workbook to stay closed and any newly opened ones to show. If I open the workbook manually without the notepad file, the userform works the way I want it to.

Any ideas on what could be happening and how to fix this?

My code in my notepad file is listed below.

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
Set objWorkbook = objExcel.Workbooks.Open("C:\Users\MyUser\Desktop\Folder\Operations.xlsm")

 

[CharlesChuckieCharles]

Why don't you put the Workbook.visible = false in the workbook.open macro in the thisworkbook module of the Operations.xlsm and just get rid of the notepad code?

 

[MistakesWereMade]

I want to get rid of the excel loading prompt at the beginning of opening an excel file. I also want to create a shortcut to my notepad so that I can make my own icon.

 

[CharlesChuckieCharles]

if you create a shortcut for your Excel you can change the load by adding "/e" (forward slash e) to suppress the loading screen, and you can change the ICON on your shortcut to whatever you wish

"excel.exe /e C:\...\operations.xlsm"

 

[MistakesWereMade]

Genius! Thanks! I did some snooping around command line arguments and found that changing the "target" box in the properties window of my custom shortcut to the line below got it working!

"C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" /e "C:\Users\MyUser\Desktop\Folder\My Excel File.xlsm"

Thanks again for your help CharlesChuckieCharles!