Macro to check file exists and take input from the file

**naidu9295** · 06-11-2010, 04:12 AM

I dont know what is worng here, its working fine in 2007, but not working in 2003
can someone please help

Please Login or Register  to view this content.

**naidu9295** · 06-12-2010, 05:10 AM

I dont know what is worng here, its working fine in 2007, but not working in 2003
can someone please help

Please Login or Register  to view this content.

[/QUOTE]

**pike** · 06-12-2010, 05:41 AM

Hi naidu9295
It all looks OK.Have you checked the addresses/paths cell the cells

**naidu9295** · 06-12-2010, 06:40 AM

Originally Posted by pike

Hi naidu9295
It all looks OK.Have you checked the addresses/paths cell the cells

Yes i have checked, it is working fine in 2007 but in 2003 its not working.
Mainly its throwing an error when "Open File as Input as #1 " command

**pike** · 06-12-2010, 07:15 AM

Hey naidu9295
just tested this code in 2003xl and worked

Please Login or Register  to view this content.

**pike** · 06-12-2010, 07:27 AM

you can check if the file exist with

Please Login or Register  to view this content.

**naidu9295** · 06-12-2010, 08:15 AM

[SOLVED=pike;2323252]Hey naidu9295
just tested this code in 2003xl and worked

Please Login or Register  to view this content.

[/SOLVED]

Thank you so much

Re: Macro to check file exists and take input from the file