+ Reply to Thread
Results 1 to 12 of 12

list excel files when a folder is selected

Hybrid View

Aishashk list excel files when a... 04-12-2013, 04:31 AM
arlu1201 Re: list excel files when a... 04-12-2013, 04:36 AM
Aishashk Re: list excel files when a... 04-12-2013, 05:23 AM
arlu1201 Re: list excel files when a... 04-12-2013, 05:26 AM
Aishashk Re: list excel files when a... 04-12-2013, 05:36 AM
arlu1201 Re: list excel files when a... 04-12-2013, 05:40 AM
Aishashk Re: list excel files when a... 04-12-2013, 05:42 AM
arlu1201 Re: list excel files when a... 04-12-2013, 05:44 AM
Aishashk Re: list excel files when a... 04-12-2013, 05:51 AM
arlu1201 Re: list excel files when a... 04-12-2013, 05:57 AM
Aishashk Re: list excel files when a... 04-12-2013, 06:14 AM
arlu1201 Re: list excel files when a... 04-12-2013, 07:08 AM
  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    13

    list excel files when a folder is selected

    I have worked on macros but not at a advanced level. Now i have been asked to do the following and need help

    1. list down all excel files if a folder is selected by a user. i have created the browse button which takes me to browse folder whre i can select a folder.also created a fetch command button to fetch files

    all i dont know is how to list down excel files in the excel sheet.pls helpShow trimmed content

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: list excel files when a folder is selected

    See if this file helps you. You will need to edit it to suit your needs.
    Attached Files Attached Files
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    04-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: list excel files when a folder is selected

    if i send u the file, will u be able to make the changes

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: list excel files when a folder is selected

    Its not my code but i can try. Upload it here.

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.

  5. #5
    Registered User
    Join Date
    04-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: list excel files when a folder is selected

    i have attached the file. tehre is some error i ma getting pls cehck

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: list excel files when a folder is selected

    Are you getting the error while attaching the file? I dont see any attachment here.

  7. #7
    Registered User
    Join Date
    04-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: list excel files when a folder is selected

    send me ur mail id and i will send teh attachment to u

  8. #8
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: list excel files when a folder is selected

    Sorry, thats not allowed as per forum rules. Why dont you upload it directly onto your post?

  9. #9
    Registered User
    Join Date
    04-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: list excel files when a folder is selected

    i am not able to upload the file here.pls help me

  10. #10
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: list excel files when a folder is selected

    Are you getting any error while uploading? How big is the file?

    Also, are you using the basic uploader or enhanced uploader? (Click on Settings at the top of your page, click on General Settings).

  11. #11
    Registered User
    Join Date
    04-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: list excel files when a folder is selected

    when i click on manage attachment and select files. it does nto show me my files in the browse folder. can u pls mail me on kishwar_shaikh@syntelinc.com

  12. #12
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: list excel files when a folder is selected

    Try uploading a screenshot of your system, so i can help you.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1