Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 16th, 2007, 06:57 AM
Registered User
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default MS Excel - File Links - VBA

I am in the process of creating a ms excel application that links to another ms excel workbook.

Using ms office 2003, the worksheet that contains the links is protected.
Thus far I have written some vba that unprotects the worksheet, but, I need some help with the code that enables the user to change the file links by using the Edit>Links dialogue and then once the changes have been made, i.e. they have changed the linked source, protects the worksheet contents again.

Old July 23rd, 2007, 10:48 AM
Registered User
Join Date: Jul 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

I am working on a very similar project. Anyone has any idea? Barnsley, were you able to solve it? If any one can share any idea or code, would be much appreciated. Thanks.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run a MS DOS Batch file from Excel VBA Louh Excel VBA 1 March 4th, 2008 10:02 PM
Calling MS Access vba function via Excel Kourosha Excel VBA 0 December 31st, 2007 08:33 AM
Saving HTML popups using VBA in MS Excel Sureshsbe VB How-To 0 June 16th, 2007 02:40 AM
Update links in excel file Wall st Guru Excel VBA 2 December 11th, 2006 05:09 AM
Links to MS Excel Worksheets Dudester Classic ASP Basics 0 June 7th, 2003 02:08 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.