Time stamp upon refresh

I just discovered a great new trick (thanks to JEC) to refresh queries remotely using VBA. My problem is that on the workbook, I have a cell with a NOW() formula. I rigged it in a way so that cell also gets refreshed when I Refresh All, therefore showing me the last time of refresh. Unfortunately when I refresh the workbook remotely via VBA, that cell does not show today's date (probably b/c I did not actually open workbook). So an accurate timestamp can not be rendered.

What is a VBA code to get NOW() date and time that works even if a workbook does not open? Really I need a timestamp when last refresh occurred via VBA.......

thanks

This one to place it in Z1

Please Login or Register  to view this content.

It keeps me struck on 3rd line (.Sheets(1).Cells(1, 26).Value = Now).
Sheet(1) refers to first sheet or name of sheet? Close 1 refers to sheet 1?

Yes, you can change sheets(1) to sheets(“your sheet name”)