Folder select box appears behind the active window?!?

[MonkeyDeath]

I have a macro attached to a button in outlook. all this button does is start and excel workbook and start a marco in excel, then closes the excel workbook.

this is the code in outlook

Please Login or Register  to view this content.

the first part of the code in excel opens a folder picker dialogue box. but the dialogue box opens behind everything that is open.....

Please Login or Register  to view this content.

so i though AH HA! i'll minimise outlook at the first part of the code, and it worked. But if i have another window open, my diaglogue box opens behind that too. i think its because Excel is opening in the background, is there any way of forcing it to open in the foreground?

[romperstomper]

Try adding:

Please Login or Register  to view this content.

[MonkeyDeath]

where would i add that?

[romperstomper]

Before your xlApp.Run line.

[MonkeyDeath]

tried it before, after etc and it still have the same effect.

[romperstomper]

Try this:

Please Login or Register  to view this content.

[MonkeyDeath]

Right, only just got back on this.

Romper, your method works (as you know) but it opens excel as well.....all i need to do is force the dialogue box to the front. as it opens inthe background, and excel doesnt open

i did find this. http://stackoverflow.com/questions/8...-basic-not-vba but I can not seem to get it to work.

[romperstomper]

Excel does open, it was just invisible before. I don't think AppActivate will work if Excel is hidden but you could try using:

Please Login or Register  to view this content.

and comment out the

Please Login or Register  to view this content.

line.

[MonkeyDeath]

the weird thing is, if i open and close the Visual Basic editor in outlook, then run my original code, the dialogue box then opens infront of all applications until i close outlook. then it reverts back to opening behind all open windows.

[romperstomper]

Try automating that then?

[MonkeyDeath]

Keh?

This text is just to pad out the messgae, as the forum said "Keh?" was too short for a reply.

[MonkeyDeath]

Just worked it out

Please Login or Register  to view this content.

[romperstomper]

Why use GetObject when you already have a reference to the application?

Please Login or Register  to view this content.

rather than:

Please Login or Register  to view this content.

[MonkeyDeath]

i was going to go through it, its a bastardised part from another macro, as i wrote it.

it seems to work gfine on my PC but not a collegues. ARRRGHHH!!!