Solved

Why the Excel file can not be open using \*xlsm

  • 8 December 2022
  • 5 replies
  • 60 views

Badge +3

Recently AA cannot open Excel file using command.

Excel Open Spreadsheet E:\Data\02_Master\YEA_ENG_05\5K00\202211\*.xlsx

But this is working before.

Is the * wildcard is not working for this case?

Anyone has similar experence?

 

icon

Best answer by Padmakumar 8 December 2022, 07:41

View original

5 replies

Userlevel 7
Badge +10

@MingshanX101307 ,

As I can see that, you are taking the Excel files from a local folder here. So, the best thing you can do here is that loop inside this folder and during each iteration, BOT will take each file and do the necessary actions according to the logic provided and go to the next one during next iteration.

 

 

Badge +3

yes, I try to start a loop in the folder, using if file extension = xlsm , then open the file name it works.

Userlevel 7
Badge +10

Mark this as best if it worked out for you so that other community members can easily access this thread for similar issues.

Badge

I have been successfully opening Excel files with wildcards, however, if there are five files in the same folder, all having the extension .xlsx, then when we choose to open a file with the *.xlsx extension, one file will be opened which appears first in alphabetical order.The Package i have used is 6.104

 

 

Userlevel 7
Badge +10

@Shalord ,

 

I don’t think using wild card here will be a good option. Because if you put wild mask, BOT will only consider the file extension and whichever file comes first with .xlsx extension, it will pick that. So basically, it will keep taking the same file again and again.

 

Whereas looping inside the folder will iterate through all files and there will be no situation like above mentioned.

Reply