ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatic update of code in other workbook (https://www.excelbanter.com/excel-programming/291583-automatic-update-code-other-workbook.html)

Tony C[_2_]

Automatic update of code in other workbook
 

I wish to send a fix to a friend, which will require me
remotely importing some new code into a specific place in
a module and removing some old code.

Can somebody give me a bit of a clue?

Thanks

Tom Ogilvy

Automatic update of code in other workbook
 
Have a look at Chip Pearson's page

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Tony C" wrote in message
...

I wish to send a fix to a friend, which will require me
remotely importing some new code into a specific place in
a module and removing some old code.

Can somebody give me a bit of a clue?

Thanks




Alan Hutchins

Automatic update of code in other workbook
 
Not sure if you can replace specific parts or not, but I
do know that you can import code, and replace code.

Best place to see an example of this is:

www.erlandsendata.no/english/

It's very good - just type 'Module' into it's search

HTH

Alan
-----Original Message-----

I wish to send a fix to a friend, which will require me
remotely importing some new code into a specific place in
a module and removing some old code.

Can somebody give me a bit of a clue?

Thanks
.



All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com