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
midrange.com
