Re: $$Excel-Macros$$ Small Query
hi Kenil Gala, find the attached file it will solve your prob regards Delin.F From: Kenil Gala keni...@yahoo.com To: excel macros excel-macros@googlegroups.com Sent: Monday, 26 November 2012 8:48 PM Subject: $$Excel-Macros$$ Small Query Hi, Pls help me solve my small doubt. I have written it in the file attached. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. doubt in excel.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Dear All.. Bhanu Prakash, works for Oracle as Business analyst...Im proud to be part of loverly group...Keep rocking.. Thanks Bhanu On Mon, Nov 26, 2012 at 10:43 PM, Ayush Jain jainayus...@gmail.com wrote: CSk, start the new topic please Thanks. On Nov 25, 2012 10:01 PM, CSK charandeeps...@gmail.com wrote: hi sir my query is i have extract last five yrs data of two stocks and one index on one sheet and prepare line chart and insert four combo boxes 1) stock 1 2) stock 2 3) Index 4)time combo box which incudes if you drag , less than one year .less than than 6 months,2 year,3 year so on and so forth.. 5) one button to chgange the chart accordingly my objective is if i select from time combo box less than six monthsand press that button it will show me less than six month chart of the above 3,nd so on so forth On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Amol Shrivastava From Mumbai...thanks On Tue, Nov 27, 2012 at 5:22 PM, bhanu prakash bhanu...@gmail.com wrote: Dear All.. Bhanu Prakash, works for Oracle as Business analyst...Im proud to be part of loverly group...Keep rocking.. Thanks Bhanu On Mon, Nov 26, 2012 at 10:43 PM, Ayush Jain jainayus...@gmail.comwrote: CSk, start the new topic please Thanks. On Nov 25, 2012 10:01 PM, CSK charandeeps...@gmail.com wrote: hi sir my query is i have extract last five yrs data of two stocks and one index on one sheet and prepare line chart and insert four combo boxes 1) stock 1 2) stock 2 3) Index 4)time combo box which incudes if you drag , less than one year .less than than 6 months,2 year,3 year so on and so forth.. 5) one button to chgange the chart accordingly my objective is if i select from time combo box less than six monthsand press that button it will show me less than six month chart of the above 3,nd so on so forth On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Amol Shrivastava +91 99671 18180 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Welcome n Keep posting!!! Sent on my BlackBerry® from Vodafone -Original Message- From: Kuldeep Singh naukrikuld...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 27 Nov 2012 17:26:16 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Introduce Yourself !! Hi Bhanu Amol, Most welcome in Excel-Macro Group. Keep posting. Regards, Kuldeep Singh On Tue, Nov 27, 2012 at 5:24 PM, Amol Shrivastava shri.a...@gmail.comwrote: Amol Shrivastava From Mumbai...thanks On Tue, Nov 27, 2012 at 5:22 PM, bhanu prakash bhanu...@gmail.com wrote: Dear All.. Bhanu Prakash, works for Oracle as Business analyst...Im proud to be part of loverly group...Keep rocking.. Thanks Bhanu On Mon, Nov 26, 2012 at 10:43 PM, Ayush Jain jainayus...@gmail.comwrote: CSk, start the new topic please Thanks. On Nov 25, 2012 10:01 PM, CSK charandeeps...@gmail.com wrote: hi sir my query is i have extract last five yrs data of two stocks and one index on one sheet and prepare line chart and insert four combo boxes 1) stock 1 2) stock 2 3) Index 4)time combo box which incudes if you drag , less than one year .less than than 6 months,2 year,3 year so on and so forth.. 5) one button to chgange the chart accordingly my objective is if i select from time combo box less than six monthsand press that button it will show me less than six month chart of the above 3,nd so on so forth On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Hi all Excelers, Jorge Marques from Portugal, work in a Logistic Company and Excel is now part of my life, my learning curve in VBA is improving alot since I discovered this group, also use chandoo.org because it has some awesome stuff, regarding formulas and Charts. In my spare time I´m learning SQL and applying the learnings I get from this group. Keep it up On 4 August 2012 16:41, Ashish ashishpr...@gmail.com wrote: Hi, this is Ashish from Delhi works as derivatives trader, passionate about travelling and cooking, finding ways to build my trading model using arbitrage strategies on excel. regards, Ashish On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- 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 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Hey welcome Keep Posting!!! Sent on my BlackBerry® from Vodafone -Original Message- From: Jorge Marques leote.w...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 27 Nov 2012 12:25:10 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Introduce Yourself !! Hi all Excelers, Jorge Marques from Portugal, work in a Logistic Company and Excel is now part of my life, my learning curve in VBA is improving alot since I discovered this group, also use chandoo.org because it has some awesome stuff, regarding formulas and Charts. In my spare time I´m learning SQL and applying the learnings I get from this group. Keep it up On 4 August 2012 16:41, Ashish ashishpr...@gmail.com wrote: Hi, this is Ashish from Delhi works as derivatives trader, passionate about travelling and cooking, finding ways to build my trading model using arbitrage strategies on excel. regards, Ashish On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- 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 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Pasting from Excel to Word - Issue with Column Width(s)
Guys - I'm facing issues with column width when pasting from Excel to Word. Briefly, - I have an Excel file comprising of several worksheets. Each worksheet comprises of several tables (with specific column width and row heights). - Certain cells within these tables are merged while others are single cells (not sure if this is relevant, just preempting a query). - This sheet helps to collect the data in an orderly manner at the specified location (data is entered manually at the specified cells). - After all the data is gathered, I need to transfer (read copy-paste) it to a word document as the submission needs to be in MS Word. - When I do that, I find that column widths for certain cells are not maintained as they are in Excel - I observe both increase and decrease in Column Width sizes. - However, the results are consistent. By that I mean, everytime I run the macro, the same cells/or group of cells are affected. - I have tried using Word Selection.PasteSpecial from within Excel with Link:= true and false both, Placement:=wdInLine DisplayAsIcon:=False, Data:=wdPasteHTML - I have also tried using calling a function in the word document (Word Selection.PasteExcelTable False False False) from within excel, but still having the same issue with the same cells. Is there a solution to ensure that the column widths remain exactly the same when pasting from Excel to Word? Has cell padding got anything to do with it? I noticed that the Excel cells have zero padding, whereas the default indent in MS Word Tables is 0.19cm. Any help or guidance would be appreciated. Regards, Jewel PS: If a similar query has been posted before - kindly direct me to that post. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Macro to copy 6 tabs to new sheet and past as values.
1. I have a number of spreadsheets in one folder. For each spreadsheet, I need to open, then copy all 6 tabs (all have the same name: Option A, Option B, Option C, Francais A, Francais B, Francais C) to a new sheet and name the new sheet with the the same name as the original sheet plus 'copy' in the name. I manually tested an found that I had to 'unprotect' each sheet, then break the links in each sheet but retaining the original data. The original sheet with the option tabs all have formulas. Once I have this macro working, I would like to inlcude it into another macro that updated cells in multiple spreadsheets in a folder. l will then updated it so that I can run it on all sheets in a folder. ie. C:\Excel-Work\. Hope this is clear. thx Mel -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Fwd: Immediate Joinee required for VBA,EXCELand MACROS in Gurgaon Location
-- Forwarded message -- From: ysofia yso...@magna.in Date: Tue, Nov 27, 2012 at 2:41 PM Subject: Immediate Joinee required for VBA,EXCELand MACROS in Gurgaon Location To: daksh1...@gmail.com *Dear Candidate,* This is *Sofia* from *Magna InfoTech*. We have an urgent requirement for* VBA, Macros, and Excel * * * *You* will be a *Permanent Employee* for *Magna InfoTech* will be deployed at *our client, **Gurgaon* * * *Skill: VBA, Macros, and Excel* *Experience: min 2+yrs* *Work Location: **Gurgaon* If you are interested send across your updated CV along with following details: 1. Updated CV: 2. Total Exp: 3. Relevant Exp: 4. Current CTC: 5. Expected CTC: 6. Notice period: 7. DOB: 8. Contact No: 9. Alternative No: 10.Location: ** ** I would appreciate if you could refer few of your friends, who are looking out for a change, Please ignore the mail if you are not interested in this opening. *About Magna Infotech * Magna InfoTech is a premier provider of IT services to clients worldwide. An associate company of asset based $1 billion Nagarjuna group of companies. *Magna Infotech is an ISO 9001:2000 certified company that offers unique solution to build, integrate and* manage IT systems across a broad spectrum of industry by using a combination of on-site, off-shore methodology. *It has offices in USA (Danbury, CT) and India including its own state of the art development center in Hyderabad.* We follow onsite-offshore methodology and provide services to end-clients like Toshiba, Saint Gobain, Pitney Bowels, Lucent Technologies and Wipro Technologies. We are strategically positioned to cater the requirements of various clients in IT domain. We are the primary SSP (Software Service Provider) to our clients like IBM, HP, Accenture, and iFlex, CSC, Patni and Oracle Corp. *More than 4813+ employees are working under the payrolls of Magna Infotech. * *Presently associated with 165 active clients. * For client testimonials please visit www.magna.in *Thanks Regards Sofia Yasmeen |IT staffing| Magna Infotech Pvt Ltd| Tel: (040) 39179113|09346062227 **yso...@magna.in* yso...@magna.in* **www.magna.in*http://www.magna.in/ *|* ** ** -- *Deepak Rai* SAS BASE CERTIFIED Programmer Mobile: 9873415255 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK
Sub emailstest() ' run loop here Call send_emails(Range(a2).Text, Range(b2).Text, Range(c2).Text) End Sub Sub send_emails(nm As String, to1 As String, cc1 As String) Dim olApp As Outlook.Application Dim olMail As MailItem Dim fld As Object, fil As Object Dim attach1 As String Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(C:\Documents and Settings\user\Desktop\test delete\my data\) attach1 = For Each fil In fld.Files If UCase(Left(fil.Name, Application.WorksheetFunction.Find(., fil.Name) - 1)) = UCase(nm) Then attach1 = fil.Path Exit For End If Next fil Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = to1 .Subject = Hello .Body = Please find the attachment .Attachments.Add fil.Path .Send End With Set olMail = Nothing Set olApp = Nothing End Sub On Tue, Nov 27, 2012 at 6:21 PM, Satendra kumar satendrakuma...@gmail.comwrote: Dear Experts, please suggest me how to attach automate match with name column (A) with workbook name. -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
RE: $$Excel-Macros$$ Macro to copy 6 tabs to new sheet and past as values.
You can go here and can modify the code as per your need http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mel Sent: 27 November 2012 7:55 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to copy 6 tabs to new sheet and past as values. 1. I have a number of spreadsheets in one folder. For each spreadsheet, I need to open, then copy all 6 tabs (all have the same name: Option A, Option B, Option C, Francais A, Francais B, Francais C) to a new sheet and name the new sheet with the the same name as the original sheet plus 'copy' in the name. I manually tested an found that I had to 'unprotect' each sheet, then break the links in each sheet but retaining the original data. The original sheet with the option tabs all have formulas. Once I have this macro working, I would like to inlcude it into another macro that updated cells in multiple spreadsheets in a folder. l will then updated it so that I can run it on all sheets in a folder. ie. C:\Excel-Work\. Hope this is clear. thx Mel -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Pasting from Excel to Word - Issue with Column Width(s)
if you rows and columns are fixed why do u create a blank template in word document , merge cells , row ,etc as per your need Then run a loop through all the cells in table to add data in word document Regards Ashish On Tue, Nov 27, 2012 at 6:15 PM, Jewel Sharma jewelsha...@gmail.com wrote: Guys - I'm facing issues with column width when pasting from Excel to Word. Briefly, - I have an Excel file comprising of several worksheets. Each worksheet comprises of several tables (with specific column width and row heights). - Certain cells within these tables are merged while others are single cells (not sure if this is relevant, just preempting a query). - This sheet helps to collect the data in an orderly manner at the specified location (data is entered manually at the specified cells). - After all the data is gathered, I need to transfer (read copy-paste) it to a word document as the submission needs to be in MS Word. - When I do that, I find that column widths for certain cells are not maintained as they are in Excel - I observe both increase and decrease in Column Width sizes. - However, the results are consistent. By that I mean, everytime I run the macro, the same cells/or group of cells are affected. - I have tried using Word Selection.PasteSpecial from within Excel with Link:= true and false both, Placement:=wdInLine DisplayAsIcon:=False, Data:=wdPasteHTML - I have also tried using calling a function in the word document (Word Selection.PasteExcelTable False False False) from within excel, but still having the same issue with the same cells. Is there a solution to ensure that the column widths remain exactly the same when pasting from Excel to Word? Has cell padding got anything to do with it? I noticed that the Excel cells have zero padding, whereas the default indent in MS Word Tables is 0.19cm. Any help or guidance would be appreciated. Regards, Jewel PS: If a similar query has been posted before - kindly direct me to that post. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Macro to copy 6 tabs to new sheet and past as values.
can u share the sample workbook On Tue, Nov 27, 2012 at 8:01 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *You can go here and can modify the code as per your need * * * *http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/* * * * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mel *Sent:* 27 November 2012 7:55 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Macro to copy 6 tabs to new sheet and past as values. ** ** 1. I have a number of spreadsheets in one folder. For each spreadsheet, I need to open, then copy all 6 tabs (all have the same name: Option A, Option B, Option C, Francais A, Francais B, Francais C) to a new sheet and name the new sheet with the the same name as the original sheet plus 'copy' in the name. I manually tested an found that I had to 'unprotect' each sheet, then break the links in each sheet but retaining the original data. The original sheet with the option tabs all have formulas. Once I have this macro working, I would like to inlcude it into another macro that updated cells in multiple spreadsheets in a folder. l will then updated it so that I can run it on all sheets in a folder. ie. C:\Excel-Work\. Hope this is clear. thx Mel -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Request Macro for Merge Text file
Hi Pascal, I am not get correct solution from this coding Please help !!! On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 bpascal...@gmail.com wrote: Another shorter programming solution would have been to autofilter column B and copy visible cells into a table and do the same thing and let CopyDataToTxtFile do the same thing. am I wrong? -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Request Macro for Merge Text file
share some sample text files On Tue, Nov 27, 2012 at 8:21 PM, Ganesh ganesh.inscr...@gmail.com wrote: Hi Pascal, I am not get correct solution from this coding Please help !!! On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 bpascal...@gmail.com wrote: Another shorter programming solution would have been to autofilter column B and copy visible cells into a table and do the same thing and let CopyDataToTxtFile do the same thing. am I wrong? -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Fwd: $$Excel-Macros$$ Re: Request Macro for Merge Text file
Hi Ashish, Please find attached text files and excel sheet for your reference. Please let me know if you have any clarifications. Regards, Ganesh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. TEXT FILE MERGER.rar Description: application/rar
Re: $$Excel-Macros$$ Modify Code to to send range
Sub emailstest() ' run loop here Dim bdy As String Dim bdyrng As Range Dim cl As Range Set bdyrng = Sheets(1).Range(g2:g50) For Each cl In bdyrng bdy = bdy vbNewLine cl.Text Next ' run loop here Call send_emails(Range(b2).Text, Range(c2).Text, bdy) End Sub Sub send_emails(to1 As String, fld1 As String, body1 As String) Dim olApp As Outlook.Application Dim olMail As MailItem Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = to1 .Subject = Hello .Body = body1 .Attachments.Add fld1 .Send End With Set olMail = Nothing Set olApp = Nothing End Sub On Mon, Nov 26, 2012 at 5:09 PM, Hilary Lomotey resp...@gmail.com wrote: Hello Excel Gurus, in the attached file i have a vba code that sends email with attachments, what i need is a little code addition to the code to include adding any comments in the range eg G2:G30 to the code, so that anytime i include something in that range, it will be part of the email , thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Small Date Query
Pls help me solve my query. I have mentioned my query in the file attached. Thanks Regards, Kenil Gala -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. doubt.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Small Date Query
Here's what I came up with: Weekly From =$A5+1-WEEKDAY($A5,2) TO =$A5+7-WEEKDAY($A5,2) Monthly From =DATEVALUE(MONTH($A5)-1-YEAR($A5)) TO =EOMONTH($A5,0) Quatrly From =DATEVALUE(ROUNDUP(MONTH($A5)/3,0)+2*(ROUNDUP(MONTH($A5)/3,0)-1)-1-YEAR($A5)) TO =EOMONTH(I5,2) Half Yearly From =DATEVALUE((ROUNDUP(MONTH($A5)/6,0)-1)*5+1-1-YEAR($A5)) TO =EOMONTH(L5,5) Yearly From =DATEVALUE(1-1-YEAR($A5)) TO =EOMONTH(O5,11) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Kenil Gala keni...@yahoo.com To: excel macros excel-macros@googlegroups.com Sent: Tue, November 27, 2012 12:44:55 PM Subject: $$Excel-Macros$$ Small Date Query Pls help me solve my query. I have mentioned my query in the file attached. Thanks Regards, Kenil Gala -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Small Date Query
check the attachment see if it helps On Tue, Nov 27, 2012 at 11:14 PM, Kenil Gala keni...@yahoo.com wrote: Pls help me solve my query. I have mentioned my query in the file attached. Thanks Regards, Kenil Gala -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. doubt (1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ sequence issue
I do not understand your problem. You SAID: I have table that give me sequence as I want.. Everything is fine till I bring numbr forward, like 10. When I push something backwords is not working, like 9. What do you mean bring number forward and push something backwards. I was able to sort your table and it sorted correctly, What is it you're trying to do EXACTLY? (step by step) and what do you want to have happen? 0 sup qty 1 2 3 10 10 4 5 6 7 8 9 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 9 9 30 Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tue, November 27, 2012 10:54:31 AM Subject: $$Excel-Macros$$ sequence issue Hi All, I have issue with putting numbers into sequence. Please see inside and advice. Regards, Pawel-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Request Macro for Merge Text file
Hi Ganesh I have currently too little time until end of week to look at your query. Just check that everything is on C: path drive and that a folder merge exist on the same location. Else, I'll have to look closer. Regards Pascal -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!!
Hi, If year,month,days are in A1,A2,A3 respectively then put the date on which you want to calculate in A4, enter the formula in A5(the joining date,if it is one complete spell, =Date(Year(A4)-(A1),Month(A4)-(A2),Days(A4)-(A3)) R.Karunanithi From: MRafique Ujjan imrafiqu...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, November 26, 2012 4:48 PM Subject: $$Excel-Macros$$ How to calculate Joining Date from a given job period!!! Dear All Excel Experts: I am having a following problem. I am given only total working days of an employee like 2 years 5 months 13 days Now i am asked to calculate joining date of each employee. Therefore, i need your help in this regard I hope u will help me as this group helped me earlier. For any clarification please feel free to ask me. Thanks in advance Muhammad Rafique Ujjan -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Small Date Query
Thank you sir! it worked amazing --- On Wed, 11/28/12, ashish koul koul.ash...@gmail.com wrote: From: ashish koul koul.ash...@gmail.com Subject: Re: $$Excel-Macros$$ Small Date Query To: excel-macros@googlegroups.com Date: Wednesday, November 28, 2012, 12:30 AM check the attachment see if it helps On Tue, Nov 27, 2012 at 11:14 PM, Kenil Gala keni...@yahoo.com wrote: Pls help me solve my query. I have mentioned my query in the file attached. Thanks Regards, Kenil Gala -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ LIST CHECK AND ADD ROWS
Hi Experts I have created a list in Name Manager named TTlist for values shown in LIST sheet of attached file. I used to update this TTlist with some other macro. I have another sheet named TT in which 1st 5 rows are constant. I sued to fill-in data from 6th row on-wards. I need a macro which will help me doing following. 1. Macro will check in sheet TT column A (A6 onwards) with TTlist for values. 2. If a value exists in column A, it ignores and go to next cell. 3. If a value doesn't exist in column A, then it copies Row 1 and paste it at the end (say at row 8 in attached file), then it fill-in the value in cell A8, and search for next value. To summarise, i need solution as shown in sheet SOLUTION_REQD. Pls help me here. Regards Amit -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. LIST CHECK ADD ROWS.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet