Re: $$Excel-Macros$$ Macroa
Its actually a sharepoint link. Its a database wherein anybody can save any file and its openly available for viewing. Its not a shared drive, however its in the folder format. Regards Jones On 5 Sep 2014 19:56, "Paul Schreiner" wrote: > You say: "office intranet" > > is that what you mean? as in: > it's a link on a web site? > > or is it actually on a network folder? > Actually, the link would actually BE pointing to a network folder. > If you can open the file location, then you'd be able to see what the > network path is to the file and use the VBA filesytem object to copy the > file. > > If it actually is on an intranet web page, then it can still be > accomplished, but it's a little more involved. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Jones George > *To:* excel-macros@googlegroups.com > *Sent:* Friday, September 5, 2014 10:15 AM > *Subject:* $$Excel-Macros$$ Macroa > > Hi All, > I have a task at hand. Wherein i have files stored online on my office > intranet. And i need those files downloaded and merged as and when required. > For example, I have 10 folders and in each folders there are 2 files say A > and B, now whenever i need the data i have to download the files 1 by 1 and > merge the details in the file. Can a macro help me in getting the work > done. As in if i run the macro, the should get downloaded and merged based > on the file names. All As to be merged and Bs to be merged. > Let me know if this can be done with the help of macros. Just yes or no > will do. > Regards > Jones > -- > 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. > For more options, visit https://groups.google.com/d/optout. > > >-- > 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. > For more options, visit https://groups.google.com/d/optout. > -- 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
$$Excel-Macros$$ Macroa
Hi All, I have a task at hand. Wherein i have files stored online on my office intranet. And i need those files downloaded and merged as and when required. For example, I have 10 folders and in each folders there are 2 files say A and B, now whenever i need the data i have to download the files 1 by 1 and merge the details in the file. Can a macro help me in getting the work done. As in if i run the macro, the should get downloaded and merged based on the file names. All As to be merged and Bs to be merged. Let me know if this can be done with the help of macros. Just yes or no will do. Regards Jones -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Mass mailer help!!!
Thanks Anil for replying. However I cannot share the worksheet as its Confidential information. Is it possible to prepare a sample list of email addresses and then prepare a macro. I know im asking too much. But need help. Regards Jones George On 2 Sep 2014 15:04, "Jones George" wrote: > Thanks Anil for replying. However I cannot share the worksheet as its > Confidential informatio. > > Is it possible to prepare a sample list of email addrsses and then prepare > a macro. > > Regards > Jones George > On 2 Sep 2014 14:16, "Anil Gawli" wrote: > >> Dear Jones, >> >> Pls share the worksheet with us, we'll do it as much we can do it.. >> >> Warm Regards, >> Gawli Anil :) >> >> >> >> On Tue, Sep 2, 2014 at 2:05 PM, Jones George wrote: >> > Hi All, >> > >> > I need an urgent help. I have to send a mass mailer to approx 10k email >> > addresses. The task at hand is that I have to filter these email >> addresses >> > before I send the mailer. I have to remove unwanted email addresses >> such as >> > @yahoo.com, @gmail.com, @rediffmail.com, @mtnl.com, etc. >> > >> > Since the list is huge can macros help me? If yes can someone guide me. >> > >> > Appreciate your help in advance. >> > >> > Regards >> > Jones George >> > >> > -- >> > 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. >> > For more options, visit https://groups.google.com/d/optout. >> > -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Mass mailer help!!!
Hi All, I need an urgent help. I have to send a mass mailer to approx 10k email addresses. The task at hand is that I have to filter these email addresses before I send the mailer. I have to remove unwanted email addresses such as @yahoo.com, @gmail.com, @rediffmail.com, @mtnl.com, etc. Since the list is huge can macros help me? If yes can someone guide me. Appreciate your help in advance. Regards Jones George -- 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. For more options, visit https://groups.google.com/d/optout.
