Prev: Access Version being used
Next: Remove Duplicate Numbers in One Cell
From: Gordon Rainsford on 17 Jan 2010 04:03
joel <joel.44w55k(a)thecodecage.com> wrote:

> Dave: Your solution won't work if it was opened with a different Excel
> application. I thought about your solution first. But if I doubled
> clicked on the file from a window explorer and 2nd excel application
> came up and the CSV file was not in the list of files.
>
> The right solution is to assign an object to the CSV file when it was
> opened but when haven't seen the code that opens the book. I assumed
> that the CSV file was not opened by the VBA code.

That's correct - the csv file is opened by another program.
First  |  Prev  | 
Pages: 1 2 3
Prev: Access Version being used
Next: Remove Duplicate Numbers in One Cell