Hi,

I have a document that runs periodically a macro to treat data that a
collect from an external device.
I want to save this new data in a woorkbook withou the macro.
How can I do that?

Thanks in advance

Rui

Hi, Rui. Something like this might help:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=359

*******************
~Anne Troy

www.OfficeArticles.com


"Rui Álvares" wrote in message
...
Hi,

I have a document that runs periodically a macro to treat data that a
collect from an external device.
I want to save this new data in a woorkbook withou the macro.
How can I do that?

Thanks in advance

Rui

Hi Rui,

If the data is held in one worksheet "Data" (say) and the VBA code is in a
standard module, then

Sub CodelessWorkbook()

'Create a new singlesheet workbook
ThisWorkbook.Sheets("Data").Copy

'Save and name the new workbook
ActiveWorkbook.SaveAs "NewFileName"

End Sub

Change Data to your sheet name.

---
Regards,
Norman



"Rui Álvares" wrote in message
...
Hi,

I have a document that runs periodically a macro to treat data that a
collect from an external device.
I want to save this new data in a woorkbook withou the macro.
How can I do that?

Thanks in advance

Rui