Run time error (Err=9) when saving file using saveas

[welchs101]

I have the following file designed to save a file. I have NO idea why this occurring but i get a run time err #9.

Any ideas?

Please Login or Register  to view this content.

[welchs101]

i tried uploading my macro......but it would not load .....its not taht big only about 140k.......any ideas?

[welchs101]

i zipped the macro and included one input file.....just make a copy of the input file so that you have two input files total. running the macro should be self explanatory but just select the directory you put the two input files in and then select the directory where you want the output saved to.

i would really appreciate some help on this one.......i am really frustrated.

[welchs101]

does anyone have any ideas?

[welchs101]

ok, i figured it out and it was by luck that i did......i happen to review ALL the code again because i knew this should work and i noticed that in another procedure i was saving this same file.........so i commented out the following code from the the "process_all_files_in_directory" and it worked.

Please Login or Register  to view this content.

i dont have a clue why this matters......but then again there is ALOT that i dont know about vba / excel programming.