Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Create a command button to Browes for file

    I want to create a command button that will allow me to browes my c:drive folders.

    Currently, I have code that will import a spreadsheet. At present, the spreadsheet file name is HARD CODED into the macros "Transferspreedshhet acimport, 3, filename...." you get the picture. Subsequesntly if the spreadsheet file name I want to import changes I have to update the macro with the new file name.

    My goal is to be able to create a button, much like a browes button, that will allow me to search for the file I want to import, select it, and then insert that file name into my macro code.

    Is this an attainable goal



    any advis would be appreciated

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  3. #3
    Join Date
    Feb 2009
    Posts
    2

    Thanks

    Thanks for the reply
    I got it to work

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad I could help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Duplicate command button
    By brettg in forum Database Design
    Replies: 1
    Last Post: 08-04-2008, 04:16 AM
  2. Command button code
    By lfolger in forum Forms
    Replies: 3
    Last Post: 03-25-2008, 04:26 PM
  3. Command button for time & date
    By joet5402 in forum Forms
    Replies: 2
    Last Post: 12-20-2007, 02:59 AM
  4. command button to filter a subform issue -
    By countdrako in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 11:58 PM
  5. Open a linked subform with a command button
    By flablueeyedblond in forum Forms
    Replies: 0
    Last Post: 11-18-2005, 01:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums