We help IT Professionals succeed at work.

Update Links

110 Views
Last Modified: 2014-08-18
Hi,

Im trying to update my links on workbook opening

so in the thisworkbook object, on open, i have the below sub, i am getting the error message

"Application defined or object defined" error

What is the error?

Thanks

Private Sub Workbook_Open()
Dim AWB As String

AWB = ActiveWorkbook.FullName

ActiveWorkbook.UpdateLink Name:=AWB, Type:=xlExcelLinks
End Sub

Open in new window

Comment
Watch Question

Finance Analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2016
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Ron, passes this spreasdheet onto other users, so cant guarantee that they will have links auto updating

Rgonzo, i stuck that in the editor and was still asked to update links on entry....
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Doing it by macro - can't guarantee that other users will enable macros.

Either way, you still have to rely on user clicking the Enable Content button.

Thanks
Rob

Author

Commented:
All users do have macros enabled....

Author

Commented:
Ive went to town with protection, ive turned my options on as above to enable updates and im still getting a warning message!

Private Sub Workbook_Open()

ActiveSheet.Unprotect ("football")


Application.AskToUpdateLinks = False
Application.DisplayAlerts = False



    Dim blnSUpdating    As Boolean
    
    With Application
        blnSUpdating = .ScreenUpdating
        .ScreenUpdating = False
    End With
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

Application.ScreenUpdating = blnSUpdating

Application.DisplayAlerts = True
Application.AskToUpdateLinks = True


ActiveSheet.Protect ("football")


End Sub

Open in new window

Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
Where are you putting the Workbook_Open sub?

It has to be on the ThisWorkbook module.

Thanks
Rob
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
I guess we are looking at the order that things are processed when a workbook opens.

1)Update Links
2)Workbook_Open Sub

or

1)Workbook_Open Sub
2)Update Links

As the Update Links is a General Option, ie at application level and not Workbook specific, I suspect it does this check first then once the Workbook is open it will run the Workbook_Open routine.

Thanks
Rob H

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.