Using data from different module

[swav_one]

Hi all,

My situation is as follows:

module1 - makes changes to the excel spreadsheet
module2 - makes changes to the excel spreadsheet
module3 - makes changes to the excel spreadsheet

module4 - inserts text into access database memo field.


Modules 1-3 concern seperate operations and each of these operations should be recorded in access database by using module4.

I could just paste the code from module4 into each of the prior modules but i was wondering how could I connect these together.

How can a string defined in module1,2,3 be used in module4 which should execute once module1,2,3 operations are compleate?

Please help,

Slawek

[Leith Ross]

Hello swav_one,

Declare your string as a Public variable in any one of the four modules. Place the declaration above any Sub or Function procedures in the module.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[swav_one]

Hello swav_one,

Declare your string as a Public variable in any one of the four modules. Place the declaration above any Sub or Function procedures in the module.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Well I tried ... :

Please Login or Register  to view this content.

But I get a compiler error: invalid attribute in Sub or Function. Debuger highlights the "Public" deffinition.

Did I get it wrong?

[Leith Ross]

Hello swav_one,

This is how the module should look...

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel

Sincerely,
Leith Ross

[swav_one]

Thank You Thank You Thank You!