$$Excel-Macros$$ Re: Excel

If you know which cells to copy, use this: Sheets("Sheet1").Select Range("A2:B20").Select Selection.Copy Sheets("Sheet2").Select Range("A2").Select ActiveSheet.Paste On Tuesday, March 25, 2014 8:55:17 PM UTC+5:30, Kene wrote: > > I have a database and want to populate data int

Re: $$Excel-Macros$$ Extract only text from alphanumeric string

SImple and good suggestion. On Thursday, March 27, 2014 11:30:27 PM UTC+5:30, Rupesh Patil wrote: > > PFA, > > > > > On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow > > > wrote: > >> Hi Team, >> >> I need to extract only the text from the alphanumeric string, can you >> please help me with

$$Excel-Macros$$ Re: Issue with Range and If statment

Error is shown because you cannot use the value of a range in IF statement. You can only use the value of each cell in that range. -- 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 Facebook page of this forum @ https://www.facebook

Re: $$Excel-Macros$$ Help Needed

This is very useful. > http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.html > Thanks for this Link. -- 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 Facebook page of this f

Re: $$Excel-Macros$$ Re: copy file via vba

Welcome. Glad you got your problem solved in this forum. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poo

$$Excel-Macros$$ Re: copy file via vba

Try this : [code] Private Sub cmdCopyTextFileToAnotherTextFile_Click() FileCopy "D:\data\sample1.txt", "D:\data\sample2.txt" End Sub [/code] -- 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 Facebook page of this forum @ https://ww

$$Excel-Macros$$ Re: help!!! creation code from data in cells

In an excel file, Change Sheet1 Name as Report and type these: Sr. Center Name Course Date of Enrol Code 1 Alma Computer Training Institute Suraj basic computer Course 31/12/13 2 Center3 Name1 Course 5 1/1/2014 3 Center5 Name2 Course 3 1/4/2014 4 Center2 Name3 Course 4 1/6/2014 5 Center4 Name4

$$Excel-Macros$$ Re: Please provide the code for data entry as mentioned in excel

Monday, 16 December 2013 20:30:22 UTC+5:30, renuka chari wrote: >> >> Thank you sir, >> i will check this once and tell you >> >> thanks once again >> >> >> On Thursday, 12 December 2013 22:24:33 UTC+5:30, pmyk wrote: >>> >

$$Excel-Macros$$ Re: Please Help

Try this: [code] Private Sub CommandButton1_Click() Dim FilePath As String FilePath = "D:\VBTrials\VBToThisText.txt" 'If it is there it will be opened 'if it is not there it will be created Open FilePath For Output As #1 'Overwrite in text file 'Open FilePath For Append As #1 'append will add