Hi
its working fine at my place
On Tue, Jul 3, 2012 at 1:38 AM, OJEMENI Uzoma uojem...@gmail.com wrote:
Ashish,
If i were to change the input from numbers too letters as in the *attached
file*, what changes to the code would be necessary as i am having an
error Run-time error '13' Type
Hello Everyone,
Kindly assist with a Macro.
Thanks.
Uzoma
Ojemeni Uzoma | Call 08060700717
-Original Message-
From: OJEMENI Uzoma uojem...@gmail.com
Date: Sun, 1 Jul 2012 19:02:25
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to populate Output file
Hello
Can you please explain with sample data.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ojemeni Uzoma
Sent: 02 July 2012 12:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro
try this see if it helps
Sub create_txtfile()
Dim arv, st1 As String
Dim s As Long, j As Long, k As Long
MyFile = C:\Documents and Settings\user\Desktop\sample\ouputfile.txt
'set and open file for output
With Sheets(Sheet1)
.Range(x:x).Clear
.Range(a1:a
Thank you Ashish. The macro worked perfectly.
On Mon, Jul 2, 2012 at 3:02 PM, ashish koul koul.ash...@gmail.com wrote:
try this see if it helps
Sub create_txtfile()
Dim arv, st1 As String
Dim s As Long, j As Long, k As Long
MyFile = C:\Documents and