filePro/Excel

[Harold]

On 6/18/2010 3:01 PM, Kenneth Brody wrote:
> On 6/18/2010 3:54 PM, Harold wrote:
> [...]
>> Sorry I took so long in replying. It is now working, which means that
>> the excel file is generated (about 1200 names with addresses, sorted by
>> zip code), and while filepro is running excel opens and the user can see
>> the results, in read only mode, which is fine.
>>
>> The code is below, and I haven't tried to clean it up or refine it---if
>> needed.
> [...]
>
> Showing us the working code is fine, but you still haven't answered any
> of the questions related to it having been broken.
>
> What was broken, and what did you change to fix it?
>

The main thing that was wrong was the line:

SYSTEM="C:/PROGRA::DECLARE LOCAL MACFILE:/OFFICE12/EXCEL.EXE<MACFIL"

It may have worked if I had tried:

SYSTEM="C:/PROGRA::DECLARE LOCAL MACFILE:/OFFICE12/EXCEL.EXE"<MACFIL

By the way, thanks to all those that sent replies.

Harold