update
 

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?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=561051

update
 

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

update
 

Add this in your macro:
Workbooks(name of workbook you want to close).Close False

Best
Petter


ceemo skrev:


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?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=561051