SV: $$Excel-Macros$$ Range reference with Cells not working

2013-06-11 Thread Rolf Edberg
YES It worked!! Thank you! Från: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] För Abhishek Jain Skickat: Tuesday, June 11, 2013 6:43 AM Till: excel-macros@googlegroups.com Ämne: Re: $$Excel-Macros$$ Range reference with Cells not working See if this works:

Re: $$Excel-Macros$$ Require code Double Click To Copy Data To Another Worksheet

2013-06-11 Thread Divaker Pandey
means you want to create new one worksheet or copy data on existing sheet. how ever according your question please use following code in thisworkbook module Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

Re: $$Excel-Macros$$ Re: VBA basic information

2013-06-11 Thread Divaker Pandey
Hi Vab, a lot of thanks to share the topics to cover for a vba developer. this group is famous, bcz it have member like you. please continue keep excelling. It will be better if you share some information for error handling technique in VBA. Divaker On Sun, Jun 9, 2013 at 12:19 PM, Vabz

$$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread Amit Desai (MERU)
Hello Friends, Does anyone have training material on SQL? Could you please share. In case if anyone knows about any good site for the same please share link. Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information

Re: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread కిరణ్ కొత్తకోట
http://www.w3schools.com/sql/default.asp is the best of my knowledge. On Tue, Jun 11, 2013 at 3:55 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Hello Friends, ** ** Does anyone have training material on SQL? Could you please share. ** ** In case if anyone knows about

Re: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread Amresh Maurya
http://www.w3schools.com/ On Tue, Jun 11, 2013 at 4:03 PM, కిరణ్ కొత్తకోట kothakota.ki...@gmail.comwrote: http://www.w3schools.com/sql/default.asp is the best of my knowledge. On Tue, Jun 11, 2013 at 3:55 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Hello Friends, ** **

RE: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread Amit Desai (MERU)
Thanks a lot. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ? Sent: 11 June 2013 16:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Tutorial on SQL http://www.w3schools.com/sql/default.asp is the best of my knowledge. On

Re: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread Gaurav Garg
Hello Friends, ** ** Does anyone have training material on VBA? Could you please share. ** ** In case if anyone knows about any good site for the same please share link.* *** ** ** Best Regards, GAURAV GARG ** On Tue, Jun 11, 2013 at 4:03 PM, కిరణ్ కొత్తకోట

$$Excel-Macros$$ Re: List in Userform

2013-06-11 Thread Lalit Mohan Pandey
Why don't you use listview form control. On Friday, 7 June 2013 18:38:48 UTC+5:30, Chandru wrote: Hi, How to get List as attached in the userform Regards, Chandra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

Re: $$Excel-Macros$$ Difference between dates

2013-06-11 Thread Chandra Shekar
Hi, Thank you its working fine now :) Regards, Chandra On Mon, Jun 10, 2013 at 10:47 PM, Ms Excel user msexcelu...@gmail.comwrote: Hi Chandra Shekar, find the attachment. On Mon, Jun 10, 2013 at 4:21 PM, Chandra Shekar chandrashekarb@gmail.com

Re: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread xlstime
try below link http://www.excel-pratique.com/en/vba.php . Enjoy Team XLS On Tue, Jun 11, 2013 at 4:26 PM, Gaurav Garg gaurav7...@gmail.com wrote: Hello Friends, ** ** Does anyone have training material on VBA? Could you please share. ** ** In case if

Re: $$Excel-Macros$$ Re: VBA basic information

2013-06-11 Thread Aditya Tyagi
Hi Divaker, Here you can get some examples of error handling: http://www.excelfox.com/forum/f23/difference-between-on-error-goto-0-and-on-error-goto-1-a-894/ and for some debugging techniques: http://usefulgyaan.wordpress.com/2013/05/23/debugging-techniques-in-vba/ On Tue, Jun 11, 2013 at

Re: $$Excel-Macros$$ Macro to Mail Merge from Excel Sheet

2013-06-11 Thread VBA VABZ
Hi, Why you need output in word? On Tue, Jun 11, 2013 at 7:09 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Expert, I need a help in creating a macro which will pick data from excel sheet to mail merge to a predefined Word template.Attached is a sample word Excel Format. Request

Re: $$Excel-Macros$$ Macro to Mail Merge from Excel Sheet

2013-06-11 Thread VBA VABZ
This can be done using Mail Merge in word only. Refer link here: http://www.timeatlas.com/5_minute_tips/chunkers/mail_merge_tutorial_using_microsoft_word_and_excel#.Ubcqfvn7AqI Thanks On Tue, Jun 11, 2013 at 7:15 PM, VBA VABZ v...@vabs.in wrote: Hi, Why you need output in word? On Tue,

Re: $$Excel-Macros$$ Macro to Mail Merge from Excel Sheet

2013-06-11 Thread Atul Kesaria
Hello Expert, Couple of reason for having a macro1) Data runs into more then 1000 rows 2) There are two many Format to which mail merge would be required. On Tue, Jun 11, 2013 at 7:18 PM, VBA VABZ v...@vabs.in wrote: This can be done using Mail Merge in word only. Refer link here:

$$Excel-Macros$$ want to do MCA through distance education

2013-06-11 Thread arvind ks
Hi Everybody, I want to do MCA through DISTANCE learning. Can you suggest me some good universities where i can enroll and after completing this i must get into a good organisation. I have got 5 years of experience. Regards Arvind K -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread ravinder negi
here u go dear http://www.w3schools.com/SQl/default.asp --- On Tue, 6/11/13, Amit Desai (MERU) amit.de...@merucabs.com wrote: From: Amit Desai (MERU) amit.de...@merucabs.com Subject: $$Excel-Macros$$ Tutorial on SQL To: excel-macros@googlegroups.com Date: Tuesday, June 11, 2013, 3:55 PM

$$Excel-Macros$$ Excel Training Material (PPT)

2013-06-11 Thread Prabhakar S H
Dear Team, MY HR given me responsibility to give training on Excel to my Marketing team. So can you send me the materilals on Basic advance traning. I have engough experience on Excel but don't know where to start. So please send me either PPT or material on Basic as well as advance

Re: $$Excel-Macros$$ Excel Training Material (PPT)

2013-06-11 Thread VBA VABZ
Hi Try this, hope it will help: https://docs.google.com/open?id=0B7i2wkMBVw9xQV9tb3hhZVdXWFE Thanks On Wed, Jun 12, 2013 at 9:25 AM, Prabhakar S H prabakar.k...@gmail.comwrote: Dear Team, MY HR given me responsibility to give training on Excel to my Marketing team. So can you send me the

RE: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread Amit Desai (MERU)
Dear Vijay, This is a Great Help Thanks alot... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of P.VIJAYKUMAR Sent: 12 June 2013 10:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Tutorial on SQL Respected Amit, You can check the

Re: $$Excel-Macros$$ Re: List in Userform

2013-06-11 Thread P.VIJAYKUMAR
Respected Chandrashekar, View the following link.Hope it helps you to create a List User form Control. http://mindkid.blogspot.in/2011/10/adding-listview-additional-activex.html Regards, VIJAYKUMAR On Tue, Jun 11, 2013 at 4:30 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Why