Repost - Shell Wait for Notepad to open file and Save

[jimrosser]

So I asked this the other night and the Binary function supplied is not the same as opening the file in notepad. I have code that checks the modified date of the file and opens in wordpad.exe Then it saves the file. There are approximately 10 files and 10macros that I'm calling and some of the files take a couple of minutes to open. So all of the files are opening in Notepad at once and my sendkeys command is not always working.
The file must be opened and saved in notepad to remove some erroneous data that exists.

Please Login or Register  to view this content.

[Norie]

Couldn't you deal with the files using VBA's file input/output methods?

[jimrosser]

Norie - I've tried that and it doesn't work. Each macro just needs to complete before the next one begins.

[Norie]

What exactly did you try?

Also, what erroneous data are you trying to get rid of?

[jimrosser]

The files are being downloaded from a server and contain various hard returns and data out of place.
Here's the code that I have tried that doesn't work.

Please Login or Register  to view this content.

[Norie]

How does that code not work?

[jimrosser]

The code works but just doesn't modify the files as notepad does. The reason for opening in notepad is there are hard returns and formatting issues with the data ie special formatting characters that are removed when the file is opened and saved in notepad.
Is there any way to remove these characters that exist with the binary process? For example the non-prining symbols that you would see in word if you hit the formatting tool.

[Norie]

What happens if you use Line Input/Print instead of Get/Put?

[jimrosser]

i get an error on this line

Please Login or Register  to view this content.

[Norie]

You wouldn't just substitute Input for Get etc, the code would be different.

Can you upload a sample file?

[jimrosser]

wish i could but it's proprietary

[jimrosser]

After viewing the file in Notepad it's showing a string of 3 nulls, if there were any way to remove those it would make me very happy.