Lets assume that a new spec was created. AutoPLANT has a very clever structure to its files so that the core ones that come with AutoPLANT need not be touched. It also helps when new specs, ebs, classes etc. are added (specs beyond just adding or changing dB rows). This article outlines how to integrate a new component where a new class was created. There is already an article which outlines how to create a ‘new spec’ (a complete one which includes class/ini sections, ebs files and mdb rows) to do this AND there is an article that outlines how that last article was figured out, so that you too can do find out more complicated classes like joints etc. for yourself.
Lets assume that you have all your files / edits ready to go. A pseudo and realistic example is at the bottom. Continue reading
Here is some discussion on a one to many join that needs the many side to return ONE row – the latest one. Also in this article are many links to the related items. It took about an hour to find solutions without a sub-select. Sub-selects are VERY popular – could this be because they are easier to understand and more logical? Many articles still claim that sub-selects are slower especially when there is no correlating field between the sub-select and the outer select statement.
The following code prompts for a full path or press E to invoke a dialog window typical to Microsoft to choose a “Save As” style windows path. Eventually an Excel file path that is fully valid and vetted will result.
Here are 2 basic ideas wrapped within eachother
a) Outer: Is there a valid filename (valid string) or did the user cancel (False),
b) Inner: Go get the filename via command line or optional dialog window – this might give garbage- hence, the above line has “valid”
Note we can ONLY do this because you already using the Excel libraries as you are writing an Excel file with this path. There is equiv. commands without this cheat.
You want to make your code contain TestVettedExcelName style code – then you can use the Functions with no issues.
Dim name As Variant
name = GetVettedExcelName
If name = False Then
' something went wrong
MsgBox ("No file selected or path is not valid")
MsgBox ("the name is: " & name & "and is a valid string")
Publishing Paypal buttons or other HTML code into your wordpress blog works great the first time, but upon subsequent saves, it can be downright frustrating because the HTML you pasted into the HTML view gets changed. With a simple abstraction using a snippet tool/plugin like HTML Snippet (XYZ Html), the code you intended can stay right in the article each time.
Watch this Youtube Video – it was written for one of my customers. But the basics are:
- In Paypal, make a paypal button & copy the button’s HTML code
- In you wordpress blog’s HTML Snippet (aka XYZ Html), copy the code and give the snippet a unique name
- Paste into your blog or article, the snippet tag/line/code (copy and paste it from the list of snippets)
- Publish your blog or article