Hi Folks, I'm working with two XML files which I can read into a variable but once I have the data into one variable I'm not sure how to break it out into individual variable that I can work with (adding certain vars, doing other math, etc). My code is basic so far simply because I'm not sure where ...

Hi Folks. So I'm running into an issue with certain scripts not completing due to a variety of different reasons. All the scripts in question begin by opening a website. Sometimes that website will have an informational pop-up that when acknowledged once, will never again appear. Other times the pag...

Perfect, thank you very much! I had a feeling there was a way to handle it properly. I tried combinations of single and double quotes thinking perhaps that was the solution to my problem. Is there a list of these system variables compiled somewhere for reference?

Hi Folks, I'm working on adding email directly from my macro and I want to add a comma in the HTML body. Currently I'm not able to get it to work in-line. If I say Let>body=Sincerely, and reference the variable it works. But if I try in the SMTPSendMail command directly it does not. I'm assuming it ...

Hi Folks.

Can someone tell me if this is possible or do I have to drop my entire macro into my script in order for it to perform its operations on my spreadsheet?

For anyone who's interested, here is my final code which ensures my start date is always two Monday's prior, and my end date is the previous day. This is for a routine which will be running Tuesday through Sunday. It could probably be prettier but it works. :D //Previous Monday *2 //What day of the ...

My bad... my dates in my example should read as follows... Tuesday 11/8 was run from 10/31 through 11/7 Wednesday 11/9 was run from 10/31 through 11/8 Thursday 11/10 was run from 10/31 through 11/9 But I see where you are going with this. I'll probably have to wrap this in a lunch of if statements b...

Hi Folks. I'm working on a new script and I have to account for data parameters. Quite simply, the start date needs to be the previous Monday, and the end date needs to be the day prior. This will run 5 (possibly 6) days a week. So taking this weeks runs for example... Tuesday 8/8 was run from 10/31...

That's what I get for staring at it for too long. -Thanks JRL

Hi Folks. Continuing along in my quest, I'm currently looking to compare the newest file date in a given folder to the today's date. To test I have the following... Month>varMonth Day>varDay Year>varYear GetNewestFile>T:\d1\d2\*.csv,strFileName FileDate>%strFileName%,dFileDate Let>dateCheck=%varYear...

That's why... I'm F8 testing and my variables are set way at the beginning of my script about 600 lines back. I knew it was right under my nose. Thank you!!

Hi Folks. I'm not sure what's wrong with this... Month>varMonth Day>varDay Year>varYear ... CreateDir>S:\dir\dir2\dir3\%varMonth%-%varDay%-%varYear% I literally get a folder named %varMonth%-%varDay%-%varYear%. I use those over and over in my code but am only having a problem with them using CreateD...

Perfect, thanks so much!

Hi Folks,

I know there is a function to retrieve the newest file in a folder but is there a way to find the newest subfolder within a folder?

Thanks mighty. I've tried RP_ADMIN=1 and I've tried it with RunProgram. I know the file exists and only have this issue when launching from the macro. I've managed to work around it by adding a bit of code to a form load event... Dim pic As String pic = "T:\Drop-Images\Attached\no-image.jpg" If Len(...