Sign in to follow this  
Followers 0
afzalw

Basic: Paste stored value in a dialog box titled "Open" ?

3 posts in this topic

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

Share this post


Link to post
Share on other sites



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

 

 

 

Share this post


Link to post
Share on other sites

I used Send keys instead for copy and pasting from excel to dilog box.

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