Seeking code to open an excel file WITHOUT adding its icon to the Windows7 Taskbar tray (vba user)

From its fluent ribbon, 'master_xl file.xlsm' opens and closes xl files: 'sub_xl1.xlsm' and  'sub_xl2.xlsm' .

When master_xl file.xlsm is open I wish its icon to appear in the within the stack of xl_icons (as default) in the Windows7 Taskbar tray
When sub_xl1.xlsm opens, its icon should also  appear in the stack of xl_icons

However, sub_xl2.xlsm opens I dont want its icon visible in the Taskbar tray. When I want to bring the Window for sub_xl2.xlsm to the front (to read it), I will just activate it via the master fluent ribbon.

How can I use code to exclude the icon for sub_xl2.xlsm from the Taskbar?
Thanks!

Kelvin4
Kelvin4Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
You can't as that is a function of the operating system
0
NVITCommented:
Try cmdow http://sourceforge.net/projects/cmdow/ 

Cmdow is a Win32 commandline utility for NT4/2000/XP/2003/2008/7 that allows windows to be listed, moved, resized, renamed, hidden/unhidden, disabled/enabled, minimized, maximized, restored, activated/inactivated, closed, killed and more.

Use the /HID option which hides the specified window. Although a hidden window will not be shown on the taskbar, it will still run and may be unhidden later.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The following code will open Test.xlsx which is saved on your Desktop and you won't see the opened excel file on your taskbar.

Is this what you are trying to achieve?
Sub OpenAndHideExcel()
Dim xlApp As Excel.Application
Dim wb As Workbook
Dim ws As Worksheet
Set xlApp = New Excel.Application
xlApp.Workbooks.Open Environ("UserProfile") & "\Desktop\Test.xlsx"
Set wb = xlApp.ActiveWorkbook
Set ws = wb.ActiveSheet
MsgBox ws.Name
wb.Close
xlApp.Quit
End Sub

Open in new window

0
Kelvin4Author Commented:
Fast and positive responses
Many thanks!
Kelvin
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.