Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-13 Thread Paul Schreiner
What I would do is use the split() function to split the value into an array. Then, loop through the array to write the values. You'd need one loop to process each of the values in the column. Split the value Loop through the array to write the values Is this direction sufficient, or do you need

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-13 Thread jmothilal
using macro and using find "," commands Thanks On Mon, May 13, 2013 at 8:43 PM, Paul Schreiner wrote: > Are you wanting to do it with a macro? or simply within Excel? > > If you want to do it one time, with Excel, > it's simply a matter of selecting the column, and use Data->Text to Columns > >

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-13 Thread Paul Schreiner
Are you wanting to do it with a macro? or simply within Excel? If you want to do it one time, with Excel, it's simply a matter of selecting the column, and use Data->Text to Columns   Paul - “Do all the good you can, By all the means you can, In all the ways

$$Excel-Macros$$ split address one bye one based on "," comma

2013-05-13 Thread jmothilal
Dear any one i want split address column wise based on comma file attached Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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 officia

Re: $$Excel-Macros$$ Split data in financial yearly wise

2013-05-13 Thread अनिल नारायण गवली
Dear Chaya, whr is the difference pls mention.. I'm not getting any difference. Run the macro . Warm Regards, Gawli Anil On Mon, May 13, 2013 at 3:54 PM, Chaya wrote: > Dear Anil sir, > > Thank you very much for the same and your time spare in this. > > The Datas are not splitting in the

Re: $$Excel-Macros$$ Split data in financial yearly wise

2013-05-13 Thread Chaya
Dear Anil sir, Thank you very much for the same and your time spare in this. The Datas are not splitting in the solction provided to me. Please check. Thanks again to all Regards, Chaya The excel learner :-) On Mon, May 13, 2013 at 3:54 PM, Chaya wrote: > Dear Anil sir, > > Thank y

$$Excel-Macros$$ hello

2013-05-13 Thread tanbhden
5q http://67.199.84.170/confidentially.htm?yhiqig=49301205&jnizjv=19552 -- 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 th

$$Excel-Macros$$ multiple user register - macro

2013-05-13 Thread Avinash
Dear Experts, i need a macro which will copy user details and paste those details on a web page to register that user for account opening. please find attached excel sheet for your reference and login page snapshot is also attached in that sheet i need to do this activity for 1500 users pleas

Re: $$Excel-Macros$$ MS Access query last modified name

2013-05-13 Thread अनिल नारायण गवली
Dear Kaushal, use this. SELECT [name] ,create_date ,modify_date FROM sys.tables Warm Regards, Gawli Anil On Mon, May 13, 2013 at 12:36 PM, Kaushal Kumar wrote: > Dear All, > > I understand its an excel forum. But just wondering if anybody has got any > idea to ide

$$Excel-Macros$$ MS Access query last modified name

2013-05-13 Thread Kaushal Kumar
Dear All, I understand its an excel forum. But just wondering if anybody has got any idea to identify the last modified by user name for MS Access queries. Need to identify the user who has made changes in a query of MS Access 2003. Appreciate your help regarding this and apologies for asking