Share via

Macro Open External Folder or File

Anonymous
2021-09-19T18:14:12+00:00

Hi,

I want to make macro:

  1. Macro open External Folder only
  2. Macro open External File only

please help me.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-09-19T18:30:16+00:00

    You can simply use

    Application.FollowHyperlink ""

    Where you can replace YourFullPath with things like

    C:\Temp

    C:\Temp\TestFile.xlsx

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-09-19T22:26:31+00:00

    Just for a second voice here, I too do not know of any way to do this without the power of VBA.

    Was this answer helpful?

    0 comments
  3. George Hepworth 22,855 Reputation points Volunteer Moderator
    2021-09-19T21:56:02+00:00

    Sooner or later everyone who works with Access encounters a situation where Macros no longer provide adequate support for the tasks you must accomplish.

    You are, it would seem, at that point. It's time to explore VBA procedures, starting with the one Daniel offered.

    Was this answer helpful?

    0 comments
  4. ScottGem 68,830 Reputation points Volunteer Moderator
    2021-09-19T21:18:10+00:00

    Macros are limited. There is no facility in macros for directly interfacing with Windows. If they still won't let you use VBA then you can't do it.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2021-09-19T18:43:01+00:00

    Hi,

    I did not see it in Macros? kindly can you help me plz

    Was this answer helpful?

    0 comments