cemocan70 wrote: ↑Thu Dec 24, 2020 9:27 am
After i've read firlandsfarm's post and changed the destination folder's name it looks like downloading the files but still getting the same error message, the main problem is the youtube links are not exists anymore so the excel dummies like me having problems.
Maybe it will help if I explain what I did and I apologise to Murdok and other contributors if they have already gone beyond this stage but it may be useful to some. Let me make something clear ... I am not an Excel expert nor a VBA person. I used to do coding when amateurs like me used BASIC language so I do have a rough idea how things work.
You need to see the VBA code and can do this by right clicking on any of the worksheet tabs at the bottom of the workbook and selecting "View Code". This opens the VBA editor.
In the left margin of the VBA editor you should see a section "Modules". Click on that and then Module 1 and the code will appear. You will see that the code is broken down in sections headed Sub UKWin() ... Sub UKPlace ... etc. And notice the first line of the code under those headings is the name of the folder where the downloaded files will be stored. Example ...
Sub UKWin()
FolderName = "UK Win"
I use the given folder names for storing the downloaded files but if you want to you can change them within the quotes.
Now scroll down to near the bottom of the code until you see the "Sub DownloadFiles()" ... this is the code instructing the app where to save the files. You will see a line (the 'bold text' is simply to highlight for you the text I changed).
DestinationFolder = "
C:\" & FolderName & "\" & DownloadFileName
This is where you can change the destination. For example I changed this to read ...
DestinationFolder = "
H:\Documents(H)\Money\Betting\Data\Betfair\Betfair SP's\" & FolderName & "\" & DownloadFileName
So I changed the destination from "
C:\" to "b]H:\Documents(H)\Money\Betting\Data\Betfair\Betfair SP's\[/b]" ... you can choose any destination path that suits your folder structure but that destination path and the eventual folder name must already exist before downloading otherwise the files will look as if downloading but just disappear into the ether!
I hope this helps you to see how the code works, once you know that, you can customise it for your own purposes but only change things in "quotes" which are assignments of text ... do not change anything outside of "quotes" unless you really know what you are doing because that is the code!