arkusM
02-08-2010, 01:46 PM
Not to sound like a broken record...
But Posted the below question here (http://www.vbaexpress.com/forum/showthread.php?t=29333).
I have some code that opens a webpage input values and submits the form.
At this point the dialog box asking what you want to do with the file pops up.
Can I get VB to say "Download" and if so specify the path?
I have spent quite a bit of time searching online. No luck!
I understand that ok'ing a download may go againt basic security issues. And if so that is fine.
That thread was marked 'solved' as Oorang was able to point me to a
'work around' of sorts.
However, though that works well, people want the same function for a different site. and now I am back to the same problem.
This time however the file to download is not from a known or predicatable format. It appears to be in sequential order, accelerated by requests. ie. I ask once, I get 1.csv, I ask again i get 2.csv, I ask a again and I get 4.csv, because someone other than me made a request between my second and third requests. confused?
Anyway I still need a way to get around the "Save-As" dialog box.
Or at least a way to store the file name and path specificed by the user in a variable so I can continue running the marco to go get the file and process. A lot of searching has yielded no results, unless I search for the wrong terms...
Thanks in advance.
But Posted the below question here (http://www.vbaexpress.com/forum/showthread.php?t=29333).
I have some code that opens a webpage input values and submits the form.
At this point the dialog box asking what you want to do with the file pops up.
Can I get VB to say "Download" and if so specify the path?
I have spent quite a bit of time searching online. No luck!
I understand that ok'ing a download may go againt basic security issues. And if so that is fine.
That thread was marked 'solved' as Oorang was able to point me to a
'work around' of sorts.
However, though that works well, people want the same function for a different site. and now I am back to the same problem.
This time however the file to download is not from a known or predicatable format. It appears to be in sequential order, accelerated by requests. ie. I ask once, I get 1.csv, I ask again i get 2.csv, I ask a again and I get 4.csv, because someone other than me made a request between my second and third requests. confused?
Anyway I still need a way to get around the "Save-As" dialog box.
Or at least a way to store the file name and path specificed by the user in a variable so I can continue running the marco to go get the file and process. A lot of searching has yielded no results, unless I search for the wrong terms...
Thanks in advance.