Making files from VBA?

P

Paul

Hey, I want to create a simple .bat file and a txt from a
macro. Is this possible? How can I do it?

-Thanks
Paul
 
C

Charles Maxson

Paul,

Here is the approach BUT promise you will be good ;-) This is a open avenue
for inappropriate behavior (uh.... viruses)

Sub WriteBatch()

Open "c:\Test.bat" For Output Shared As #1
Print #1, "echo Your code here"
Close

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get a Shareable URL via VBA code to a OneDrive image? 0
Executing a .BAT file using excel macro 1
Drop down list control value in vba 2
How to make repeating drop-down lists? 2
Adding data to MS Access from csv file 0
Office365 Family + TXT or MX Domain 0
New computer, how do i move outlook 365 ENTIRELY? 0
Program buttons to create a word document 0

Top