Stuart_Wales

Worked it out. Please ignore above. However, the below "unhide all tabs", if anyone could assist me with what this code means by steps:   Private Sub UnHideAllTabs()     Dim arrSheet     ReDim arrSheet(Sheets.Count)     For iIndex = 1 To Sheets.Count          arrSheet(iIndex) = Sheets(iIndex).Name     Next     For iIndex = 1 To UBound(arrSheet)         Worksheets(arrSheet(iIndex)).Visible = True     Next End Sub

Hi all, I'm trying to update an old document generation tool that someone has built in excel via Visual Basic code. Whilst I have experience in PLC & HMI programming, this is new to me. However, I have managed to crack the passwords with help via excel and to the point where it's not letting me "save as" with a custom message. I've found the message, and believe I've found the code preventing me from saving... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True MsgBox arrLanguage(30, 2) End Sub Can someone please talk me through it (every day is a school day) and then, how can I bypass. Disclaimer - there is absolutely nothing exciting past this document, so no ethical misconduct haha, it's a isolation placard generator that has masses of admin (which will save me a heap of time) that needs updating. This thread may grow.... Thanks in advance.

Can someone please confirm/deny the following: The attached photo has the command     [$MOV           "tring Part Number"      D4156"]   Now does that throw in whatever is in the "   ", as a block starting with D4156, or is it just a comment that is ignored as it's in "  "? I am changing a laser mark print from Part Number to Part No to give myself a larger marking area for longer customer part numbers. The ASCII data transfer has me head scratching. Thanks in advance,  

Also, not to hijack.... I've been told that MX Sheet is old tech. What is the modern day software which would mimic MX Sheet

I'd be interested in this aswell. The e-screens this was in the e-designer/HMI software. Examples we've had delivered to site have been in the PLC program. Which I've had to change in one occasion as it didn't work.  

Thank you

haha 100% a college question right here.

Hi Gambit, what do you mean by C24 module?

See photo, I've used the help feature but it's not helping much..... Especially the ">SFLD 3" command? Code is linked to a 12 character ASCII input from HMI (which I am extending length to 16 characters), and then sent to a laser controller to mark a part.

Thanks mate. I am on there Thursday to test the triggers etc.

Hi Mate, Can you get me an image of your PLC address mapping on the Keyance software? I've understood your PLC program, and it's a massive help, but a few things will be confirmed if I see what you have set your plc registers to in the Keyance set up page.

Sorry, it'll be using a Mitsi Q Series PLC.

The courses are very good, I can't comment on 15/20 years ago.. but all support is free (24 hours) as long as you have a licenced bit of software. Also, once you complete all courses, or fancy your chances, you have the option for £85 one off payment to do a 'Certified Engineer Exam' which by the sounds of it, is a 1 off payment. I wasn't made away of any yearly packages after that, however certified engineer status isn't really a benefit for me.  

We completed the Mitsubishi training last week, and it was VERY much worthwhile. Me and my colleague both came away with the full intent to use it in the future. There are loads of little extras to standard ladder, especially when drawing lines etc. And then the function blocks are handy for mass repeat of certain sections of ladder. It's very user friendly, but has subtle differences which we wouldn't have known without doing the course. I have no doubt someone could sit and learn structured from ladder, but you'll need to apply a lot of time and manual reading - that is a luxury we don't have where I work.   Anyone UK based, I FULL recommend the 2 day structured course which is based in the Mitsi Electrics Euro Headquarters in Hatfield.

What's the best method to retro fit a test that will detect the presence of a 31 to 35 ohm (range) resistor and then fail a 0.4ohm variant at 13.4v D/C. Thanks.