Hi Folks, As the title says, I'm running into a problem with a .xlsm file that is called from my script. I've tried using ExecuteFile, RunProgram, and the XLOpen functions and each time the file launches but then encounters an error as it runs. If I run the xlsm file directly or from another schedul...

Hi Folks, I'm simply trying to SetFocus to an existing instance of Outlook. No luck. I tried ensuring I was running MS as Admin, still no luck. I've tried IfWindowOpen, FindObject with UIClick, and WindowAction. I continue to be unsuccessful. Why am I having such a hard time setting the focus or mak...

I've got the python part covered, what I need to learn in MS is reading and copying array values to a file of my choosing. Update: Here's my solution... CapsOff Label>HEADER ReadFile>C:\py\header.txt,header PutClipBoard>header Run>Notepad.exe WaitWindowOpen>Untitled - Notepad SetFocus>Untitled - Not...

Hi Folks, I'll start by saying I've never worked with an API before and I'm sure there are more advanced ways of handling my problem but I myself and not that advanced. That being said I'm using MS to build the file framework but I need to account for multiple items to be processed in the same file....

that's a good question... so can I simply say today-1?
edit:
yes, yes I can...
GetDate>today
DateAdd>today,dd,-1,strDate
MessageModal>%strDate%

brilliant, thank you so much!

I'm getting closer but can't figure out why the following produces a date formatted as mm/d/yyyy. When I run the same code and comment out 'Let>dd=dd-1 the result is proper at mm/dd/yyyy. Why does subtracting 1 from the date remove the leading zero? How and I fix this? Press Enter Month>mm Day>dd Ye...

Hi Folks,
I have the following code returning 06/03/2002 & 06/03/0201, respectively. If I run it again I get a completely different set of dates.

DayOfWeek>dow
GetDate>the_date
Sub>the_date,{%dow%-1}
SetFocus>Report Options
Send> %the_date%
Press Tab
Send> %the_date%

What am I doing wrong?

Thanks for the idea Marcus. But I'm not sure that's the right way to go... So I'm trying to work with TeamViewer to remote into a PC and perform a few clicks or tabs to accomplish running and saving a report. To that end I'm working with a free version of TeamViewer and at the end of a session (not ...

Hi Folks, I'm looking to build a solution whereby I check a folder via a unc path and take the newest file and import it into excel. The file in questions will be a .csv file BUT the delimiter is a semicolon (I have no control over that). Not sure if that complicates things. I've been playing around...

Given to me by JRL and modified to suit my specifics... basically I use this to check if quickbooks is open and if it is I close it before opening clean. If it's not open the script simply opens it. hope this helps. Let>Looptimes=0 Label>CheckQuickBooks ProcessExists>QBW32.EXE,vQuickBooksRes If>vQui...

Try adding %title% to your modal message so you know what title is actually being captured.

I didn't think of that thanks! I guess all the nesting did was confuse the issue. Yeah, the Repeat does have an Until.

And thanks for the vote of competence

Hi Folks, I'm back at it and trying to figure out where I went wrong with this block of code. What I'm trying to accomplish is checking the resulting window for one of two results. Either way I want the text of that windows captured and written to a file. What I'm getting is both scenarios being ass...

I've got a GetActiveWindow with an If>title= working and returning the expected message but can I nest an If statment inside another If statement?

So I've got WriteLn happily logging my current file name and date/time of process.

Now how do I seek out and act upon one of two possible message windows that can open... WaitWindowOpen or GetFocusedObject with an if/then doesn't seem to be doing the trick... I wonder what will.