-
Posts
4,247 -
Joined
-
Last visited
-
Days Won
63
Cory last won the day on August 29
Cory had the most liked content!
Contact Methods
-
MSN
cory@bluepointdesign.com
-
Website URL
http://bluepointdesign.com
-
Skype
cory_jackson
Profile Information
-
Gender
Male
-
Location
Fallbrook, CA
-
Interests
Making money by helping people save money!
Recent Profile Visitors
1,679 profile views
Cory's Achievements
-
MX Creative Console Has anyone tried one of these with MEP?
-
I've never had a problem with the date format order. Can you give me an example? And why can't you use the "Choose a Date/Time Format from the Date/Time command, Operation dialog? A few tricks too. It's been a while and I don't have time to test them out now, but one can be tricky by using only part of the format. IE type or convert the same Date/Time variable by "YY" then another like "MM". I mean imagine doing the command twice or more but only doing the month or other portions. Imagine right now I created a DT variable and had it type it out or save it to a variable with "dd". Only "28" would be output. Reverse Date String This is an old article I wrote you might find interesting. I'm not sure if it's relevant anymore.
-
MXE files: unexpected behaviour
Cory replied to terrypin's topic in Macro Express and Macro Express Pro
6.6.4.1 I tried it and it play the macro. I'm not sure what could be causing that for you. I would check the file extension association. Maybe it got associated with the MEP installer instead of MEP? What happens if you use the command line to launch MEP with a parameter to open that file? What happens when you double click on an MEX file? I can't think of anything else. Sounds like a matter for ISS support. Good to see you again. -
VMs are tricky and not ideal for MEP where GUI interaction is needed. But most times it will work as long as the user is active, has the client window visible and focussed in the client software on the client machine. You see if the VM decides no one is there, many events, controls, and maybe more, go into a state of suspension. I suppose to conserve resources. I've had it before when the user would have the VM app open on one screen and then was doing Facebook or whatever in the client machine in another window, and whenever the VM client app lost focussed, things would go haywire. One thing I found that would often help using any kind of RDP client software like Remote Desktop is to connect to the console session. By default an RDP session will connect to a remote session. There was a command-line parameter to connect to the console session. That's the session a local/normal user connects to. See here a better description. It will likely be different for your service. Another thing I used with great success many years ago, was VNC. It is simpler and doesn't interact at the control/signal/message level like good RDP or VM client software, instead it transmits all of the visual data graphically and emulates the actual keyboard and mouse commands like a user sat at the console session. This crudeness was a blessing for MEP macros. I don't know if it will connect to a VM. Doubtful. Many years ago I had a big client which was a hospital and was running my macros to port data from a billing system to a medical system and back. We could only get it to work reliably with a real computer and VNC. So they grabbed about 20 old outdated surplus retired machines from the IT desktop support department, put them on rolling wire racks in a old supply room, and ran them 24/7. It was humorous to watch them all running. Seemed silly, but it was cheap and effective.
-
One of the limitations of MEP is it's designed for one prompt, one variable. Often we need a simple form. However I will say when it gets to that point, it should be a program and not a macro. But I'll toss out some ideas. Have me write a simple WinForm program for you which you can use with controls from MEP. It takes me no time to do this. There's a post here from long ago of using forms in active MHT files. Prompt for text in multiline but pre-fill it with things like "Start date: " and another line "Finish date: " and then manipulate the text in MEP to get the desired dates. But you need to make sure and validate the user input carefully. I've written many simple programs that are a springboard for macros, user interface, or are an extension. For instance i created one that takes a string and executes RegEx on it and outputs tabular data. This way MEP can benefit from RegEx, something not native, easily using the Windows Controls commands in MEP. Imagine it being like Windows Calculator where MEP can access math functions not available natively.
-
You description is verbose, but I'm still left with a vague understanding of what the environment is and what exactly you're doing, and those details would greatly affect how I would approach the job. This is the kind of thing I do professionally and I never get it by the potential client explaining in a message. One reason is the writer often has context already in their mind and doesn't realize that I don't have the some contextual understanding. Second is that often the client has already made up on their mind what for the solution shoudl take despite that usually not being the best way because they don't understand the full capabilities of MEP or other tools. EG I often find that users automate from a table in Excel using arrows and clipboard, when it would be better to link that table to a tab delimited file and link the spreadsheet to that file instead so that the Macro can use ASCII file process. I recommend taking my up on a free consultation. There's no obligation at you're likely to learn some things that will benefit you at no cost. Another would be to break this down into parts I can understand and help you with here. I agree with what rberq suggested. I also think this might be something that would be better as a set of macros that either trigger each other or has a master macro that drives them. Also easier for development.
-
Compare date of file to today
Cory replied to TomTmilk's topic in Macro Express and Macro Express Pro
You are welcome. I'm glad it works. -
Compare date of file to today
Cory replied to TomTmilk's topic in Macro Express and Macro Express Pro
<DATE/TIME Flags="\xB0" Date="2024-09-23 17:30:00" Day_Offset="0" Month_Offset="0" Year_Offset="0" Hour_Offset="0" Minute_Offset="0" Second_Offset="0" Left="Center" Top="Center" Monitor="0" Variable="%Now%" IsDateVar="TRUE"/> <CONVERT DATE/TIME TO DECIMAL Source="%Now%" Dest="%dNow%"/> <VARIABLE MODIFY DECIMAL Option="\x06" Destination="%dNow%" Variable="%iNow%"/> <VARIABLE MODIFY INTEGER Option="\x05" Destination="%iNow%" Variable="%dNow%"/> <CONVERT DECIMAL TO DATE/TIME Source="%dNow%" Dest="%Now%"/> DateTime is a decimal essentially so I often resort to converting it to that for manipulations. The time you want to compare to is today at 0000 hour. Here I convert it to decimal, truncate it to integer because I can't see how to round down, and then convert it back to decimal, and set the time variable %Now% to it. Then you can use the Variable Set From File to save the files date using "To Date Var" and compare if it's less than %Now%. Probably use a better name for that variable or add another name like BeginningOfDay%. I couldn't decide it this was better or not to extracting the day, month, and year as integer, and building a DateTime variable with those. I kinda like the math way better, so that's what I showed. -
Compare date of file to today
Cory replied to TomTmilk's topic in Macro Express and Macro Express Pro
I'm checking something now on the best way to round down.Which time do you want to to compare? EG creation, modified, or last access? -
Compare date of file to today
Cory replied to TomTmilk's topic in Macro Express and Macro Express Pro
Do you have a question? -
Also know you can link to delimited text files in Excel. The macro can do things there and instead of moving around in Excel and posting, you just refresh the query and "BAM!" there it all is. Often you have to reference the data in the right spot however. Also with the F5 Go To you can paste ranges you build in MEP with tabs and newline sets.