Get filename in var without path and extension

[toopnad]

Code: Select all

Let>GFL_TYPE=0
Let>GFL_SORTTYPE=1
IfFileExists>Z:\Обмен\ЗАЯВКИ\ЗАЯВКИ в поставку\ОТЕЧ\2021\*.*
GetFileList>Z:\Обмен\ЗАЯВКИ\ЗАЯВКИ в поставку\ОТЕЧ\2021\*.*,files,;
Separate>files,;,file_names
MessageModal>Num Files: %file_names_count%
Let>k=0
Repeat>k
  Let>k=k+1
  Executefile>file_names_%k%
  //Message>file_names_%k%
  //wait>15
  WaitWindowOpen>* - Excel
Until>k,file_names_count

How to get the file name into a variable without path and extension to substitute in waitWindowOpen instead of *?

[toopnad]

Code: Select all

 ExtractFileName>file_names_%k%,oldfilename,0
  StringReplace>oldfilename,.xlsb,,strNewString
  WaitWindowOpen>%strNewString% - Excel

I think I did it

[Grovkillen]

Code: Select all

ExtractFileName>file_names_%k%,oldfilename,1

[toopnad]

This will shorten the code thanks! May I ask offtopic? If I want to open an Excel file with a password, is it only through VBA? Are there any other options?

[Grovkillen]

Yes I believe the best way is to use VBA.

[toopnad]

Thank you, I did so, the topic is closed.

[JRL]

Adding the password at the end of XLOpen> works for me.

Code: Select all

XLOpen>Filename,1,hndl,password

[toopnad]

Great news! I'll try)