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(" Enter Text File Name ", "Text File")
FilePath = "c:\download\" & Filename & ".txt"
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile(FilePath, True)
Can you re-do the sheet based on something similar ?
On Fri, Oct 22, 2010 at 9:44 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Enjoy
>
>
>
> On Fri, Oct 22, 2010 at 6:26 PM, Gmail <cdelano...@gmail.com> 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# Date Time Net Funded
>> 1212178 2 *10/10/2010* 11:02 481
>> 1212178 0000000000002*101020*echeck 00048100
>> Do you want current date in YYMMDD format
>>
>> 2)
>>
>> Will platform are you working?
>>
>>
>>
>>
>>
>> On Fri, Oct 22, 2010 at 2:28 AM, CAN < <cdelano...@gmail.com>
>> cdelano...@gmail.com> wrote:
>>
>>> 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.
>>>
>>> PropertyID Account# Date Time Net Funded
>>> 1212178 2 10/10/2010 11:02 481
>>> 1212CAS 311 10/10/2010 20:23 75
>>> 1212CAS 312 10/10/2010 8:30 158.43
>>> 1212CCP 5951B4 10/10/2010 7:51 209.94
>>> 1212CCP 5951B4 10/10/2010 8:30 43.7
>>> 1212CWG 401 10/10/2010 20:45 748.72
>>> 1212EWP 1152535L 10/10/2010 12:16 67.22
>>> 1212EWP 1331716C 10/10/2010 16:48 67.22
>>> 1212EWP 1332412C 10/10/2010 9:48 69
>>> 1212EWP 1332812C 10/10/2010 11:08 84.25
>>> 1212EWP 1352215P 10/10/2010 19:36 134.44
>>> 1212GWC 306 10/10/2010 9:15 275
>>> 1212GWC 604 10/10/2010 8:34 265.16
>>> 1212POR 107 10/10/2010 9:14 666
>>> 1212SSN 205 10/10/2010 18:21 124.15
>>> 1212SSN 205 10/10/2010 9:00 249.07
>>> 1212VSM 103 10/10/2010 9:57 185
>>> 1212VSM NC 10/10/2010 10:14 393
>>> 1212LP3 1490023 10/10/2010 15:57 50
>>> 1212LP3 1503023 10/10/2010 12:57 162.61
>>>
>>> For fields in the order listed above
>>> PropertyID, Account#, Date Time ,Net Funded
>>>
>>> Notice that third field has date and time combined in the same cell.
>>> (sorry but that's how it is generated). For the output file I only
>>> need the date.
>>>
>>> The outfile needs to be in .txt as follows
>>>
>>> 1212178 0000000000002101020echeck 00048100
>>> 1212CAS 0000000000311101020echeck 00007500
>>> 1212CAS 0000000000312101020echeck 00158643
>>> 1212CCP 00000005951B4101020echeck 00020994
>>> 1212CCP 00000005951B4101020echeck 00004370
>>> 1212CWG 0000000000401101020echeck 00074872
>>> 1212EWP 000001152535L101020echeck 00006722
>>> 1212EWP 000001331716C101020echeck 00006722
>>> 1212EWP 000001332412C101020echeck 00006900
>>> 1212EWP 000001332812C101020echeck 00008425
>>> 1212EWP 000001352215P101020echeck 00013444
>>> 1212GWC 0000000000306101020echeck 00027500
>>> 1212GWC 0000000000604101020echeck 00026516
>>> 1212POR 0000000000107101020echeck 00066600
>>> 1212SSN 0000000000205101020echeck 00012415
>>> 1212SSN 0000000000205101020echeck 00024907
>>> 1212VSM 0000000000103101020echeck 00018500
>>> 1212VSM 00000000000NC101020echeck 00039300
>>> 1212LP3 0000001490023101020echeck 00005000
>>> 1212LP3 0000001503023101020echeck 00016261
>>>
>>> The format is as follows:
>>>
>>> Property ID follow by 6 blank spaces
>>> Beginning in location 13 it will have the Account #. Field must is
>>> alphanumeric with a total of 13 digits. (zero filled to the left )
>>>
>>> After Account #, goes the date in format YYMMDD (notice that no spaces
>>> will be required between field 2 (Account #) and field 3 (Date).
>>>
>>> After Date the words "echeck" (standard for all records).
>>>
>>> After the word echeck there are 4 blank spaces.
>>>
>>> The last field after the 4 blank spaces is Net Funded (numeric, 8
>>> digits, no decimals )
>>>
>>> I would really, really be greatful and super happy to anyone that can
>>> do this macro as explained.
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> <http://twitter.com/exceldailytip>http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @
>>> <http://www.linkedin.com/groups?gid=1871310>
>>> http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at <http://www.excel-macros.blogspot.com/>
>>> http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at <http://www.quickvba.blogspot.com/>
>>> http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at <http://exceldailytip.blogspot.com/>
>>> http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to <excel-macros@googlegroups.com>
>>> excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> <http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>> --
>> Srinivasan Ethirajalu,
>> +919840544295
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> <http://twitter.com/exceldailytip>http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ <http://www.linkedin.com/groups?gid=1871310>
>> http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at <http://www.excel-macros.blogspot.com/>
>> http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at <http://www.quickvba.blogspot.com/>
>> http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at <http://exceldailytip.blogspot.com/>
>> http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to <excel-macros@googlegroups.com>
>> excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> <http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> Srinivasan Ethirajalu,
> +919840544295
>
> --
>
> ----------------------------------------------------------------------------------
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
----------------------------------------------------------------------------------
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
