Power Query

[Domroy]

I have a query that's connected to a file that's supposed to automatically every day. Today, for some reason (not my issue), the file wasn't there, but my query didn't tell me the file was missing. Can I flag the query so that if the file is missing it alerts me?

Thank you!

Judi

 

[Domroy]

Totally not your fault! It's a big file, with a lot of other macros, and my work computer can't handle it. They've ordered me a developer system so I'll be able to do more coding and manipulation of data...but it honestly *may* have to wait until that shows up before I can do anything more with the document.

But I WILL, and I'm grateful for your help!

 

[sandy666]

You are welcome and good luck