Hi
its working fine at my place
On Tue, Jul 3, 2012 at 1:38 AM, OJEMENI Uzoma 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 Mismatch". Th
Thank you Ashish. The macro worked perfectly.
On Mon, Jul 2, 2012 at 3:02 PM, ashish koul 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 Settings\user\Desktop\sample\ouputfile.txt"
> 'set an
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" & .Range("a1048576").End(xlUp).Row)
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
Hello Everyone,
Kindly assist with a Macro.
Thanks.
Uzoma
Ojemeni Uzoma | Call 08060700717
-Original Message-
From: OJEMENI Uzoma
Date: Sun, 1 Jul 2012 19:02:25
To:
Subject: $$Excel-Macros$$ Macro to populate "Output" file
Hello Everyone,
I would appreciate some assistance in creat
