Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > BOOK: Excel 2003 VBA Programmer's Reference
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 21st, 2006, 02:50 PM
Registered User
 
Join Date: Nov 2006
Location: , , .
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 08:37 AM.


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