REading in entire file

[aheu9]

What is the best way to read in an entire file without editing any characters. For example if I use a for loop until EOF it will input every string up to a space of newline, I want the spaces and the newlines intact. Is there an easy way to read in the entire file to a variable. I am using VBA 6.
Thanks in advance.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/cc47419a-259b-4c22-a454-bac2ed150866.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CautionMP]

aheu9,
If your not using the File System Object you might look at the Input() function.

[tt]strFile = Input(LOF(filenumber),filenumber)[/tt]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[aheu9]

Thank you for all the help, I ended up using the file system object, and used the ReadLine instead of ReadAll Method to avoid any future memory problems in a while loop using the AtEndOfStream property.
Thanks for all the help!!