ceemo wrote:
I am exporting some information from a workbook into my open work
book. the macro opens the other workbook inserts a date which is
calculated and returns the outcome into my original book.

The problem is that when i open the closed book it updates a now()
function and when i close it, it asks if i want to save the book,
which i dont?

can i get around this?

You can use something like this:

ThisWorkbook.Saved = True

or

ActiveWorkbook.Saved = True


Check for Saved on VBA on line help.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy