PDA

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



gringo287
12-08-2012, 04:37 AM
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
12-08-2012, 05:54 AM
why not attach your file ?

Daxton A.
12-08-2012, 06:01 AM
application.DisplayAlerts = False

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

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

gringo287
12-08-2012, 06:01 AM
No point, the links are internal

gringo287
12-08-2012, 06:20 AM
why not attach your file ?


no point the links are internal

Daxton A.
12-08-2012, 08:15 AM
change the www_ to .

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

gringo287
12-10-2012, 10:34 AM
Thank you Daxton A