Re: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
Hi All,
In my project I am having a requirement to upload file from IE browser
browse button. We are invoking this browser through macro in excel VB.
HTML code for webpage is :-
please share VB code to select any file from my system.
Gaurav
On Sunday, May 12, 2013 at 2:33:26 PM UTC-7, Mathan wrote:
>
> Thanks david !
>
> --Original message--
> From: David Grugeon >
> To: "excel-...@googlegroups.com " >
> Date: Friday, May 10, 2013 12:08:12 PM GMT+1000
> Subject: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to
> upload " window in internet explorer
>
> OK. To to this you need to analyse the URL that is sent when you do it
> manually, then you need to construct an appropriate URL and make this a
> hyperlink.Then you can refer to the cell containing the hyperlink and open
> the hyperlink.
>
> It will be something like Range("A1").hyperlink.follow.
>
> Regards
> David Grugeon
>
>
>
> On 10 May 2013 06:42, Mathan > wrote:
>
> > Sorry, please refer to this screenshot. Thanks
> >
> >
> > On Fri, May 10, 2013 at 2:11 AM, Mathan > wrote:
> >
> >> Hi David,
> >>
> >> Please refer to the attached screenshot. I believe you would get my
> point
> >> after seeing that. I might have confused you earlier.
> >>
> >> Thanks
> >> Mathan
> >>
> >>
> >> On Thu, May 9, 2013 at 12:30 PM, David Grugeon >wrote:
> >>
> >>> In essence, internet explorer does not understand excel files. You
> >>> could save the file as a web page and load that. It would not have
> the
> >>> functionality of excel though.
> >>>
> >>> There are some proprietary products which allow you to run excel
> >>> spreadsheets through a browser. They cost though! Min $500, I think.
> >>>
> >>> Or you could upload the file to Google Apps or Office 365 and then
> open
> >>> that in a browser.
> >>>
> >>> Regards
> >>> David Grugeon
> >>>
> >>>
> >>>
> >>> On 9 May 2013 16:31, Mathan > wrote:
> >>>
> >>>> Hi David/Anil,
> >>>>
> >>>> We are trying to upload the excel file through excel vba.
> >>>>
> >>>> The files are from common shared folder not on the local drive.
> >>>>
> >>>> I hope this helps, However, I will share the screenshot by tonight.
> >>>> Thanks for your time.
> >>>>
> >>>> Thanks
> >>>>
> >>>>
> >>>> On Thu, May 9, 2013 at 10:11 AM, David Grugeon >wrote:
> >>>>
> >>>>> IN particular we need to know what type of file is it that you want
> to
> >>>>> "Upload". Is it an internet file like .html, .asp .php etc or is it
> an
> >>>>> excel XLS file, xlsm, xlsb, etc. or perhaps a different type.
> >>>>>
> >>>>> Then we need to know if there is an internet server running on the
> >>>>> site where the file is located.
> >>>>>
> >>>>> We also need to know why VBA code is required, rather than simply a
> >>>>> hyperlink.
> >>>>>
> >>>>> Regards
> >>>>> David Grugeon
> >>>>>
> >>>>>
> >>>>>
> >>>>> On 9 May 2013 06:56, Mathan >
> wrote:
> >>>>>
> >>>>>> Hi Experts,
> >>>>>>
> >>>>>> I'm trying to upload a file from shared folder (directory) to the
> >>>>>> internet explorer.
> >>>>>>
> >>>>>> Need a VBA code to do this. Could anyone help me on this?
> >>>>>>
> >>>>>> Thanks in advance.
> >>>>>>
> >>>>>> --
> >>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
> be?
> >>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
> forum @
> >>>>>> https://www.facebook.com/discussexcel
> >>>>>>
> >>>>>> FORUM RULES
> >>>>>>
> >>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
> >>>>>> Please
Re: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
Thanks david !
--Original message--
From: David Grugeon
To: "excel-macros@googlegroups.com"
Date: Friday, May 10, 2013 12:08:12 PM GMT+1000
Subject: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload "
window in internet explorer
OK. To to this you need to analyse the URL that is sent when you do it
manually, then you need to construct an appropriate URL and make this a
hyperlink.Then you can refer to the cell containing the hyperlink and open
the hyperlink.
It will be something like Range("A1").hyperlink.follow.
Regards
David Grugeon
On 10 May 2013 06:42, Mathan wrote:
> Sorry, please refer to this screenshot. Thanks
>
>
> On Fri, May 10, 2013 at 2:11 AM, Mathan wrote:
>
>> Hi David,
>>
>> Please refer to the attached screenshot. I believe you would get my point
>> after seeing that. I might have confused you earlier.
>>
>> Thanks
>> Mathan
>>
>>
>> On Thu, May 9, 2013 at 12:30 PM, David Grugeon wrote:
>>
>>> In essence, internet explorer does not understand excel files. You
>>> could save the file as a web page and load that. It would not have the
>>> functionality of excel though.
>>>
>>> There are some proprietary products which allow you to run excel
>>> spreadsheets through a browser. They cost though! Min $500, I think.
>>>
>>> Or you could upload the file to Google Apps or Office 365 and then open
>>> that in a browser.
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 9 May 2013 16:31, Mathan wrote:
>>>
>>>> Hi David/Anil,
>>>>
>>>> We are trying to upload the excel file through excel vba.
>>>>
>>>> The files are from common shared folder not on the local drive.
>>>>
>>>> I hope this helps, However, I will share the screenshot by tonight.
>>>> Thanks for your time.
>>>>
>>>> Thanks
>>>>
>>>>
>>>> On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote:
>>>>
>>>>> IN particular we need to know what type of file is it that you want to
>>>>> "Upload". Is it an internet file like .html, .asp .php etc or is it an
>>>>> excel XLS file, xlsm, xlsb, etc. or perhaps a different type.
>>>>>
>>>>> Then we need to know if there is an internet server running on the
>>>>> site where the file is located.
>>>>>
>>>>> We also need to know why VBA code is required, rather than simply a
>>>>> hyperlink.
>>>>>
>>>>> Regards
>>>>> David Grugeon
>>>>>
>>>>>
>>>>>
>>>>> On 9 May 2013 06:56, Mathan wrote:
>>>>>
>>>>>> Hi Experts,
>>>>>>
>>>>>> I'm trying to upload a file from shared folder (directory) to the
>>>>>> internet explorer.
>>>>>>
>>>>>> Need a VBA code to do this. Could anyone help me on this?
>>>>>>
>>>>>> Thanks in advance.
>>>>>>
>>>>>> --
>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>>> https://www.facebook.com/discussexcel
>>>>>>
>>>>>> FORUM RULES
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>> 5) Jobs posting is not allowed.
>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>
>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>>> and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>&
Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
I
Sent from BlackBerry® on Airtel
-Original Message-
From: David Grugeon
Sender: excel-macros@googlegroups.com
Date: Fri, 10 May 2013 12:08:12
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload
" window in internet explorer
OK. To to this you need to analyse the URL that is sent when you do it
manually, then you need to construct an appropriate URL and make this a
hyperlink.Then you can refer to the cell containing the hyperlink and open
the hyperlink.
It will be something like Range("A1").hyperlink.follow.
Regards
David Grugeon
On 10 May 2013 06:42, Mathan wrote:
> Sorry, please refer to this screenshot. Thanks
>
>
> On Fri, May 10, 2013 at 2:11 AM, Mathan wrote:
>
>> Hi David,
>>
>> Please refer to the attached screenshot. I believe you would get my point
>> after seeing that. I might have confused you earlier.
>>
>> Thanks
>> Mathan
>>
>>
>> On Thu, May 9, 2013 at 12:30 PM, David Grugeon wrote:
>>
>>> In essence, internet explorer does not understand excel files. You
>>> could save the file as a web page and load that. It would not have the
>>> functionality of excel though.
>>>
>>> There are some proprietary products which allow you to run excel
>>> spreadsheets through a browser. They cost though! Min $500, I think.
>>>
>>> Or you could upload the file to Google Apps or Office 365 and then open
>>> that in a browser.
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 9 May 2013 16:31, Mathan wrote:
>>>
>>>> Hi David/Anil,
>>>>
>>>> We are trying to upload the excel file through excel vba.
>>>>
>>>> The files are from common shared folder not on the local drive.
>>>>
>>>> I hope this helps, However, I will share the screenshot by tonight.
>>>> Thanks for your time.
>>>>
>>>> Thanks
>>>>
>>>>
>>>> On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote:
>>>>
>>>>> IN particular we need to know what type of file is it that you want to
>>>>> "Upload". Is it an internet file like .html, .asp .php etc or is it an
>>>>> excel XLS file, xlsm, xlsb, etc. or perhaps a different type.
>>>>>
>>>>> Then we need to know if there is an internet server running on the
>>>>> site where the file is located.
>>>>>
>>>>> We also need to know why VBA code is required, rather than simply a
>>>>> hyperlink.
>>>>>
>>>>> Regards
>>>>> David Grugeon
>>>>>
>>>>>
>>>>>
>>>>> On 9 May 2013 06:56, Mathan wrote:
>>>>>
>>>>>> Hi Experts,
>>>>>>
>>>>>> I'm trying to upload a file from shared folder (directory) to the
>>>>>> internet explorer.
>>>>>>
>>>>>> Need a VBA code to do this. Could anyone help me on this?
>>>>>>
>>>>>> Thanks in advance.
>>>>>>
>>>>>> --
>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>>> https://www.facebook.com/discussexcel
>>>>>>
>>>>>> FORUM RULES
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>> 5) Jobs posting is not allowed.
>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>
>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>>> and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "MS
Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
OK. To to this you need to analyse the URL that is sent when you do it
manually, then you need to construct an appropriate URL and make this a
hyperlink.Then you can refer to the cell containing the hyperlink and open
the hyperlink.
It will be something like Range("A1").hyperlink.follow.
Regards
David Grugeon
On 10 May 2013 06:42, Mathan wrote:
> Sorry, please refer to this screenshot. Thanks
>
>
> On Fri, May 10, 2013 at 2:11 AM, Mathan wrote:
>
>> Hi David,
>>
>> Please refer to the attached screenshot. I believe you would get my point
>> after seeing that. I might have confused you earlier.
>>
>> Thanks
>> Mathan
>>
>>
>> On Thu, May 9, 2013 at 12:30 PM, David Grugeon wrote:
>>
>>> In essence, internet explorer does not understand excel files. You
>>> could save the file as a web page and load that. It would not have the
>>> functionality of excel though.
>>>
>>> There are some proprietary products which allow you to run excel
>>> spreadsheets through a browser. They cost though! Min $500, I think.
>>>
>>> Or you could upload the file to Google Apps or Office 365 and then open
>>> that in a browser.
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 9 May 2013 16:31, Mathan wrote:
>>>
Hi David/Anil,
We are trying to upload the excel file through excel vba.
The files are from common shared folder not on the local drive.
I hope this helps, However, I will share the screenshot by tonight.
Thanks for your time.
Thanks
On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote:
> IN particular we need to know what type of file is it that you want to
> "Upload". Is it an internet file like .html, .asp .php etc or is it an
> excel XLS file, xlsm, xlsb, etc. or perhaps a different type.
>
> Then we need to know if there is an internet server running on the
> site where the file is located.
>
> We also need to know why VBA code is required, rather than simply a
> hyperlink.
>
> Regards
> David Grugeon
>
>
>
> On 9 May 2013 06:56, Mathan wrote:
>
>> Hi Experts,
>>
>> I'm trying to upload a file from shared folder (directory) to the
>> internet explorer.
>>
>> Need a VBA code to do this. Could anyone help me on this?
>>
>> Thanks in advance.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en
>> .
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
>
Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
see if it helps http://www.motobit.com/tips/detpg_uploadvbaie/ On Thu, May 9, 2013 at 12:30 PM, David Grugeon wrote: > In essence, internet explorer does not understand excel files. You could > save the file as a web page and load that. It would not have the > functionality of excel though. > > There are some proprietary products which allow you to run excel > spreadsheets through a browser. They cost though! Min $500, I think. > > Or you could upload the file to Google Apps or Office 365 and then open > that in a browser. > > Regards > David Grugeon > > > > On 9 May 2013 16:31, Mathan wrote: > >> Hi David/Anil, >> >> We are trying to upload the excel file through excel vba. >> >> The files are from common shared folder not on the local drive. >> >> I hope this helps, However, I will share the screenshot by tonight. >> Thanks for your time. >> >> Thanks >> >> >> On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote: >> >>> IN particular we need to know what type of file is it that you want to >>> "Upload". Is it an internet file like .html, .asp .php etc or is it an >>> excel XLS file, xlsm, xlsb, etc. or perhaps a different type. >>> >>> Then we need to know if there is an internet server running on the site >>> where the file is located. >>> >>> We also need to know why VBA code is required, rather than simply a >>> hyperlink. >>> >>> Regards >>> David Grugeon >>> >>> >>> >>> On 9 May 2013 06:56, Mathan wrote: >>> Hi Experts, I'm trying to upload a file from shared folder (directory) to the internet explorer. Need a VBA code to do this. Could anyone help me on this? Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge
Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
In essence, internet explorer does not understand excel files. You could save the file as a web page and load that. It would not have the functionality of excel though. There are some proprietary products which allow you to run excel spreadsheets through a browser. They cost though! Min $500, I think. Or you could upload the file to Google Apps or Office 365 and then open that in a browser. Regards David Grugeon On 9 May 2013 16:31, Mathan wrote: > Hi David/Anil, > > We are trying to upload the excel file through excel vba. > > The files are from common shared folder not on the local drive. > > I hope this helps, However, I will share the screenshot by tonight. Thanks > for your time. > > Thanks > > > On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote: > >> IN particular we need to know what type of file is it that you want to >> "Upload". Is it an internet file like .html, .asp .php etc or is it an >> excel XLS file, xlsm, xlsb, etc. or perhaps a different type. >> >> Then we need to know if there is an internet server running on the site >> where the file is located. >> >> We also need to know why VBA code is required, rather than simply a >> hyperlink. >> >> Regards >> David Grugeon >> >> >> >> On 9 May 2013 06:56, Mathan wrote: >> >>> Hi Experts, >>> >>> I'm trying to upload a file from shared folder (directory) to the >>> internet explorer. >>> >>> Need a VBA code to do this. Could anyone help me on this? >>> >>> Thanks in advance. >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > -
Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
Hi David/Anil, We are trying to upload the excel file through excel vba. The files are from common shared folder not on the local drive. I hope this helps, However, I will share the screenshot by tonight. Thanks for your time. Thanks On Thu, May 9, 2013 at 10:11 AM, David Grugeon wrote: > IN particular we need to know what type of file is it that you want to > "Upload". Is it an internet file like .html, .asp .php etc or is it an > excel XLS file, xlsm, xlsb, etc. or perhaps a different type. > > Then we need to know if there is an internet server running on the site > where the file is located. > > We also need to know why VBA code is required, rather than simply a > hyperlink. > > Regards > David Grugeon > > > > On 9 May 2013 06:56, Mathan wrote: > >> Hi Experts, >> >> I'm trying to upload a file from shared folder (directory) to the >> internet explorer. >> >> Need a VBA code to do this. Could anyone help me on this? >> >> Thanks in advance. >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
IN particular we need to know what type of file is it that you want to "Upload". Is it an internet file like .html, .asp .php etc or is it an excel XLS file, xlsm, xlsb, etc. or perhaps a different type. Then we need to know if there is an internet server running on the site where the file is located. We also need to know why VBA code is required, rather than simply a hyperlink. Regards David Grugeon On 9 May 2013 06:56, Mathan wrote: > Hi Experts, > > I'm trying to upload a file from shared folder (directory) to the internet > explorer. > > Need a VBA code to do this. Could anyone help me on this? > > Thanks in advance. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer
Dear Manthan, Pls Elaborate More with Eg. Warm Regards, Gawli Anil On Thu, May 9, 2013 at 2:26 AM, Mathan wrote: > Hi Experts, > > I'm trying to upload a file from shared folder (directory) to the internet > explorer. > > Need a VBA code to do this. Could anyone help me on this? > > Thanks in advance. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
