Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: VishalkumarT
- Order by date
-
Store Worksheets from a Workbook as Text files
Dear Friends I think I have solved this problem :) And thanks for your time to read my problem and reply. Best Regards Vishalkumar- VishalkumarT
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Store Worksheets from a Workbook as Text files
Hello Friend This is really a good help, but here I have one question, I think in this method, it takes some default file saving path, so how can I provide my own path. I mean in the line, s.SaveAs Filename:=s.Name, FileFormat:=xlTextMSDOS I want to provide my own path to save the...- VishalkumarT
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Store Worksheets from a Workbook as Text files
Dear Friends I have a Workbook and it contains 10 Worksheets. (for example, c:\wb.xls) So how can I store separate worksheets from this Workbook in a folder, with names like 1.xls, 2.xls ... 10.xls (e.g. c:\ws\1.xls, c:\ws\2.xls ... c:\ws\10.xls) And then I want to convert this worksheets as...- VishalkumarT
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
