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
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("
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#
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
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
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