Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
11
Views
Topic starter
Hello,
Let's say I have a sheet with A1 cell having value as "1" and I have a folder having file 1.xlsx. Can I write a code such that the name of the file will be selected from a given reference cell and the file corresponding to that name automatically opens up and I don't have to browse individually.
Please assist.
Posted : 13/09/2020 2:03 pm
Hi,
Try this
Workbooks.Open Range("A1").Value & ".xlsx"
Regards
Phil
Posted : 13/09/2020 7:05 pm