why not use a water based RP? This can be easily cleaned off and will provide better corrosion protection that an iron phosphate line. The chances are that the RP he wants to cut with xylene will be a lot harder to clean than a synthetic RP
Or use safety solvent (142 flash solvent) and cut...
I just tried this by modifying your code and the original file name stays open! Not sure what you mean by location
ActiveWorkbook.SaveCopyAs NewFileName
ck1999
Contact Heatbath. They are the leader in manganese phosphate in the industry. Or contact your supplier. Have you checked:
Free Acid
Total Acid
Iron Content
ck1999
electricpete,
if you click on the module name and then click on the properties icon in the toolbar at the top (or hit f4) it will display the properties window and the only property is name
ck1999
You can look using enzymes to reduce the starchs and COD you will need a holding tank for this to work. I have heard they are very effective in cardboard facilities
ck1999
See if this helps it uses vba and make more work but hopefully it will help you
Sub FixAllPies()
Dim pie As ChartObject
Set pie = ActiveSheet.ChartObjects("Chart 1")
With pie.Chart.SeriesCollection(1)
.Points(1).Format.Fill.Patterned msoPatternLightHorizontal...
To clarify this is excel 2007. Thanks to Microsoft for all the changes jk . I tried a pie chart and you no longer have the options you did with previous editions of excel.
GeoPaveTraffic maybe you might want to label your pieces numericall and then have them ontop of your pie pieces and then...
Our group is based off of some managers and some representatives. Usually production manager and employee where issue occurred, maintenance and quality manager or representative.
ck1999
You could use this code in the report workbook
Sub getinfo()
Dim wb As Excel.Workbook
Dim sh As Excel.Worksheet
wbname = ActiveWorkbook.Name
Set wb = Workbooks.Open("\\server\network\data.xlsx")
Set sh = Worksheets("sheet1")
valuewanted = Range("B" &...
Our company uses a CA team. This team is made up of QA, maintenance and production.
This team works for us. It has been effective by thinking about the problem from differnt points of views.
If production management does not care about QC then it will be hard to get employees consciousness...
Do you have any other code? What about your before or after update options is there any code listed in them? There has to be other code somewhere.
ck1999
My understanding of your question states that you would like to perform a calculation in the row that corresponds with todays Date. And then when tomorrow occurs. The product of todays equation will stay in the cell. If this is correct I would like at putting a macro in the workbook.open...
Try this
Private Sub DrawScales()
dblDistTick = frmProfile.txtDistTick.Value
dblElevTick = frmProfile.txtElevTick.Value
Dim dclicks
Dim eclicks
Dim counter
Dim yloc
dclicks = (frmProfile.txtDistMax.Value - frmProfile.txtDistMin.Value) / frmProfile.txtDistTick...
if they are always groups of 5 then
assuming data in column a
sub helping()
dim jarray(100,5) ' Will do 100 sets
dim keepgoing as boolean
keepgoing=true
' Replace the 1 with whatever line the data starts in
counter2=1
for counter =1 to 1000 step 6
jarray(counter2,1) = range("a" &...
Powder coating is applied to galvanized surfaces all the time. You can either use an ironphosphate which slightly etches the zinc coating and allows for better paint adhesion or look at using a zinc phosphate. But this is regularly done in the metal finishing industry.
ck1999
I think you may want to reduce the titration to about 10 - 12mL. In both of the stages. If you have to high of a concentration you will tend to over phosphate.
Also If you use a White paper towel and whipe the parts off if the residue is yellow then it is phoshate if its red it it rust.
Why...
We do not use color as an indication there is a test method ISO 3892 that explains how to calculate coating weights.
Another easy method is
Take a panel that has been phosphated
1. Immerse in acetone.
2. Then dry with hot forced air (hairdryer or something similar)
3. Weigh using an...
