+ Reply to Thread
Results 1 to 6 of 6

Using msofiledialogpicker, for wb name (subscript error)

  1. 09-08-2021, 12:32 PM #1
    immigrated4urjob
    immigrated4urjob is offline
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Question Using msofiledialogpicker, for wb name (subscript error)

    Objective: use fFile variable, using FileDialog propert,y to extract column E in sheet 1 to another workbook. 

    Please Login or Register  to view this content.
    Note: changed file to workbook, but still failed.
    Attached Files Attached Files
    Last edited by immigrated4urjob; 09-08-2021 at 12:36 PM.
    Reply With QuoteRegister To Reply
  2. 09-08-2021, 04:36 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Using msofiledialogpicker, for wb name (subscript error)

    You have to open the file first. A workbook is in the collection Workbooks only if it is open.

    By the way I have no idea what is the csv file you attached.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 09-08-2021, 05:26 PM #3
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,523

    Re: Using msofiledialogpicker, for wb name (subscript error)

    Stringjazzer was faster but I had this waiting for you while I went for lunch.
    Change references as and where required.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 09-15-2021, 09:41 AM #4
    immigrated4urjob
    immigrated4urjob is offline
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Re: Using msofiledialogpicker, for wb name (subscript error)

    Thanks helped.
    Reply With QuoteRegister To Reply
  5. 09-15-2021, 10:10 AM #5
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Using msofiledialogpicker, for wb name (subscript error)

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.
    Reply With QuoteRegister To Reply
  6. 09-15-2021, 12:08 PM #6
    immigrated4urjob
    immigrated4urjob is offline
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126
    Quote Originally Posted by 6StringJazzer View Post
    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon Attachment 747816 below their name.

    I dodnt know yow to do it lol. Thanks for pointing.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error code "run time error 9: subscript out of range
    By iBennett93 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 06-28-2021, 05:03 AM
  2. [SOLVED] Excel VBA set a filter for a exact filename using MsoFileDialogPicker
    By Keebellah in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-07-2020, 04:10 AM
  3. [SOLVED] Help with error run-time error '9" (subscript out of Range)
    By thong127 in forum Excel General
    Replies: 7
    Last Post: 05-02-2018, 02:17 PM
  4. [SOLVED] Run-time error '9': subscript out of range - error occurs on multiple computers except one
    By BrettE in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2014, 11:19 PM
  5. Defining Array - Runtime error 9, Subscript out of range error
    By MaartenW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-03-2012, 07:32 AM
  6. Subscript out of range error - save copy error
    By bg18461 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2006, 11:53 AM
  7. Type Mismatch error & subscript out of range error
    By Jeff Wright in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2005, 03:06 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1