Sign in to follow this  
Followers 0
Ivako

excel and file path

6 posts in this topic

Hi everyone

I am a Newbie in AutoIt and autoit forum .

I am playing with autoit and spreadsheets.here is example what I have done so far

#include"ExcelCom.au3"
$asd = InputBox ("Payroll","Enter your Payroll number")

$filepath = "D:\spreadsheets\"*I want here put $asd vlue*".xls"
_XLpaste($FilePath"xls",1,"a",1,"It Works",1)
Exit

And i want to chose a xls file by inputing name of file in inputbox

Thanx in advance and sorry for bothering

Share this post


Link to post
Share on other sites



Will the following work? Try it out and let me know :)

#include"ExcelCom.au3"
$asd = InputBox ("Payroll","Enter your Payroll number")

$filepath = "D:\spreadsheets\"&$asd &".xls"
_XLpaste($FilePath"xls",1,"a",1,"It Works",1)
Exit

A decision is a powerful thing

Share this post


Link to post
Share on other sites

It is Working

Thank YOU

Share this post


Link to post
Share on other sites

Hello friend... I'm also very new to this AutoIT... I installed the very new Version3. But i could not be able to find the excel related help from this "Help" files.... Could you pls guide me about this... i had gone through all other functions and i understood... Because of that i'm not able to automate the testing for my applications.... actully i want to automate the web applications by connecting with the excelldata-scripts-testresults and all....

Could you pls guide me to get correct...

Thanks

Manickam

Share this post


Link to post
Share on other sites

Manickam start a new question and post your code :whistle:


Start here if you are new Valuater's AutoIT 1-2-3Looking for an UDF - Look hereDo you need to do it twice - Autoit

Share this post


Link to post
Share on other sites

Hello friend... I'm also very new to this AutoIT... I installed the very new Version3. But i could not be able to find the excel related help from this "Help" files.... Could you pls guide me about this... i had gone through all other functions and i understood... Because of that i'm not able to automate the testing for my applications.... actully i want to automate the web applications by connecting with the excelldata-scripts-testresults and all....

Could you pls guide me to get correct...

Thanks

Manickam

Where could i get the help infromation about the "ExeclCum.au3" header file informations and where can i get information for excel related info with the AutoIT

Manickam :whistle:

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  
Followers 0