$$Excel-Macros$$ Re: Interrogating the file name used/selected in a query of an external CSV file

2009-04-19 Thread Mr Incredible
; '''' > Ajit > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > On Behalf Of Mr Incredible > Sent: Sunday, April 19, 2009 3:00 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Re

$$Excel-Macros$$ Re: Interrogating the file name used/selected in a query of an external CSV file

2009-04-18 Thread Mr Incredible
te... > > Let me know if this is what you are looking for... > > Regards > > Ajit > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > On Behalf Of Mr Incredible > Sent: Friday, April 17, 2009 3:58 PM &

$$Excel-Macros$$ Interrogating the file name used/selected in a query of an external CSV file

2009-04-17 Thread Mr Incredible
Hi all, I've done many searches for a potential solution to my "problem", and have drawn a blank. Any help/suggestions will be appreciated. Problem to solve: I have a worksheet in which there is just one named external query which loads an external CSV file. The "Data Range Properties" is set