+ Reply to Thread
Results 1 to 9 of 9

Open file from a folder and assign that file to an Object variable

  1. 06-21-2012, 08:44 AM #1
    pratyu
    pratyu is offline
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    15

    Open file from a folder and assign that file to an Object variable

    Hi all!!

    I need a code in Excel vba to open a folder, select a file from that folder and assign that file to a variable (obj1 As Object type)


    Please help!!

    Thanks in Advance
    Last edited by pratyu; 06-22-2012 at 02:52 AM.
    Reply With QuoteRegister To Reply
  2. 06-21-2012, 09:31 AM #2
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Open file from a folder and assign that file to an Object variable

    Try this,

    Please Login or Register  to view this content.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files
    Reply With QuoteRegister To Reply
  3. 06-21-2012, 09:58 AM #3
    Kyle123
    Kyle123 is offline
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Open file from a folder and assign that file to an Object variable

    To expand a little on Dave's suggestion:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 06-21-2012, 10:59 PM #4
    pratyu
    pratyu is offline
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Open file from a folder and assign that file to an Object variable

    Thanks to Dave & Kyle for the quick replies.
    But, I have a different problem...

    The code should give an option to SELECT ANY file from a folder and assign it to a variable of Object type....


    Sorry for the ambiguity in my thread.!

    Please help!
    Reply With QuoteRegister To Reply
  5. 06-22-2012, 01:51 AM #5
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Open file from a folder and assign that file to an Object variable

    Maybe the msoFilepicker,

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 06-22-2012, 01:57 AM #6
    pratyu
    pratyu is offline
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Open file from a folder and assign that file to an Object variable

    Hi Dave!!

    This code is working but somehow the files aren't shown in the folder!!

    Any other thing to be added?
    Reply With QuoteRegister To Reply
  7. 06-22-2012, 02:04 AM #7
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Open file from a folder and assign that file to an Object variable

    Try this

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  8. 06-22-2012, 02:11 AM #8
    pratyu
    pratyu is offline
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Open file from a folder and assign that file to an Object variable

    I've mistyped the file extension name...
    I've corrected that and it worked...!! Thanks a lot!!
    Reply With QuoteRegister To Reply
  9. 06-22-2012, 02:11 AM #9
    pratyu
    pratyu is offline
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Open file from a folder and assign that file to an Object variable

    Thanks a lot royUK... it worked!!
    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)

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