Full Version: Macro question for Carl

From: Carl (CSEWELL) [#6]
 26 Jan 2007
To: laserman (MIKEMAC) [#5] 26 Jan 2007

Yes, all of that is possible. I haven't verified it all but I don't see any problems.

The CorelDraw file would be used as the icon on the desktop which should open when the operator double clicks on it. The macro would execute (Corel will have to be configured for this.... a couple of steps) and insert the date in the desired format. It could be hard-coded, ie it would always place the date in the position specified by the macro, or it could look for a specific string to replace or an object name to be replaced.

It's not going to be totally foolproof. They are making fools way too good these days..........

From: Shaddy [#7]
 26 Jan 2007
To: Carl (CSEWELL) [#6] 26 Jan 2007

If they're always using a template of sorts, same pieces in the same place, and the text boxes are already set up and formatted, you can just use the Name feature of the object (change the name of the text box to something like TodaysDate), then set the new selection to everything with that name, then change the text value.

That frees them up to add to that template and move everything around. And if they don't want the date in a particular item anymore, they just rename it to something different.

Shaddy

From: laserman (MIKEMAC) [#8]
 26 Jan 2007
To: Carl (CSEWELL) [#6] 26 Jan 2007

Carl,

I hear that! the method of hard coding it would be the best that way no one would have access to change it and screw things up.

If you would like to take on this challenge Please send me a pm and I will be sure to compensate you for your efforts.

Thank you!!

From: Carl (CSEWELL) [#9]
 26 Jan 2007
To: Shaddy [#7] 26 Jan 2007

quote:
That frees them up to add to that template and move everything around.


And totally screw up everything!! ;^)

Yes, ideally that would be nice and can be done, but once you give someone that 'freedom', you are free to become the end of that word. I worked in manufacturing for far too many years.........

And, besides, if you give them all that flexibility, they won't have to come back to you for macro changes! ;^)

From: laserman (MIKEMAC) [#10]
 26 Jan 2007
To: Shaddy [#7] 26 Jan 2007

Shaddy,

This will be on going for years these parts are injection molded and are required to have a date engraved onto everyone the dates will stay the same for the run ie start at 8:00 am on 1-26-07 and end at 5:00 on 1-26-07 everything that is produced during that time frame must have a date code of 12607. When they come in the next morning 1-27-07 everything molded on that day must have a new date code (12707).

This is why we want to automate it to change the date code using the computer clock.

The parts will always be in the same location and the date code will always be in the same position.

We have had special fixturing machined and mounted to the laser so that the robotic arm will insert and remove the molded parts automatically this is already done its now just a matter of changing the date code automatically

From: Harvey only (HARVEY-ONLY) [#11]
 26 Jan 2007
To: laserman (MIKEMAC) [#10] 26 Jan 2007

Some of the older programs I used had the ability to insert a code that put in today's date. I cannot find it in Corel X3. Bad to have that feature omitted.

From: Dave Jones (DAVERJ) [#12]
 26 Jan 2007
To: Harvey only (HARVEY-ONLY) [#11] 26 Jan 2007

A feature like that would have to not only insert the date automatically, but allow a full custom date format in order to meet the non-standard format he needs.

From: Carl (CSEWELL) [#13]
 26 Jan 2007
To: Dave Jones (DAVERJ) [#12] 26 Jan 2007

That's a fairly standard format. Most commercial software allows you to specify date fields in an MMDDYYYY format. VBA supports that also.

From: Dave Jones (DAVERJ) [#14]
 26 Jan 2007
To: Carl (CSEWELL) [#13] 26 Jan 2007

Well the VBA Format() funtion can certainly format date strings to user specs, but I was thinking more about the built in current date string that a lot of programs provide. Most of those that I've seen only offer standard US and European date formats.

From: Carl (CSEWELL) [#15]
 26 Jan 2007
To: Dave Jones (DAVERJ) [#14] 27 Jan 2007

If you want to get down to the system level, Windows operating systems allow you to specify the date format (as in mmddyyyy, or whatever) that application software will use for the default, provided they are using operating system calls to get the date, of course. It surprised me that that functionality existed in Windows.

From: logojohn [#16]
 26 Jan 2007
To: laserman (MIKEMAC) [#10] 29 Jan 2007

quote:
12607


Couldn't that be 1-26-07
or 12-6-07
Might help to field fill with zeros
012607
120607

Show messages: All  1-5  6-16

Back to thread list | Login

© 2025 Project Beehive Forum