Share
ReportHello,
Sorry for my terrible English.
I was asked to do this by a distant friend.
Despite it running successfully in my environment, it fails in his environment.
His OS is Windows 11, and PAD is the latest version, exactly the same as mine.
I’m using two flows, main and sub, and the process flow is briefly described below.
Main
- User chooses a folder, say InputDirectory
Sub
- Launch Excel
- Find xlsx files in InputDirectroy and open them in a loop
- Store the first column data of each xlsx file in a list variable “List”
- Remove duplicates in the List
- Write List to a blank Excel worksheet(Error occurs)
An error occurs at the very end of the sub-flow.
So, I created the following flow and had it run in a friend's environment. Then, no error occurred.
Experiment
- User chooses a folder
- Launch Excel
- Write “test” to Excel worksheet
- Save the Excel document
Why do errors occur in his environment that do not occur in mine?
Also, why do errors sometimes occur when writing to an Excel worksheet in his environment and sometimes not?
Also, why do errors sometimes occur when writing to an Excel worksheet in his environment and sometimes not?
Attached is an image of the error. Thank you.
Categories:
I have the same question (0)
All responses (
Answers (
261
