Open specific workbook

L

Li Jianyong

Dear Sirs,

I want to program an addin to my excel to open a workbook named
"Prod_01.xlsx". and I will share this addin with my colleagues,they have same
file in their computer,but kept in different path. so I thin my macro should
always find the workbooks("Prod_01.xlsx") firstly, then open it.Anybody can
provide these code?

thanks advancely.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
forcing specific sheet opening upon launch of .xlsx file 4
MS Query 7
Activate workbook using partial name 5
move worksheet to end of another workbook 7
ADOBE Connection to open Excel workbook 3
Hotkey in proper workbook 2
Macro to open file and copy information from worksheet 1

Top