Hi
I would like to move my standard modules from the current form (as it is too
large to email) and paste it into an empty workbook which will only be used
for holidng and running the code.

Can someone please advise how I go about doing this.

I dont want the workbook with the code to be visible so users are not aware
it is being used but I do want it to be availble for the original workbook to
refer back to run the module of codes.

Any help would be greatly appreciated.

thanks
Noemi

Hi,

I use public variable to retrieve data after I run a macro...
So if in one Application (excel) I can retrieve the data...

Try to use public variable
--

Regards,

Halim


"Noemi" wrote:

Hi
I would like to move my standard modules from the current form (as it is too
large to email) and paste it into an empty workbook which will only be used
for holidng and running the code.

Can someone please advise how I go about doing this.

I dont want the workbook with the code to be visible so users are not aware
it is being used but I do want it to be availble for the original workbook to
refer back to run the module of codes.

Any help would be greatly appreciated.

thanks
Noemi

Halim

Can you please provide further clarification as I am not quite clear on what
to do.

Thanks
Noemi

"Halim" wrote:

Hi,

I use public variable to retrieve data after I run a macro...
So if in one Application (excel) I can retrieve the data...

Try to use public variable
--

Regards,

Halim


"Noemi" wrote:

Hi
I would like to move my standard modules from the current form (as it is too
large to email) and paste it into an empty workbook which will only be used
for holidng and running the code.

Can someone please advise how I go about doing this.

I dont want the workbook with the code to be visible so users are not aware
it is being used but I do want it to be availble for the original workbook to
refer back to run the module of codes.

Any help would be greatly appreciated.

thanks
Noemi

Export the module, FileExport in the VBIDE, and mail that file.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Noemi" wrote in message
...
Halim

Can you please provide further clarification as I am not quite clear on
what
to do.

Thanks
Noemi

"Halim" wrote:

Hi,

I use public variable to retrieve data after I run a macro...
So if in one Application (excel) I can retrieve the data...

Try to use public variable
--

Regards,

Halim


"Noemi" wrote:

Hi
I would like to move my standard modules from the current form (as it
is too
large to email) and paste it into an empty workbook which will only be
used
for holidng and running the code.

Can someone please advise how I go about doing this.

I dont want the workbook with the code to be visible so users are not
aware
it is being used but I do want it to be availble for the original
workbook to
refer back to run the module of codes.

Any help would be greatly appreciated.

thanks
Noemi