+ Reply to Thread
Results 1 to 6 of 6

click the open button in the windows file dialog box "Choose file for upload"

  1. #1
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    click the open button in the windows file dialog box "Choose file for upload"

    Hi all,

    I keep running in the wall with the button that needs to be clicked in internet expolorer when you choose a file for upload.
    I can manage to put the file name with the whole path, but I can't manage to click the button to upload "open".
    Any ideas how I can do this? (send keys does not work at all)

    Any help to get that button clicked would be really welcome.

    Greetings.

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: click the open button in the windows file dialog box "Choose file for upload"

    Hi all,

    I found the below link, but can't make it to work with my code. It keeps telling me that there is no file extension in C:\test

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=1146

    Any clue what I'm doing wrong?

    Greetings.

  3. #3
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: click the open button in the windows file dialog box "Choose file for upload"

    Hi,

    according the code it says that test.txt should contain the full path of the file that you wish to upload.
    Please Login or Register  to view this content.
    test.txt will contain text something like this C:\myimages\mypicture.jpg
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  4. #4
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: click the open button in the windows file dialog box "Choose file for upload"

    Hi,

    I still get the error. No mather what changes I make.
    I guess that it really hard to work with the windows dialog boxes. i'm sure there should be a solution for it, but this drives me nuts.

    Greetings.

  5. #5
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: click the open button in the windows file dialog box "Choose file for upload"

    Hi,

    I get actually the error when I get to:
    Please Login or Register  to view this content.
    The run time error 424 object requiered and the Windows Script Host: There is no file extension in C:\

    Where do I go wrong?

    Greetings.

  6. #6
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: click the open button in the windows file dialog box "Choose file for upload"

    Hi,
    I got it finally working. Just a stupid typo in the code :-)

    Greetings.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 10-08-2014, 03:16 AM
  2. Replies: 4
    Last Post: 04-05-2014, 08:53 AM
  3. Replies: 0
    Last Post: 04-09-2013, 04:29 AM
  4. VBA - IE - click on "Open" in an internet explorer "file download" window
    By victoire in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2013, 07:08 AM
  5. How to change file type to "All Files (*.*)" in excel 2007 open dialog box
    By snowball in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-21-2012, 05:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1