Hi everyone,
How can I open the workbook through vba from desktop with a single click?
Thanks for your time for looking.
Regards,
Vikas
Hi everyone,
How can I open the workbook through vba from desktop with a single click?
Thanks for your time for looking.
Regards,
Vikas
Yes Vikas, With the help of macro & on a Button click you can open any workbook from any folder...
Regards
Parth
I appreciate your feedback. Hit * if u Like.
Rules - http://www.excelforum.com/forum-rule...rum-rules.html
[code]
Dsktop_dir="C:\Documents and Settings\User\Desktop" 'change this
ChDir Dsktop_dir
Workbooks.Open Filename:= _
Deshtop_dir & "\ Your file .XLS"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks