Forum

workbook.open not w...
 
Notifications
Clear all

workbook.open not working

2 Posts
2 Users
0 Reactions
60 Views
(@chatmenot85)
Posts: 1
New Member
Topic starter
 

Dear all,

Any body can help me for below VBA code.

Workbooks.Open ("ThisWorkbook.Path & " "abc.xlsx") this code not working.

 
Posted : 19/08/2021 6:15 am
(@jstewart)
Posts: 216
Estimable Member
 

I believe it is this part in red:

Workbooks.Open ("ThisWorkbook.Path & " "abc.xlsx").

You would need to change it to

Workbooks.Open (ThisWorkbook.Path & " abc.xlsx"), I do believe.

I'm just learning though and peruse this thread to learn, so someone may need to fact check me on this!

 
Posted : 19/08/2021 11:37 am
Share: