Dowload excel file from one drive folder using excel vba
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I would appreciate if someone could help me in downloading an excel file from a onedrive folder.
One of my colleague has shared a one drive folder link. Where he keeps changing the excel file every day. Inside the folder contains only one file. I have a link of a folder. I will not have link of the file inside the folder, because every day file will be replaced. How do I download the excel file inside the onedrive folder using excel vba. Also it would be great if you could give me an idea on how to download an excel file with it's partial name inside a folder. Any portion of the solution is fine.
Please note that, it's an office 365 onedrive not Sharepoint. Will the provided solution work for google drive as well?
excel vba internet-explorer automation onedrive
edited Nov 26 '18 at 7:22
Pᴇʜ
25.3k63052
asked Nov 24 '18 at 23:22
SinghSingh
93
add a comment |
I would appreciate if someone could help me in downloading an excel file from a onedrive folder.
One of my colleague has shared a one drive folder link. Where he keeps changing the excel file every day. Inside the folder contains only one file. I have a link of a folder. I will not have link of the file inside the folder, because every day file will be replaced. How do I download the excel file inside the onedrive folder using excel vba. Also it would be great if you could give me an idea on how to download an excel file with it's partial name inside a folder. Any portion of the solution is fine.
Please note that, it's an office 365 onedrive not Sharepoint. Will the provided solution work for google drive as well?
excel vba internet-explorer automation onedrive
edited Nov 26 '18 at 7:22
Pᴇʜ
25.3k63052
asked Nov 24 '18 at 23:22
SinghSingh
93
2
This is still too broad at present. Please see Minimal, Complete, and Verifiable example and How to Ask for guidance on showing your research attempts and sharing current coding.
– QHarr
Nov 25 '18 at 8:49
i have not found any code on internet, which will download the excel file from one drive folder. If could write the complete vba code, it will be helpful for me. Assume one link to go to the one drive folder and once you opened that link there is only on excel file that needs to be downloaded in your local drive.
– Singh
Nov 25 '18 at 9:22
Meanwhile, can you plese help on this?
– Singh
Nov 25 '18 at 18:16
1
Welcome to Stack Overflow. You might have misunderstood how this site works. Please note that because this is no free code writing service it is necessary to show either what you have tried so far and where you got stuck or errors (by showing your code) or at least to show what you have researched and the effort you made. Otherwise it is just asking us to do all the work for you. Taking the Tour and reading How to Ask might help you to improve your question.
– Pᴇʜ
Nov 26 '18 at 7:23
add a comment |
I would appreciate if someone could help me in downloading an excel file from a onedrive folder.
One of my colleague has shared a one drive folder link. Where he keeps changing the excel file every day. Inside the folder contains only one file. I have a link of a folder. I will not have link of the file inside the folder, because every day file will be replaced. How do I download the excel file inside the onedrive folder using excel vba. Also it would be great if you could give me an idea on how to download an excel file with it's partial name inside a folder. Any portion of the solution is fine.
Please note that, it's an office 365 onedrive not Sharepoint. Will the provided solution work for google drive as well?
excel vba internet-explorer automation onedrive
edited Nov 26 '18 at 7:22
Pᴇʜ
25.3k63052
asked Nov 24 '18 at 23:22
SinghSingh
93
I would appreciate if someone could help me in downloading an excel file from a onedrive folder.
One of my colleague has shared a one drive folder link. Where he keeps changing the excel file every day. Inside the folder contains only one file. I have a link of a folder. I will not have link of the file inside the folder, because every day file will be replaced. How do I download the excel file inside the onedrive folder using excel vba. Also it would be great if you could give me an idea on how to download an excel file with it's partial name inside a folder. Any portion of the solution is fine.
Please note that, it's an office 365 onedrive not Sharepoint. Will the provided solution work for google drive as well?
excel vba internet-explorer automation onedrive
excel vba internet-explorer automation onedrive
edited Nov 26 '18 at 7:22
Pᴇʜ
25.3k63052
asked Nov 24 '18 at 23:22
SinghSingh
93
edited Nov 26 '18 at 7:22
Pᴇʜ
25.3k63052
asked Nov 24 '18 at 23:22
SinghSingh
93
edited Nov 26 '18 at 7:22
Pᴇʜ
25.3k63052
edited Nov 26 '18 at 7:22
Pᴇʜ
25.3k63052
edited Nov 26 '18 at 7:22
Pᴇʜ
25.3k63052
25.3k63052
asked Nov 24 '18 at 23:22
SinghSingh
93
asked Nov 24 '18 at 23:22
SinghSingh
93
asked Nov 24 '18 at 23:22
SinghSingh
93
93
2
This is still too broad at present. Please see Minimal, Complete, and Verifiable example and How to Ask for guidance on showing your research attempts and sharing current coding.
– QHarr
Nov 25 '18 at 8:49
i have not found any code on internet, which will download the excel file from one drive folder. If could write the complete vba code, it will be helpful for me. Assume one link to go to the one drive folder and once you opened that link there is only on excel file that needs to be downloaded in your local drive.
– Singh
Nov 25 '18 at 9:22
Meanwhile, can you plese help on this?
– Singh
Nov 25 '18 at 18:16
1
Welcome to Stack Overflow. You might have misunderstood how this site works. Please note that because this is no free code writing service it is necessary to show either what you have tried so far and where you got stuck or errors (by showing your code) or at least to show what you have researched and the effort you made. Otherwise it is just asking us to do all the work for you. Taking the Tour and reading How to Ask might help you to improve your question.
– Pᴇʜ
Nov 26 '18 at 7:23
add a comment |
2
This is still too broad at present. Please see Minimal, Complete, and Verifiable example and How to Ask for guidance on showing your research attempts and sharing current coding.
– QHarr
Nov 25 '18 at 8:49
i have not found any code on internet, which will download the excel file from one drive folder. If could write the complete vba code, it will be helpful for me. Assume one link to go to the one drive folder and once you opened that link there is only on excel file that needs to be downloaded in your local drive.
– Singh
Nov 25 '18 at 9:22
Meanwhile, can you plese help on this?
– Singh
Nov 25 '18 at 18:16
1
Welcome to Stack Overflow. You might have misunderstood how this site works. Please note that because this is no free code writing service it is necessary to show either what you have tried so far and where you got stuck or errors (by showing your code) or at least to show what you have researched and the effort you made. Otherwise it is just asking us to do all the work for you. Taking the Tour and reading How to Ask might help you to improve your question.
– Pᴇʜ
Nov 26 '18 at 7:23
2
2
This is still too broad at present. Please see Minimal, Complete, and Verifiable example and How to Ask for guidance on showing your research attempts and sharing current coding.
– QHarr
Nov 25 '18 at 8:49
This is still too broad at present. Please see Minimal, Complete, and Verifiable example and How to Ask for guidance on showing your research attempts and sharing current coding.
– QHarr
Nov 25 '18 at 8:49
i have not found any code on internet, which will download the excel file from one drive folder. If could write the complete vba code, it will be helpful for me. Assume one link to go to the one drive folder and once you opened that link there is only on excel file that needs to be downloaded in your local drive.
– Singh
Nov 25 '18 at 9:22
i have not found any code on internet, which will download the excel file from one drive folder. If could write the complete vba code, it will be helpful for me. Assume one link to go to the one drive folder and once you opened that link there is only on excel file that needs to be downloaded in your local drive.
– Singh
Nov 25 '18 at 9:22
Meanwhile, can you plese help on this?
– Singh
Nov 25 '18 at 18:16
Meanwhile, can you plese help on this?
– Singh
Nov 25 '18 at 18:16
1
1
Welcome to Stack Overflow. You might have misunderstood how this site works. Please note that because this is no free code writing service it is necessary to show either what you have tried so far and where you got stuck or errors (by showing your code) or at least to show what you have researched and the effort you made. Otherwise it is just asking us to do all the work for you. Taking the Tour and reading How to Ask might help you to improve your question.
– Pᴇʜ
Nov 26 '18 at 7:23
Welcome to Stack Overflow. You might have misunderstood how this site works. Please note that because this is no free code writing service it is necessary to show either what you have tried so far and where you got stuck or errors (by showing your code) or at least to show what you have researched and the effort you made. Otherwise it is just asking us to do all the work for you. Taking the Tour and reading How to Ask might help you to improve your question.
– Pᴇʜ
Nov 26 '18 at 7:23
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53463258%2fdowload-excel-file-from-one-drive-folder-using-excel-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53463258%2fdowload-excel-file-from-one-drive-folder-using-excel-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
This is still too broad at present. Please see Minimal, Complete, and Verifiable example and How to Ask for guidance on showing your research attempts and sharing current coding.
– QHarr
Nov 25 '18 at 8:49
i have not found any code on internet, which will download the excel file from one drive folder. If could write the complete vba code, it will be helpful for me. Assume one link to go to the one drive folder and once you opened that link there is only on excel file that needs to be downloaded in your local drive.
– Singh
Nov 25 '18 at 9:22
Meanwhile, can you plese help on this?
– Singh
Nov 25 '18 at 18:16
1
Welcome to Stack Overflow. You might have misunderstood how this site works. Please note that because this is no free code writing service it is necessary to show either what you have tried so far and where you got stuck or errors (by showing your code) or at least to show what you have researched and the effort you made. Otherwise it is just asking us to do all the work for you. Taking the Tour and reading How to Ask might help you to improve your question.
– Pᴇʜ
Nov 26 '18 at 7:23