× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I have used Excel with ODBC Data Source configurations. I don't think this
could be the case, but you should check the Data Tab and follow to see if
there is any data source configured for those queries.

El vie, 11 nov 2022 a las 9:38, Freeman, Greg (<gfreeman@xxxxxxxxxx>)
escribió:

Well, I discovered there isn’t any VBA code. There are several queries.
Below is the authentication settings on the first query (and the other
queries).

The problem is that somewhere there is a password for the user that is
incorrect – could it be cached somewhere? The user’s iSeries password has
changed, but when she puts in her new password, it keeps indicating that
the password is incorrect, then eventually her iSeries account gets
disabled. Any ideas?


[cid:image001.png@01D8F5B1.42C80190]

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Sizer, Joseph via MIDRANGE-L
Sent: Friday, November 11, 2022 8:15 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx

Cc: Sizer, Joseph <JSizer@xxxxxxxxxx>
Subject: RE: Excel/iSeries issue

This could be embedded in a VBA script within the Excel worksheet. You
would need to access the Developer tab and view the associated source code.
Here is a helpful link that shows how to access it. https: //www.
basicexceltutorial. com/how-do-i-open-vba-in-excel/#: ~: text=1%201.
%20To%20open%20the%20feature%2C%20click%20on,VBA%20window%2C%20press%20on%20Alt%20%2B%20F11%20keys.

ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.
ZjQcmQRYFpfptBannerEnd

This could be embedded in a VBA script within the Excel worksheet.



You would need to access the Developer tab and view the associated source
code.



Here is a helpful link that shows how to access it.




https://www.basicexceltutorial.com/how-do-i-open-vba-in-excel/#:~:text=1%201.%20To%20open%20the%20feature%2C%20click%20on,VBA%20window%2C%20press%20on%20Alt%20%2B%20F11%20keys
.





-----Original Message-----

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:
midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of Freeman, Greg

Sent: Friday, November 11, 2022 9:09 AM

To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>

Subject: Excel/iSeries issue



________________________________

CAUTION: This email originated from outside of the PENCOR network. Do not
click on any links or open attachments unless the sender is known, and the
content is verified as safe.

________________________________



I have an Excel file that uses queries to pull data from the iSeries. The
user ID seems to be stored somewhere for a particular user, but default.
Where are these credentials stored? Are they hidden in Excel somewhere? I
didn't create the Excel file, it was created years ago by a power user, no
longer with the company.



Anyone want to help?



Greg

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L@xxxxxxxxxxxxxxxxxx> To subscribe, unsubscribe, or change list
options,

visit: https://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>

Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.



Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.



Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L@xxxxxxxxxxxxxxxxxx>

To subscribe, unsubscribe, or change list options,

visit: https://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>

Before posting, please take a moment to review the archives

at https://archive.midrange.com/midrange-l.



Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.



Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.