Hi again,
I have developed a workbook that other people use on their machines, and
when any modifications are to be made I send out a separate workbook
containing VBA code to do the changes. The problem I have is that I cant
change any of the code within the remote workbooks.
Is there a way I can use vba to change vba?
Any help greatly appreciated
John

Hi John,

See Chip Pearson's VBE programming page at:

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

---
Regards,
Norman



"JohnUK" wrote in message
...
Hi again,
I have developed a workbook that other people use on their machines, and
when any modifications are to be made I send out a separate workbook
containing VBA code to do the changes. The problem I have is that I cant
change any of the code within the remote workbooks.
Is there a way I can use vba to change vba?
Any help greatly appreciated
John

I would suggest that you look at isolating the code from the data, and
create an add-in for the code which you can distribute.

--
HTH

Bob Phillips

"Norman Jones" wrote in message
...
Hi John,

See Chip Pearson's VBE programming page at:

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

---
Regards,
Norman



"JohnUK" wrote in message
...
Hi again,
I have developed a workbook that other people use on their machines, and
when any modifications are to be made I send out a separate workbook
containing VBA code to do the changes. The problem I have is that I cant
change any of the code within the remote workbooks.
Is there a way I can use vba to change vba?
Any help greatly appreciated
John