Hi Ashish,
I want to open the excel file & then convert to text.
Can I add this code within my macro code?
On Mon, Feb 23, 2015 at 5:32 PM, ashish koul wrote:
> Option Explicit
> Sub export_range_delimit()
>
> Dim arr As Variant
> Dim fs As Object
> Dim delimittxt
> Dim i As Lo
Option Explicit
Sub export_range_delimit()
Dim arr As Variant
Dim fs As Object
Dim delimittxt
Dim i As Long
Dim j As Long
Dim line As String
Dim rng As Range
Dim delimittype As String
delimittype = ","
Set fs = CreateObject("Scripting.FileSystemObject")
Do you wanna export range in comma delimit text file?.
On Mon, Feb 23, 2015 at 9:38 PM, Muneera Shabana
wrote:
> Hello there,
>
> I have written a macro to convert xls files to text file, however I have 2
> problems here:
> 1. My code doesnot show xlsx format to pick up from the source folder
>
Hello there,
I have written a macro to convert xls files to text file, however I have 2
problems here:
1. My code doesnot show xlsx format to pick up from the source folder
2. I am not sure when to add the code to have delimiter "comma" in my text
file.
I am not an expert, so seeking support fr