Excel file name changes when downloaded

Re: Excel file name change causes macro not to work You've been quite helpful. I think I will abandon the ribbon idea. Seems too risky. Made shortcuts to the macros, hence the elegance. That will give me what I am looking for. Thanks very much. Replies: 1 Last Post: , PM. Old excel file with picture insert macro doesn't work properly Replies: 4 Last Post: , PM.

Replies: 2 Last Post: , PM. Replies: 3 Last Post: , PM. This is my code: Is there anyway that I can give the file being downloaded a specific name? Improve this question. Why not rename it after the download Using the Shutil module? Since the filname always have a random name, I want to name it when I am downloading it. So it will be easier to locate it later. Add a comment. Active Oldest Votes. Improve this answer. Community Bot 1 1 1 silver badge. If yest which package? I need to import it accordingly.

You need the below 3 imports. The chrome entry was helpful, but "except: pass" is a horrible idea. In incognito mode at least on the latest chrome, it spits out an error: selenium. JavascriptException: Message: javascript error: Cannot read property 'shadowRoot' of null It can't find the percentage tag it seems, and fails with no proper error message due to your overly broad except case. Thanks for bringing up the behavior in the latest chrome version.

There might be changes to the behavior of the browser, I will take a look into this. This is still the most efficient answer for me with a few tweaks though If you want the webdriver to always wait until the download is complete, you can remove the wait time and the if block — kcEmenike. Show 5 more comments. Note: borrowed methods from google searches may have errors.

Sudharsana Rajasekaran 3 3 silver badges 10 10 bronze badges. The problem with above code is that filename var gets its value before the download is finished. This will create two type of errors. If the download directory was empty, then filename will be empty and hence shutil. If the directory was not empty, filename will get the name of last file downloaded before current file which is still downloading and shutil.

Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Project Bonsai. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT. Green Tech. MVP Award Program. Video Hub Azure. Free Download You are guest Login Now. Loading comment The comment will be refreshed after To post as a guest, your comment is unpublished.

Love this so much! Is there a way to use Kutools to edit metadata tags for music similar to this with filenames? Would love being able to mass edit song tags through Excel rather than on iTunes or other third party song tag editors.

Thank you! I did this for a couple of files and it worked successfully. The next few files i tried, did not work. There were a few formulas added to the new names, could that be the issue? Thank you so much for your information.

It was really nice! Hi there It does not work with unicode file names. How can it be done fine? Hi, I'm trying to use the code for renaming the non extension files to files with extension. It works fine with files which have extension already. Thanks Jay. Hello, some of the files have same name. Scripts skip those files. Is there a way to modify the script so it adds a number 1, 2, 3 and so on for every duplicate name? Hello, Kay, To rename the files based on duplicate new names with name-1,name-2, the following VBA code may help you, please try it.

Value If Not xDictionary. Exists xVal Then xDictionary. Add xVal, xCount Else xDictionary.