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!
-
Saving Excel as .dat file
Thanks for your reply. I am not sure what the code you sent is all about. If I understand, your code opens a fixed width file and if I reverse it, it should save as a fixed width file. Sorry, I am confused. I get information in as an Excel spreadsheet and I need to save it as a .dat file with...- ajohn1124
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Saving Excel as .dat file
I need the output to be in a fixed column width, with no commas -the "flatfile" command works well, but the drawback is it's 240 character limit per line. The DAT file will be imported back into a financial program. This program using only the .dat format with fixed column widths. I...- ajohn1124
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Saving Excel as .dat file
How do you save Excel as a .dat file? I tried both of the following methods: METHOD ONE (does not pick up all the columns) Application.CutCopyMode = False With ActiveWorkbook.Styles("Normal") .IncludeNumber = False .IncludeFont = True .IncludeAlignment =...- ajohn1124
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
