danial
Board Regular
- Joined
- Apr 29, 2006
- Messages
- 107
Sawasdee,
Help me please
I want to create vba code for open file from the server.
but the above code is not work. It's can't open file.
I try with code is can open file.
actualy I want to open many files.
I need to create code for set path one time only
any idea pls share.
tnx in advance
Help me please
Code:
ChDir "\\Thh01fil103\scth005f\IRONMAN"
Workbooks.Open Filename:="IRONBASE.xls"
Sheets("SXF").Select
but the above code is not work. It's can't open file.
I try with code is can open file.
Code:
Workbooks.Open Filename:=""\\Thh01fil103\scth005f\IRONMAN\IRONBASE.xls"
actualy I want to open many files.
I need to create code for set path one time only
any idea pls share.
tnx in advance