Hi All,
I'm struggling with the following. I need to write a script that will 1) identify the users' default download location, and 2) open the latest download within said download location.
Essentially, I've automated internet explorer to download an excel file to the end-users machine, but not everyone has the same default download location.
Any ideas here?
Thanks in advanced!
Does this work for you ?
Please Login or Register to view this content.
Last edited by bakerman2; 05-09-2018 at 01:48 AM. Reason: Typo
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi Bakerman2,
This is great. However, how would I go about opening the file using vba? This returns the name of the excel file in a message box.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks