$$Excel-Macros$$ Generate random numbers based on number given in a cell
Hi Experts, Need a formula or a code for the sample sheet Attached, this is about the generating a random based numbers given in spread sheet Thanks Prasad -- -- 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 Test.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ How to change Date format in to number
Hi Friends, I have change my cell which in the date format ex.MMDD or DDMM to original number i.e smiler to type date.I have attached the sheet in which Column A shows date format and Column B is what i need to convert A in to B as a number. Plz help. Regards Prabhu -- -- 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 Book1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: How to remove space in excel cell
Hi Friends, I have attached a sheet, which contains space in prefix and suffix. But below formula is not working. Kind do the needful. -- -- 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 Book1.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ MAC Address
HI What are the changes required to get the result in a cell instead of msg box. Regards Rajesh kainikkara On 5/28/11, GoldenLance samde...@gmail.com wrote: This is because MAC addresses are attached physically to the network adapter hardware and not to the base computer itself. Computers with multiple network adapters installed (sometimes called multihomed systems) therefore possess multiple unique MAC addresses. On May 28, 7:47 pm, Mahesh parab mahes...@gmail.com wrote: Hi Rajesh dont know about this in details, other way you can enter ipconfig/all in cmd prompt and find Physical address i.e MAC address check info on below linkhttp://ecs.rutgers.edu/physicaladdr.php3 Thanks Mahesh On Sat, May 28, 2011 at 7:16 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Thanks for the reply. It shows two different results eg 00.1C:10:F2:FO:C6 then 00:10:IF:08:15 what does it mean will u explain it a little bit more. Reagards Thanks Rajesh kainikkara On 5/27/11, Mahesh parab mahes...@gmail.com wrote: Hi Rajesh Try: Sub test() Dim strComputer As String Dim objWMIService As Object Dim colAdapters As Object Dim objAdapter As Object strComputer = . Set objWMIService = GetObject _ (winmgmts: !\\ strComputer \root\cimv2) Set colAdapters = objWMIService.ExecQuery _ (Select * from Win32_NetworkAdapterConfiguration Where IPEnabled = True) For Each objAdapter In colAdapters MsgBox Physical address: objAdapter.MACAddress Next objAdapter End Sub On Fri, May 27, 2011 at 8:37 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts Is there any code to get MAC address of the computer. Regards Rajesh kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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 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 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 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 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
Re: $$Excel-Macros$$ rank column
Dear Dew, Rank is already starting from 1. Please check and revert with some more details. Thanks. Best Regards, DILIPandey On 5/20/11, dewbro2 kdew...@brownmre.com wrote: How can I make this rank start with 1 instead of zero. On Jul 7 2010, 2:41 am, Dilip Pandey dilipan...@gmail.com wrote: HI Subbu, I hope you have found the solution for this query. Recently I came across a similar kind of query and after solving that I have customized the solution to solve your query. Please find the attached solution and let me know if this helps. Thanks. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Wed, May 19, 2010 at 5:01 PM, subs subbu1...@gmail.com wrote: ocity ostate carrier price a b X1200 a b Y 1290 c d X1300 c d Z 1500 e f R 129 i want to add another column to the above spreadsheet called as rank which basically ranks every lane(ocity and dcity) based on price(in the ascending order). for example the output should be as follows ocity ostate carrier price rank a b X1200 1 a b Y 12902 c d X13001 c d Z 1500 2 e f R 1291 what is the formula to create the column rank in exel . help is appreciated -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 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 Rank or Sort by DiLipandey.xls 27KViewDownload- Hide quoted text - - Show quoted text - -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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$$ Re: Generate random numbers based on number given in a cell
=RANDBETWEEN(X,Y) Where X is a number greater than Y Example, =RANDBETWEEN(1,500) will give random numbers ranging from 1 and 500 On May 29, 7:29 am, Suryaprasad suryaprasad...@gmail.com wrote: Hi Experts, Need a formula or a code for the sample sheet Attached, this is about the generating a random based numbers given in spread sheet Thanks Prasad Test.xlsx 18KViewDownload -- -- 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$$ Re: How to change Date format in to number
=VALUE(TEXT(A2,MMDD)) On May 29, 9:05 am, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have change my cell which in the date format ex.MMDD or DDMM to original number i.e smiler to type date.I have attached the sheet in which Column A shows date format and Column B is what i need to convert A in to B as a number. Plz help. Regards Prabhu Book1.xls 35KViewDownload -- -- 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
Re: $$Excel-Macros$$ Re: How to remove space in excel cell
Hi Prabhu Try '=TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))) http://office.microsoft.com/en-us/excel-help/remove-spaces-from-the-beginning-and-end-of-a-cell-HP003056131.aspx Thanks Mahesh On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have attached a sheet, which contains space in prefix and suffix. But below formula is not working. Kind do the needful. -- -- 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
Re: $$Excel-Macros$$ How to change Date format in to number
Hi Try Sub Format() Dim LR, i As Long LR = Range(A Rows.Count).End(xlUp).Row For i = LR To 2 Step -1 Range(A i).Offset(0, 1).Value = Range(A i).Value Range(A i).NumberFormat = mmdd Range(A i).Offset(0, 1).NumberFormat = mmdd Next i End Sub Thanks Mahesh On Sun, May 29, 2011 at 9:35 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have change my cell which in the date format ex.MMDD or DDMM to original number i.e smiler to type date.I have attached the sheet in which Column A shows date format and Column B is what i need to convert A in to B as a number. Plz help. Regards Prabhu -- -- 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
Re: $$Excel-Macros$$ Re: How to remove space in excel cell
HI Prabhu, You can use the trim command... and another solution is that u can use 'Text to columns' action under 'Data' menu and then take fixed width... On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have attached a sheet, which contains space in prefix and suffix. But below formula is not working. Kind do the needful. -- -- 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
Re: $$Excel-Macros$$ Re: How to remove space in excel cell
Hi Prabhu, Try the below formula in cell B2. =TRIM(SUBSTITUTE(A2,CHAR(160),)) At the same time the same is provided in the attached excel for better understanding. Hope that helps! --- *Sixthsense **:) Man of Extreme Innovative Thoughts :) * On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have attached a sheet, which contains space in prefix and suffix. But below formula is not working. Kind do the needful. -- -- 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 Solution File.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ How to change Date format in to number
Hi Prabhu, just convert those dates into below format using below formula. lets say in col A17 thr is date thn in col B17 type this formula. =TEXT(A17,mmdd) A B 5/29/2011 20110529 From: Prabhu prabhugate...@gmail.com To: excel-macros@googlegroups.com Sent: Sun, 29 May, 2011 9:35:23 AM Subject: $$Excel-Macros$$ How to change Date format in to number Hi Friends, I have change my cell which in the date format ex.MMDD or DDMM to original number i.e smiler to type date.I have attached the sheet in which Column A shows date format and Column B is what i need to convert A in to B as a number. Plz help. Regards Prabhu -- -- 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
Re: $$Excel-Macros$$ How to change Date format in to number
Hi Prabhu, Try the below formula in cell B2. =IF(AND(ISNUMBER(A2),LEN(A2)=5),--TEXT(A2,MMDD),) Drag the B2 cell formula to the remaining cells of B Column based on the Column-A data. At the same time the same is provided in the attached excel for better understanding. Hope that helps! --- *Sixthsense **:) Man of Extreme Innovative Thoughts :) * On Sun, May 29, 2011 at 9:35 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have change my cell which in the date format ex.MMDD or DDMM to original number i.e smiler to type date.I have attached the sheet in which Column A shows date format and Column B is what i need to convert A in to B as a number. Plz help. Regards Prabhu -- -- 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 Solution File.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: How to remove space in excel cell
Hi Prabhu, see if the enclosed file helps Regards Umesh On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have attached a sheet, which contains space in prefix and suffix. But below formula is not working. Kind do the needful. -- -- 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 Space removed.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Urgent:: Is there a way out to increase the cell character limit to beyond 255.
Hi , Thanks for the response. This did solve part of my problem.However when I split the cell containing more than 255 characters using text to columns options. I see only the first 255 characters getting split, others are just ignored. Let me know how I can get away with this issue. Other members can also share your views. Rgds, Bharghav On Fri, May 27, 2011 at 12:08 PM, Sixthsense sixthsense...@gmail.comwrote: Hi Bharghav, This problem will occur when you perform the sheet *Move or Copy *option. My suggestion is just press Cntrl+A twice, which will select all data in your active worksheet and press Cntrl+C (to copy) and in New Worksheet Press Cntrl+A and Press Cntrl+V (to paste). In this case the data which is there in the the cells more than 255 characters won\t get affected. Hope that helps!!! --- *Sixthsense **:) Man of Extreme Innovative Thoughts :) * On Fri, May 27, 2011 at 9:50 AM, Bharghav Ramdas bhargha...@gmail.comwrote: Hi All, Looking forward to your reponses. Rgds, Bharghav Ramdas On Tue, May 24, 2011 at 9:57 AM, Bharghav Ramdas bhargha...@gmail.comwrote: Hi All, I am currently working on an excel (2003)sheet whose cell character length is beyond 255. I am able to copy just 255 characters. The remaining characters get truncated.Your help in this regard will be very much appreciated. Example cell character length =300. While pasting or doing any cell operations, I see only the first 255 characters considered. Rgds, Bharghav R -- -- 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$$ Moving files from folder to folder
Hi Using VBA in Excel 2003 is it possible to select a pdf file in a folder and move it to another folder. If not, how can I automate this procedure. Thanks Paul -- -- 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
Re: $$Excel-Macros$$ MAC Address
Hi try: For Each objAdapter In colAdapters Cells(1, 1) = Physical address: objAdapter.MACAddress Next objAdapter End Sub On Sun, May 29, 2011 at 4:46 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: HI What are the changes required to get the result in a cell instead of msg box. Regards Rajesh kainikkara On 5/28/11, GoldenLance samde...@gmail.com wrote: This is because MAC addresses are attached physically to the network adapter hardware and not to the base computer itself. Computers with multiple network adapters installed (sometimes called multihomed systems) therefore possess multiple unique MAC addresses. On May 28, 7:47 pm, Mahesh parab mahes...@gmail.com wrote: Hi Rajesh dont know about this in details, other way you can enter ipconfig/all in cmd prompt and find Physical address i.e MAC address check info on below linkhttp://ecs.rutgers.edu/physicaladdr.php3 Thanks Mahesh On Sat, May 28, 2011 at 7:16 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Thanks for the reply. It shows two different results eg 00.1C:10:F2:FO:C6 then 00:10:IF:08:15 what does it mean will u explain it a little bit more. Reagards Thanks Rajesh kainikkara On 5/27/11, Mahesh parab mahes...@gmail.com wrote: Hi Rajesh Try: Sub test() Dim strComputer As String Dim objWMIService As Object Dim colAdapters As Object Dim objAdapter As Object strComputer = . Set objWMIService = GetObject _ (winmgmts: !\\ strComputer \root\cimv2) Set colAdapters = objWMIService.ExecQuery _ (Select * from Win32_NetworkAdapterConfiguration Where IPEnabled = True) For Each objAdapter In colAdapters MsgBox Physical address: objAdapter.MACAddress Next objAdapter End Sub On Fri, May 27, 2011 at 8:37 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts Is there any code to get MAC address of the computer. Regards Rajesh kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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 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 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 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 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
Re: $$Excel-Macros$$ How to change Date format in to number
Hi, what is the significance of -- just before TEXT in the below formula. this formula works same even without --. From: Sixthsense sixthsense...@gmail.com To: excel-macros@googlegroups.com Sent: Sun, 29 May, 2011 3:55:33 PM Subject: Re: $$Excel-Macros$$ How to change Date format in to number Hi Prabhu, Try the below formula in cell B2. =IF(AND(ISNUMBER(A2),LEN(A2)=5),--TEXT(A2,MMDD),) Drag the B2 cell formula to the remaining cells of B Column based on the Column-A data. At the same time the same is provided in the attached excel for better understanding. Hope that helps! --- Sixthsense :) Man of Extreme Innovative Thoughts :) On Sun, May 29, 2011 at 9:35 AM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I have change my cell which in the date format ex.MMDD or DDMM to original number i.e smiler to type date.I have attached the sheet in which Column A shows date format and Column B is what i need to convert A in to B as a number. Plz help. Regards Prabhu -- -- 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
Re: $$Excel-Macros$$ Generate random numbers based on number given in a cell
can u pls give some light on this coding. i tried to debug but it jus have sendkey F9. so if i manually press F9 key in other workbook nothing happens there. can u explain the logic of this macro. From: ChilExcel chilexcel...@gmail.com To: excel-macros@googlegroups.com Sent: Sun, 29 May, 2011 8:42:50 PM Subject: Re: $$Excel-Macros$$ Generate random numbers based on number given in a cell Please see attached file Chilexcel 2011/5/28 Suryaprasad suryaprasad...@gmail.com Hi Experts, Need a formula or a code for the sample sheet Attached, this is about the generating a random based numbers given in spread sheet Thanks Prasad-- -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- 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
RE: $$Excel-Macros$$ Moving files from folder to folder
ThnxRgrdp SUNIL B.N -Original Message- From: PAB Sent: 29/05/2011 9:36:40 pm Subject: $$Excel-Macros$$ Moving files from folder to folder Hi Using VBA in Excel 2003 is it possible to select a pdf file in a folder and move it to another folder. If not, how can I automate this procedure. Thanks Paul -- -- 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
Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 14 Messages in 5 Topics
hai...viewer. your asking the prombem? how to change landscape to portrait data ans: just copy all the cells : Go to paste special - transpose -- -- 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
Re: $$Excel-Macros$$ Moving files from folder to folder
Sub Copy_One_File_Only() FileCopy D:\Bla_Bla_Bla\SOS\SourceFolder\FileName.pdf, E:\WOW\AngelinaJoly\DestinFolde\FileName.pdf End Sub On Sun, May 29, 2011 at 11:06 PM, PAB pab1...@gmail.com wrote: Hi Using VBA in Excel 2003 is it possible to select a pdf file in a folder and move it to another folder. If not, how can I automate this procedure. Thanks Paul -- -- 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