Jump to content

Recommended Posts

Posted

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)

Posted (edited)

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 by water
Should post a working example :>

My UDFs and Tutorials:

  Reveal hidden contents

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...