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...
