Dear Bé Trần Văn Oh Great, it is the really very worth-full Solution by you. my hats off for Solution this concept among excel user.I never thought in my mind,this can do as it so easily
Thank you!! ;-) Regards Amar On Wed, Feb 27, 2013 at 6:57 AM, Bé Trần Văn <betnmtdongna...@gmail.com>wrote: > > > > *Automatically create links to any of the files contained in the folder to > open it.* > > Basically it generates number automatically, named File (sorted in order > of A, B, C), File size, File (Word, Word, WinRAR archive, Bitmap Image, > Foxit PDFDocument, Flash Video File) create or repair File, and finally a > hyperlink > to the file. > > > > *How **to** **list all** **the** **files** **contained** **in** **the** ** > folder**:*** > > > > To list all the files contained in that folder, please click on Shapes Find > the drive name and select the folder, bring up the Browse dialog box, > click the down arrow next of Lookin item to select driveplate, then click > on the first folder and click the OK button. Next, please click on Shapes > Get Link and File name print sheet, the macro to run and finish creating > hyperlinks to the files contained in that folder. Attachments. > > 2013/2/26 ANKUR AGGARWAL <ankur9_aggarwa...@yahoo.co.in> > >> Hi Anil, >> >> VBA code is password protected. Also, I am interested to know, how this >> is possible, can you briefly explain, how you did the same. >> >> Thanks ! >> >> Warm Regards >> Ankur Aggarwal >> Analyst >> ------------------------------ >> *From:* अनिल नारायण गवली <gawlianil8...@gmail.com> >> *To:* excel-macros@googlegroups.com; ankur9_aggarwa...@yahoo.co.in >> *Sent:* Tuesday, 26 February 2013 11:52 AM >> >> *Subject:* Re: $$Excel-Macros$$ PDF attachment in Excel Cell >> >> >> Dear Ankur, >> >> Whr u find password protected. the workbook which i have provided is not >> protected. >> >> >> My be the url of the first cell of that icon will be not available, >> because the url is from my desktop that's why. >> >> Warm Regards, >> Gawli Anil. >> On Tue, Feb 26, 2013 at 11:47 AM, ANKUR AGGARWAL < >> ankur9_aggarwa...@yahoo.co.in> wrote: >> >> How is it working ?, Also the code is password protected, can you >> please share the password ? >> >> Warm Regards >> Ankur Aggarwal >> 91-8010614628 >> Analyst >> Mckinsey Knowledge Center >> Mckinsey & Co. >> >> ------------------------------ >> *From:* अनिल नारायण गवली <gawlianil8...@gmail.com> >> *To:* excel-macros@googlegroups.com; amar takale <amartak...@gmail.com> >> *Sent:* Tuesday, 26 February 2013 9:40 AM >> *Subject:* Re: $$Excel-Macros$$ PDF attachment in Excel Cell >> >> Dear Amar, >> >> Yes it is possible with hyperlink >> >> just give the right url and save it. >> >> Pl see the attached sheet. >> >> Warm Regards, >> Gawli Anil. >> >> On Mon, Feb 25, 2013 at 7:28 PM, Anil B <ank.bira...@gmail.com> wrote: >> >> listen for this one to attach the PDF Files u just need to hyperlink the >> file from desktop or file thats it u got the solution when u click it opens >> the file. >> >> Thanks, >> Anil >> >> On Mon, Feb 25, 2013 at 7:28 PM, Anil B <ank.bira...@gmail.com> wrote: >> >> Hi dude, >> >> >> >> >> On Mon, Feb 25, 2013 at 7:23 PM, amar takale <amartak...@gmail.com>wrote: >> >> Dear All Experts, >> >> Discuss to all about PDF attachment in Excel Cell >> >> Regards >> Amar >> >> >> >> -- >> 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. >> >> >> >> >> >> >> -- >> 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. >> >> >> >> >> -- >> 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. >> >> >> > > -- > 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.
