![]() ![]() ![]() ![]() I have a file exported from an accounting system that has no extension. How do I assign a variable to original code page and not have it reset to the default Windows (ANSI)? However, the macro recorder assigns a code page number to the TextFilePlatform property. QueryTable.TextFilePlatform has a number that refers to one of these constants. XlPlatform can be one of these XlPlatform constants.Īnd. This works fine for all parameters except TextFilePlatform. I want to set the connection parameters to variables and reapply them with a different filepath.ĭim TabDelimiter as Boolean, CommaDelimiter as Boolean I am writing a macro that changes the filepath for an existing text file import as a QueryTable. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |