You could use the more simple property of Application. use on the Web you might have to save the file in a pipedelimited format. In the second Convert Text to Columns Wizard dialog box, only check the Comma box in the Delimiters. In the first Convert Text to Columns Wizard dialog box, select the Delimited option, and then click the Next button. The function then uses the conditional compilation constant to check the OS: Function newLine() As Stringįrankly now that I do this I remember it's not strictly necessary to use conditional compile here unless you have methods/properties that won't compile in some versions. Excel data in the textbased CSV, or Comma Separated Value, format for use. Select the range of cells you want to split values into columns, and then click Data > Text to Columns. You can refer to this list of built-in compiler constants:ĭefine your delimiter variable as a string and assign it the result of a function. If you need to support multiple OS (or different versions on the same OS) you can look in to conditional compilation statements.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |