Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Matilda Hughes   on Dec 04 In MS Office Category.

  
Question Answered By: Bama Cohen   on Dec 04

I used suggestions to clean this code and make it more efficient.

The ultimate solution was found by rexamining the incoming file
names at which time I found that 1 file was coming in with a modest
difference in the naming convention (1 file actually had 2 spaces
instead of 1) and it caused my loop  to fail.

I addressed this with an If . . .Then statement and all seems to
work as expected now.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Why does this loop end before all workbooks are closed Or get search suggestion and latest updates.


Tagged: