Jump to content
Sign in to follow this  
tonysing

How to create a new excel file at a targeted destination path?

Recommended Posts

tonysing

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 !

Share this post


Link to post
Share on other sites
November

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]

Share this post


Link to post
Share on other sites
water

Welcome to Autoit and the forum!

Which version of AutoIt do you run?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
tonysing

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.

Share this post


Link to post
Share on other sites
water

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 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×