opening another workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need a code that will open workbook [Commission.xls] and update the link
automatically. then when user is done. close the workbook without saving it.

thank you in advance
 
Hi
try
workbooks.Open filename:="c:\temp\Commission.xls", UpdateLinks:=3
 
You must log in or register to reply here.

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

Excel Protection 2
Open Referenced Add In Workbook as Read Only 5
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Opening a list of Excel files and run a macro in each 17
Excel 2013 menubar incompatibility? 1
All Workbook Saved except This Workbook - Part2 3
Why do charts disappear? 2
closing another file by code causes failure to run workbook activate event 2

Back
Top