2005-06-24, 04:22 #1
- Join Date
- Jan 2001
- Brisbane, Queensland, Australia
- Thanked 0 Times in 0 Posts
Display xlUpdateLink dialog (VBA/Excel/2003)
I have tried the following code to programattically open the Edit Links dialog box in a workbook that has external links. I need the user to click on a form button to open it so that the user can then use the Open Source command button to see the linked file and data.
I have tried
but get the 'Run-time error '1004' message.
What should I be doing or what am I missing?
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2005-06-24, 08:05 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: Display xlUpdateLink dialog (VBA/Excel/2003)
The arguments xlDialogChangeLink and xlDialogUpdateLink never seem to work Instead, try