Fwd: $$Excel-Macros$$ How to copy the list of autofilter selection?
-- Forwarded message -- From: Meimei xxu8810...@gmail.com Date: Fri, Sep 10, 2010 at 6:55 AM Subject: $$Excel-Macros$$ How to copy the list of autofilter selection? To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Hi all, I have a question about copy the list of unique values generated by autofiltering in VBA. For example, if in column A I have cells listing some animal names, dog, cat, dog, sheep, cat, dog, cat, cat, dog, sheep. If I do an autofiltering on column A, the autofilter will have the selection of all, (Total), cat, dog, sheet. My question is whether there is a way to copy this autofilter's selections to other cells? Thanks a lot! -- -- 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 vba filter.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Macro to reshade every other row after column sort
Usha, This function is used mainly in finance. This can be better explained by an example. Let us assume, you are having Rs. 1,00,000/- which you want to invest. You got two proposals. 1. Fixed deposit at 10% interest for five years. 2. an annuity plan : end of 1st year you will get 17,000 end of 2nd year you will get 22,000 end of 3rd year you will get 27,000 end of 4th year you will get 32,000 end of 5th year you will get 37,000 In the first case you know the interest rate. In the second case you have to calculate the interest rate. So that you can choose what is more benificial. for this purpose you can use IRR function Just type your proposed investment and returns in like below in A1 -10 Your investment in B117000 first year return in C122000 second year return... and the like D1, E1, F1 Now use IRR function =IRR(A1:F1) This is only sample example. Regards, Kishan Reddy, K On Sep 9, 1:17 pm, Usha Negi ushadhvin...@gmail.com wrote: Dear All, Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel and how to use it? Regards, Usha -- -- 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$$ Re: How To Connect To Access Database Through VBA
Deepak, Let me know, why you want to create the form in Excel and link it to access. You can directly create a form in access which is very simple. Regards, Kishan Reddy, K On Sep 9, 10:48 am, Deepak Pal Singh deepaktheind...@gmail.com wrote: Hi, I need a help to connect excel file to a database in Access, I've a table format in the attached file, can anyone make a macro to solve this query. 1) Macro should take inputs from a useform and saved the data in the table in access databse. Seq# should be unique and auto generated for every new entry. 2) Details already entered in the databse should be ammendable through a userform, like if i have to make changes in date of birth of a individual then it should be possible by entering Seq# (Unique No) 3) If someone want to view data for an individual then it can be done by providing the unique Seq# in a user form. Platform is 2007. I hope it is enough chellangable to get response from experts. All the Best Thanks Regards Deepak Kumar Access.xlsx 13KViewDownload -- -- 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$$ Macro to reshade every other row after column sort
What has this got to do with shading rows? has someone hijacked another's post? P From: Kishan Reddy, K kishanreddy.kethire...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Fri, September 10, 2010 2:58:35 AM Subject: Re: $$Excel-Macros$$ Macro to reshade every other row after column sort Usha, This function is used mainly in finance. This can be better explained by an example. Let us assume, you are having Rs. 1,00,000/- which you want to invest. You got two proposals. 1. Fixed deposit at 10% interest for five years. 2. an annuity plan : end of 1st year you will get 17,000 end of 2nd year you will get 22,000 end of 3rd year you will get 27,000 end of 4th year you will get 32,000 end of 5th year you will get 37,000 In the first case you know the interest rate. In the second case you have to calculate the interest rate. So that you can choose what is more benificial. for this purpose you can use IRR function Just type your proposed investment and returns in like below in A1 -10 Your investment in B1 17000 first year return in C1 22000 second year return... and the like D1, E1, F1 Now use IRR function =IRR(A1:F1) This is only sample example. Regards, Kishan Reddy, K On Sep 9, 1:17 pm, Usha Negi ushadhvin...@gmail.com wrote: Dear All, Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel and how to use it? Regards, Usha -- -- 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$$ Track changes inside text box in Excel
The final conclusion is text box gets locked during track changes. Thanks for the info. On Fri, Sep 10, 2010 at 9:50 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Hello, You can use change tracking to log details about workbook changes every time that you save a workbook. This change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) can help you identify any changes that were made to the data in the workbook, and you can then accept or reject those changes. Change tracking is especially useful when several users edit a workbook. It is also useful when you submit a workbook to reviewers for comments, and then want to merge the input that you receive into one copy of that workbook, incorporating the changes and comments that you want to keep. How change tracking works Change tracking is available only in shared workbooks. In fact, when you turn on change tracking, the workbook automatically becomes a shared workbook. Although a shared workbook is typically stored in a location where other users can access it, you can also track changes in a local copy of a shared workbook. When changes are made in the shared workbook, you can view the change history directly on the worksheet or on a separate history worksheet (History worksheet: A separate worksheet that lists changes being tracked in a shared workbook, including the name of the person who made the change, when and where it was made, what data was deleted or replaced, and how conflicts were resolved.). Either way, you can instantly review the details of each change. For example, you can see who made the change, what type of change was made, when it was made, what cells were affected, and what data was added or deleted. When you use change tracking, you should consider the following: Change tracking differs from undo and backupYou might expect that change tracking creates a backup copy of the workbook before changes are made, or that you can undo any of those changes. Unfortunately, you cannot use the change history to back out of changes by undoing them or by restoring an earlier version of the workbook. However, the history worksheet includes a record of all deleted data so that you can copy that data back to the original cells in the shared workbook. Because change tracking is not designed to help you return to earlier versions of a workbook, you should continue to back up workbooks that have change tracking in effect. Some types of changes are not trackedChanges that you make to cell contents are tracked, but other changes, such as formatting changes, are not tracked. Some Microsoft Office Excel features are unavailable in shared workbooks, and therefore cannot be tracked. So when you track changes the workbook automatically becomes shared and text book is a formatting change and formatting changes are not tracked, so when you do track changes text box becomes locked.Hopes this clears your doubt. Thanks Regards, P.VIJAY KUMAR -- -- 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$$ Clear cookies, cahce
How to clear Browser cookies cache thru VBA code. -- -- 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$$ Clear cookies, cahce
check the link see if it helps* source*:http://www.vbforums.com/showthread.php?t=440508 Sub Clear_Temp_Files() Shell RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 8 End Sub Sub Clear_Cookies() Shell RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 2 End Sub Sub Clear_History() Shell RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 1 End Sub Sub Clear_Form_Data() Shell RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 16 End Sub Sub Clear_Saved_Passwords() Shell RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 32 End Sub Sub Clear_All() Shell RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255 End Sub Sub Clear_Clear_Add_ons_Settings() Shell RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 4351 End Sub On Fri, Sep 10, 2010 at 6:08 PM, Anju anjulav...@gmail.com wrote: How to clear Browser cookies cache thru VBA code. -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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