Saving a excel document after data refresh

[b1nd3r512]

Hi Guys

Sorry im new to autoit and coding in general i have a basic understanding.

Heres what im trying to do and i hope someone can help.

I need to open a excel document that retrieves data from sql and then saves the excel files with todays date.

Basically we are pulling reports daily to see who does what in our warehouse. 

The problem is the data refresh once the excel document is open takes about 5 minutes to generate.

Here is my starting code of just opening the document. 

"

run('"C:Program Files (x86)Microsoft OfficeOffice14EXCEL.EXE" "C:Test"')

"

the sheet will pull the data automatically but how do i get the script to save the file AFTER the data has been recieved and with todays date.

 

Regards

Red

[water]

Welcome to AutoIt and the forum!

You could use the Excel UDF that comes with AutoIt to open and save the Workbook.

I haven't tested it but I think the _ExcelBookOpen function will return after the data has been loaded. Then you can save the updated Workbook.

[b1nd3r512]

Sounds good thanks man ill give it a try the problem is im trying to automate this whole process. So 5pm script runs, It opens file generates results and after 5-10min it saves as the current date and closes excel :/

[water]

Which file format do you want to work with: xls or xlsx?