LinkBack URL
About LinkBacks
using the Do While function
CODE:
Do While FileName > 0
END CODE
Gets hung up and needs to debug, I dont understandt why
using the Do While function
CODE:
Do While FileName > 0
END CODE
Gets hung up and needs to debug, I dont understandt why
Assuming FileName is a string, you can't compare a string against a numeric data type using mathematical operators.
What are you trying to accomplish with that line of code?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
AH HA! yep that fixed it! Thanks!
I am using it to keep a loop going, I am opening a series of files in one folder to pull and consolidate data into one sheet, but the # of files changes everyweek, thus I am using a bogus referance to allow it to keep running.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks