Results 1 to 2 of 2

Thread: Using file selection for data query function

  1. Oct 24th, 2005, 03:33 AM #1
    tohkl
    tohkl is offline

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    3

    Using file selection for data query function

    Hi everyone,

    I would like to enquire if anyone know how to write a micro that allows the user to select the file for data query function instead of a fixed file everytime you run a micro?

    Thanks very much.

    Best regards
    KL
    Reply With Quote Reply With Quote
  2. Oct 24th, 2005, 03:58 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Using file selection for data query function

    What application?

    VB ->
    common dialog active x?
    api calls

    VBA (Excel/Access?) ->
    application.FileDialog (msoFileDialogFilePicker).Show <<--- read the help files
    api calls / common dialog

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width