homer15
07-10-2002, 03:00 PM
ok, so i wrote an excel macro that will open a series of spreadsheets, steal their data and import it into a new spreadsheet, then delete the old spreadsheet. all of the code looks correct to me, but when it's running i get a 1004 error. it says it cannot open the other spreadsheets because they don't exist. i happen to know that they do exist because i can see them there.
ok, how it actually works is i have the macro look for all 0*.xls files. it has no idea what the actual sheets are called, just that they start with a 0. as i run the macro, i get the error message that 020619.xls does not exist, but in order for it to even know that name, it has to be able to see the file, know what i mean? i attached a zip that contains my sheet (called debug), and 020619.xls, which contains the information i need to extract. if someone could help me troubleshoot the problem, i would really appreciate it. thanks a lot.
ok, how it actually works is i have the macro look for all 0*.xls files. it has no idea what the actual sheets are called, just that they start with a 0. as i run the macro, i get the error message that 020619.xls does not exist, but in order for it to even know that name, it has to be able to see the file, know what i mean? i attached a zip that contains my sheet (called debug), and 020619.xls, which contains the information i need to extract. if someone could help me troubleshoot the problem, i would really appreciate it. thanks a lot.