$$Excel-Macros$$ Fwd: Need help on a formula
Dear Experts, I haven't yet received solution for my query below. Please help. Regards, -- Forwarded message -- From: hemant shah Date: Sun, Aug 19, 2012 at 12:56 PM Subject: Need help on a formula To: excel-macros Dear Experts, I am stuck up which my work in an excel. I need a help on a formula in the attached sheet. I have given a complete details & explanation in the attached sheet. Need your help to come out of this situation. For any question or details please revert back. Thanks in advance. Regards, Hemant -- 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. Point Based formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help on a formula
Dear Experts, I am stuck up which my work in an excel. I need a help on a formula in the attached sheet. I have given a complete details & explanation in the attached sheet. Need your help to come out of this situation. For any question or details please revert back. Thanks in advance. Regards, Hemant -- 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. Point Based formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ What is Application.OnKey, Application.OnTime
Hi Group, Pls explain, What is Application.OnKey, Application.OnTime with syntex. I had tried but couldn't understand how to use and when to use. If Possible can give me an example. Regards, Hemant. -- 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$$ Formula Help
Thanks to all for the Prompt reply. The problem is solved. Regards Hemant Dange On Dec 7, 9:55 pm, "dguillett1" wrote: > A macro to populate column B > > Don Guillett > SalesAid Software > dguille...@gmail.com > > > > -Original Message- > From: hemant > Sent: Wednesday, December 07, 2011 2:30 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Formula Help > > Hi all > > I need help on the following in EXCEL 2007: > > Compare the values of sheet 1:column A with Values of Sheet2:column A > > If the CELL values in sheet1 column matches with Range of values in > Sheet2 column. > > copy that CELL VALUE from sheet1 and paste it adjacent column (Column > B) of sheet2. Or COLOUR that particular cell background. > > Thanks and Regards > Hemant Dange > > -- > FORUM RULES (934+ 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 > > > > cfmacro.xls > 50KViewDownload- Hide quoted text - > > - Show quoted text - -- FORUM RULES (934+ 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
$$Excel-Macros$$ Formula Help
Hi all I need help on the following in EXCEL 2007: Compare the values of sheet 1:column A with Values of Sheet2:column A If the CELL values in sheet1 column matches with Range of values in Sheet2 column. copy that CELL VALUE from sheet1 and paste it adjacent column (Column B) of sheet2. Or COLOUR that particular cell background. Thanks and Regards Hemant Dange -- FORUM RULES (934+ 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
$$Excel-Macros$$ Cell Formatting
Hi all I am supposed to enter data in say "22:11" format in Excel 2007. Is there any method by which i will enter only "2211" and cell shows it as "22:11". Thus it will save my time to enter ":" (Semicolon) frquently. I am supposed to enter lot of data in this format and thus has to enter ":" also. Thanks Regards Hemant Dange -- FORUM RULES (934+ 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
Re: $$Excel-Macros$$ "@" character in Excel
Thanks for your reply. The problem is resolved. Regards Hemant On Nov 21, 6:18 pm, Manish Pandey wrote: > Hi Hemant, > > Go to File>Excel Options>Proofing>Auto Correct Options, there uncheck > 'internet and network path with hyperlink'. This will resolve creating > hyperlink automatically. > > Regards, > Manish > maverickpan...@gmail.com > > > > On Mon, Nov 21, 2011 at 5:09 PM, hemant wrote: > > Hi i am suppose to enter "@" character in coumns. And whenever i > > enter it, it opens OUTLOOK configuration. > > > How can i enter "@" character and without starting OUTLOOK in Excel > > 2007. > > > I don't want to change any settings of OUTLOOK. > > > Kindly provide solution. > > > Thanks > > Hemant Dange > > > -- > > FORUM RULES (934+ 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- Hide > > quoted text - > > - Show quoted text - -- FORUM RULES (934+ 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
$$Excel-Macros$$ "@" character in Excel
Hi i am suppose to enter "@" character in coumns. And whenever i enter it, it opens OUTLOOK configuration. How can i enter "@" character and without starting OUTLOOK in Excel 2007. I don't want to change any settings of OUTLOOK. Kindly provide solution. Thanks Hemant Dange -- FORUM RULES (934+ 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
RE: $$Excel-Macros$$ Need help on Email from Excel
Team, Can you please help me on my query. I want you to work on attached file itself. Waiting for your response Regards, -- Forwarded message -- From: hemant shah Date: Wed, Aug 3, 2011 at 9:26 PM Subject: $$Excel-Macros$$ Need help on Email from Excel To: excel-macros Dear Team, I need a help on emailing from excel itself. I have explained all the steps in the attached excel. Regards, -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Email.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help on Email from Excel
Dear Team, I need a help on emailing from excel itself. I have explained all the steps in the attached excel. Regards, -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Email.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Solution plse
Hi I have a data in cells and and want to add Blank cells to existing data such that every alternate cell will be empty. e.g. 1 2 3 To 1 Blank 2 Blank Thanks -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help with formula
Hi I have a data in cells and i want to reformat it with every alternate cell as empty cell in excel. so without any data loss every alternate cell will be empty. please give me the solution. Thanks -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Fwd: A help which will be most appreciated.
Hi, Can you please help me on my query. I have mentioned every thing in attached sheet. Regards, Hemant Shah -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts Book1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Please Help
Hi Team, Can you please help on the attached file. I have explained my query in the attached sheet. Regards, Hemant Shah -- Forwarded message -- From: Date: Mon, Sep 27, 2010 at 9:25 PM Subject: Book1.xls To: hemanthin...@gmail.com Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com -- -- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts Book1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Fwd: Date Stamp Help
Hi, Can you please help. Regards, Hemant Shah -- -- 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 Copy of Book1 (3).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Fwd: Hide & Protect Sheet from other User
Hi Team, Please help on the attached. Thanks in advance. Regards, Hemant Shah -- -- 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 Hide & Protect the Sheet from other Users.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Back up database from web to excel
Hi friends I have made a chat site using php and mysql. it is http://mylogo.0fees.net . Is there a way to automatically back up the database to an excel workbook using VBA macros? I mean is there a way to make a POST data request without user interface? Any help is verymuch appreciated :) Hemant Hegde -- -- 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$$ Creating new sheet for each person and transferring their data
Hi Amanda You haven't specified at what stage you are stuck with your macro or attached the workbook. The correct way to go would be 1) Confirm if names are repeated in the source sheet 2) Loop through the column containing the names. 3) Go on adding and renaming sheets and pasting the specific row from the source sheet to an empty row next to the used range! . . . ... pls attach your workbook!! :) Hemant Hegde On 7 June 2010 09:59, Amanda wrote: > Hi all, > > I'm stuck on a macro I'm working on. I'm uploading an example sheet. > > I have a list of data - the first column has the person's name - each > person can have any number of rows. > > I need the macro to create a new tab with the name of the person > (which is the entry in the 'A' column) and and to copy over all of the > rows for that person. In the end I want the first page with all the > data, and then a tab for each person with their data in it. It would > be safest to copy the entire row - the number of columns with data may > change. > > Thanks, > Amanda > > -- > > -- > 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$$ Re: Creating new sheet for each person and transferring their data
Hi You may also 1) sort the column (say A) 2) write this formula in an empty (or insert a new one) column next to A (B) =A2=A1 3) Filter column B for all "TRUE" values and delete entire rows of the filtered range! :) Hemant Hegde On 8 June 2010 19:34, ashish koul wrote: > first sort the sheet on col a basis then run it > > > > Sub Macro1() > Dim i, j, s, r As Long > Dim a As String > > j = 1 > Sheets(1).Select > Range("A10").Select > Selection.End(xlUp).Select > r = ActiveCell.Row > > For i = 1 To r > > If Range("a" & i + 1) <> Range("a" & i) Then > a = Range("a" & i).Value > > s = i > > > Rows(j & ":" & s).Select > Selection.Copy > Sheets.Add After:=Sheets(Sheets.Count) > ActiveSheet.Paste > > ActiveSheet.Name = a > > > > j = i + 1 > Sheets(1).Select > End If > > Next i > Sheets(1).Select > > > End Sub > > > > On Tue, Jun 8, 2010 at 1:22 PM, L.K. Modi wrote: > >> thank you i understand >> >> >> On Tue, Jun 8, 2010 at 4:43 AM, Amanda wrote: >> >>> Hi Lkmodi, >>> >>> The uploaded spreadsheet does not have any formulas/VBA in it. It is >>> simply to give you an idea of what the sheet will look like (first >>> tab) and what I want the tabs to eventually look like (2nd tab). >>> >>> Thanks, >>> Amanda >>> >>> On Jun 7, 6:15 pm, "L.K. Modi" wrote: >>> > > DEAR AMANDA >>> > >>> > > I HAVE FOUND THE SAMPLEWORKSHEET BUT UNABLE TO FINE THE LOGIC BECAUSE >>> > > THERE IS NO FORMULA IS THERE. PLS EXPLAIN IN DETAILS THAT WORKSHEET >>> SO THAT >>> > > WE CAN KNOW THE LOGIC. I WANT TO KNOW HOW U SEGREGATED THAT TWO NAMES >>> FROM >>> > > THE DATA WORKSHEET >>> > >>> > > REGARDS >>> > > LKMODI >>> > >>> > > On Mon, Jun 7, 2010 at 10:57 AM, Amanda >>> wrote: >>> > >>> > >> Or you can download the sample spreadsheet here: >>> > >>> > >>http://dl.dropbox.com/u/7375694/Amanda%20Example.xlsx >>> > >>> > >> -- >>> > >>> > >> >>> --- >>> --- >>> > >> 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 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
Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach
you can download it from this link *http://www.easy-share.com/1909713544/Excel 2007 Bible.pdf Regards Hemant Koranne * On Fri, May 14, 2010 at 10:06 AM, Vikas Chouhan wrote: > me also send pleasvikask...@gmail.com > > On Thu, May 13, 2010 at 11:22 AM, Nani Ram <06n...@gmail.com> wrote: > >> Hi Excel Masters, >> >> Could any one have MS-Excel Bible by john walkenbach e-book. >> if so could please send it to me at 06n...@gmail.com. >> >> >> Thanks in advance, >> >> Nani Ram >> >> >> >> -- >> >> -- >> 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 >> > > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, > 9911868518, > "We can't Spell S_ccess without U" > > Life is Very beautiful !!! > ¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling! > `•.¸.•´. > > -- > > -- > 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 > -- Regards Hemant Koranne Check out my web site for learning excel http://exceltnt.blogspot.com/ -- -- 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$$ FILTER
Yes you can put filters to 2 or more times in Excel The Trick is first time you put the normal filters. and 2nd and onwards choose the data you wanna put filters and go to insert table select the range click on "My Table has Headers" and it is done. Example attached Regards Hemant Koranne On Wed, Apr 7, 2010 at 6:23 PM, Jai wrote: > Dear All Members. > > How can put the filter 2 times in One Excel file . > > -- > 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 Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > -- Regards Hemant Koranne Check out my web site for learning excel http://exceltnt.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 To unsubscribe, reply using "remove me" as the subject. Example.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Access 2007 Bible
Dear Ajinkya & Vikas Thanks for providing download link. Hegards Hemant On Wed, Apr 7, 2010 at 7:00 PM, ajinkya natu wrote: > Hi Hemant, > > I suppose this is what ur looking for...the file size is around 50MB so had > to upload it on 4shared. > > http://www.4shared.com/file/259007389/9ff776d/Access_2007_Bible.html > > > Regards, > AJ > > > > > > > > On 7 April 2010 18:09, Hemant K wrote: > >> >> Hi Group, >> >> Any one have this book pls provide it. >> >> >> -- >> Regards >> Hemant Koranne >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 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 >> > > -- Regards Hemant Koranne Check out my web site for learning excel http://exceltnt.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 To unsubscribe, reply using "remove me" as the subject.
$$Excel-Macros$$ Access 2007 Bible
Hi Group, Any one have this book pls provide it. -- Regards Hemant Koranne -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 To unsubscribe, reply using "remove me" as the subject.
Re: $$Excel-Macros$$ hi-help required .
Here is the solution attached you can do it with the help of sumproduct formula or with Sumif Formula Regards Hemant On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh wrote: > > hi > > i have a worksheet where sizes and qty are maintained for each item in this > way > > 460*12 Pet 31 460*12 Pet 265 460*12 Pet 340 460*12 Pet 392 460*12 Pet > 523 460*12 Pet 150 470*12 Pet 35 470*12 Pet 212 470*12 Pet 159 480*12 > Pet 131 480*12 Pet 7 480*12 Pet 56 480*12 Pet 12 480*12 Pet 91 > > daily some sizes and qty are added , deleted, modified. > > i need to know the total requirement of each size eg: 480*12 pet > =+131+7+56+12+91 which is 297. > > same way need for all the sizes. the list is very big. > > i am not familiar with macros , any other formulae based solution will be > helpful. > > thanks > > > regards, > *sarvesh lahoti.* > > -- > Your Mail works best with the New Yahoo Optimized IE8. Get it > NOW!<http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/>. > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > -- Regards Hemant Koranne Check out my web site for learning excel http://exceltnt.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 To unsubscribe, reply using "remove me" as the subject. Solution.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ 12 secret shortcuts of Excel
Thanks Ayush for providing this great book and congrats on completing three years by the great group that is created by you and now it becomes a important part of my daily life I must say this. The solutions provided by the groups are so accurate and easy to use. Keep up good work and great going ahead. Thanks & Regards Hemant On Fri, Apr 2, 2010 at 8:56 PM, ayush jain wrote: > Dear Members, > > Thanks for all your contribution to the group. > > The group has successfully completed three years. On this occasion, I would > like to launch an eBook on excel shortcuts written by me recently. > * Through this eBook I want to show some powerful shortcuts so you become > more productive and efficient at work.* > > I hope this eBook will help you. Please let me know your feedback. > > Please share this *free eBook* with your friends and colleagues and help > spreading the word. Thanks. > > Keep Posting!! > > Best regards, > Ayush Jain > Group Manager > http://discussexcel.com/ > > P.S. The book is also available in files section of group. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > -- Regards Hemant Koranne Check out my web site for learning excel http://exceltnt.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 To unsubscribe, reply using "remove me" as the subject.
$$Excel-Macros$$ E Book "Excel 2007 Macros Made Easy by Gail Parry"
Hi All, Here is the link for the following great book for beginners in field of Macros http://cid-8debefc810167f39.skydrive.live.com/self.aspx/.Public/Excel%202007%20Macros%20Made%20Easy.pdf?lc=16393 Regards Hemant Koranne -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
$$Excel-Macros$$ Multiple Row Filters in Same Sheet
*I was working on my data sheet and countered with one problem **I required filters in two row ranges on being specific I want first filter to be placed for data range from Row no. 1 to 200 and second one I want for Row no. 210 to 350. So I try to do it with filter options that are available in Excel 2007 & Excel 2010 Beta but not getting it but whenever I put filter on second range first filter goes disappear so with the help of search on various options I got the answer for this problem. And it is here for help of our group members also this we can do without macros. First Go to Insert ribbon in MS Excel 2007 Click on Table "Create Table" Window will open * *Select the data range* *Mark My Table has headers option * *And repeat same function for another range you will get the desired results. * *Regards Hemant* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
Re: $$Excel-Macros$$ CONVERT
Hi, Find this add in this will help you to convert no to text first install this in and use it to use for example in Cell A1 you put no. 2000 in Cell B1 put formula "=spellnumber(A1)" you will get result Rs. Two Thousand Only" Regards On Tue, Mar 16, 2010 at 2:13 PM, Jai wrote: > > Hello All, > > Please Tell me That, > > Can we convert number to Text In Ms Word -2007, > > For Example 2000 (Number) > > Two thousand (Text) > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > -- Regards Hemant Koranne Check out my web site for learning excel http://exceltnt.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 No in word Excel Addin.xla.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ How to save data from html to excel.
Can you send that html file Regards Hemant On Thu, Jan 28, 2010 at 9:17 PM, Murtaza Dalal wrote: > Naah Ankur it didnt serve the purpose. I've created an HTML page. is there > an HTML code for saving data in excel. > > On Wed, Jan 27, 2010 at 12:18 PM, ankur wrote: > >> hi Murtaza Dalal >> the following link will help you >> >> http://prashantnayak.freeservers.com/Download/ExportButton.html >> >> On 26/01/2010, Murtaza Dalal wrote: >> > How do i save data from a form thats created in Html format? >> > >> > I have 5 fields for example >> > >> > 1. Name. >> > 2. Address >> > 3. Telephone >> > 4. Sex (combo box Male or Female) >> > >> > On click of submit button all this data should be stored on an excel >> file. >> > same has to be retrieved another button click for example Show Data >> button. >> >> > >> > -- >> > >> -- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> > http://www.excelitems.com >> > 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 >> > If you find any spam message in the group, please send an email to: >> > Ayush Jain @ jainayus...@gmail.com >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> > >> > We reach over 6,700 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 >> > >> >> >> -- >> >> Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> -- >> >> -- >> >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 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 >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice no
$$Excel-Macros$$ A question
Hi Team Can you pls help me with my question. Every thing is mentioned in the attached sheet. Pls help, Regards, Hemant Shah -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Attempt.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ need help in excel
Hi Shilpa If you tried to copy/move all the sheets to another workbook and it didn't work, it might be because either of the workbook is protected. Go to Tools>>Protection>>Unprotect Workbook and try to copy again. Another reason I can think of could be that either of the workbooks is opened in a separate instance of Excel! In this case when you try to copy sheets, you wont see the name of the destination workbook in the menu! In that case use CTRL+O rather that doubleclicking on the file icon to open those workbooks.. :) Good luck Hemant Hegde 2009/12/2 Amitabh Bose > > Hi Shilpa, > > Just to add to Mahesh's email .. this will work if you open both Excel > workbooks in the same Excel 'window'. > > Thanks, > > Amitabh > > -- > Date: Wed, 2 Dec 2009 17:00:52 +0530 > Subject: Re: $$Excel-Macros$$ need help in excel > From: mahender.bi...@gmail.com > To: excel-macros@googlegroups.com > > > Hi Shilpa, > > Open both the files(Ex:- A & B) and the select all the sheet u want move > from B to A. > Then right click on the tab and select move, w will see a new pop- up > select Sheet A and press ok. > > > > On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > > Hi Friends, > > I have 2 excel file having 12 sheets in it, what I want is to merge two > file into one. I tried using move or copy but it din't work. Is there any > method. Please not that i have formula in both file > > -- > Regards, > Shilpa > > -- > > -- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > > > > -- > With Love, > Mahesh Bisht > > -- > > -- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- > View your other email accounts from your Hotmail inbox. Add them > now.<http://clk.atdmt.com/UKM/go/186394592/direct/01/> > > -- > > -- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><>
$$Excel-Macros$$ Urgent Help Needed!!!!!
I had almost completed my VBA project and then decided to convert it to stand alone exe file using VB6 so that I can register my custom type data files to have a specific Icon and enable them to be opened with my application on doubleclick. I have converted most of it successfully but just now I am seeing that Comboboxes and Listboxes here are totally different than in VBA. I was using a *hidden* column in almost all comboboxes and listboxes but having multiple columns in VB6 is *not possible* However I can *fake* a multicolumn listbox by using TAB (vbtab) but the problem is that the hidden column must contain a value of data type Integer which I have to access many times within code. Is there any *other* way to include a hidden value for each list item of a combobox or a listbox in *VB6*? Hemant Hegde -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ ADO
Hi Please tell me the difference between ADODC and ADODB and how to move to next record using ADODC. I didnt see any method like Adodc1.MoveNext Hemant Hegde -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Date format problem
If it has already been converted into date format and you want to reverse it, use =Text(date,"yy-mm-dd") or =Text(date,"dd-mm-yy") the way you want and then remove formulae by pasting only the values Hemant Hegde 2009/11/27 Norman May > Jitesh > > Try formatting the cells as TEXT > > Norman > > > On Fri, Nov 27, 2009 at 5:40 AM, Jitheesh Vazhapully <7jit...@gmail.com>wrote: > >> Good Evening Excel Gurus, >> >> I have a data in this format 01-01-01, however as soon as I enter them in >> the excel sheet,excel picks it up as date and stores it in date format, Is >> there any way I can prevent this from happening. >> Also how to convert this data back from date format 01/01/2001 to original >> 01-01-01 format >> >> Thanks >> >> Regards >> >> Jitesh >> >> -- >> >> -- >> Some important links for excel users: >> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 2. Excel tutorials at http://www.excel-macros.blogspot.com >> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com >> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com or >> Ashish Jain @ 26may.1...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,500 subscribers worldwide and receive many nice notes >> about the learning and support from the group. Our goal is to have 10,000 >> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ A Non-Excel Query
Is it windows? If you want to use VBA for that, filecopy() function should help Hemant Hegde 2009/11/25 Peetu > There are free utilities available such as Allways Sync which can > synchronize your data between two locations. > > On Nov 25, 3:52 pm, Aindril De wrote: > > Hi Abhishek, > > > > Use the following command: > > > > XCOPY "E:\My Collection" "D:\My Collection" /E /S > > > > Let me know if you need any further help. > > > > Regards, > > Andy > > On Wed, Nov 25, 2009 at 2:19 PM, Abhishek Jain >wrote: > > > > > Hi Guys, > > > > > I am not sure whether I should ask it here or not because as the > subject > > > suggests, this is a non-excel query. > > > > > What is the scenario - > > > > > I have two locations: > > > > > 1. D:\My Collection > > > 2. E:\My Collection > > > > > Under both these folders I have like 500 subfolders. *All the > subfolders > > > are named exactly same in both these locations.* > > > > > What I want to achieve - > > > > > I want to copy (or move) the contents of subfolders from location no. 2 > to > > > location no. 1. > > > > > Example - > > > > > Copy *.* from E:\My Collection\Folder 1 to D:\My > Collection\Folder > > > 1 > > > Copy *.* from E:\My Collection\Folder 2 to D:\My > Collection\Folder > > > 2 > > > Copy *.* from E:\My Collection\Folder 3 to D:\My > Collection\Folder > > > 3 > > > and so on. > > > > > You all would appreciate that manually doing this with around 500 > folders > > > would be a headache. Is there any batch program or software or > something > > > which can help me in this ? > > > > > Any sort of help is greatly appreciated. Thanks in advance. > > > > > Best regards, > > > > > Abhishek Jain > > > > > -- > > > > > > -- > > > Some important links for excel users: > > > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > > >http://www.excelitems.com > > > 2. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com > > > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > If you find any spam message in the group, please send an email to: > > > Ayush Jain @ jainayus...@gmail.com or > > > Ashish Jain @ 26may.1...@gmail.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > > HELP US GROW !! > > > > > We reach over 6,500 subscribers worldwide and receive many nice notes > about > > > the learning and support from the group. Our goal is to have 10,000 > > > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Replace contents in a formula used for whole sheet.
Hi Nikhil If you are using find and replace option, make sure that the word you want to "find" does not contain any part of any of the sheet names. In case it contains (if it is damaging the formulae), change the sheet names before "replacing" the formulae. You can restore the sheet names afterwards Hemant Hegde 2009/11/25 RolfJ > You should provide a bit more detail. What's the formula? Which > characters do you need to change? > > On Nov 24, 2:51 am, nikhil deshpande wrote: > > Dear all, > > > > I need to change characters used to show results in (IF ELSE ) formula. > > > > I tried ctrl F- replace. but it is disturbing mu sheet and askin g to > save > > some where else. > > > > Kindly guide. > > -- > > Nikhil > > -- > > -- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.
logspot.com >> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com or >> Ashish Jain @ 26may.1...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,500 subscribers worldwide and receive many nice notes >> about the learning and support from the group. Our goal is to have 10,000 >> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Hemant Hegde -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Share your Coolest VBA codes!
Here is another code I wrote but could not make much use of it In the attached excel file, I have a frame inside a sheet which I wanted to be able to move by drag and drop... It is working fine. See if you can use that in you application -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Move.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Share your Coolest VBA codes!
Hi everyone Sorry for the delay: 'This is a function which I wrote for displaying and adjusting the form size for my project: Public Sub mZoom(ByRef Form As Object, Optional Hzoom As Integer, Optional Vzoom As Integer) If Vzoom = 0 Or Hzoom = 0 Then Hzoom = Application.Width / Form.Width * 100 Vzoom = Application.Height / Form.Height * 100 End If Dim MinZoom If Hzoom > Vzoom Then MinZoom = Vzoom Else MinZoom = Hzoom End If For Each c In Form.Controls If Hzoom > 100 Then c.Width = c.Width * Hzoom / 100 c.Left = c.Left * Hzoom / 100 Else c.Width = c.Width * Hzoom / (200 - Hzoom) c.Left = c.Left * Hzoom / (200 - Hzoom) End If If Hzoom > 100 Then c.Height = c.Height * Vzoom / 100 c.Top = c.Top * Vzoom / 100 Else c.Height = c.Height * Vzoom / (200 - Vzoom) c.Top = c.Top * Vzoom / (200 - Vzoom) End If On Error Resume Next c.Font.Size = CInt(c.Font.Size * MinZoom / 100) Next c If Hzoom > 100 Then: Form.ScrollWidth = Form.Width * Hzoom / 100 If Vzoom > 100 Then: Form.ScrollHeight = Form.Height * Vzoom / 100 Form.Width = Form.Width * Hzoom / 100 Form.Height = Form.Height * Vzoom / 100 Form.Show End Sub If you have missed to read the original post, I had told that I will post some code for 1) adjusting the form size according to the screen size 2) distributing the controls and adjusting their font size and 3) determining and adjusting the scroll height/width of the form If you ommit to specify the optional variables, it will maximise the excel window and use the dimensions of its parent aplication. Otherwise, you may also specify the percentage of how much you want to strech/shrink the userform. eg: call mzoom(userform1, 120,120) or just call mzoom(userform1) Thanking you :) Hemant Hegde -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Share your Coolest VBA codes!
Why not we share some of our own useful codes or techniques (which can not be easily found by a google search) which will save lot of effort and time? :) I am going to post some of the vb codes I wrote or got on the net. I will post a function (tomorrow because I don't have it here!) I wrote which will adjust the size of a userform to the screen size and also will distribute all the controls in it without overlapping on each other. Please post yours -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Fwd: Urgent Help required
Hello Everyone, Can you help me with my query. I have updated everything i require in the attached excel. Regards, Hemant Shah Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Book1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Store Cell formatting
Hi Paul Thanks for the reply. I am using excel 2003. I learnt about xll files only through google search. I dont have any Idea how to make an xll file or how to use an existing one. Do you know how to evaluate this? x = " = Y(1,1).Value1" where value1 is a property of a variable defined in a class module. Notice that the argument is stored as a string. The Evaluate() function doesn't work as it is for the workbook object and not for VBA Actual code I am using is below: Inside the class module named "MySpreadSheet" Option Explicit Private pFormula1 As String Private pValue1 As Variant Property Let Formula1(Text) pFormula1 = Text End Property Property Get Formula1() Formula1 = pFormula1 End Property Property Let Value1(Value As Variant) pValue1 = Value End Property Property Get Value1() Value1 = pValue1 End Property Sub Calculate() On Error GoTo Err: 'This is where I dont know what to do! pValue1 = Evaluate(pFormula1) Exit Sub Err: pValue1 = "#ERROR! " & Err.Description End Sub This is the code inside a normal module: Option Explicit Public X() As New MySpreadSheet Public Y() As New MySpreadSheet Sub Test() Dim mRow, mColumn As Integer ReDim Preserve X(1 To 10, 1 To 10) ReDim Preserve Y(1 To 10, 1 To 10) X(1, 1).Formula1 = "=Y(1,1).Value1" Y(1, 1).Value1 = "Hello Wrold" For mRow = 1 To UBound(X, 1) For mColumn = 1 To UBound(X, 2) X(mRow, mColumn).Calculate Next mColumn Next mRow MsgBox CStr(X(1, 1).Value1) End Sub Result I want is "Hello World" But I am getting "ERROR 2015" Please run this code and suggst me if there is any way to evaluate a string argument With regards Hemant Hegde -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ unable to set the visible property of the worksheet class
Hi Its because you have protected the workbook. Unprotect it Press Alt+t p w and then provide the password and then try :) Hemant Hegde 2009/11/12 mahesh parab > Dear All > > In attach sheet when i try to unhide sheet i am getting caption error. > steps are mention on below mention link > > http://www.ehow.com/how_2132122_worksheet-another-user-cant-unhide.html > > In visual basic screen when i click on the sheet & try to make visible in > properties window. i am getting caption error.Anyone knw how to unhide > worksheet through visual basic > > > > -- > > -- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Problem with Hyperlink
Hi I don't know the exact reason for this problem. But I can suggest you to use HYPERLINK() Formula. Using this, you can make the hyperlinks dynamic, more stable (as u say it isn't right now) and intelligent! It can be little difficult but its is not a rocket science. You can google it or attach an example workbook here so that I can tell you how to start with it if you are interested. With Regards Hemant Hegde 2009/11/13 DEBASHIS BANERJEE > > > -- Forwarded message -- > From: DEBASHIS BANERJEE > Date: Nov 12, 2009 1:34 PM > Subject: $$Excel-Macros$$ Problem with Hyperlink > To: excel-macros@googlegroups.com > > Dear Friends , > > I have workbook having multiple sheet. Each Page is connected with > Hyperlink . Problem is that as soon as the file is closed , Hyperlinks > disappear. It is continuing for several time that I have edited the > hyperlink and it is disappearing . > > > > > Kindly help how to solve this problem. > > -- > > -- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Store Cell formatting
Hi Paul Thank you for the suggestion. Whenever I have to format a sheet which requires complex formatting, I will always keep a hidden sheet which is already formatted. I will copy the default formatting (and also formulae) from the hidden sheet and paste it on the target sheet using "ActiveSheet.paste" and it is very quick. But in spite of that, the macro has to do a number of iterations (something like 2000*300) and it is very slow! Hidden sheet templates are already inter-linked to each other and contain a complex array of formulae (I have used them to decide which rows are to be deleted and which to be retained) We can easily guess why excel takes so much time when we are deleting/inserting rows. It has to update all the formulae in the workbook as the CELL ADDRESS CHANGES when we delete/insert a row (it does that even when calculation is set to XlManual and AS and WHEN we delete a row) I don't think simulation of a spreadsheet using code to accomplish this is feasible solution as im sure its going to be too complex. The only way to do this could be to use *.XLL files as these are already compiled and as fast as excel's built in functions. Where on the net can I get examples (open code of course) of working *.XLL files? If you know it yourself and want to help me, It will be very very nice and I will be grateful to you for the help.. thanking you Hemant Hegde 2009/11/12 Paul Schreiner > I'm not sure of any other ways, but one piece of advice: > > Determine what the "default" formatting is for the sheet. > Save the "default" once. > then, check the cells against the default. > Only save those that DIFFER from the default > (or perhaps only the features that are different) > > that way, when you restore the document, > you first set the defaults for the sheet, then only process the > differences. > > Paul > > -- > *From:* Hemant Hegde > > *To:* excel-macros@googlegroups.com > *Sent:* Wed, November 11, 2009 10:55:41 AM > *Subject:* $$Excel-Macros$$ Re: Store Cell formatting > > Hi > > Thank you Paul and RolfJ > > The file I want to save in binary format already contains 4 ararys of > variable size (these are to store: the file version info, settings and user > preferences, main data, and other data) > > The excel formatting I and values I am trying to save is just a part of the > above said file. I dont want to create two files (one myformat.svi and > another, excel.xls) but to include it in the same file. > > Furthermore I want the file to be as small as possible because the data to > be save can be accounting transactions data which can run into any length... > > If I am able to convert different combinations (there wont be many) of cell > formatting into a number (preferably between 0 - 255 so that i can store > that as a Byte) It would make my file smaller than excel's own format. > > What I mean by different combinations is: > > a Byte with value 0 may mean [ Font color=*Black*, Backgroung color=white, > Bold=*False*, Font ="Arial"] and > > a Byte with value 1 may mean [ Font color=*Red*, Backgroung color=white, > Bold=*True* Font ="Arial"] and > > and so on untill its 255 and I think more combinations wont be required. > > > Another important reason to do that is to avoid recalculation when the user > makes only a small change which affects only few values (or formatting) in > the final report.. > > I dont know if applying the cell formatting to each cell one after another > takes same [or more :( ! ] amount of time as a total recalculation!! > > It will be nice if you advice me if I can do it in some other way. I heard > "*.DLL" and *.XLL" files are faster? will these help? > > Thank You > Hemant Hegde > > > On 10/11/2009, RolfJ wrote: >> >> >> Please explain why you don't save the worksheet resulting from your >> calculations in the intrinsic Excel format (i.e. as an Excel >> workbook). >> >> On Nov 8, 12:20 pm, Hemant Hegde wrote: >> > Hi >> > >> > After a lot of coding and lengthy calculations (takes up to 2 minutes) I >> get >> > a sheet (actually a report) with lot of numbers and different cell >> > formatting. >> > >> > Now I need to store the cell values together with cell formatting in a >> > binary file to avoid repeated lengthy calculations. >> > >> > The only option I able to think is to store all the formatting values >> one >> > after another in the binary file eg. For cell's background colour, I >> will >> > have to store
Re: $$Excel-Macros$$ procdure to limit the printing to fix number of times
Hi You can keep a count of number of prints taken using VB but I don't think you can actually restrict it because the user can print it 1) on another machine 2) Or by just changing the name of the workbook 3) Or by restoring the original copy of the workbook after the number of prints allowed are exhausted. If you can explain the reason and importance of doing it, we may be able to give you a suitable solution Hemant Hegde 2009/11/10 OSAVentures Calamba > dear gurus, > > say i have a worksheet, but i want to limit the printing of this worksheet > to 10 times only. is it possible? > any vba idea. most probably this is a worksheet print event? > > im new to macro. thanks for understanding. > > dellosa > > --~--~-~--~~~---~--~~ > -- > > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Declare constant inside a type block
Hi Paul I managed it without a constant inside type block but I wanted to dceclare one because I use many subs where I use (and plan to use) custom type variables to write to and read from binary files (eg: save, open, import from old file, convert file to higher version etc) and I dont want to remember what value I assigned for each "mDataType" property of different custom types. I could do that with class modules BUT before I learnt to write data in binary format, I only knew to write data in "random access" format and it was not possible to write a "Class" to a random access file as a single record (ie. without writing each property of the variable separately which I cant avoid while writing a binary file!) The problem is that I dont want to change much of code I already wrote! With regards Hemant Hegde On 09/11/2009, Paul wrote: > > > I may be a little slow... but why does it need to be a constant within > the "Type"? > > If what you're saying is that MySviData.mDataType is always 1, then > why do you need to declare it? > > sorry, > > can't see a way... > > Paul > > On Nov 6, 1:46 pm, Hemant Hegde wrote: > > Is there a way to declare a constant strin inside a type block? > > > > I have this code > > > > Type MySviData > > Const mDataType As Byte = 1 > > SettingName As String * 16 > > SettingValue As String > > End Type > > > > Now this gives an error > > > > > "Compile Error: > > Statement Invalid inside Type Block" > --~--~-~--~~~---~--~~ > > -- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -~--~~~~--~~--~--~--- > > -- Hemant Hegde -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: vba to close workbook if last row with data = 10
Hi :) Why do you want to do that with the poor user? (he will have to re-open it and probably with macros turned off) You can Protect the sheet or Set the scroll area by putting this code : Sheets("name").scrollArea="A1:Z10" If you anyway want to close the workbook, this can help write If not isblank(target) then:thisworkbook.close(false) inside worksheet_change() event With regards Hemant Hegde On 10/11/2009, OSAVentures Calamba wrote: > > Dear Paul and gurus, > > I want to find the last row. Is this OK? > > Private Sub Worksheet_Change(ByVal Target As Range) > > Dim LastRow As Long > > If WorksheetFunction.CountA(Cells) > 0 Then > 'Search for any entry, by searching backwards by Rows. > LastRow = Cells.Find(What:="*", After:=[A1], _ > SearchOrder:=xlByRows, _ > SearchDirection:=xlPrevious).Row > MsgBox LastRow & " You cant go beyond this workbook closed." > > end sub > > or somthing like this. > > Private Sub Worksheet_Change(ByVal Target As Range) > > Dim LastRow As Long > LastRow = ActiveSheet.UsedRange.Rows.Count > if LastRow=>10 then > > MsgBox LastRow & " You cant go beyond this workbook closed." > endif > end sub > > Thanks > > On Mon, Nov 9, 2009 at 8:34 PM, Paul wrote: > >> >> What do you mean by "last row with data = 10"? >> do you mean that row #10 has data? >> or that the last row with data has a VALUE of 10 in a specific column? >> will there be data in rows 1-9? >> What columns will the data be in? look for ANY data in row 10? >> >> What do you want to use to trigger the event? >> When does the last row change to 10? >> >> do you want to save the workbook when it closes? >> >> You could create an event: >> Private Sub Worksheet_Change(ByVal Target As Range) >> >> test for whatever you're testing for: >> If (Target.Row = 10) then >> >> then: >> >> >> ThisWorkbook.Close savechanges:=False >> >> >> >> >> On Nov 8, 11:31 pm, OSAVentures Calamba wrote: >> > dear gurus, >> > >> > i need to close a workbook if last row with data =10, Any VBA >> suggestion >> > please? >> > >> > dellosa >> >> > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Store Cell formatting
Hi Thank you Paul and RolfJ The file I want to save in binary format already contains 4 ararys of variable size (these are to store: the file version info, settings and user preferences, main data, and other data) The excel formatting I and values I am trying to save is just a part of the above said file. I dont want to create two files (one myformat.svi and another, excel.xls) but to include it in the same file. Furthermore I want the file to be as small as possible because the data to be save can be accounting transactions data which can run into any length... If I am able to convert different combinations (there wont be many) of cell formatting into a number (preferably between 0 - 255 so that i can store that as a Byte) It would make my file smaller than excel's own format. What I mean by different combinations is: a Byte with value 0 may mean [ Font color=*Black*, Backgroung color=white, Bold=*False*, Font ="Arial"] and a Byte with value 1 may mean [ Font color=*Red*, Backgroung color=white, Bold=*True* Font ="Arial"] and and so on untill its 255 and I think more combinations wont be required. Another important reason to do that is to avoid recalculation when the user makes only a small change which affects only few values (or formatting) in the final report.. I dont know if applying the cell formatting to each cell one after another takes same [or more :( ! ] amount of time as a total recalculation!! It will be nice if you advice me if I can do it in some other way. I heard "*.DLL" and *.XLL" files are faster? will these help? Thank You Hemant Hegde On 10/11/2009, RolfJ wrote: > > > Please explain why you don't save the worksheet resulting from your > calculations in the intrinsic Excel format (i.e. as an Excel > workbook). > > On Nov 8, 12:20 pm, Hemant Hegde wrote: > > Hi > > > > After a lot of coding and lengthy calculations (takes up to 2 minutes) I > get > > a sheet (actually a report) with lot of numbers and different cell > > formatting. > > > > Now I need to store the cell values together with cell formatting in a > > binary file to avoid repeated lengthy calculations. > > > > The only option I able to think is to store all the formatting values one > > after another in the binary file eg. For cell's background colour, I will > > have to store the value of cells(1,1).interior.colorindex as a number and > > write it to the binary file. While opening the binary file, it has to > read > > it and apply it back to the cell. > > > > Any better Idea? > > > > Im sorry if I failed to explain correctly what i want to do! > > Can I get all the formatting of a cell as a single number or a string by > any > > means? > > > > Professional programmers help me please > > > > -- > > Hemant Hegde > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: InputBox
Hi Tommy Where did you get the code "name.copy" ? It doesnt work that way. Its very simple just write Range("a1")=name when you use "=" operator, the value on the right hand side is assigned to the variable on left side" 2009/11/9 Tommy > > > I need to be able to insert text into a cell using the “inputbox” > function linked to a button. The macro below allows me to input the > text, but getting it to go somewhere eludes me. I realize that > "Copy.Name" doesn't work but how do i direct the entered text to a > cell? Suggestions appreciated. > > Tommy > > Sub New_Name() > Name = Application.InputBox("Enter New Name") > Copy.Name > Range("A1").Select > ActiveSheet.Paste > End Sub > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Store Cell formatting
Hi After a lot of coding and lengthy calculations (takes up to 2 minutes) I get a sheet (actually a report) with lot of numbers and different cell formatting. Now I need to store the cell values together with cell formatting in a binary file to avoid repeated lengthy calculations. The only option I able to think is to store all the formatting values one after another in the binary file eg. For cell's background colour, I will have to store the value of cells(1,1).interior.colorindex as a number and write it to the binary file. While opening the binary file, it has to read it and apply it back to the cell. Any better Idea? Im sorry if I failed to explain correctly what i want to do! Can I get all the formatting of a cell as a single number or a string by any means? Professional programmers help me please -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating Txn file
Hi :) I saw your file. Its fine but what are 401114 and 40120 in TXN40114ForG TXN40120ForH Some random numbers or what ?;) On 07/11/2009, Prasad Gadgil wrote: > > *Dear All Excel Gurus,* > > I have one problem creating transaction file. > > Please find attached file showing input table & expected output > > I will be really grateful to all of you if you help me in creating macro > where i can get the output as expected. > > *Thanks & Regards > Prasad Gadgil > Cell:9819442088* > > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need a function or formula
@Pooja Hi If you want an accurate solution, you start with a sample data, big enough to include all possible patterns of raw data. The initial sample you attached did not contain all possible patterns. =Len() =Mid(,,,) =Left(,,) =Right(,,) =ISERROR() =IF(,,,) =SEARCH(,,,) I suggest you to understand these functions yourself (these are not so difficult and powerful enough handle most of text data manipulations) and try to identify the pattern of your raw data and see if they: 1) BEGIN and/or END with a CERTAIN character(s) (eg "_", "e-" or a ) 2) have a FIXED LENGTH (eg: you ALWAYS don't want the first 5 digits of a number) 3) If none of the above are applicable, just see how you identify the information you require from a raw data, and tell the computer to do the same! Well the computer may ask you to give each and every break-up of the procedure! Good Luck :) Hemant Hegde - @All It would be nice if forums like this which have got a big number of experts and professional programmers should help a member to learn rather than being a place where we can post some files of which we forgot the password and and wish someone would break it for us. I had asked for a help about dealing with Importing code to a code module. But I got suggestions about how to search the web better with Google ;) and how to make the query short and interesting [yes! it did help! :)] But I am unhappy that no one bothered to answer my last few posts :( Good Day :) Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Question
Hi sudhir For that purpose, I had created a file and uploaded at www.hemant.caclubindia.com . You can download it there. But you may have to sign up On 07/11/2009, sudhir kumar wrote: > > Hi firends > > My Question is how to convert numerical in words to > in Ms Excel ? > > > > -- > sudhir > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Problem with Calling a Sub in a Module from a Form
I guess when you are passing some values to a sub, You should use "Call" keyword Try Call Modul1.Get_Param(CInt(TextBox1.Text), CInt(TextBox2.Text)) Hemant Hegde 2009/11/6 laudes > > Hi all > > I've got a problem and it seems, that I'm not able to solve it without > your help. Needless to say anything more about my programming- > skills ;-) > There is a Form and a Module in my Workbook. I try to pass User-Input > from the Form to a Sub in the Module. > > If I call the Sub from inside the Form by using the On_Click Event of > a Button, Excel throws an error: > > "Error while compiling: > Expected: =" > > Here is how I try it: > > --function in the > module- > Public Sub Get_Params (Stichjahr As Integer, Stichmonat As Integer) > > End Sub > > --function call in the > Form-- > Modul1.Get_Param(CInt(TextBox1.Text), CInt(TextBox2.Text)) > > Can anybody Help? > Thank you very much in advance > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name as sheet name
Hi I think you are saying you have many columns with headings "ramesh", "ravi" etc and you want a macro which will create as many sheets as the number of columns you have with the respective names and segregates the data in the columns to respective sheets right? It is possible. But why do you want to do that? I, by experience know that its better to have data in a single sheet in a table format than in different sheets so that we can use advanced features of excel like pivot tables effectively. Hemant Hegde 2009/11/3 Chanti > > > Hi Team, >> >> Is there a way we can segregate the data depending upon the name >> (column A) to different tabs. >> >> Example >> If it is a macro, and if I run it, the result would be: >> >> Sheet names: “Ramesh”, Ravi”, “Rakesh”, and “Sridhar” and each tab >> would contain the data as per the sheet name. >> >> I hope this is a confusing request, please let me know if you have any >> questions. >> >> Thanks in advance >> Ramesh >> > > > > -- > Thanks!!! > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: need macro for a simple vlookup and pivot
Hi I did not understand what you want to accomplish with a VBA code. But can i pls know why you hate recorded macros? Hemant Hegde 2009/11/2 vinod rao > HI Team, > > Need a VBA code for doing pivot - below condition is needed > > > > > 1 > Z F C > I am eliminating these from pivot table, see pivot for more details > 2 > if name k is available it should be considered in pivot > 3 > I don’t want recorded vba macro > > > > Second simple macro on vlookup. See attached sheet. > > Thanks in advance. > Regards, > Vr > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: $$Excel-Macros$$
good luck friend ! :) Hemant Hegde 2009/11/1 karthikeyan sankaran > I have download this data from PDF.Now I want to create pivotTable through > this data. <http://groups.google.com/group/excel-macros/subscribe> > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need a function or formula
Hi Pooja Pls find the attached sheet Hemant Hegde 2009/10/31 Pooja Sharma > Hi All, > > I need your help in extracting some words (having defined format) from one > cell in another cell. Attached is a sheet where I have mentioned the case > and the solution I require. > > Hope you will help me. > > Best Regards > Pooja Sharma > *** > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Solution on the Data.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need Urgent Help (While Statement)
Hi Anish I Have corrected the code and it works fine now: Pls note that it runs on the ACTIVE SHEET. you may change it later. Sub Test() j = 1 While j <= Cells(65000, 1).End(xlUp).Row For i = 2 To Sheets("Replace_Values").Cells(65000, 1).End(xlUp).Row If Cells(j, 1) Like Sheets("Replace_Values").Cells(i, 1) Then Cells(j, 1) = Sheets("Replace_Values").Cells(i, 2) Else Cells(j, 1) = Sheets("Replace_Values").Cells(i, 3) End If Next i j = j + 1 Wend End Sub --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ How to do this?
Hi I have an excel sheet (attached) having a table with 3 columns, "Entry Number", "Party Name" and "Amount" In the result sheet I have: 1) In the row first row: selected values from "Party Name" 2) In the first column: selected values from "Party Name" (though from the same field as the first row, items are mutually exclusive) What result I want to get is: For each intersection of row and column items in the result sheet, sum of the field "Amount" where the "Entry number" is same. I tried many combinations of array formulae but could not get the result. But I think it is possible.. any help pls? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- PlsHelp.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Need help in Pivot table
Hi See attached file 2009/10/29 Mahesh > Dear Frineds, > > Please help me to solve the problem in attached sheet. > > > > > -- > With Love, > Mahesh Bisht > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Copy of Xl000.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Excel values to Website, HTML extraction back to Excel. PLEASE Help!!!
Hi Sorry.. I am not able to help in this regard now because I don't have much knowledge about that. But what you have posted here is what I was searching on the net for so many days but wasn't able to get. Thank you so much. :) I will now do some trial and error with your code. I will post it back if I get any success.. With regards, Hemant --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Macro Virus, Digital Certificate
Hi Experts, I had a disappointing experience.. I have a workbook with a VBA project which I carry to my clients' place when I go for audit and sometime run it on their machines. Yesterday an antivirus program in client's computer deleted all the the VBA code in my workbook calling it a "Macro Virus!". It did not even prompt as to what should be done with the file! In my code I have made references to the code module and it requires "Trust access to VBA" enabled. It might have appeared to be self replicating to the antivirus. But I don't want to remove that part of the code. Is there any way eg. I will digitally sign the workbook or some other person will certify it and the above situation be avoided? Thanking you Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: New user VBA to help random sheet
Hi Simon If you are already using excel to select random samples, I guess you are familar with excel formulae. VB is not required for this purpose. I have already uploaded a file here for almost the same kind of problem. With smal modifications, the file I have uploaded may serve your purpose. Visit my profile or search the group. You will find the attachment Best regards, Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Problem with calling macro periodically and automatically
Hi praveen to disable an ontime event, you need to know the scheduled time. So, declare a module level variable to store the schedule time. Use the same to disable the event 2009/10/27 Praveen Khunte > Hi Everyone > > I have used a macro given in site > http://www.cpearson.com/excel/OnTime.aspx > > This code copy cell D4 and paste to D30 automatically after every 2 minutes > when you press “start timer” button. > > But when I press “Stop timer” button, the macro didn’t stop and keeps on > continuing even when workbook is closed. > Can anyone please figure out why StopTimer() is not working? > > Regards > Praveen > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Conditional Formating of more than one cell
Hi If I understood correctly what you are trying to do, I would suggest you to use "RefEdit" control which you may find in the additional controls dialog box in form toolbox. It will allow the user to select a range from the worksheet. then u can use the following code (supposing the name of the RefEdit control is RefEdit1) On error resume next Range(RefEdit1).interior.colorindex=rgb(100,20,20) Best regards Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: TO PASTE THE DATE IN ATTACHED FORMAT & VALIDATE IT
The validation macro used by sales tax department is really stupid.. I have not checked your workbook but I have tried a workbook downloaded from Karnataka state VAT dept. Every time I download the workbook from their site, they would have changed it and it will give new error messages. Try filing paper returns! ;) 2009/10/27 RolfJ > > Hi Rahul: > > I didn't say that your WORKBOOK is password-protected. However the > MACROS that are associated with it ARE password-protected!!! It would > help to know whether you are familiar with Excel macros. > > Thanks for bearing with me, > Rolf > > On Oct 26, 4:15 am, RAHUL GARG wrote: > > HI ROLF, > > > > THE WORKBOOK IS NOT PROTECTED BY MY PASSWORD, THE PVAT-18.XLS FILE IS A > SALE-TAX FILE IN WHICH WE HAVE TO SUBMIT OUR E-RETURNS.I DOWNLOAD IT FROM > THE WWW.PEXTAX.COM OTHER THINGS LIKE BILL NO. PARTY NAME PASTE EASILY & > VALIDATE OPTOIN GIVEN AT THE END VALIDATE THE SAME, WHICH IS ESSENTAIL FOR > UPLOADING THE FILE TO THE SALE-TAX SITE. BUT WHEN WE PASTE THE DATE IN THE > ABOVE SAID FILE .THE VALIDATE OPTION DOES NOT VALIDATE THE DATA. SO I > HAVE ASKED TO YOU & DEAR EXCEL MACROS FRIEND IS THERE ANY WAY TO PASTE THE > DATE IN THE FILE & VALIDATE THE SAME. > > > > THANKS FOR YOUR REPLY. > > > > RAHUL GARG > > > > --- On Fri, 23/10/09, RolfJ wrote: > > > > From: RolfJ > > Subject: $$Excel-Macros$$ Re: TO PASTE THE DATE IN ATTACHED FORMAT & > VALIDATE IT > > To: "MS EXCEL AND VBA MACROS" > > Date: Friday, 23 October, 2009, 10:46 PM > > > > Hi Rahul: > > > > you will need to provide a LOT more information than this if you want > > anyone to assist you with this problem. The first thing I noticed when > > I opened your workbook was that you password protected your macros. > > That's not a great start, because it prevented me from trying to > > understand what you mean by 'IT'S VALIDATE OPTION'. > > > > Best wishes, > > Rolf > > > > On Oct 21, 12:33 am, RAHUL GARG wrote: > > > > > DEAR ALL, > > > > > > > > > PLEASE HELP ME HOW I CAN PASTE THE DATE FROM AN ORDIANRY EXCEL FILE IN > TO THE ATTACHED FILE. ALL OTHER THINGS SUCH AS PARTY NAME,B.NO. PASTE > EASILY , BUT WHEN WE PASTE THE DATE IT'S VALIDATE OPTION DOES NOT VALIDATE > IT WHICH IS ESSENTIAL. SO, PLEASE DO THE FAVOR FOR ME TO REDUCE MY WORK. > > > > > > THANKS & REGARDS, > > > RAHUL GARG, > > > > > > > > From cricket scores to your friends. Try the Yahoo! India > Homepage!http://in.yahoo.com/trynew > > > > > PVAT-18.xls > > > 640KViewDownload > > > > Keep up with people you care about with Yahoo! India Mail. Learn > how.http://in.overview.mail.yahoo.com/connectmore > > > > PVAT-18.xls > > 640KViewDownload > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need Urgent Help (While Statement)
Hi Anish If you are simplifying the code, you can even reduce your code to less than 20 lines from 100s of IF conditions 1) Create a sheet named "Replace Values" 2) Make 3 columns with the headings: a) "Find Text" (col A) b) "Replace Text" (col B) c) "Alternative text" (col C) 3) Write in (Col A) values you want to find and replace (Use the wild cards here and not in the code! you may write "*SALES*" or *Sales?*" or other patterns) 4) Write in (Col B) the new value to be written if the condition is satisfied 5) Write in (Col C) the new value to be written if the condition is NOT satisfied 6) Now write the following code: j=1 'write your While-wend loop here! ' For i = 2 to sheets("Replace Values").cells(1,65000).end(xlup).row if cells(j,1) like Sheets("Replace Values").cells(i,1) then cells(j,1)=Sheets("Replace Values").cells(i,2) else cells(j,1)=Sheets("Replace Values").cells(i,3) endif Next i '--- j = j+1 'Wend! I have not tested this code yet. Pls test and let me know if its not working 2009/10/26 Hemant Hegde > Hi Anish > > Its not the problem with "WHILE" or "WEND" > > Make sure you have closed all "IF" conditions with "END IF" at proper > places > > Just check if you have started an IF condition inside the loop and tried to > close it after the loop > > 2009/10/26 Anish Shrivastava > >> Hello Experts.. >> >> I m using While and Wend statement in my code and it has got more than 100 >> if conditions. when I run the macro it says "WEND WITHOUT WHILE", it's >> buggin my head...and I don know wht's wrong. Could anyone of you please help >> me... >> >> Sample code... >> >> Sub dept() >> i = 1 >> z = Cells(Rows.Count, "B").End(xlUp).Row >> While i <= z >> If Cells(i, 2).Value Like "*FINANCE*" Then >> Cells(i, 4) = "FINANCE / ACCOUNTING" >> Else >> If Cells(i, 2).Value Like "*ACCOUNTS*" Then >> Cells(i, 4) = "FINANACE / ACCOUNTING" >> Else >> If Cells(i, 2).Value Like "*SALES*" Then >> Cells(i, 4) = "SALES" >> *(IN BETWEEN THR R MORE THAN 100 IF CONDITIONS LIKE THIS)* >> endif >> endif >> endif >> i=i+1 >> wend >> end sub >> >> -best >> ANISH >> >> > > > -- > Hemant Hegde > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need Urgent Help (While Statement)
Hi Anish Its not the problem with "WHILE" or "WEND" Make sure you have closed all "IF" conditions with "END IF" at proper places Just check if you have started an IF condition inside the loop and tried to close it after the loop 2009/10/26 Anish Shrivastava > Hello Experts.. > > I m using While and Wend statement in my code and it has got more than 100 > if conditions. when I run the macro it says "WEND WITHOUT WHILE", it's > buggin my head...and I don know wht's wrong. Could anyone of you please help > me... > > Sample code... > > Sub dept() > i = 1 > z = Cells(Rows.Count, "B").End(xlUp).Row > While i <= z > If Cells(i, 2).Value Like "*FINANCE*" Then > Cells(i, 4) = "FINANCE / ACCOUNTING" > Else > If Cells(i, 2).Value Like "*ACCOUNTS*" Then > Cells(i, 4) = "FINANACE / ACCOUNTING" > Else > If Cells(i, 2).Value Like "*SALES*" Then > Cells(i, 4) = "SALES" > *(IN BETWEEN THR R MORE THAN 100 IF CONDITIONS LIKE THIS)* > endif > endif > endif > i=i+1 > wend > end sub > > -best > ANISH > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Random Sampling
Hi sarang I created a worksheet (attached) which with necessary modifications should meet your sampling requirements. I have not used any VB code in that. But for further manipulation and management of data, I think you already have required code 2009/10/25 Sarang84 > > I'm trying to build a macro (code) that can be used as an automated > tool for a sampling module that is part of a data quality / assurance > process. This sampling process needs to be done for various users. > i.e. samples have to be chosen for a set of users according to certain > pre-defined conditions. I'm trying to pick out sample rows from a > sheet of data by constantly filtering the source data. > > To understand more clearly of my requirement, read on... > > I've a big chunk of data in a sheet from where i need to pick out > sample rows of data (at random) according to some pre-defined > conditions (I may need to over-ride these conditions at times when any > of the conditions do not apply). I'll use auto-filtering a lot which > will export data to many worksheets created at runtime. But at the > end, the sample rows need to be consolidated (few samples) together > from all such sheets created. > > I've already coded few modules and I'm trying to build a master module > where I can integrate everything together. But I'm currently engrossed > with some shortfalls in the existing modules which i need to fix > before the final integration of the entire working code which can be > tested. If i come across any bugs i need to work around those too. > > I'm exploring for code across the web through forums / blogs / groups > to accomplish the following: > > • Keep some track of data that needs to be exported (which can be > done with one of the existing modules) and then creating (sort of) a > recordset (like in a database) where i can store the samples. In other > words, when I want to export data to new sheet(s), I only need to > determine the filtered rows and not actually exporting the whole data > at that point of time (when the code is in execution) which can be > stored temporarily (in an array or a defined data structure). > > • Since i want to choose random samples for various users – at the > end of an execution step for an user (say), i'll have to set some sort > of flagging points (to identify the rows that have met the sampling > conditions) and also need to randomly sample out these identified > rows. Probably, these flags can be cleared out every time and reset > but I also should take care of the overriding conditions > > This way I can have a control of the data being copied to many sheets > from the master sheet (to avoid duplication) and also can consolidate > the samples chosen for various users to a single sheet. > > If need be, i can post the modules i've created, but i don't know how. > > Can anyone help me with some coding / suggestions with which I can > accomplish the above? > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Sampler.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Run Excel Macro?
Hi Holsten and Rolf You can create a new instance of an excel application with this code Sub Test() Dim X As Object Set X = CreateObject("excel.application") X.Workbooks.Add 'X.Visible = True '--- 'Your code here.. X.ActiveWorkbook.ActiveSheet.Cells(1, 1) = "It works!" '--- X.DisplayAlerts = False X.ActiveWorkbook.SaveAs "C:\temp.xls" X.DisplayAlerts = True X.Quit Set X = Nothing End Sub -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel Query
Hi I forgot to put cell references before posting the file here.. I think you can look into the formula yourself and replace the constant values like "A" with the corect cell references like $C$6.. 2009/10/23 > Thanx for your HELP. > > But my query is when I enter “A” or “B” automatic data display,(looks like > Vlookup formula) > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Hemant Hegde > *Sent:* Thursday, October 22, 2009 8:45 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Excel Query > > > > Hi Malek* > > *I have attached the solution to your problem. > > > But can you people please give some introduction about your querry in the > message? This is because many people including me like to go through > interesting querries but without spending much time on downloading the > attachment.. > > Regards > > Hemant Hegde > > 2009/10/22 > > Can any one solved my problem?? > > > > > > *Malek Sarfraj* > > > > > > > > *DISCLAIMER:* > > Please note that this e-mail and its attachments are intended for the named > addressee only and may contain information that is confidential and > privileged. If you have by coincidence or mistake or without specific > authorization received this e-mail and its attachments we request that you > notify us immediately that you have received them in error, uphold strict > confidentiality and neither read, copy, nor otherwise make use of their > content in any way. Please note that the sender of this e-mail and its > attachments is solely responsible for its content if it does not concern the > operations of Intas group or its subsidiaries. > > > > > > > > > -- > Hemant Hegde > > > > > *DISCLAIMER:* > > Please note that this e-mail and its attachments are intended for the named > addressee only and may contain information that is confidential and > privileged. If you have by coincidence or mistake or without specific > authorization received this e-mail and its attachments we request that you > notify us immediately that you have received them in error, uphold strict > confidentiality and neither read, copy, nor otherwise make use of their > content in any way. Please note that the sender of this e-mail and its > attachments is solely responsible for its content if it does not concern the > operations of Intas group or its subsidiaries. > > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ help required in inserting multiple rows together
Hi friends, > > Can any body help me in this i want to insert rows between alternate rows > > for example > > Row No. > > sr. no. > > name > > 10 > > 1 > > sachin > > 11 > > 2 > > piyush > > 12 > > 3 > > amit > > 13 > > 4 > > pankaj > > 14 > > 5 > > hitendra > > > I want it to be > > Row No. > > sr. no. > > name > > 10 > > 1 > > sachin > > 11 > > > > > > 12 > > 2 > > piyush > > 13 > > > > > > 14 > > 3 > > amit > > 15 > > > > > > 16 > > 4 > > pankaj > > 17 > > > > > > 18 > > 5 > > hitendra > > > How can i add all the alternate rows together. > > Thanks & Regards > Hemant > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel Chart Macro to Set Axis Values
Hi friends, Can any body help me in this i want to insert rows between alternate rows for example Row No. sr. no. name 10 1 sachin 11 2 piyush 12 3 amit 13 4 pankaj 14 5 hitendra I want it to be Row No. sr. no. name 10 1 sachin 11 12 2 piyush 13 14 3 amit 15 16 4 pankaj 17 18 5 hitendra How can i add all the alternate rows together. Thanks & Regards Hemant --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel Query
Hi Malek* *I have attached the solution to your problem. But can you people please give some introduction about your querry in the message? This is because many people including me like to go through interesting querries but without spending much time on downloading the attachment.. Regards Hemant Hegde * * 2009/10/22 > Can any one solved my problem?? > > > > > > *Malek Sarfraj*** > > > > > > *DISCLAIMER:* > > Please note that this e-mail and its attachments are intended for the named > addressee only and may contain information that is confidential and > privileged. If you have by coincidence or mistake or without specific > authorization received this e-mail and its attachments we request that you > notify us immediately that you have received them in error, uphold strict > confidentiality and neither read, copy, nor otherwise make use of their > content in any way. Please note that the sender of this e-mail and its > attachments is solely responsible for its content if it does not concern the > operations of Intas group or its subsidiaries. > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Solution -Excel Query.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Insert file path and name into cell
Use this code Jp, Sub get_path () Dim x as string x=Application.getopenfilename If not x="FALSE" then: Activecell=x End sub :) Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Set reference through VBA
Why dont you include the original vb code in the new workbook? use application.savecopyas("\\path\name.xls") Or if you are anyway closing the original workbook 'delete unwanted sheets and save applcation.displayalerts=false sheets("unwanted1").delete sheets("unwanted2").delete thisworkbook.saveas("\\path\name.xls") applcation.displayalerts=true thisworkbook.close(false) 2009/10/19 Doug > > Hello, again. > > I have a workbook which creates a new worksheet each day. When the > worksheet is completed for the day, it is then saved as a new > workbook. The original workbook is set to reference an xla add-in that > I made but the newly created workbook doesn't have the reference. > > Can someone please tell me how to set the reference to a custom made > add-in automatically through code? > > Thank you. > Doug > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Run Excel Macro?
I am not much familar with data connections to/from excel or automating emails but I remember when I had checked "data query" property (i got it by right-clicking on a cell in a sheet having external data connections) I had seen an option for "background refresh". When I enabled this feature, excel was available for use while it refreshed the data in the background. Have you noticed that when an excel application is busy (running a macro etc.) you could always open a separate excel application using [WINDOWS + R] key and entering "excel" in the dialog box? Why don't you run a separate excel application programatically (i guess you can even keep it invisible), get the data refreshed and values copied to the original workbook later when the refresh is complete? Please let me know if any of the above solve the problem Can you please email me the workbook (or a part of it) which you use to send emails to yourself or any other way of posting data from an excel workbook to a web site? I prefer the easiest way of doing it. That is may be like by generating an easy url like http://mywebsite.com/?mymsgsub=test%message?body=blah%blah%blah and without depending on a configured MS Outlook account. Thank you :) -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: getting option buttons to work
Use this code friend Sub Test() On Error GoTo Ext: Dim X As Range Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks) X.Cells(1, 1) = 1 X.Cells(1, 2) = 30 Ext: Exit Sub -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Using the [A1] notation
Thank you so much Michael :) I am going to test it now! On Oct 15, 2:55 pm, Michael wrote: > Why does no one seem to use the [A1] notation in preferece to Range > ("A1")? > > [A1].Select seems easier than > Range("A1").Select > > Thanks > > Michael --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: To Learn VBA
I suggest Trial and error and Excel help file :) On Oct 16, 11:49 am, summu wrote: > 1)I am Unable decide Starting and Endling of VBA > Can any body suggest good book on EXcel Vba or any other good sources > > 2) How to learn Financial Modeling ,can anybody suggest me > Good books to learn FInancial Modeling --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Complex Look-ups
I think ARRAY FORMULAE may make it more simpler.. Its only today that I learnt to use array formulae... Go to www.cpearson.com They have put excellent excel tips on excel and VBA. But they have not mentioned that using cell range addresses like "A:A" does not work with array formulas but we have to use it like "A1:A65536" I nearly went mad till i found that out.. I still guess array formulae are more powerful and quicker than regular lookup formulae On Oct 15, 5:56 pm, Eric wrote: > I have a report that I need to put together regularly from several > different data sources. I keep each data set on it's own sheet within > a workbook. To create a single data set that I can generate a pivot > table from I usually end up using many looks-ups like this one: > > =INDEX(Exchanges,MATCH($E14,ExchangeCodes,0),10) > > When I need another field, I just drop in another one and change the > last number: =INDEX(Exchanges,MATCH($E14,ExchangeCodes,0),3) > > To avoid errors I usually wrap these requests in an "if/iserror" > statement: > if ( iserror(INDEX(Exchanges,MATCH($E14,ExchangeCodes,0),10)) , "0", > =INDEX(Exchanges,MATCH($E14,ExchangeCodes,0),10) ) > > As you can imaging having several hundred of these statements is a > killer on my cpu during the constant recalcs. I've tried disabling > auto-calc but I really need the instant feedback to make sure I'm not > entering any erroneous formulas. > > Does anyone know of a better, more elegant way to retrieve data from > several worksheets to create a single data table? > > Thanks, > Eric --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need a formula in picking right status
Hi friend I have tried to solve. Please find the attachment Happy Deepavali to all Hemant Hegde 2009/10/15 vinod rao > HI Expert Guru, > > I need a formula in finding status in column G. For reference the result > expected is given in column J. > > The contion is the status should be picked based on the latest date. > condition 2 is if the date is same for expire and active consider active > > At least i want the first condition to satisfy, provided the second > conditon is difficult in finding formula. > kindly find attached xls file attached, fyi,I am using 2003 xls. > > Wish you all the happy DWALI!! > VR > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Solution_Texting5.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: HAPPY DIWALI to All Members!!
Good Wishes for all the group members on this Diwali. The festival of lights bring all lights of joys and happiness to all of us. Regards Hemant On Fri, Oct 16, 2009 at 8:37 AM, Aindril De wrote: > Dear Fellow Group Members, > > Wish you All and Your Families a Happy and Prosperous Diwali. > Hope the festive season brings in health, happiness and prosperity to your > lives. > > Warm Regards, > Aindril De (Andy) > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Plz Help
Hi Prashant Please find the attached solution Hemant Hegde 2009/10/11 Prashant Bhawar > > Plz help here i attached a problem file with required ans. plz help me > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > > > > -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- PROBLEM.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Protect code from being hacked
Hi friends We know that there are loads of softwares available to crack VBA passwords. But can i convert some part of my VBA code to a *.dll file and use? (I guess it should be a bit harder to crack) I have worked with excel for 2 years and have some programming knowledge but I am nowhere near to creating a *.dll file. So when you are posting a reply, you can start from abc.. of it Thank you :) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Extracting a range from multiple files from a folder - Help!
Hi Abhishek I wonder why you need a macro or any software for this at all! I have not tested but try this 1) Have two columns for "Address" and "Data" (say col A and B) 2) Write down the path, filename and addresses in column A (anyway you have to do this normally even while using macros). 3) in column B, (say in row 2 as you may have headings in row 1) write this formula "=INDIRECT(A2)" 4) The formula should give you #REF! error because the target workbooks are not open. Open them! 5) Press F9 and copy and paste-special only the values. Pls let us know about more specific requirement if any. Regards Hemant Hegde On Sep 24, 4:45 pm, Abhishek Jain wrote: > Dear All, > > I am stuck at this. All I need to do is to extract a range, say, J18:J35, > from Sheet1 of all files placed in a single folder. > > Additional details (in case they are required) - > > > File names are like DIS01Aug.xls, DIS02Aug.xls and so on. > > Folder Name is DISAUG located at F:\ > > Range J18:J35 contains a few merged cells. > > I have tried and found some softwares who extracts value of given cell > address but all of them were having one or the other problem. Have tried a > few macros toobut to no avail. > > There are like 150 files so opening each one and then manually copy-paste > can cause excessive hair loss to me :) > > I believe, you guys can help me outa working macro would be ideal. The > results are required on a new workbook in columns - (data of 1st file in > Column A and Second in Column B and so on.) I would be amazed if the file > name can be put in the first row of each column. > > Thanks a lot in advance to you all excel masters. > > Awating a prompt reply from this group..as usual. > > Best regards, > > Abhishek Jain --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help with quotes in COUNTIF formula
Hi Good day cadunn and Dave I think this is because in VBA you cant use double quotes directly inside a text string. Just use& Chr(34) & Instead of double quotes Hemant Hegde On Sep 24, 9:30 am, Dave Bonallack wrote: > Hi, > > Try this: > > Range("C" & CStr(LCurSRow)).Formula = "=COUNTIF(Dept!AR" & CStr(lRow) > & ":CE" & CStr(lRow) & ",>0)" > > Regards = Dave. > > > > > > > Date: Wed, 23 Sep 2009 17:12:13 -0700 > > Subject: $$Excel-Macros$$ Help with quotes in COUNTIF formula > > From: cad...@gmail.com > > To: excel-macros@googlegroups.com > > > Hi Everyone, > > > I'm have a problem with modifying the following excel formula into a > > macro. > > > This is the basic cell formula from excel > > It counts the number of cells in the range that are greater than 0. > > Excluding blank cells. > > > =COUNTIF(Dept!AR40:CE40,">0") > > > This is my attempt at writing the same formula above for a macro. > > Seems to be a problem with the quotes. Not sure what the problem is. > > Can someone help me? > > > THanks. > > Range("C" & CStr(LCurSRow)).Formula = "=COUNTIF("Dept!AR" & CStr(lRow) > > & ":CE" & CStr(lRow) & "," ">0")" > > _ > Get Hotmail on your iPhone Find out how > herehttp://windowslive.ninemsn.com.au/article.aspx?id=845706 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ To: Excel Gurus - Run a macro when a workbook is opened
Hi friends I have a workbook which will automatically create another workbook in XLSTART folder when it is opened for the first time on a computer. The workbook which is saved in XLSTART folder contains a macro which will 1) Close any workbook with a name ending with ".svi" which is opened with excel without saving any changes to it and without prompting the user. 2) Open the same workbook (name ending with ".svi") using a macro inside another workbook (which is saved in another location; path stored in a registry key) Currently I am using Application.OnTime function (once in a second) to check whether any workbook with a name ending with ".svi" is open. But is there a better way to find out when a workbook with a name ending with ".svi" is opened? I mean is there a direct or indirect method to trigger the macro to run using any events like "Workbook_Open", "Calculate" etc? (I don't want to keep the macro running all the time) Let me also explain why I want to do all these: I have created a random access file with extention "*.svi" which can be opened only using a specific macro (I have good reasons for using a random access file) I want the users to be able to open that file by double clicking on the icon of "*.svi" file (otherwise the same had to be opened only through another workbook containing the macro) I could not think of any other way of doing this. I don't know how to create a new icon for my custom type file. Any help regarding this is highly appreciated Thank you in advance :) Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help! - Code Module, Protected project, Import code, link to web site, Decrypt,
No Replies! :( On Sep 19, 2:44 pm, Hemant wrote: > Good day friends :) > > I have an excel workbook with one of its hidden (XlVeryHidden) sheets > contains a link to my web site and gets updated every time the > workbook is opened and once in 15 minutes. > > When I will publish some encrypted information on my website (It can > be a message to all the user or to a specific user or it can be a *VBA > code to run*) the data will be decrypted by the workbook and used by > the workbook. > > Now the problem is that as it is important for me to keep the project > locked, I am not able to import the code from the worksheet to the > code module. > > Please help me out soleve this problem and consider if the following > are possible > > 1) Import the code to the module while the project remains locked > > 2) Unlock and lock the project programmatically > > 3) Insert two projects in a workbook one of which I can leave > unprotected > > 4) Insert a macro sheet (?!) > > I am thanking you in advance and It will be of great help! If I will > be able to do this, I can make automatic updates to my workbooks and > send pop up messages etc. when I would have distributed the workbook > to many people. :) > > Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Opening Specific Worksheet By Selecting its Name from Dropdown List
Use this code Mohit '1) Create a ComboBox in "Sheet1" '2) Insert a new module and paste the following code Sub Auto_Open() For i = 1 to thisworkbook.sheets.count Combobox1.Additem sheets(i) Next i End Sub '-- '3) Paste the following code in the module "Sheet1(Sheet1)" ComboBox1_change() sheets(combobox1).activate end sub Hemant Hegde On Sep 22, 7:41 pm, Mohit Agarwal wrote: > Hi, > Is it possible to go to create a drop down list of names of all the > worksheets in a workbook without writing the names on a different sheet and > then using data validation. I mean if I am not sure about the names of > worksheets or if some more worksheets are added later then is it possible to > get a drop down automatically containing all the worksheet names. > > Also, is it possible to go to a specific worksheet by selecting its name > from drop down. (even if the above query does not work and i have to write > the names of all the worksheets on a different sheet and then create a drop > down from it, is it possible to open a specific worksheet by selecting its > name in drop down list) > > Regards > Mohit Agarwal > 09214368691 > > "We are what we do repeatedly. Excellence then, is not an act, but a habbit" > - Aristotle > > Excel Query.xls > 23KViewDownload --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: HEY NEED HELP
I dont know why in some computers excel stores date in mm/dd/ and in some as dd/mm/ BUT You can convert the same to any format without using any formula or a macro. Just select the column containing the data (Date. in whatever format! like 1.13.2009, or 13-1-2009, or 13/1\2009) Go to DATA>>TEXT TO COLUMNS Select "Delimited" option button >>Next>> Do NOT select any delimiter >>Next>> In the column data format, select "Date" and then select the format in which the data is stored. eg. DDMMYY or MMDDYY etc >>FINISH>> Now your data is in date format On Sep 21, 12:05 pm, ashish koul wrote: > 8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009 > 5/8/2009 5/8/2009 5/8/2009 5/8/2009 > THEY ARE IN DD MM > > I WANT TO CONVERT THEM INTO > > MM DD > > regards > > ashish --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Restore an Excel function
Friend! If you are not confused about the functions =TEXT() (in excel) and =Format() in VBA, (like i was confused) You can just rename your macro in the code module by pressing ALT+F11 to get the function "Forrmat" working again. On Sep 21, 5:41 pm, Doug wrote: > I'm so annoyed at myself! I recorded a quick macro just to take a look > at the code it wrote and I named it "Format". Now Excel is not > recognizing it's own Format() function. How can I restore the original > function? > > Thanks. > Doug --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Name Matching In Excel
Hi dear Sonal, You can refer to Help on VLOOKUP (or COUNTIF whichever is easy!) function in excel (excel as I feel has got excellent help file) I would put the required formula in your attachment and upload it back but I do not see the "Attach" option here! I had asked for help but no one seems to know why! Let me just try to explain the formula =VLOOKUP( , , , ) =COUNTIF(,) will give you the count of search term in the range. returns zero if its not found Hemant Hegde On Sep 21, 9:16 pm, Sonal Gadgil wrote: > Hi... > > I am new in this group. > > I am facing one proble while working in the excel. > > I am having two excel files where i have to map the customer based on > customer name by matching customer name manually. > > Now, in case there is any macro available which help me to search & map > names this will be great help to me & other users > > Example: > > Name Maching.xls > 18KViewDownload --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Get name of the sheet using formula
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,31) :) Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Screen fluttering during macro run time
Yeah You can use Application.ScreenUpdating=False But you can also: 1) avoid codes like ".Select" , ".Activate" 2) If you are formatting a sheet, Create a sheet which is already formatted and keep it hidden. And then you can just copy the hidden sheet and paste the format the new sheet. It will save lot of time and the screen will not filcker much in case you dont use "Application.ScreenUpdating=False" when you want the user to be able to see whats happening when the macro is running. As you said your macro is pretty long, you may also want to alow the user to change sheets, scroll or minimise the window etc.. in that case use the code "DoEvents" inside loops On Sep 19, 3:04 am, "Daniel" wrote: > Hello. > Add the following line at the beginning of your macro : > > Application.ScreenUpdating = False > > Optionally, restore at the end of the macro : > > Application.ScreenUpdating = False > > HTH > > Daniel > > > > > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] On Behalf Of Tommy > > Sent: vendredi 18 septembre 2009 04:11 > > To: MS EXCEL AND VBA MACROS > > Subject: $$Excel-Macros$$ Screen fluttering during macro run time > > > I have a rather long macro, which when running causes distractful > fluttering > > of the screen, is there a way to either blank out or freeze the screen > during > > that time period? > > Any help appreciated. > > Tommy- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: hi all backup code
This code will definetly serve your purpose. Use Location = "E:\abdc" Filename = "MyFile_Backup_" & Format(Now(),"YY-MM-DD HH:MM:SS") & ".xls" Thisworkbook.SaveCopyAs (Location & Filename) Please note that I have not use "SaveAs " You can this code and see what is the difference between these two On Sep 15, 10:02 pm, Paul Schreiner wrote: > First of all, Excel already has an AutoRecover feature > that saves the file every X minutes to a separate location... > > but I don't like it either. > > What do you mean by "automatically"? > > for instance, I have a "save event" that > does a "SaveCopyAs" > > like: > > Option Explicit > Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) > Dim ThisDay, CurTime, fso, BackupFolder, BackupName > If (ActiveWorkbook.Name = "TGOR Project Summary_Master.xls") Then > Cancel = True > Set fso = CreateObject("Scripting.FileSystemObject") > ThisDay = Format(Now, "-mm-dd") > CurTime = Format(Now, "hh") > BackupFolder = "C:\temp\" > BackupName = "TGOR Project Summary_Master_" & ThisDay & "_" & CurTime > & ".xlsm" > If (Not fso.fileexists(BackupFolder & BackupName)) Then > Application.EnableEvents = False > Application.StatusBar = "Saving Backup File" > Application.DisplayAlerts = False > ActiveWorkbook.SaveCopyAs Filename:=BackupFolder & BackupName > Application.StatusBar = False > ActiveWorkbook.Save > Application.EnableEvents = True > Application.DisplayAlerts = True > End If > End If > Application.StatusBar = False > End Sub > > with this event, whenever I hit the SAVE button, it creates a backup of the > file before it is saved. > But only once an hour. > Otherwise, I'd have hundreds of files! > > is this the kind of thing you're looking for? or something more automated? > > > From: ashish koul > To: excel-macros@googlegroups.com > Sent: Tuesday, September 15, 2009 12:07:40 PM > Subject: $$Excel-Macros$$ hi all backup code > > hi > > i need a code which will automatically create a backup of my file at the > location i specify to it > > thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: unique record retrieval
1) Sort the column which you want to filter (say column A) 2) Insert a column to the right of sorted column (Column B) 3) In the inserted column, enter this formula (Say in Row 2) =A1=A2 4) drag the formula till the end of the table 5) Now use an autofilter and select all the cells having TRUE in column B 6) Delete the entire rows of the selection! Isnt that very quick? On Sep 16, 1:26 pm, Anish Shrivastava wrote: > Dude, > > Go For Advanced Filter. > > > > On Wed, Sep 16, 2009 at 12:51 PM, Aligahk06 wrote: > > Dear All, > > > I want to fetch unique records through Formula or VBA. > > I have two records in two different column.I want to fetch Unique records > > from both the Column. > > E.g > > > Col k10:k25 Col L10:L25 > > > Rstyv 1"50 2.5 > > Rstyv 2"50 3.5 > > Rstyv 1"50 2.5 > > Rstyz 3"50 8.5 > > Rstyv 2"50 3.5 > > ..and so on. > > i want to display in another two column the unique records from range > > k10:k25 to corresponding > > Col L10:L25. > > > Please assist, > > > Rgds, > > aligahk06- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Help! - Code Module, Protected project, Import code, link to web site, Decrypt,
Good day friends :) I have an excel workbook with one of its hidden (XlVeryHidden) sheets contains a link to my web site and gets updated every time the workbook is opened and once in 15 minutes. When I will publish some encrypted information on my website (It can be a message to all the user or to a specific user or it can be a *VBA code to run*) the data will be decrypted by the workbook and used by the workbook. Now the problem is that as it is important for me to keep the project locked, I am not able to import the code from the worksheet to the code module. Please help me out soleve this problem and consider if the following are possible 1) Import the code to the module while the project remains locked 2) Unlock and lock the project programmatically 3) Insert two projects in a workbook one of which I can leave unprotected 4) Insert a macro sheet (?!) I am thanking you in advance and It will be of great help! If I will be able to do this, I can make automatic updates to my workbooks and send pop up messages etc. when I would have distributed the workbook to many people. :) Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---