Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > BOOK: Excel 2003 VBA Programmer's Reference
|
BOOK: Excel 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Excel 2003 VBA Programmer's Reference by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg, Brian Patterson; ISBN: 9780764556609
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2003 VBA Programmer's Reference 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 December 21st, 2006, 02:50 PM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel 2003 VBA - Need to open a workbook in a fold

I have two Excel 2003 workbooks in a folder. The first opens automatically and runs until it is done and then it calls the second workbook to open. Apparently this requires that I hardcode the full path for the second file (at least, that is what I've had to do to get it to work). As long as the files run on my computer, this works fine. My problem is that when I've finally finished with these files, they are to be stored zipped into a folder on a SharePoint server to be downloaded by anyone who needs them to be run on their computers.

This is where my grand strategy falls to pieces. The zipped folder is downloaded to a different computer and extracted. Once the first file is opened, everything works until the second workbook is called. The second workbook cannot be found and an error stops the whole shebang. I've tried truncating the address to C:\(the folder both files live in)\(name of second workbook file). That doesn't work either.

Is there a way to make this work using relative addresses intead of absolute addresses?

Any help would be greatly appreciated.

Barbara





Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 workbook name qualifier AveryB Excel VBA 1 December 17th, 2007 10:41 PM
Excel 2003 VBA Function RollingWoodFarm Excel VBA 15 August 2nd, 2006 04:24 PM
FTP Upload from Excel 2003 VBA Jersey Eric Excel VBA 3 January 5th, 2006 09:29 AM
excel 2003 vba book xeugx Excel VBA 3 June 27th, 2005 11:35 PM
Excel Workbook created from Access VBA clueless_may Access VBA 0 June 8th, 2004 09:42 AM





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