asked on

how to 1>create a txt file 2>run a exe file

Hi experts,

May I know how to create a txt file and later also can open, write to and close it in VBA script.

Also may you give suggestion how to run a exe file in VBA script.

Thanks,

Turbot

ASKER CERTIFIED SOLUTION

Dirk Haest

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

turbot_yu

ASKER

How to run the exe in background?

Dirk Haest

http://www.vb-helper.com/howto_shell.html

turbot_yu

ASKER

Hi, is there any way to clean all the txt in the txt file fitrts and then put a paragraph in it

turbot_yu

ASKER

Also may I know how to kill the exe file after it finish the task.
Thanks

Dirk Haest

Normally you ask only one question at the time. You asked already 2 questions to start with (so far no problem), but now you keep asking other questions... That's not the purpose !

turbot_yu

ASKER

ok, let me start new ones

Dirk Haest

About the killing of the exe ... -> is it still running or is it inactive ? If it's inactive, you just can use the kill-statemen which will delete the file

Dirk Haest

I guess if you create the textfile like the way I showed above, it will be overwritten (and be empty). Put a paragrahp on it, I'm not sure, start your text and add a empty line between paragraphs ?

nffvrxqgrcfqvvc

Its been more than 21 day's since a comment has been posted. I am going to leave this question for cleanup.
Recommend: [Accept: Dhaest comment]

nffvrxqgrcfqvvc

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:

[Accept: Dhaest comment]

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

egl1044
EE Cleanup Volunteer

how to 1&gt;create a txt file 2&gt;run a exe file

how to 1>create a txt file 2>run a exe file