accessing file created in different macro within the same project

[Mbrolass]

Hi,

In one module I have created a file, say 'intel.dne', which I need to access in another module in the same project. I've tried using "public" statement but it does not work and I have to save the file once created and then access it via inserting the complete file path in any macro I create which needs to access it. This cause problem with the portability of the excel program and the run time needed to complete the program.

Another issue with this method is that any changes implemented in any module, after the file has been saved, are not carried forward to future runs in other macros. Each macros opens the original saved version.

Does anyone have any suggestions?

[Mbrolass]

Please help, I still have no idea how to do this.

Thanks,

Mbrolass

[Mbrolass]

Hi,

does any one have any ideas of how to do this?