$$Excel-Macros$$ Auto Hide Empty Columns
Hello Dear Gurus I have a large worksheet with huge numbers of rows and columns. What I want is that when I filter a row all irrelevant (empty) columns should hide automatically. Please help as a lot of time is wasted on daily basis while hiding and unhiding columns. Thanks lot. -- 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.
$$Excel-Macros$$ IN TROUBLE
Hello Dear Gurus I want to add columns in an *excel sheet* between *R* and *AQ* to be total in number as in cell *H5* and I also want this to be replicated in sheet2, sheet3, and sheet4 and these columns should also carry the formula from column *R*. Gurus please help me. Thanks -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Urgent Help
Dear can you please tell me how to change the extention from txt to exe. thanks AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 5 May 2010 19:58, sudhir kumar wrote: > i attached the folder lock software, u install it , it is very good for > folder lock. > first change the extension to .exe > > > On Tue, May 4, 2010 at 10:32 PM, Harpreet Singh Gujral < > harpreetguj...@gmail.com> wrote: > >> Sudhir ji, >> >> Koi link toh do, >> >> harry >> >> On Mon, May 3, 2010 at 7:50 PM, sudhir.pals wrote: >> >>> HI, >>> u can use folder lock software , it is very gud... >>> >>> >>> >>> >>> On Mon, May 3, 2010 at 8:49 AM, Harpreet Singh Gujral < >>> harpreetguj...@gmail.com> wrote: >>> >>>> Hi Ashish/Jai/Group, >>>> >>>> I am also looking for some kind of Folder protection program.. >>>> >>>> Please advise >>>> >>>> Cheers! >>>> >>>> Harry >>>> >>>> On May 2, 12:15 pm, ashish koul wrote: >>>> > try this it may help you >>>> > >>>> > 1. Go to the directory where your folder is in. >>>> > 2. Create a new notepad file and paste this without the double quotes: >>>> > >>>> > "ren Users.{21EC2020-3AEA-1069-A2DD-08002B30309D} Users" >>>> > >>>> > (Make sure to replace the word “Users” with the name of your folder.) >>>> > >>>> > 5. In Notepad, go to File -> Save As, and save it with the name >>>> "key.bat" >>>> > (MAKE SURE TO CHANGE THE FILE TYPE FROM .txt to ALL FILES) >>>> > >>>> > 6. Run the "key.bat" file >>>> > >>>> > >>>> > >>>> > >>>> > >>>> > On Sat, May 1, 2010 at 1:43 PM, Jai wrote: >>>> > > hi priyan,,,aamir here,, >>>> > > priyan, >>>> > > I recently downloaded this file encrpytion program : >>>> > >http://priyanr.somee.com/downloads/folderprotect.zip >>>> > >>>> > > It was working good until a few weeks later when suddenly all my >>>> locked >>>> > > folders changed into a control panel icon. >>>> > >>>> > > Usually to unlock it, i would just have to double click the folder & >>>> enter >>>> > > my password but this time when i double clicked it, it just open the >>>> control >>>> > > panel. Right clicking on the folder doesnt work either, theres no >>>> Unlock >>>> > > option. Theres no way i can view the folder contents! >>>> > >>>> > > >>> The same problem has occured to me. URGENT HELP NEEDED !!! The >>>> folder >>>> > > is very important for me. Its all my savings till today. I need to >>>> unlock it >>>> > > immediately >>>> > >>>> > > -- >>>> > > Thanks For Mail. >>>> > >>>> > > -- >>>> > >>>> > > >>>> ------ >>>> > > Some important links for excel users: >>>> > > 1. Follow us on TWITTER for tips tricks and links : >>>> > >http://twitter.com/exceldailytip >>>> > > 2. Join our LinkedIN group @ >>>> http://www.linkedin.com/groups?gid=1871310 >>>> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >>>> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >>>> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >>>> > >>>> > > To post to this group, send email to excel-macros@googlegroups.com >>>> > >>>> > > <><><><><><><><><><><><><><><><><><><><><><> >>>> > > HELP US GROW !! >>>> > >>>> > > We reach over 6,800 subscribers worldwide and receive many nice >>>> notes about >>>> > > the learning and support from the group.Let friends and co-workers >>>> know they >>>> > > can subscribe to group at >>>> > >http://groups.google.
Re: $$Excel-Macros$$ Date formatting
Dear Members I was just trying to calculate a similer thing but could not. Please help me too. I need to add a certain number of years to a date and get the resulting date. HOW? Thanks AZHAR RAI Skype: azhar.rai On 6 May 2010 16:13, dare2gold wrote: > Dear Members,., > > i want to know how to get a later date just by inserting present date > into one column and getting the date we desire just by typing the no > of days > > suppose i entered 1.04.2010 29days the output should be 30.04.2010. > > > please tell me ... > > thanks in anticipations > > goldie > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ TOUGH QUESTION
Dear Members Can someone help me create a trick related to mail merge in Office 2007/2010. I want to mail merge pictures FROM an excel sheet (where there are hyperlink to different pictures) TO a word document. Your help will save a lot of my time and efforts. Regards AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ TOUGH QUESTION
Hi aindril The pictures are stored on my local hard disk. AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 7 May 2010 18:33, Aindril De wrote: > Hi azhar, > > Are these images stored somewhere in your local disk or online? > > Regards, > aindril > > On Fri, May 7, 2010 at 10:46 AM, Azhar Rai wrote: > >> Dear Members >> >> Can someone help me create a trick related to mail merge in Office >> 2007/2010. >> >> I want to mail merge pictures FROM an excel sheet (where there are >> hyperlink to different pictures) TO a word document. >> >> Your help will save a lot of my time and efforts. >> >> Regards >> >> AZHAR RAI >> Cell: 0333-552-7731 >> Skype: azhar.rai >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ URGENT Request
Hi Members I have an excel sheet with huge text data and at the beginning of each cell text string there are names (mostly single names) I want to count the number of letters in the first word (that is the name I referred to above). Please tell some excel function that does this work for me. Thanks and regards in advance for urgent replies. AZHAR RAI Cell: +92 333-552-7731 Skype: azhar.rai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ URGENT Request
Thanks a lot Vigooo. You have solved my problem. Thanks again and again. AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 13 May 2010 10:10, Vigooo wrote: > to make it precise, > > > > =if(ISERROR(SEARCH(" ",A1)),LEN(A1),SEARCH(" ",A1)-1) > > > > > > With best regards, > > Vignesh > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Dave Bonallack > *Sent:* Wednesday, May 12, 2010 3:59 PM > > *To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ URGENT Request > > > > Hi, > Assuming there is a space after the first name, look for that space using > search, then subtract 1: > =SEARCH(" ",A1)-1 > Change the A1 ref to suit your data. > Regards - Dave. > -- > > From: azhar@gmail.com > Date: Wed, 12 May 2010 14:33:26 +0500 > Subject: $$Excel-Macros$$ URGENT Request > To: excel-macros@googlegroups.com > > Hi Members > > I have an excel sheet with huge text data and at the beginning of each cell > text string there are names (mostly single names) I want to count the number > of letters in the first word (that is the name I referred to above). Please > tell some excel function that does this work for me. > > Thanks and regards in advance for urgent replies. > > AZHAR RAI > Cell: +92 333-552-7731 > Skype: azhar.rai > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- > > Find it on Domain.com.au Need a new place to > live?<http://clk.atdmt.com/NMN/go/157631292/direct/01/> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Excel Wonders(Excel formulas)
Hi Rajesh The document is really impressive. Can you please guide where to find its latest version after Office 2010 has appeared in the market and may be author has made changes since then as its v1.0 Beta copyright 1998-2001. I am grateful to you. AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 14 May 2010 08:57, Aindril De wrote: > Hi Rajesh, > > A nice one for quick reference... > Thanks buddy > > Regards, > Andy > > On Fri, May 14, 2010 at 12:33 AM, Rajesh Nair wrote: > >> Hi All, >> >> Please find attached Excel formula book . >> This may help. >> >> Regards, >> Rajesh. Nair >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired
Hi All / I feel that I am facing a similar problem in word. My work relates to prepare a large number of reports and I use mail merge for all this process. I have to save each and every report separately. The file name I need to use is also generated through mail merge at the very first line of each report. What I need is when I apply the save as command on MS Word the new file name is fetched from the first line of the report (a combination of Ref No, Name, country or whatever). Please help me out in the issue. Thanks AZHAR RAI Cell: +92-333-552-7731 On Tue, Jun 1, 2010 at 15:38, Harmeet Singh wrote: > *Here you go* > *use mentioned code* > * > * > *Sub ren()* > * > * > *mo = InputBox("Enter Month number.")* > * > * > *For i = 1 To Application.Worksheets.Count* > * > * > *Sheets(i).Name = Left(Sheets(i).Name, 3) & mo & Right(Sheets(i).Name, > 3)* > *Next i* > * > * > *End Sub* > > > > Warm Regards, > > Harmeet Singh > > http://www.facebook.com/libraharry > > > > On Tue, Jun 1, 2010 at 3:07 PM, Venkatesan c wrote: > >> Dear Group, >> >> I have attached here file for help required. >> >> I am having 31 sheets the sheet names contains like 31.05.10,30.05.10,etc >> . want to change the sheet names Like 31.06.10,30.06.10,etc by using macros >> automatically >> >> is there anything macros please assist me >> >> Best Regards, >> * >> >> Venkat >> * >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge
Hi Gurus My work relates to prepare a large number of reports and I use mail merge for all this process. I have to save each and every report separately. The file name I need to use is also generated through mail merge at the very first line of each report in MS Word document. What I need is when I apply the save as command on MS Word the new file name is fetched from the first line of the report (a combination of Ref No, Name, country or whatever). Please help me out in the issue. Thanks AZHAR RAI Islamabad, Pakistan +92-333-552-7731 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge
Hello Gurus I am afraid I did not receive response from anyone. AZHAR RAI Cell: +92-333-552-7731 Skype: azhar.rai On Thu, Jun 3, 2010 at 10:03, Azhar Rai wrote: > Hi Gurus > > My work relates to prepare a large number of reports and I use mail merge > for all this process. I have to save each and every report separately. The > file name I need to use is also generated through mail merge at the very > first line of each report in MS Word document. > > What I need is when I apply the save as command on MS Word the new file > name is fetched from the first line of the report (a combination of Ref No, > Name, country or whatever). > > Please help me out in the issue. > > Thanks > > AZHAR RAI > Islamabad, Pakistan > +92-333-552-7731 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge
Hi All Finally I have recorded the following macro code: Sub reports() ' ' reports Macro ' ' With ActiveDocument.MailMerge .Destination = wdSendToNewDocument .SuppressBlankLines = True With .DataSource .FirstRecord = ActiveDocument.MailMerge.DataSource.ActiveRecord .LastRecord = ActiveDocument.MailMerge.DataSource.ActiveRecord End With .Execute Pause:=False End With Selection.EndKey Unit:=wdLine, Extend:=wdExtend Selection.Copy ActiveDocument.SaveAs2 FileName:="PAK000366 - USA.docx", FileFormat:= _ wdFormatXMLDocument, LockComments:=False, Password:="", AddToRecentFiles _ :=True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts _ :=False, SaveNativePictureFormat:=False, SaveFormsData:=False, _ SaveAsAOCELetter:=False, CompatibilityMode:=11 Windows("Progress Reports 201010 JUN 10.dotm [Compatibility Mode]"). _ Activate End Sub The problem i am facing is only that: every time the file is saved with the same name and not for what the copy function is performed. Please help me debug the problem. Thanks in anticipation of quick response. AZHAR RAI Skype: azhar.rai On Fri, Jun 4, 2010 at 16:52, Azhar Rai wrote: > Hello Gurus > > I am afraid I did not receive response from anyone. > > AZHAR RAI > Cell: +92-333-552-7731 > Skype: azhar.rai > > > On Thu, Jun 3, 2010 at 10:03, Azhar Rai wrote: > >> Hi Gurus >> >> My work relates to prepare a large number of reports and I use mail merge >> for all this process. I have to save each and every report separately. The >> file name I need to use is also generated through mail merge at the very >> first line of each report in MS Word document. >> >> What I need is when I apply the save as command on MS Word the new file >> name is fetched from the first line of the report (a combination of Ref No, >> Name, country or whatever). >> >> Please help me out in the issue. >> >> Thanks >> >> AZHAR RAI >> Islamabad, Pakistan >> +92-333-552-7731 >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge
Thanks Alvin My question is HOW? I am just failed to accomplish the task. Please help me. AZHAR RAI Skype: azhar.rai On Wed, Jun 16, 2010 at 07:10, fongie wrote: > Hi Azhar, > > Try using a variable for your file name. This variable file name can > be driven from the mail merge data set or from an adjacent data set. > > Alvin > > > > > On Jun 15, 8:08 pm, Azhar Rai wrote: > > Hi All > > > > Finally I have recorded the following macro code: > > > > Sub reports() > > ' > > ' reports Macro > > ' > > ' > > With ActiveDocument.MailMerge > > .Destination = wdSendToNewDocument > > .SuppressBlankLines = True > > With .DataSource > > .FirstRecord = > ActiveDocument.MailMerge.DataSource.ActiveRecord > > .LastRecord = > ActiveDocument.MailMerge.DataSource.ActiveRecord > > End With > > .Execute Pause:=False > > End With > > Selection.EndKey Unit:=wdLine, Extend:=wdExtend > > Selection.Copy > > ActiveDocument.SaveAs2 FileName:="PAK000366 - USA.docx", FileFormat:= > _ > > wdFormatXMLDocument, LockComments:=False, Password:="", > > AddToRecentFiles _ > > :=True, WritePassword:="", ReadOnlyRecommended:=False, > > EmbedTrueTypeFonts _ > > :=False, SaveNativePictureFormat:=False, SaveFormsData:=False, _ > > SaveAsAOCELetter:=False, CompatibilityMode:=11 > > Windows("Progress Reports 201010 JUN 10.dotm [Compatibility > Mode]"). > > _ > > Activate > > End Sub > > > > The problem i am facing is only that: > > > > every time the file is saved with the same name and not for what the copy > > function is performed. > > > > Please help me debug the problem. > > > > Thanks in anticipation of quick response. > > > > AZHAR RAI > > Skype: azhar.rai > > > > > > > > On Fri, Jun 4, 2010 at 16:52, Azhar Rai wrote: > > > Hello Gurus > > > > > I am afraid I did not receive response from anyone. > > > > > AZHAR RAI > > > Cell: +92-333-552-7731 > > > Skype: azhar.rai > > > > > On Thu, Jun 3, 2010 at 10:03, Azhar Rai wrote: > > > > >> Hi Gurus > > > > >> My work relates to prepare a large number of reports and I use mail > merge > > >> for all this process. I have to save each and every report separately. > The > > >> file name I need to use is also generated through mail merge at the > very > > >> first line of each report in MS Word document. > > > > >> What I need is when I apply the save as command on MS Word the new > file > > >> name is fetched from the first line of the report (a combination of > Ref No, > > >> Name, country or whatever). > > > > >> Please help me out in the issue. > > > > >> Thanks > > > > >> AZHAR RAI > > >> Islamabad, Pakistan > > >> +92-333-552-7731 > > > > >> -- > > > > >> > --- > --- > > >> Some important links for excel users: > > >> 1. Follow us on TWITTER for tips tricks and links : > > >>http://twitter.com/exceldailytip > > >> 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > >> To post to this group, send email to excel-macros@googlegroups.com > > > > >> <><><><><><><><><><><><><><><><><><><><><><> > > >> HELP US GROW !! > > > > >> We reach over 7000 subscribers worldwide and receive many nice notes > about > > >> the learning and support from the group.Let friends and co-workers > know they > > >> can subscribe to group at > > >>http://groups.google.com/group/excel-macros/subscribe > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join o