Go To Post #7 for new Question(adsbygoogle = window.adsbygoogle || []).push({});

So let's that I have a .txt file called input.txt that simply contains the following:

abc+123

I want to load input.txt using VBA into a 1-dim array called MyArray. I want eachcharacterto be an element of the array. That isais MyArray(1),cis MyArray(3) "+" is MyArray(4) etc.

I am not sure about whitespace. If it is easier, whitespace could be considered a character.

Any ideas?

Edit: ALternatively, each charecter could got to a cell...I just cant figure out how to set the dilmeter since there is not one...

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel VBAWriting a .txt file to an Array or Wrksht

Loading...

Similar Threads for Excel VBAWriting file |
---|

Help with Excel graph please |

LaTeX Putting Excel graph into LaTeX |

Mathematica FeynArts model file |

Excel Error Bars |

**Physics Forums | Science Articles, Homework Help, Discussion**