Hi all,

I'm having a very wierd error with my MS Excel VBA coding. I have a
macro that gets caught on the line

Open "C:\{filename}" for Append as #2

It throws the error, "file not found" during runtime. I'm confused for
2 reasons: 1: Append should create the file if it wasn't found,
shouldn't it? and 2: this exact same macro works on other machines
that as far as i can tell are identical. Both are running the same
Excel version (2002 SP3), both XP Pro, and same antivirus (Kaspersky)
as well. I've been trying for a couple days on and off to try to
figure out the problem, and have come up with nada. I found a previous
post that sounds similar he

http://groups.google.com/group/micro...0e3b8399774704

Does anyone know of a glitch in VBA that makes the Open command work
sometimes and not others? or is there some windows setting that
affects it's ability to create a file? it just doesn't make any sense
to me! Help!

Thanks to any and all,
-Michael