Full Version: Macro question for Carl

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]
 27 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-7  8-16

Back to thread list | Login

© 2024 Project Beehive Forum