RE: issue with Excel formula

I think I'm back in business.
I Updated POIi to 3.6 and updated to the latest version of your procedures. I then reran the programs and no longer have an issue with the VLOOKUP.

Thanks for all the help.


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Monday, July 15, 2013 9:55 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: issue with Excel formula

Renaming the files by putting XX in front of them would not stop them from being used if they are in a Java "ext" directory, or similar.

Consider creating a "/backup" directory or some such, and moving all of the files to that location, instead of renaming with "XX".



On 7/15/2013 8:23 AM, Smith, Mike wrote:

Ok, I think I need a little more help on this.
I used qshell Find
find / -name 'poi*'

Found a few poi jar files.
In /QIBM/PRODDATA
/QIBM/USERData
/excel

I renamed them by placing an XX at the beginning of the file names.

I reran one of my programs to create a spreadsheet, expecting it to fail but it created the spreadsheet.

I also checked WRKENVVAR looking to see if we had set up a classpath, but did not see any listed.

So if I've renamed these why do my programs still create the spreadsheets?

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.