how to open .txt file just from .mvba?

Hi All,

excuse me my simple question...

In my .mvba macro, I do some operations on text elements. After all changes are applied, I save new text contents to .txt file. So far, so good.

The problem is that I cannot open the file from .mvba. I tried Shell command and it didn't work.

My command was:

Shell ("C:\Documents and Settings\R\My Documents\test.txt")

and I got a message saying "invalid procedure or called argument".

What did I do wrong?

Maybe there is another way for opening text files? Thank you for any tip.

Parents Reply Children