Thanks Paul Schreiner . Thank u very much. Cheers... REgards Gawli Anil
On Wed, Oct 17, 2012 at 12:22 AM, Paul Schreiner <schreiner_p...@att.net>wrote: > first: a little "Group Etiquette": > > Being in the United States, I'm in a different time zone than many people > who participate in these forums. > Therefore, while I'm napping away, others are leading productive lives. > > Consequently, when I peruse my email, > I often have between 30 and 330 emails awaiting my review. > > The first thing I do, is sort by Subject. > Many of the posts have an active discussion ongoing, so I feel confident > that the questions are being dealt with. > Unless I recognize the subject, or have an active interest, I delete them. > > Next, I look for any subject like: > Please Help > Need Help > Formula problem > Code Problem > Need Advice > Urgent > or ANY THAT ARE ALL CAPS > > These I also delete. > > Since A) the forum guidelines state: > 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. > I figure that if the author doesn't want to spend enough time describing > the problem and isn't concerned that his/her question is mixed in with all > the > other people that don't want to spend the time to describe their problem, > then why should I? > > I suspect that many other people on this forum are like me, and value > their time and would rather spend their effort with members that can > articulate their problem. > > It really doesn't matter if you can VERY PRECISELY describe your situation, > and spent 1000 words showing EXACTLY what code you've written and where > the error occurs, but your opening line (subject) says "I really don't have > time for this, I have a problem and want someone to fix it for me, please > do the needful while I get a cup of coffee and discuss my travel plans with > my coworkers, I'll check back to see if you're finished" > --------------------------------------------------------------------------- > > Having said all of that... > I happened to delete a group of emails this morning, and yours came to the > top. > The first in the list shows up in my "preview" pane, and I happened to > glance > at it before hitting "delete". > > I happened to see the word "filedialogbox" and chose to read further. > Upon further investigation, I found that I had, indeed, received your > previous posting, but sadly, it was in my "Trash" folder because it failed > to catch my eye the first time. > I maintain 80,000 lines of VBA code in 8-10 different applications. > I've used the filedialog box a few times, so I knew I had some sample code > I could copy. > > Attached is a test file that uses the filedialog box. > The macro is called: > > Import_Sheets > > you can select multiple files > When you hit "open", the first file in the list will open > and a UserForm will display, showing the sheets in the workbook. > (and the name of the workbook) > You can select multiple sheets from this workbook. > It will process each sheet, prompting for a new name for each sheet > and copy the sheet into the existing workbook, > placing the copied sheet at the end. > Once all selected sheets have been copied, > it will then move to the next workbook selected. > > You "said" that you wished to "import" sheets. > 4-5 of them, one at a time. > But the description does not say in what way you were "importing" them. > The context would indicate that you're just copying the sheets from one > workbook to another, and renaming them along the way. > So that's what I did. > If you're truly "importing" the sheets (which implies taking data from one > form and applying it to a different format), then you'll have to modify the > code to accomplish this. > > I didn't spend a lot of time "cleaning up" the code, so it may have some > variables that have been declared that were brought over from my original > application, but are not required here. > > It actually took me longer to write this "rant" than it did to throw > together the code. > > hope this helps get you started. > > > *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:* अनिल नारायण गवली <gawlianil8...@gmail.com> > *To:* excel-macros@googlegroups.com > *Cc:* NOORAIN ANSARI <noorain.ans...@gmail.com>; gawlianil8...@gmail.com > *Sent:* Tue, October 16, 2012 5:59:58 AM > *Subject:* $$Excel-Macros$$ Re: Pls help me on this. > > Pls somebody help me on this > On Monday, October 15, 2012 5:37:44 PM UTC+5:30, अनिल नारायण गवली wrote: >> >> Dear Groups and Noorian, >> >> I want a macro that import other worksheets in a excel workbook by using >> filedailogbox . >> >> 1) when filedailogbox opens i have to select the required file and >> automatically all the sheets name should displayed in a box from that i >> have to select one sheet and import that in one file . >> 2) likewise i have to import 4-5 sheets one by one. >> >> 3) note:- while importing a sheet a input box should be displayed for >> renaming a sheet for every imported once. >> >> pls help me on this. >> >> >> -- >> Thanks & Regards, >> Gawli Anil Narayan >> Software Developer, >> Abacus Software Services Pvt Ltd >> > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
