• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

File Select within Macro (1 Viewer)


Registered User.
Local time
Today, 14:14
Sep 18, 2002
I have a macro that uses ImportExportSpreadsheet option, but the file is hardcoded. Is there a way, within the macro, to open a select dialog box to allow me to select a file. I know I can be done with VBA just didn't know if there was a way within the Macro.



I’m here to help
Staff member
Local time
Today, 11:14
Oct 29, 2018
Well, maybe you could use VBA to open the file dialog and then save the user's selection into a macro variable. Other than that, I am not sure how else you might do it. Let's hope others will have a better idea.

Users who are viewing this thread

Top Bottom