Re: $$Excel-Macros$$ Moderators of discussexcel forum
Dear Forum member, I have been an avid reader of this forum and have interacted with a few of you at a personal level. I enjoy reading some contribution during my free time and admire the creativity by some members. Spam was getting to me, to the point that I thought of leaving the group. In that sense this move is a welcome step. We, as members also need keep in mind that people post spam because we are unable ignore them. Each time a group member replies, even requests the moderator to ban the member, they are helping the spammer get the eyeball. We are unknowingly giving them the attention. We need to ignore them so that posting spam become futile for the spammer, atleast not circulate it further even if it is to highlight it. Let's wait for the moderators to observe and ban the member from our beloved group. Rgds, Roopesh Kapur E:roopesh.ka...@gmail.com -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 23 Aug 2012 22:54:48 To: ashish koulkoul.ash...@gmail.com; Don Guillettdguille...@gmail.com; NOORAIN ANSARInoorain.ans...@gmail.com; rajanverma1...@gmail.com Reply-To: excel-macros@googlegroups.com Cc: excel-macrosexcel-macros@googlegroups.com Subject: $$Excel-Macros$$ Moderators of discussexcel forum Hi Ashish, Don, Noorain and Rajan, ** Many thanks for your great contribution in the forum. Since there is increase in spam and job posts in the forum, I would like to recognise you all as Moderators of the Forum with some exclusive rights to manage members and topics. I have selected you all on the basis of your past contribution and confident you will use this power responsibly. You will be assigned a Moderator badge as [image: Inline image 1] as part of recognition. The badge should appear with your name in the forum. I hope this step will control spamming in the forum. Let me know if you have any queries. For any feedback, please feel free to post herehttps://docs.google.com/spreadsheet/viewform?formkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ . Thanks Best regards, Ayush Jain Group Manager Microsoft MVP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Moderator.jpg
$$Excel-Macros$$ Financial Accounting
Hi Everyone, Does anyone have any excel workbook that can cater to end to end financial accounting of a business. Regards, Roopesh Kapur -- 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.
Re: $$Excel-Macros$$ Finacial Excel Work Books
Hi Vijay, Thx. I had seen the website before writing in our group, however did not find anything that could help me with my day to day financial accounting (journal entries, ledgers, trial balances, PL Balance sheet. Rgds, Roopesh Kapur E:roopesh.ka...@gmail.com -Original Message- From: P.VIJAYKUMAR vijay.4...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 16 Aug 2012 21:09:36 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Finacial Excel Work Books Hi, Roopesh, For Financial excel sheets you can visit www.exinfm.com which has about 100 free excel sheets catering fianancial topics. Regards, P.VIJAY KUMAR -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: custom macro for email. Need to link excel to apple email.
Dear Members, Can anyone help me. regards, Roopesh Kapur On Dec 25, 4:37 pm, RK roopesh.ka...@gmail.com wrote: Dear Group members, Below is the code that i have been using in windows based laptop to connect MS excel to outlook. It takes the email address from a predefined col G and sends a customized email to the recipient. I have a two problems. 1) I have now moved to a Mac and instead of outlook now have apple mail. Can someone modify this code to link excel to apple email instead of outlook. 1.1) If linking it to Apple is difficult, can someone convert this code into CDO. 2) As you can see, I have modified the code for the email body using html, what I want to additionally add to this code is that when someone click on the hyperlink, I should get an email back with the email id of the person who had clicked the link in the email. Can someone help me with a php script that can help me with this. rgds, Roopesh Kapur Sub TestFile() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim str As String Dim Subs As String Application.ScreenUpdating = False Set OutApp = CreateObject(Outlook.Application) OutApp.Session.Logon On Error GoTo cleanup For Each cell In Sheets(Mailer).Columns(G).Cells.SpecialCells(xlCellTypeConstants) Set OutMail = OutApp.CreateItem(0) str = cell.Offset(0, -2).Value On Error Resume Next With OutMail .To = cell.Value .Subject = Subs .HTMLBody = body _ table align =middle border=0 cellspacing=0 cellpadding=0 valign=toptrth colspan=3 align=middle bgColor=#00FONT size=3 color=#ffTo, nbspb cell.Offset(0, -5).Value /b/FONT/th/tr/table _ table align =middle border=1 valign=top _ trth width=693 colspan=3 align=center bgColor=#ffa href=http://www.starstoneseries.co.in;img src=http://www.starstoneseries.co.in/logo.png;/abrClick on the logo to visit our website/th/tr/table .Display AppActivate Subs Application.Wait (Now + TimeValue(0:00:01)) Application.SendKeys %s, True End With On Error GoTo 0 Set OutMail = Nothing A = A + 1 Range(H1).Value = A Next cell cleanup: Set OutApp = Nothing Application.ScreenUpdating = True End Sub -- 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$$ custom macro for email. Need to link excel to apple email.
Dear Group members, Below is the code that i have been using in windows based laptop to connect MS excel to outlook. It takes the email address from a predefined col G and sends a customized email to the recipient. I have a two problems. 1) I have now moved to a Mac and instead of outlook now have apple mail. Can someone modify this code to link excel to apple email instead of outlook. 1.1) If linking it to Apple is difficult, can someone convert this code into CDO. 2) As you can see, I have modified the code for the email body using html, what I want to additionally add to this code is that when someone click on the hyperlink, I should get an email back with the email id of the person who had clicked the link in the email. Can someone help me with a php script that can help me with this. rgds, Roopesh Kapur Sub TestFile() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim str As String Dim Subs As String Application.ScreenUpdating = False Set OutApp = CreateObject(Outlook.Application) OutApp.Session.Logon On Error GoTo cleanup For Each cell In Sheets(Mailer).Columns(G).Cells.SpecialCells(xlCellTypeConstants) Set OutMail = OutApp.CreateItem(0) str = cell.Offset(0, -2).Value On Error Resume Next With OutMail .To = cell.Value .Subject = Subs .HTMLBody = body _ table align =middle border=0 cellspacing=0 cellpadding=0 valign=toptrth colspan=3 align=middle bgColor=#00FONT size=3 color=#ffTo, nbspb cell.Offset(0, -5).Value /b/FONT/th/tr/table _ table align =middle border=1 valign=top _ trth width=693 colspan=3 align=center bgColor=#ffa href=http://www.starstoneseries.co.in;img src=http:// www.starstoneseries.co.in/logo.png/abrClick on the logo to visit our website/th/tr/table .Display AppActivate Subs Application.Wait (Now + TimeValue(0:00:01)) Application.SendKeys %s, True End With On Error GoTo 0 Set OutMail = Nothing A = A + 1 Range(H1).Value = A Next cell cleanup: Set OutApp = Nothing Application.ScreenUpdating = True End Sub -- 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$$ macro to translate from one languague to another
Hi Sam, As suggested, I searched the net, however didnot find anything or it was that couldnot understand anything. Having a paid option doesnot work for me as I am looking for a macro to automate a time consuming activity. Donot have the scale to justify an expense to achieve it Any help from the group would be highly appreciated. Rgds, Roopesh Kapur E:roopesh.ka...@gmail.com -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 30 Nov 2011 00:38:52 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro to translate from one languague to another Another feature that Excel 2007-10 provides in terms of Translation can be found in the Review tab. If you have a cell selected, and use this translation feature, it will most likely translate it for you automatically. The manual part is that you will have to click on the insert button or copy button. This doesn't use Google Translation by the way. It uses Bing translation. Not sure if you can change that setting though. Regards, Sam On Wed, Nov 30, 2011 at 12:32 AM, Sam Mathai Chacko samde...@gmail.comwrote: You could possibly use the Google Translation API, but I am not sure if they have one for VB or VBA. If they do, probably have to pay some money for that. But search for the text Google Translation API for VB/VBA, and you might get something. If you reach a dead end, post back. Maybe we could help. Sam Mathai Chacko On Wed, Nov 30, 2011 at 12:25 AM, RK roopesh.ka...@gmail.com wrote: Dear Developers, I am looking for an excel macro to translate a sentence in a cell from one language to another and paste the result in another cell next to it. Thx in advance. Rgds, Roopesh Kapur E:roopesh.ka...@gmail.com -- 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 -- Sam Mathai Chacko -- Sam Mathai Chacko -- 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 -- 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$$ Re: Email Macro required for mail Boday
Thx Sam, I will try this tomorrow and if it works in office 2K3, it will solve an year old problem for me. Dear developers, Just to extend this conversation and make it more wholesome. I am using MS office 2011 on a mac machine. How do I link excel to mail app on Mac instead of outlook. Assuming that everything in the code below remains the same except that I will be using mail instead of outlook. Rgds, Roopesh Kapur E:roopesh.ka...@gmail.com -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 29 Nov 2011 19:22:52 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday Go to ToolsMacroSecurityProgrammatic AccessNever Warn Sam On Tue, Nov 29, 2011 at 8:28 AM, maulik desai mauliksde...@gmail.comwrote: Thanks you so much deepak for your great support lastly i just want to ask you 1 thing that when ever i clicked on Macro for mail send microsoft gives me pop up for stating that whould you like to send this mail (with allow or dinied option ) so every time i have to click allow buttion is there any why to remove this pop uo windlow rest everytrhing working fine pls revert with solution thanks once again.. On Wed, Nov 23, 2011 at 10:14 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Attached is the updated file, now you won't need to prepare a separate table to get channel wise unique email id's... On Mon, Nov 21, 2011 at 10:09 PM, maulik desai mauliksde...@gmail.comwrote: Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids are not common it is also not based on channel name.its is based on location wise its always get change so i suggest you to kindly add the new column after G or After M Actaully My Database is from A to G if u add the new col then From A To H , actually there is no summry sheet (From K to M ,if u want u can remove the column L(person name ) from summary sheet can add in main database after col F so while macro prepares summry sheet it will be easy for me to get data) i have just shown to u for ref actaully i want it like once i update the database in column A to H , Macro can create the summry sheet based on unique list then send the mail to mail ids (from To in CC fields) Thanks On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Sure Maulik... I just want to know those email ids (which you want to add in CC BCC) are common or they'll be changed with every channel name...?? Regards Deepak On Sun, Nov 20, 2011 at 2:43 PM, maulik desai mauliksde...@gmail.comwrote: Thanks you so much deepak for your effort sorry for late reply becasue i can not able to use Gmail from my office pc i check your file it is working very well just one thing i want to ask u that i want to add some email id on CC BCC can u please help in this that how can i do that. while data pasted to mail body , bottom line of table is not reflected . Request you to please look in small chnages revert Thnaks in Advance.. On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Here it is I developed this code on 2007 platform..I hope it'll work in 2003 as well... Sorry.. I couldn't attached the excel file with my previous post because I's in office at that time can't access to gmail over there... Regards Deepak On Tue, Nov 15, 2011 at 11:32 PM, maulik desai mauliksde...@gmail.com wrote: Hi deepu, Thanks you so much for your reply I have tried to paste the code in module but it not work properly request you to kindly provide me the excel sheet with your macro code but before you send me the file required small changes do not use K M column for Chennel name email address that is given just for information my actual database is from A to G request you to kindly change the macro code accordingly send it back for the other checks also if you want u can create the summary sheet with the help of macro paste it on sheet 2 also for name u can use Column H for the proper output.1 more thing i want to tell you that a have to send mail with our official signature so if u can apply macro logic for the same also it would be very great ful to u. Request you to kindly make the changes resend it for the final check Thanks in Advance thanks for your time support. On Mon, Nov 14, 2011 at 4:10 PM, deepu deepaktheind...@gmail.comwrote: Hi Maulik, Below is the code that you're looking for... Insert a module in your workbook and paste the following code and run it... --- Dim MyArray() As Variant, ListArray() As Variant Dim R As Long, C As Integer, LastRow As Long, i As Long Dim OutObj As Object,
$$Excel-Macros$$ macro to translate from one languague to another
Dear Developers, I am looking for an excel macro to translate a sentence in a cell from one language to another and paste the result in another cell next to it. Thx in advance. Rgds, Roopesh Kapur E:roopesh.ka...@gmail.com -- 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$$ Reasons for increase in excel file size
Try the following: Press CTRL+A Press F5 Click on special at left bottom Choose blank Click ok Go to edit in the menu Choose clear Click all Press CTRL+END See if this is truly the end of your file, delete all unnecessary rows and column. Again press CTRL+END Delete all cols to the right of it and all rows below it. Right click on sheet name and move it to a new workbook, save it and see the reduction in size Rgds, Roopesh Kapur E:roopesh.ka...@gmail.com -Original Message- From: Divaker Pandey divake...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 7 Sep 2011 13:18:02 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Reasons for increase in excel file size you have just change cell formatting again and again. clear all formatting.and then apply on only used cell. Divaker On Wed, Sep 7, 2011 at 10:59 AM, bé trần văn betnmtdongna...@gmail.comwrote: 2011/9/7 Amit Desai (MERU) amit.de...@merucabs.com What could be the reason for increase in excel file? I have a file with size of 4.5 MB, but data contents are not that much. ** ** You can do the following: - First you file your virus scanner. - Then select all the rows and columns and delete it. - Finally, you copy the data of each sheet and paste Special, then select Value and click OK. ** ** ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- 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 -- -- 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
$$Excel-Macros$$ Help with code
Hi Champion, Below is a code that I found, can someone help me plot it in excel. I am trying to paste data directly from excel to google translator, copy the translated text from google and paste it in excel along side the original text. Assume: 1) A1 has the original text that needs to be translated 2) A2 has the language of original text 3) A3 has the languague in which I want the translation to happen 4) A4 is where I want to place the translated text. 5) I will be using a loop for my actual requirement and hence want to use range instead of fixes hard coated values. I searched the internet and this is the closest code that I have found, at least this is what I think. Pls opine. What I want to know is 1) How do I tweak the code to get my desired output 2) quality of the code 3) is it a code which is based on features available in excel or will it require any downloads from the creater of this code. net net are there any strings attached with this code. 4) help in understanding this code Dim core As TwebstLib.ICoreVbaSet core = New TwebstLib.core Dim browser As TwebstLib.IBrowserVba Set browser = core.StartBrowserVba(http://www.google.com/;) For i = 1 To 5 ' Get the current text to be translated Dim textToTranslate As String textToTranslate = ActiveSheet.Cells(i, 1).Formula ' Twebst web automation part Call browser.Navigate(http://www.google.com/language_tools?hl=en;) Call browser.FindElementVba(textarea, id=source).InputText(textToTranslate) Call browser.FindElementVba(select, name=sl).Select(English) Call browser.FindElementVba(select, name=tl).Select(French) Call browser.FindElementVba(input submit, text=Translate).Click ' Find result span object Dim resultObj As TwebstLib.IElementVba Set resultObj = browser.FindElementVba(span, id=result_box) ' Get the text result Dim translatedText As String translatedText = resultObj.Text ' Save the result into Excel sheet ActiveSheet.Cells(i, 2).Formula = translatedText Next Regards, Roopesh Kapur -- -- 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=wallref=ts
$$Excel-Macros$$ Network days with a tweak
Hi Champs, I am looking for a formula or an add in that works like networkdays, the only difference being that I want saturday to be included as a working day, rest everything to remain same as Networkdays. Regards, Roopesh Kapur -- -- 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$$ Network days with a tweak
Thx Aindril/Abhishek, I will try your solutions and let you know if I need any further help. Regards, Roopesh Kapur On Apr 7, 3:07 pm, Aindril De aind...@gmail.com wrote: This is another alternative solution:http://www.mrexcel.com/forum/showthread.php?t=86072 On Wed, Apr 7, 2010 at 3:29 PM, Aindril De aind...@gmail.com wrote: OOps.. Sorry missed the link... Here is the link: http://spreadsheets.about.com/od/excelfunctions/qt/080321networkda.htm Hope this helps... Regards, aindril On Wed, Apr 7, 2010 at 2:31 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear Aindril As i m seeing this mail there is no link at all in your mail. Is there any way to calculate networking days Regards LKModi On Wed, Apr 7, 2010 at 2:20 PM, Aindril De aind...@gmail.com wrote: Hi Roopesh, The process given in the link below will be a good start. Regards, Aindril On Wed, Apr 7, 2010 at 12:29 PM, RK roopesh.ka...@gmail.com wrote: Hi Champs, I am looking for a formula or an add in that works like networkdays, the only difference being that I want saturday to be included as a working day, rest everything to remain same as Networkdays. Regards, Roopesh Kapur -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe- Hide quoted text - - Show quoted 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
$$Excel-Macros$$ Convert code into VBA Code
Hi Friends, how are you all doing. My last post regarding excel based translation from Google when unanswered. I am really hopeful that this time the champs in the group will not disappoint me. I want to convert the below code into a vba code. My requirement is to translate a string from excel into lang. of my choice. Pls help and donot hesitate to ask incase you have a query. /* * How to detect the language of text. */ google.load(language, 1); function initialize() { var content = document.getElementById('content'); // Setting the text in the div. content.innerHTML = 'div id=textHola, me alegro mucho de verte. \/divdiv id=detected/'; // Grabbing the text to translate var text = document.getElementById(text).innerHTML; // Detect the language of the text. google.language.detect(text, function(result) { var detected = document.getElementById(detected); // If there wasn't an error in the request if (!result.error) { var langCode = result.language; var langName; // Loop through the languages enum so that we can find the actual name of the language. // Learn about the languages enum here: // http://code.google.com/apis/ajaxlanguage/documentation/reference.html#LangNameArray for (var i in google.language.Languages) { var thisLangCode = google.language.Languages[i]; if (thisLangCode == langCode) { // If we find the language code, store the language name. langName = i; break; } } // Se the detected language. detected.innerHTML = 'Detected: ' + result.language + ' - aka ' + langName + ''; } }); } google.setOnLoadCallback(initialize); -- -- 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: Connecting excel to Google Translation
Hi All, I though this will be child's play for wizards like you. While I see that most of the queries posted after mine have been answered, my query has rcvd no response. I have a document available http://vbaexcel.eu/vba/google_translate_internet_explorer_automation.xls which is very near to what I want, however I being a very basic level programmer donot understand it, moreover the code in the file doesnot work well. Can some pls make an attempt to build on it and help me understand the code, so that I can tweek it to suit my requirement. I will really appreciate your help. When you open the sheet, you will need to first delete cell F5 to O15 and then the macro will work. Looking forward to some replies. Regards, Roopesh Kapur On 10 Aug, 10:06, RK roopesh.ka...@gmail.com wrote: Hi All, I need some help from you all. I have to do lot of translation. Currently what I am doing is this; 1) I write my msg in English in Excel, what I have found out is that for near accurate translation you need to break your msg lines of 10 -15 words so 2) I break my msg into various parts and paste them in different rows of the same column. This way my msg becomes very long and can go up to 25 columns 3) I translate msg in bits and then copy and paste the translation in the corresponding cell on the right hand side. this very cumbersome and painful and this is what I want to automate. I want a button, that 1) Connects my excel to the website changes the from and 2 values to what I choose. 2) Copies the first cell and pastes it to the website dialogue box. 3) hits the button for translation. 4) Copies the output and pastes it in the cell corresponding to cell mentioned in point 2. 5) repeats the cycle of point 1 to 4 for the next line that needs to be translated. I know that it is child’s play for wizards in this forum as I have seen much more complex solutions. Regards, Roopesh Kapur --~--~-~--~~~---~--~~ -- 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 5,200 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$$ Connecting excel to Google Translation
Hi All, I need some help from you all. I have to do lot of translation. Currently what I am doing is this; 1) I write my msg in English in Excel, what I have found out is that for near accurate translation you need to break your msg lines of 10 -15 words so 2) I break my msg into various parts and paste them in different rows of the same column. This way my msg becomes very long and can go up to 25 columns 3) I translate msg in bits and then copy and paste the translation in the corresponding cell on the right hand side. this very cumbersome and painful and this is what I want to automate. I want a button, that 1) Connects my excel to the website changes the from and 2 values to what I choose. 2) Copies the first cell and pastes it to the website dialogue box. 3) hits the button for translation. 4) Copies the output and pastes it in the cell corresponding to cell mentioned in point 2. 5) repeats the cycle of point 1 to 4 for the next line that needs to be translated. I know that it is child’s play for wizards in this forum as I have seen much more complex solutions. Regards, Roopesh Kapur --~--~-~--~~~---~--~~ -- 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 5,200 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: Different passwords for different Coloumns
Hi Shiv, Can you share the macro? Dear friends I am attaching a file passwords. xls which helps in giving two passwords for differnt coloums. Kindly give me your feedback Thanx N.SHIVKUMAR Mobile : +919866533180 Office : +914027685309 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com -- --- Thanks for contacting us. Please note the change of contact telephone address. Telephone numbers +44 1534 838200 +44 7797 886 248 --- This e-mail ( any attachments) has been sent on behalf of the Auto Tours (UK) Group, to the above named only and may be confidential. If it has come to you in error you must take no action based on it, nor must you copy or show it ( any attachments) to anyone; please reply to this e-mail and highlight the error. The e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. We have taken steps to ensure that the e-mail ( any attachments) are free from any virus, but advise that in keeping with good computing practice the recipient should ensure they are actually virus free. -- 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 5,200 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 -~--~~~~--~~--~--~---