Euro5
asked on
VBA open file from excel cell
The existing code opens a csv file from desktop where path is hardcoded.
I would like to use an excel cell instead, to make it dynamic.
Current code
Set wb = Workbooks.Open("C:\users\5 42323\desk top\Surcha rge Data.csv")
How do I change the path to open from
Sheets("Selection") Cell("K:28")
I would like to use an excel cell instead, to make it dynamic.
Current code
Set wb = Workbooks.Open("C:\users\5
How do I change the path to open from
Sheets("Selection") Cell("K:28")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!!
you are welcome.
Open in new window