Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 29th, 2004, 10:29 AM
Authorized User
 
Join Date: Dec 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Taskbar

Hello All,

This may sound like a strange request but does anyone know how to hide the application from the task bar but still have it running.

Is there a vba shell command which will do this??

Cheers

 
Old July 5th, 2004, 04:06 AM
Authorized User
 
Join Date: Jun 2003
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

From VB/VBA you can try this:

Code:
Dim xlApp as Object
Set xlApp = CreateObject("Excel.Application")
This creates a "hidden" instance of the Excel application. To make it visible (ie. appear in the taskbar) you would need to set the Visible property to True, eg.

Code:
xlApp.Visible = True
 
Old July 5th, 2004, 04:26 AM
Authorized User
 
Join Date: Jun 2004
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

  If you are using VB 6 then set 'ShowInTaskbar' = False of form property in design mode...
or
  appprocessid = Shell (app.path "full file path" ,vbHide)

 and if you are using xlvba then gcianfanelli is right

thanks,





Stay Beautiful,
Abdul Salam





Similar Threads
Thread Thread Starter Forum Replies Last Post
Window visible in taskbar pazzuzu Visual C++ 1 March 31st, 2006 04:21 AM
flashing taskbar button jon23d Access VBA 1 July 7th, 2005 03:26 PM
Hide the Taskbar yeetesh VB How-To 1 January 10th, 2005 09:25 AM
How to make a Form dock onto the taskbar dinosaur_uk VB.NET 2002/2003 Basics 1 September 24th, 2004 10:14 AM
Disabling the Taskbar FSBC Excel VBA 3 April 24th, 2004 03:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.