A Late night lazy general question sharing code ??
Hi;
Just looking for some pointers. I am sharing my data remotely with a friend. I have managed to get that organized without much difficulty. However, while he adds and alters the spreadsheet's data. I would like to continue to work on the VBA coding and provide updates and improvements in the code. My question is, how would I go about making code changes on my copy of Excel and then download the code and install it in his copy of the workbook? If someone can give me some general directions, I'll dig into the process in the morning. Regards Bill |
A Late night lazy general question sharing code ??
Right click on a module in the project explorer, then choose Export
He can import the new module after deleting the existing module using the same procedure. -- Regards, Tom Ogilvy "Bill Case" wrote in message ... Hi; Just looking for some pointers. I am sharing my data remotely with a friend. I have managed to get that organized without much difficulty. However, while he adds and alters the spreadsheet's data. I would like to continue to work on the VBA coding and provide updates and improvements in the code. My question is, how would I go about making code changes on my copy of Excel and then download the code and install it in his copy of the workbook? If someone can give me some general directions, I'll dig into the process in the morning. Regards Bill |
A Late night lazy general question sharing code ??
Hi,
Just adding a little , try to use this code to automatically export : Sub export() ThisWorkbook.VBProject.VBComponents("Module1"). _ export "C:\module1Copy.bas" End Sub -- Regards, Halim "Bill Case" wrote: Hi; Just looking for some pointers. I am sharing my data remotely with a friend. I have managed to get that organized without much difficulty. However, while he adds and alters the spreadsheet's data. I would like to continue to work on the VBA coding and provide updates and improvements in the code. My question is, how would I go about making code changes on my copy of Excel and then download the code and install it in his copy of the workbook? If someone can give me some general directions, I'll dig into the process in the morning. Regards Bill |
A Late night lazy general question sharing code ??
I am sorry guys. It's so simply. I guess it really was a lazy question.
Reagrds Bill "Bill Case" wrote: Hi; Just looking for some pointers. I am sharing my data remotely with a friend. I have managed to get that organized without much difficulty. However, while he adds and alters the spreadsheet's data. I would like to continue to work on the VBA coding and provide updates and improvements in the code. My question is, how would I go about making code changes on my copy of Excel and then download the code and install it in his copy of the workbook? If someone can give me some general directions, I'll dig into the process in the morning. Regards Bill |
All times are GMT +1. The time now is 04:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com