How do I prevent variable from getting cleared before completing loop

**Wiigit** · 10-05-2023, 01:39 PM

I'm getting a runtime error 75 file/path access error due to the script "forgetting" the filepath name stored in ReadTextFile

The file being read looks something like this:

Please Login or Register  to view this content.

Sheet1 looks something like this:

Please Login or Register  to view this content.

And the script is as follows:

Please Login or Register  to view this content.

**Bernie Deitrick** · 10-05-2023, 04:19 PM

You have this line

Please Login or Register  to view this content.

That does not skip to the next file... to do that change that line to

Please Login or Register  to view this content.

and add this to just before your Next FileCell line:

Please Login or Register  to view this content.

**Wiigit** · 10-05-2023, 04:28 PM

That didn't quite fix it, but I understand better why the script is failing, so I'm going to play with it some more to see if I can figure it out on my own. (Columns A through E have values, and some of those columns are longer than column D, so it's pulling the filename/path from a blank cell)

Thanks!

**Bernie Deitrick** · 10-05-2023, 04:32 PM

Your filepath variable is used exactly once, so I don't see any possibility of it being erased or forgotten....

How do I prevent variable from getting cleared before completing loop

LinkBack

Thread Tools

Rate This Thread

Display

How do I prevent variable from getting cleared before completing loop

Re: How do I prevent variable from getting cleared before completing loop

Re: How do I prevent variable from getting cleared before completing loop

Re: How do I prevent variable from getting cleared before completing loop

Thread Information

Users Browsing this Thread

Similar Threads

finding cell value and completing loop based on that

[SOLVED] How to prevent certain cells from being deleted when page is cleared

A Loop not completing

Loop only completing first loop

Why did an inner loop variable start overwriting the outer loop range suddenly?

For Loop not completing

How do I prevent Crtl+End moving to a cleared cell?

Bookmarks

Bookmarks

Posting Permissions