How to find file path in specific folder by cell data and get this path in Excel cell.

K

knaabis

Active Member
Joined
Apr 25, 2006
Messages
254
Office Version
  1. 2013
Platform
  1. Windows
How by cell A1 data find file with this name from specific folder and insert in cell B2 hyperlink of this file.
1590669650641.png
 

Attachments

  • 1590669586947.png
    1590669586947.png
    2.1 KB · Views: 3

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

P
  • Solved
VBA to open file using Cell for the path
Replies
4
Views
579
Peter Davison
P
J
  • Question
VBA Script - Can't figure out one error...
2
Replies
15
Views
232
Peter_SSs
Peter_SSs
F
  • Question
Convert a OneDrive path to the local path
Replies
2
Views
387
FryGirl
F
P
  • Question
Delete File or Folder VBA Issue
Replies
4
Views
396
Domenic
D
M
  • Question
VBA search for specific file name in folders and their subfolders
Replies
7
Views
816
Candyman8019
C

Forum statistics

Threads
1,214,834
Messages
6,121,873
Members
449,056
Latest member
ruhulaminappu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top