Show Excel From Task Bar 1

[mavest]

I am automating Excel through Visio.

In one instance I want a button in Visio to bring a certain Excel worksheet to the front. I've gotten this to work fine as long as Excel is not minimized to the task bar, i.e. it works if Excel is currently displaying as a window. However, the user may have Excel minimized to the task bar!

So the question is how can I get Excel to come off the task bar and show itself as a window in the fore ground.

Here are a few lines that I've been using:

If Not xlwb Is Nothing Then
xlwb.Application.Visible = True
xlwb.Worksheets(wksht).Activate
'xlwb.Worksheets(wksht).home
'xlApp.ScreenUpdating = True
End If

as mentioned they will not bring Excel off the task bar.


Thanks for your help!!

-Mike

 

[PHV]

Have you tried this ?
xlwb.Application.WindowState = xlMaximized

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mavest]

Thanks!

xlwb.application.windowstate = xlnormal

does just what I want!


-Mike