Run Time Error '13' Type Mismatch
Hi guys,
I am trying to browse a file and then download a file into the selected browsed file location.
here is my code
I am getting a mismatch error here in this particular set of code:
Please Login or Register to view this content.
MsgBox "Download Status : " & URLDownloadToFile(0, URL, LocalFilename, 0, 0) = 0
thanks guys..
Best Regards
Plasma33
Last edited by plasma33; 12-24-2014 at 09:38 PM.
Hello Plasma33
Try:
To convert the Boolean function call 'result' to StringPlease Login or Register to view this content.
If this was helpful then please click the small star icon at the bottom left of my post. A little appreciation goes a long way.
Barryleajo beat me to it.
David
(*) Reputation points appreciated.
You shouldn't need to convert the boolean to a string.
Have you checked what this is returning when you get the error?
Please Login or Register to view this content.
If posting code please use code tags, see here.
Norie,
I get the same 'Error 13'. A long value of 0 is returned. When the '= 0' is removed the function works fine. I get the same error even when I cast everything to long using CLng.
---------------------
However, since 'Option Explicit' is not used at the top, incorrect API declarations sneak by the compiler.
Try the following code. After testing, remove the lines in red below, which were used to test a smaller file to download.
To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspxPlease Login or Register to view this content.
Lewis
Last edited by LJMetzger; 12-24-2014 at 11:15 AM.
I think wrapping the expression in quotes might fix things.
If you don't do that you could have something like this,Please Login or Register to view this content.
which will return a type mismatch.Please Login or Register to view this content.
As will this,
and this.Please Login or Register to view this content.
All work without error when you wrap the expression in ().Please Login or Register to view this content.
Please Login or Register to view this content.
Norie,
Wrapping the expression in parentheses made runtime error 13 go away. Great catch.
LewisPlease Login or Register to view this content.
Oops, meant quotes not brackets.
Hi guys,
First of all Wish everyone of you a Merry Christmas!!
Thank you all for your kind replies. I checked all the solutions given by you guys. It all worked but its giving me a message saying "Download Status: False". I checked the link and its working perfectly. So the URL is not an issue. I also disabled my antivirus and then tried again but I am still getting the same message.
The code that I am using now is as following:
@Lewis,Please Login or Register to view this content.
I tried your solution but its giving me a type mismatch compile error in the following piece of code highlighting "URLDownloadToFile":
Thanks guys for all your help!!Please Login or Register to view this content.
Best Regards
Plasma33
Last edited by plasma33; 12-24-2014 at 07:45 PM. Reason: Forgot to Wish everyone Merry Christmas!!
@Norie,
When I tried your piece of code which is...I got the following message i.e. "Download Status: -2146697203". I tried searching that number on google but didn't find anything.Please Login or Register to view this content.
Thanks.
Best Regards
Plasma33
plasma,
Your error is probably because the file can't be found.
Your original code:
Please Login or Register to view this content.
Corrected code (tested and working):
Please Login or Register to view this content.
Lewis
hi lewis,
thank you for the prompt reply. it works perfectly fine now. i just have one more query. now the file thats downloading has file name as "whatever_file_chosen_by_user.exef1040sb.pdf". i just want the file name as "f104sb.pdf" but the file should be downloaded in the same location as the browsed file.
thanks lewis for all your help.
best regards
plasma33
plasma33
Eh, I didn't post that code.
Last edited by Norie; 12-25-2014 at 08:41 AM.
Hi plasma33,
The rep points are much appreciated.
1. I changed the code to look for a folder instead of a file.
2. Your profile says Excel 2003, but the code does not compile using Excel 2003. Please update your profile to indicate which version(s) of Excel you are using.
3. I corrected the declarations at the top to eliminate sleep(), which is not needed. I added URLDownloadToFile() declaration at the top so the code should compile for any version of Excel.
4. You should use 'Option Explicit' at the very top of your file. You will get compile errors because several variables must be defined with Dim statements. To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx
See the following code with subtle changes in red.
LewisPlease Login or Register to view this content.
thanks lewis for the code and no worries about the rep.
i have changed my excel version.
i will be using option explicit from now on.
thanks again, lewis.
best regards
plasma33
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks