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: 3
Default can i use VBA in one XLS file to change VBA in another?

hi all:

i have a bunch of XLS files that have VBA code in them that have
already been sent out to another consultant (all are hospital
specific) and i was notified earleir today that a "button" on one tab
does not work

i verified that it does not work (had forgot to update the assigned
macro to reflect new tab names)

so ... i was hoping to send out a very simple XLS file w/ just one
macro inside it ... and have the other consultant simply call that
macro from within each of the hospital specific XLS file to change the
undering macro to make the button work as designed

can i do that? .... am at a loss so far (i've done other "fix" XLS
files, but those changes were always to the workbooks proper, changing
formulas, etc.

thanks in advance

 
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
How to change closed file name - Error: file not found PGM Excel Programming 5 April 18th 06 02:07 PM
2 users open same file and both can edit/change the file RANDY Excel Discussion (Misc queries) 1 January 24th 06 04:06 PM
How do I change *.CSV excel file to column seperated file? Pankaj Excel Discussion (Misc queries) 2 July 5th 05 07:35 PM
How to change a MS Word file to an Excel file Sameera Excel Worksheet Functions 1 June 28th 05 08:57 PM
How do I change file/open/"files of type" to default to "all file. How do I changefiles of type default Excel Discussion (Misc queries) 1 April 19th 05 10:45 PM


All times are GMT +1. The time now is 08:00 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"