Retrieving title bar info.

  • Thread starter Thread starter aah-boy
  • Start date Start date
A

aah-boy

Hi all,

This is not especially Excel related - but it's an interesting
question (in my view anyway).

Is there a way of getting the title bar contents of an open Windows
application ? ie. the stuff that appears in the blue bar at the top of
the screen of a 'windowed' package.

Any help would be appreciated,

Many thanks,
Dave
 
Dave,

Do you mean Application.Caption?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Dave,
Click to expand...

Hi Bob,

Thanks for the reply.
Do you mean Application.Caption?
Click to expand...

I'm trying to pick up something in the title bar of another
application to insert into my spreadsheet.

It's just another windowed package - but there is a number in its'
title bar that I can use to insert into my spreadsheet.

Regards,
Dave
 
Dave,

I had the same problem and made a general purpose workbook for this. It
works with a userform. It uses the code as mentioned in the post of Tom.
If you are interested I will send the workbook. It is about 70 Kb.

RBS
 
Back
Top