Re: $$Excel-Macros$$ csv macro to convert to .txt

2010-10-26 Thread CAN
Anyone has a different take on my problem. I would like to get a .txt file output to a file location rather than a conversion within the sheet so I don't have to copy and paste. Pleas!! Any help is greatly appreciated On Oct 22, 1:54 pm, Cesar Delanoval wrote: > Thank you for the re

Re: $$Excel-Macros$$ csv macro to convert to .txt

2010-10-22 Thread Cesar Delanoval
Thank you for the reply. While this works fine, it find it that it requires a lot of copy and paste back and forth. I was looking for an answer that would be more like creating a file in .txt format. Some time ago I had a similar problem and the solution involve this code: Filename = InputBox("

Re: $$Excel-Macros$$ csv macro to convert to .txt

2010-10-22 Thread Srinivasan Ethirajalu
Enjoy On Fri, Oct 22, 2010 at 6:26 PM, Gmail wrote: > Yes the format for the date is yymmdd > I am working with excel 97 > > Sent from my Blackjack via AT&T > > On Oct 21, 2010, at 10:35 PM, Srinivasan Ethirajalu < > srinivasan.ethiraj...@gmail.com> wrote: > > 1) > > PropertyID Account#

Re: $$Excel-Macros$$ csv macro to convert to .txt

2010-10-22 Thread Gmail
Yes the format for the date is yymmdd I am working with excel 97 Sent from my Blackjack via AT&T On Oct 21, 2010, at 10:35 PM, Srinivasan Ethirajalu wrote: > 1) > > PropertyID Account#Date Time Net Funded > 1212178 2 10/10/2010 11:02481 > 1212178

Re: $$Excel-Macros$$ csv macro to convert to .txt

2010-10-22 Thread roberto mensa
if you want to work with csv files closed, please open the csv file with Notepad, copy and paste the contents here. regards r 2010/10/21 CAN > I have a .CSV file see sample below which I need macro to convert > to .txt file in an specific format. > > Orginal file will be like this. > > Propert

Re: $$Excel-Macros$$ csv macro to convert to .txt

2010-10-21 Thread Srinivasan Ethirajalu
1) PropertyID Account#Date Time Net Funded 1212178 2 *10/10/2010* 11:02481 1212178 2*101020*echeck00048100 Do you want current date in YYMMDD format 2) Will platform are you working? On Fri, Oct 22, 2010 at 2:28 AM, CAN wrote: > I have