tonysing Posted August 13, 2014 Share Posted August 13, 2014 Hello guy, I am a new user of Autoit and encounter some question when writing a script I want to read the file in a selected folder, record down file name, modified time etc. and write these data into a newly create excel file. Here is how I do it now _ExcelBookSaveAs($oExcel,$ScriptPath) Sleep(1000);To allow the excel file save properly and ready to move FileMove($ScriptPath,$DestPath) This method works. But I want to create the excel file at the $DestPath directly. Function FileWrite and FileOpen seems help, but I am not really clean of how to use them. Can anybody give me a example? Thanks a lot ! Link to comment Share on other sites More sharing options...
November Posted August 13, 2014 Share Posted August 13, 2014 Hi and welcome, Why not this? _ExcelBookSaveAs($oExcel,$DestPath) Cheers Old Scriptology Visual Ping 1.8 - Mass Ping Program with export to txt delimited. Desktop 2 RGB and YMCK - Pick a color in the desktop and get the RGB and YMCK code. Desktop 2 RGB - Pick a color in the desktop and get the RGB code. ShootIT 1.0 - Screen Capture full and partial screen [font="'Arial Black';"]Remember Remember The Fifth of November.[/font] Link to comment Share on other sites More sharing options...
water Posted August 13, 2014 Share Posted August 13, 2014 Welcome to Autoit and the forum! Which version of AutoIt do you run? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
tonysing Posted August 14, 2014 Author Share Posted August 14, 2014 ver : 3.3.8.1 November: As my $DestPath is not at the same directory with my script, so I want to find a better way to save the file. Link to comment Share on other sites More sharing options...
water Posted August 14, 2014 Share Posted August 14, 2014 What's the value of $Destpath? The 3.3.8.1 Excel UDF is a bit picky about this parameter. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now