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.
Pleaseeeeeeee!!!!!! Any help is greatly appreciated
On Oct 22, 1:54 pm, Cesar Delanoval <cdelano...@gmail.com> wrote:
> 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&;...>
> >>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> >> --
> >> 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&;...>
> >>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> >> --
>
> >> ----------------------------------------------------------------------------------
> >> 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 athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://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&;...
>
> > --
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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&...-
> >Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
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
