Jump to content
Sign in to follow this  

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

Recommended Posts

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")
         MsgBox(0, "", "You chose " & $result)


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

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...