Press question mark to learn the rest of the keyboard shortcuts Log in sign up User account menu 1 How to set xlListSeparator.I know I can get the current list separator using Application.International(xlListSeparator) and change it manually in the Excel options menu.However, if possible Id like to be able to temporarilyprogrammatically set said separator as well.
![]() Thanks in advance. Upvoted This thread is archived New comments cannot be posted and votes cannot be cast Sort by best level 1 14 4 years ago Use vba built in file io to output. That way you have much more control. Report Save level 2 4 years ago edited 4 years ago Yeah, this is what I ended up doing, just iterating over rows and writing them out with FSO. Dim path As String: path C:MyPathMyFile Format(Now, YYYY-MM-DD-HH-MM-00).txt. Dim fso As Object: Set fso CreateObject(Scripting.FileSystemObject). All rights reserved Back to top.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |