Can vba change the default path of IE save as file dialogue box?

Hi all,

Can vba change the default path of IE save as file dialogue box?
Thanks.

Thanks JasperD. Your information is very useful. I wonder VBA can change Registery before.
by the way, It seem complex.

Originally Posted by JasperD

Most likely, yes.

http://support.microsoft.com/en-us/kb/258867
http://www.slipstick.com/developer/r...key-using-vba/

Thanks Leith. In fact, I will call a browser to save file. The object of this browser called open twebst. I am not sure if you hear from it.
My idea is that I call the twebst object to nagivate a webpage
then click submit button though the open twebst
then change the default path of IE save file.
then copy my filename to the clipboard using MSForms.DataObject
then I manual ctrl-V the clipboard to the filename.

only "change the default path of IE save file" I can't write the macro.

Originally Posted by Leith Ross

Hello mrkhchan,

I have code to do this. Telling me which folder you want to change to will shorten the code. Which folder will be the new default?

maybe my technique is not good enough. I only can use twebst to perform some click or select action.
If you don't mind, Would you help to provide the methiod of change the deafault folder? Thanks.

Originally Posted by Leith Ross

Hello mrkhchan,

So, do you still the code to change the default folder or can you do this with twebst?