Uploading a file to a Webpage(IE11) with Excel Macro Vba
I'm trying to use the following code to upload a file to a webpage:
WD.document.getElementById("fileUpload").Value = "filepath"
'The code does not came with the property 'value' empty( = "") its just not 'there until i click the buttom "search"
'and use the popup dialog to select a file.
'Also when inserting the value by code, the source code
' returns 'value = ""' and whenever i try again,
' it still gets value = ""
WD.document.getElementById("fileUpload").Click
'The Click fires a windows popup dialog for selecting a file, so its not worthy 'to use it.
WD.document.getElementById("frmUpload").submit
'i can use this command to fire the event of uploading, but with a value = "" 'its going to return the "file not found" popup
'HERES THE SOURE CODE FOR THE SITUATION___________________:
<INPUT id=fileUpload size=48 type=file name=fileUpload>'the element
<FORM id=frmUpload encType=multipart/form-data method=post action=/ChamadoPC/Upload/12295979/1 target=fraUpload jQuery15105169442065138357="118">'the form
hope you can help me, hope everybody understand!
excel vba internet-explorer file-upload ihtmldocument2
asked Jan 19 at 11:55
AJRAJR
61
add a comment |
I'm trying to use the following code to upload a file to a webpage:
WD.document.getElementById("fileUpload").Value = "filepath"
'The code does not came with the property 'value' empty( = "") its just not 'there until i click the buttom "search"
'and use the popup dialog to select a file.
'Also when inserting the value by code, the source code
' returns 'value = ""' and whenever i try again,
' it still gets value = ""
WD.document.getElementById("fileUpload").Click
'The Click fires a windows popup dialog for selecting a file, so its not worthy 'to use it.
WD.document.getElementById("frmUpload").submit
'i can use this command to fire the event of uploading, but with a value = "" 'its going to return the "file not found" popup
'HERES THE SOURE CODE FOR THE SITUATION___________________:
<INPUT id=fileUpload size=48 type=file name=fileUpload>'the element
<FORM id=frmUpload encType=multipart/form-data method=post action=/ChamadoPC/Upload/12295979/1 target=fraUpload jQuery15105169442065138357="118">'the form
hope you can help me, hope everybody understand!
excel vba internet-explorer file-upload ihtmldocument2
asked Jan 19 at 11:55
AJRAJR
61
Is it possible to share the website so that we can see more code?
– Matteo NNZ
Jan 19 at 12:10
Its a private server, but i can post some more parts of the source code if necessary
– AJR
Jan 19 at 14:43
There is an excellent multipart form file upload answer given by @santosh here
– QHarr
Jan 19 at 15:02
From your description, It looks like you are trying to load file for HTML input file control. It has property 'files' which returns a FileList object, representing the file or files selected with the file upload control. But this is a read only property. Due to this reason we cannot load the file value using VBA or JS for this control.
– Deepak-MSFT
Jan 21 at 5:56
add a comment |
I'm trying to use the following code to upload a file to a webpage:
WD.document.getElementById("fileUpload").Value = "filepath"
'The code does not came with the property 'value' empty( = "") its just not 'there until i click the buttom "search"
'and use the popup dialog to select a file.
'Also when inserting the value by code, the source code
' returns 'value = ""' and whenever i try again,
' it still gets value = ""
WD.document.getElementById("fileUpload").Click
'The Click fires a windows popup dialog for selecting a file, so its not worthy 'to use it.
WD.document.getElementById("frmUpload").submit
'i can use this command to fire the event of uploading, but with a value = "" 'its going to return the "file not found" popup
'HERES THE SOURE CODE FOR THE SITUATION___________________:
<INPUT id=fileUpload size=48 type=file name=fileUpload>'the element
<FORM id=frmUpload encType=multipart/form-data method=post action=/ChamadoPC/Upload/12295979/1 target=fraUpload jQuery15105169442065138357="118">'the form
hope you can help me, hope everybody understand!
excel vba internet-explorer file-upload ihtmldocument2
asked Jan 19 at 11:55
AJRAJR
61
I'm trying to use the following code to upload a file to a webpage:
WD.document.getElementById("fileUpload").Value = "filepath"
'The code does not came with the property 'value' empty( = "") its just not 'there until i click the buttom "search"
'and use the popup dialog to select a file.
'Also when inserting the value by code, the source code
' returns 'value = ""' and whenever i try again,
' it still gets value = ""
WD.document.getElementById("fileUpload").Click
'The Click fires a windows popup dialog for selecting a file, so its not worthy 'to use it.
WD.document.getElementById("frmUpload").submit
'i can use this command to fire the event of uploading, but with a value = "" 'its going to return the "file not found" popup
'HERES THE SOURE CODE FOR THE SITUATION___________________:
<INPUT id=fileUpload size=48 type=file name=fileUpload>'the element
<FORM id=frmUpload encType=multipart/form-data method=post action=/ChamadoPC/Upload/12295979/1 target=fraUpload jQuery15105169442065138357="118">'the form
hope you can help me, hope everybody understand!
excel vba internet-explorer file-upload ihtmldocument2
excel vba internet-explorer file-upload ihtmldocument2
asked Jan 19 at 11:55
AJRAJR
61
asked Jan 19 at 11:55
AJRAJR
61
asked Jan 19 at 11:55
AJRAJR
61
asked Jan 19 at 11:55
AJRAJR
61
asked Jan 19 at 11:55
AJRAJR
61
61
Is it possible to share the website so that we can see more code?
– Matteo NNZ
Jan 19 at 12:10
Its a private server, but i can post some more parts of the source code if necessary
– AJR
Jan 19 at 14:43
There is an excellent multipart form file upload answer given by @santosh here
– QHarr
Jan 19 at 15:02
From your description, It looks like you are trying to load file for HTML input file control. It has property 'files' which returns a FileList object, representing the file or files selected with the file upload control. But this is a read only property. Due to this reason we cannot load the file value using VBA or JS for this control.
– Deepak-MSFT
Jan 21 at 5:56
add a comment |
Is it possible to share the website so that we can see more code?
– Matteo NNZ
Jan 19 at 12:10
Its a private server, but i can post some more parts of the source code if necessary
– AJR
Jan 19 at 14:43
There is an excellent multipart form file upload answer given by @santosh here
– QHarr
Jan 19 at 15:02
From your description, It looks like you are trying to load file for HTML input file control. It has property 'files' which returns a FileList object, representing the file or files selected with the file upload control. But this is a read only property. Due to this reason we cannot load the file value using VBA or JS for this control.
– Deepak-MSFT
Jan 21 at 5:56
Is it possible to share the website so that we can see more code?
– Matteo NNZ
Jan 19 at 12:10
Is it possible to share the website so that we can see more code?
– Matteo NNZ
Jan 19 at 12:10
Its a private server, but i can post some more parts of the source code if necessary
– AJR
Jan 19 at 14:43
Its a private server, but i can post some more parts of the source code if necessary
– AJR
Jan 19 at 14:43
There is an excellent multipart form file upload answer given by @santosh here
– QHarr
Jan 19 at 15:02
There is an excellent multipart form file upload answer given by @santosh here
– QHarr
Jan 19 at 15:02
From your description, It looks like you are trying to load file for HTML input file control. It has property 'files' which returns a FileList object, representing the file or files selected with the file upload control. But this is a read only property. Due to this reason we cannot load the file value using VBA or JS for this control.
– Deepak-MSFT
Jan 21 at 5:56
From your description, It looks like you are trying to load file for HTML input file control. It has property 'files' which returns a FileList object, representing the file or files selected with the file upload control. But this is a read only property. Due to this reason we cannot load the file value using VBA or JS for this control.
– Deepak-MSFT
Jan 21 at 5:56
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%2f54266807%2fuploading-a-file-to-a-webpageie11-with-excel-macro-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%2f54266807%2fuploading-a-file-to-a-webpageie11-with-excel-macro-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
Is it possible to share the website so that we can see more code?
– Matteo NNZ
Jan 19 at 12:10
Its a private server, but i can post some more parts of the source code if necessary
– AJR
Jan 19 at 14:43
There is an excellent multipart form file upload answer given by @santosh here
– QHarr
Jan 19 at 15:02
From your description, It looks like you are trying to load file for HTML input file control. It has property 'files' which returns a FileList object, representing the file or files selected with the file upload control. But this is a read only property. Due to this reason we cannot load the file value using VBA or JS for this control.
– Deepak-MSFT
Jan 21 at 5:56