Re: Code looping through files
- From: "Tom Ogilvy" <twogilvy@xxxxxxx>
- Date: Sun, 31 Dec 2006 18:09:37 -0500
Since you don't show the code, have him send you the file that fails to open
and test the code with that file. Perhaps the file is damaged or not a file
Excel will open.
--
Regards,
Tom Ogilvy
"Otto Moehrbach" <ottokmnop@xxxxxxxxxxx> wrote in message
news:%23vP3hpSLHHA.4848@xxxxxxxxxxxxxxxxxxxxxxx
Excel XP & Win XP
I'm helping an OP with a project. The code loops through all the files in
a folder, opens each, does things, closes the file and opens the next
file, etc.
The code is placed in the Personal.xls file. It works fine for me. It
fails on opening the first file for him (will not open the file). An
error is produced saying that opening the file failed. He has Excel 2003.
He sent me his Personal.xls file. I changed the name and put it in my
XLSTART folder. It works fine with my path. I created his path on my
computer and that works fine too.
I checked the VBE - Tools - References. The only thing I have checked
that he doesn't is "Microsoft Forms 2.0 Object Library". He doesn't have
anything like that to check.
Does anyone have any ideas of what I could do? Thanks for your time.
Otto
.
- Follow-Ups:
- Re: Code looping through files
- From: Otto Moehrbach
- Re: Code looping through files
- From: Otto Moehrbach
- Re: Code looping through files
- References:
- Code looping through files
- From: Otto Moehrbach
- Code looping through files
- Prev by Date: Hide row if particular cells are empty
- Next by Date: Re: Randomly selecting a cell weighted on percentage
- Previous by thread: Re: Code looping through files
- Next by thread: Re: Code looping through files
- Index(es):
Relevant Pages
|
