afzalw Posted April 15, 2013 Posted April 15, 2013 I have this basic code which read cell in an excel file and I am assuming that it stores it in $sCellValue, now how do I paste this data in a Window tittled "Open" in a software ? Local $sFilePath1 = @ScriptDir & "\Master File.xlsm" ;This file should already exist Local $oExcel = _ExcelBookOpen($sFilePath1) _ExcelSheetActivate($oExcel,"Part B") $sCellValue = _ExcelReadCell($oExcel, 2, 1) Basically I have all paths of files that I want to open in a single column of excell, and I want to open each file so I am trying to copy each path from excel file and Paste it in Open dialog box. Also, is there is any simpler way ? Thanks for any help
GreenCan Posted April 15, 2013 Posted April 15, 2013 Not really sure what you want to do but does this help? #include <Excel.au3> Local $oExcel = _ExcelBookNew() ;Create new book, make it visible _ExcelWriteCell($oExcel, "C:\Program Files", 1, 1) _ExcelWriteCell($oExcel, "C:\Windows", 2, 1) _ExcelWriteCell($oExcel, "C:\Windows\System32", 3, 1) _ExcelWriteCell($oExcel, "C:\Users", 4, 1) Local $sCellValue, $result For $i = 1 To 4 ;Loop $sCellValue = _ExcelReadCell($oExcel, $i, 1) ConsoleWrite($sCellValue & @CRLF) $result = FileOpenDialog("Open Excel", $sCellValue & "\", "Excel (*.xlsm)", 1 + 4) If @error Then MsgBox(0, "", "No File(s) chosen") Else MsgBox(0, "", "You chose " & $result) EndIf Next Contributions CheckUpdate - SelfUpdating script ------- Self updating script Dynamic input validation ------------------- Use a Input masks can make your life easier and Validation can be as simple MsgBox with CountDown ------------------- MsgBox with visual countdown Display Multiline text cells in ListView ---- Example of pop-up or ToolTip for multiline text items in ListView Presentation Manager ---------------------- Program to display and refresh different Border-less GUI's on a Display (large screen TV) USB Drive Tools ------------------------------ Tool to help you with your USB drive management Input Period udf ------------------------------ GUI for a period input Excel ColorPicker ---------------------------- Color pickup tool will allow you to select a color from the standard Excel color palette Excel Chart UDF ----------------------------- Collaboration project with water GetDateInString ------------------------------ Find date/time in a string using a date format notation like DD Mon YYYY hh:mm TaskListAllDetailed --------------------------- List All Scheduled Tasks Computer Info --------------------------------- A collection of information for helpdesk Shared memory Demo ----------------------- Demo: Two applications communicate with each other through means of a memory share (using Nomad function, 32bit only) Universal Date Format Conversion -------- Universal date converter from your PC local date format to any format Disable Windows DetailsPane -------------- Disable Windows Explorer Details Pane Oracle SQL Report Generator ------------- Oracle Report generator using SQL SQLite Report Generator ------------------- SQLite Report generator using SQL SQLite ListView and BLOB demo ---------- Demo: shows how binary (image) objects can be recognized natively in a database BLOB field DSN-Less Database connection demo --- Demo: ActiveX Data Objects DSN-Less Database access Animated animals ----------------------------- Fun: Moving animated objects Perforated image in GUI --------------------- Fun: Perforate your image with image objects UEZ's Perforator major update ------------- Fun: Pro version of Perforator by UEZ Visual Crop Tool (GUI) ----------------------- Easy to use Visual Image Crop tool Visual Image effect (GUI) -------------------- Visually apply effects on an image
afzalw Posted April 15, 2013 Author Posted April 15, 2013 I used Send keys instead for copy and pasting from excel to dilog box.
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