For a better experience, please enable JavaScript in your browser before proceeding.I am new to VBA macros and want to prepare a macro which will 1.Fortunately I have now a macro which can do first 2 steps but I am struggling to work for 3rd step.
LocalFilename 34;here the drive and download directory34; DownloadFile. MsgBox 34;Download Status: 34; URLDownloadToFile(0, URL, LocalFilename, 0, 0) 0. Many thanks for your prompt responce Was little worried if you could help me here, as when I added Website address, path and name of sheet to download, it gives me error as RUN TIME ERROR 13 - TYPE MISMATCH I googled about it, but no success yet. Vba For Directory Path In Excel 2011 Password For ObviousI am not on my desk at my desk so Apologies I could not find if your solution is right, but I am sure you are pointing at correct thing The website that I was trying to download data needed a Login,password for obvious reasons. ![]() Regards PS: But as Marc L correctly stated, for newbies to VBA itd be either funny or hardly painful, depending on your sense of humor. Now the problem is though I dont want the msgbox because I just want to run it and not have a user do anything. Vba For Directory Path In Excel 2011 Code And II dont understand code and I cant figure out why it is the case but with the MsgBox command it works perfect without it, it doesnt save the file.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |