Open files in folders

Help StudioX
,
1

Hi, I can’t open files in a folder. There are several folders in the folder, and there are files in those folders. How do I open all the files?

image
image691×711 28.8 KB

2

If they’re .docx you have to open them in Word not Excel.

3

Get rid of the For Each Folder in Folder activity. You don’t need it. Just use the For Each File in Folder and check the “Include subfolders” box.

4

Hi @sullivanne

In For each file in folder activity give CurrentFolder in In Folder and Filter give “.xlsx”

5

Hi @sullivanne

No need of For each folder in folder
Enable the check box inside the file in folder which includes folders too

image
image666×503 15.2 KB

Hope it helps!!

1 Like
7

@sullivanne
Give “.xlsx” in quotes

Regards

1 Like
9

@sullivanne

Give “*.xlsx”

  • indicates the remaining file path
1 Like
10

You don’t open Excel files to work with them, and you don’t automate in them by using UI automation (ie keyboard shortcuts, etc)

Excel automation is done with the Excel activities - Read Range, Write Range, etc.

1 Like
11
12

@sullivanne
Use For each file in folder ( with Enable the check box Include SubFolders,“.xlsx” filteration)
Excel Process Scope
Use Excel file
Read Range

Hope it helps!!

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.