LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 141
Default keeping VBA script with a workbook

I have written a VBA script that is very specific to a workbook. I have no problems running the VBA script on my machine, but when I give the excel.xls file to another user by copying it to their machine, the VBA script tries to open another workbook. When the user opens the copy of the .xls file all the data is fine. They then run the script via a menu button and it seems to be attempting to open the original workbook on my machine rather than the workbook in session, which is an exact copy of the workbook on my machine. How can I share the workbook and the VBA script together since they are dependant on each other?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
VB Script to copy incremental data from one sheet of workbook to o Samarth Excel Discussion (Misc queries) 1 May 25th 10 11:58 AM
keeping formula the same in a workbook when adding a row to one sh jcrowe Excel Worksheet Functions 1 May 28th 09 05:24 PM
Update a workbook from a script [email protected] Excel Discussion (Misc queries) 1 March 8th 06 02:30 PM
Button/Script to create a new workbook from a current one. downer Excel Worksheet Functions 0 February 17th 06 09:09 PM
"Urgent" use script to share the workbook man Excel Discussion (Misc queries) 1 August 17th 05 02:09 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"