cool_capybara
New Member
- Joined
- Apr 8, 2004
- Messages
- 16
Sadly, I've got one of those problems that are intermitant...
I have an excel file and a .txt file that sit in the same folder together. The excel file has a macro that reads (or writes) a piece of data to that file (simply):
This works almost all the time. However, when I e-mail the folder to a colleague, and they have the same folder structure (both files in the same folder), they will get a "File Not Found" error.
As weird as it sounds, sometimes when I show off the version on my own PC, it will work 9 times out of 10...but when it really counts, I'll get the "File Not Found" error too.
Is there any way to explicitly state that the file is in the same folder? My guess is that I have it right (w/ no stated path, it assumes the same location)...or any other suggestions?
Thanks!
I have an excel file and a .txt file that sit in the same folder together. The excel file has a macro that reads (or writes) a piece of data to that file (simply):
Code:
Sub Macro2()
Dim Cntr, NewInvoiceNumber As Integer
Cntr = FreeFile()
Open "incident.txt" For Input As #Cntr
Input #Cntr, NewInvoiceNumber
Close #Cntr
This works almost all the time. However, when I e-mail the folder to a colleague, and they have the same folder structure (both files in the same folder), they will get a "File Not Found" error.
As weird as it sounds, sometimes when I show off the version on my own PC, it will work 9 times out of 10...but when it really counts, I'll get the "File Not Found" error too.
Is there any way to explicitly state that the file is in the same folder? My guess is that I have it right (w/ no stated path, it assumes the same location)...or any other suggestions?
Thanks!