Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB Script to copy incremental data from one sheet of workbook to o | Excel Discussion (Misc queries) | |||
keeping formula the same in a workbook when adding a row to one sh | Excel Worksheet Functions | |||
Update a workbook from a script | Excel Discussion (Misc queries) | |||
Button/Script to create a new workbook from a current one. | Excel Worksheet Functions | |||
"Urgent" use script to share the workbook | Excel Discussion (Misc queries) |