AutoIt Excel file Save as

[ilona]

Hello ,

please help me with an autoit script for Excel file "save as" where the file name is range ("D2") from Activesheet

something like

 $filename = $Workbook.Activesheet.Range("D2")
   

    _Excel_BookSaveAs($Workbook,"C:\desktop\$filename.xls"   

 

Thank you!!!

[Xenobiologist]

Where is your problem? Use _Excel_RangeRead to get the path and then the save function.

Edited September 4, 2019 by Xenobiologist

[ilona]

Thank You! 

[Xenobiologist]

2 minutes ago, ilona said:

Thank You! 

No problem. Easy one and glad I could help.

[ilona]

Sorry I can't put the path in the file name. The file is saved a ($sResult.xls ).I cant create the link with  the excel range read

Thank you

 

#include <excel.au3>

Local $oExcel = ObjGet("","Excel.Application")

if NOT @error then
  for $Workbook in $oExcel.Workbooks
  Local $sResult = _Excel_RangeRead($Workbook, Default, "D2",3)

    

    _Excel_BookSaveAs($Workbook,"C:\desktop\($sResult).xls"   )
  next
  _Excel_Close($oExcel,true,true)
EndIf

[Nine]

Please use this tool when you are posting code.

Try this :

_Excel_BookSaveAs($Workbook,"C:\desktop\" & $sResult & ".xls")

 

[ilona]

It works !!! Many, many thanks!!!!!