I need to open the Worksheet exactly as in my shortcut target otherwise my other software I'm using can't find it. My Software will only update my cells if my shortcut is open.

My Shortcut Target is:
"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" "c:\Batch Records\ShiftRecords"
My Shortcut Start in is:
"C:\Program Files\Microsoft Office\Office10"

Recommended Answers

All 2 Replies

Private Sub Command1_Click()
Shell "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE"
End Sub

Thanks JX_MAN but I already know how to open Excell with the Shell command, my problem is that opening Excel and my wookbook separatly must not work the same as opening them together as my shortcut does.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.