How do i supress the file opening box?

[Macdave_19]

Hi All,

I'm pretty good with VBA now and realy i should know how to do this but alas I don't.

I don't want the annoying Loading box to appear when a file is opening in Excel 2007.

Is there a way of doing this?

Cheers Folks

Dave

[fredlo2010]

Hi Mac,

Is this what you are looking for?

http://www.howtogeek.com/?post_type=post&p=104448

Create a shortcut to the application with this source

“C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE” /e

[Macdave_19]

Hi Fredlo,

Not quite mate,

I have a Macro which build a report, It open several Source xls, xlsm files etc however whe they are being opened there is an annoying box that appears with a progressbar on it.

I want to get rid of that if i can as i have a userform which it is appearing in front of.

Any ideas?

Cheers for any help

Dave

[fredlo2010]

It would be good if you could post your code and maybe a screen shot of the box. Boxes and messages can be tricky. I remember a couple of months ago the program was giving me an error that looked a lot like a msgbox I had two lines after the message showed up. It took me and a few others to figure out the code was not jumping backwards that it was something else. You get the point right?

[Macdave_19]

Hi dude,

There's no error mate its just an annoying box i don't want to have to see:

http://imgur.com/LcXdh