Solved: how to programatically skip the "open or Save" box.

[gringo287]

Hi,

Ive set up a userform that allows users (amongst other things), to gain quick access to useful product info though command boxes, that are linked to a WebBrowser control. it works very well, but theres one "useful" aspect that im struggling with. Theres an existing spread sheet that users already use, that i intend on linking to the WebBrowser. Ive tested it and it technically works,but, it asks the user if they want to open or save the file. This is far to complicated a task for a user, so if they get confused and (X) off the "open,save" box, it crashes and opens up the debug box, which really freaks them out.

How auto "open" the sheet??

[patel]

why not attach your file ?

[Daxton A.]

[vba]application.DisplayAlerts = False[/vba]

Note: Make sure that you end the code by turning the displays back on though

http://www.excelforum.com/excel-gene...ialog-box.html

[gringo287]

No point, the links are internal

[gringo287]

why not attach your file ?

no point the links are internal

[Daxton A.]

change the www_ to .

www_excelforum.com/excel-general/491778-how-do-you-turn-off-save-a-copy-overwrite-changes-dialog-box.html

[gringo287]

Thank you Daxton A