Hi All, I am trying to convert the excel file into text file and saving it into a folder. Somehow i am not able to do it.
1) It will convert into excel format but code is for text format.
2) When i copy the content of the worksheet to new workbook then if you run
the macro it will convert to text file, but if you run the same macro with
current
excel workbook which has filename it will convert it into excel file not as
text file.(i need to save text file by using activefile name of excel).
The code is like this.
Sub saveme()
Dim spath1 As String
spath1 = "C:\Documents and Settings\"
ActiveWorkbook.SaveAs Filename:= _
spath1 & ActiveWorkbook.Name, FileFormat:=xlText,
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub
Please try to find solution for my problem, I am attaching you workbook
which has button to run the macro.
To view code section press Alt + F11 and click on the Module section.
Regards,
Gururaj.P.
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
KC_IP02_IC.xls
Description: MS-Excel spreadsheet
