Auto it excel help

[yasha]

So i have excel files i want to open, my company sends me files as ddmmyy  500.xlsx all in the same folder with the only difference being ddmmyy

is there any way to get a variable to work in this program

(i am very new to auto it)

Global $excelno
       $excelno= InputBox('new excel','please write the excel no as yymmdd 500')
       sleep(500)
       Local $oExcel = _Excel_Open()
       Local $sWorkbook = J:\OPS\"$excel .xlsx"
       Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook)

[water]

Welcome to AutoIt and the forum!

Sure you can let the user select the workbook to process. I suggest something like this:

#include <FileConstants.au3>
#include <Excel.au3>

Local $sWorkbook = FileOpenDialog("Please select workbook to process", "", "Excel Workbooks (*.xlsx)", $FD_FILEMUSTEXIST + $FD_PATHMUSTEXIST)
If @error Then Exit msgBox(0, "Error", "File selection returned error " & @error) ; @error = 1 means: So file was selected
Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook)

Edited September 17, 2018 by water
Should post a working example :>

[yasha]

Thanks a lot