Workbook open event

  • Thread starter Thread starter G Lam
  • Start date Start date
G

G Lam

Hi, I have a price master sheet (2MB) in the server and a lookup sheet in
every workstation. When the lookup sheet loading up, it takes two minutes to
link to the master sheet. I am thinking of copying this master file from the
server to the workstation every time when users load up the lookup sheet.
How can I do this?
Thank you.
GL
 
GL

Put this in every workbook at the workstation. (Change the name and location
of the Price master of course)

Private Sub Workbook_Open()
Workbooks.Open Filename:="F:\Shared\Price Master.xls", UpdateLinks:=True
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Nick,
Thank you. That helps.
After the files opened, the active sheet is the Price Master.xls. How can I
switch it to the lookup sheet instead?
Thank you.
GL
 
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

Lookups - how to obtain data from a master spreadsheet into another 5
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to Compile Data from Different Sheets 2
Macro to copy specific data from master workbook to another workbook 13
Merge Multiple workbook sheets into one workbook 0
Autohide rows based on formula in another sheet 0
copy and paste data only to a new file 1
Linking Worksheets 1

Back
Top