Interesting. Thanks fore the info, much appreciated. We will give this a shot.

So this one is a little odd. We have an automation that opens an Excel file and refreshes the data in the file. The data is pulling from a SharePoint list that we have linked to a table. The automation works fine, but when it kicks off the refresh of the data, Excel asks for us to choose an account ...

Perfect, this was incredibly helpful!

Got it! Thanks for the clarification there. So with that out of the wy and values being returned. I am stumped on another issue that seems like it should work. For the first part of IF statement I am trying to write all values of the first line in the array to a new file. The code instead returning ...

Hello, I am trying to figure out how to return the column values in an array. I am using the CSVtoArray function to create the array from an existing file, but I am unable to return the column values. The overally purpose of this automation is to take the fields in the array and create a new file ba...

I am trying to figure out a way to have a macro send me an email if the macro fails or hangs for a certain amount of time and I am really not sure how to do this, or if it can be done. Any help would be appreciated.

Hi there, We just moved over our licensed copy of Macro Scheduler from a server to a laptop as we were having some server related issues. I was able to compile EXEs no problem on the server, but using it on the laptop, I am getting an error. The error is "Cannot compile due to incomplete installatio...

Perfect this worked, thanks again!

I was just informed that we are looking to do this with Outlook as well, is there any setting similar to Google that I need to change somewhere to get it to work? I have the macro set up with all of the correct info for Outlook, but that is not working.

That did it. Appreciate the help!

I am trying to send a simple email message when a script completes. I am using Gmail and have tried the format of the example in the help docs. I still Cannot get this to work, and I am not sure what I am missing. Let>SMTP_AUTH=1 Let>SMTP_USERID=xxxxx@gmail.com Let>SMTP_PASSWORD=xxxxx Let>SMTP_PORT=...