What's the best way of writting a text file through VBA?

G

Guest

I have to create several text files through VBA every month, and the text
files have to be created line by line. What I do right now is to write to the
text file everytime I created a new line for this text file. And it became
extremely slow when everything is located on a network drive. I am guessing
the major reason is because writing to the network drive frequently makes the
process slow.

So I am thinking about if it is possible to put the data for the text file
in a buffer and then save it to the network drive only once. The text file is
not huge, its size is just about 3M. Saving a 3M file on the network drive
should just take a few seconds, at most 1 minute.

Could anybody help me on this problem? Thanks a lot!
 
D

Dave Peterson

So why not write to your C: drive (maybe a temp folder) and just move the file
to the network drive when you're done?

Look at Name Statement in VBA's help:
 

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

VBA Read-Manipulate-Save Text File 5
Problem in Saving the Activeworkbook on a network drive 2
parsing and importing a text file with records through a VBA macro 2
VBa Write integer to file 0
File owner attributes through Excel VBA 4
Save Text to File 3
looping through text files in a folder 2
VBA Select File 4

Top