Can any body convert tis VB code in Java,
' quotation Macro
' Macro compiled 15 March 2002 by Syed Raza Haider
'
' Keyboard Shortcut: Ctrl+q
'
' ***************** UNPROTECTION OPERATION *****************
Sub quotation()
Sheets("Quotation").Select
Range("A1").Select
ActiveSheet.Unprotect
Sheets("Plan Features").Select
Range("A1").Select
ActiveSheet.Unprotect
Sheets("Census").Select
Range("A1").Select
ActiveSheet.Unprotect
Sheets("Hospitalisation").Select
Range("A1").Select
ActiveSheet.Unprotect
Sheets("Maternity").Select
Range("A1").Select
ActiveSheet.Unprotect
Sheets("Outpatient").Select
Range("A1").Select
ActiveSheet.Unprotect
Sheets("Outpatient - Family").Select
Range("A1").Select
ActiveSheet.Unprotect
Sheets("Critical Illness").Select
Range("A1").Select
ActiveSheet.Unprotect
Sheets("Major Medical").Select
Range("A1").Select
ActiveSheet.Unprotect
' ***************** DATABASE UPDATION *****************
Sheets("Quotation").Select
ChDir "C:\Documents and Settings\hammad\Desktop\New Folder"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Table_pa.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_CA.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_CB.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_CC.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_CD.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_CE.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_CF.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_CG.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\plan_cil.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_HA.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_HB.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_HC.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_HD.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_HE.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_HF.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_HG.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\plan_hos.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MMA.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\plan_MM.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MMB.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MMC.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MMD.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MME.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MMF.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MMG.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MA.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\plan_mat.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MB.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MC.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MD.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_ME.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MF.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_MG.dbf"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_OA.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_OB.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_OC.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_OD.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Plan_OE.DBF"
Workbooks.Open Filename:="C:\Documents and Settings\hammad\Desktop\New Folder\Planopat.DBF"
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
ActiveWindow.Close
' *************** AUTO-FIT OPERATION WITH PARAMETERS SHEET ***************
Sheets("Plan Features").Select
Cells.Select
Selection.Columns.AutoFit
Range("A1").Select
Sheets("Census").Select
Cells.Select
Selection.Columns.AutoFit
Range("A1").Select
' ***************** QUOTATION DEFAULT VALUE INPUT *****************
Sheets("Quotation").Select
Range("H7:H11").Select
Selection.ClearContents
Range("D19").Select
ActiveCell.FormulaR1C1 = "1"
Range("D20").Select
ActiveCell.FormulaR1C1 = "1"
Range("D21").Select
ActiveCell.FormulaR1C1 = "1"
Range("D22").Select
ActiveCell.FormulaR1C1 = "1"
Range("D23").Select
ActiveCell.FormulaR1C1 = "1"
' ***************** OUTPATIENT FAMILY DEFAULT VALUE INPUT *****************
Sheets("Outpatient - Family").Select
Range("c6:d12").Select
Selection.ClearContents
' ***************** CENSUS DEFAULT VALUE INPUT *****************
Sheets("Census").Select
Range("C8").Select
ActiveCell.FormulaR1C1 = "0"
Range("C9").Select
ActiveCell.FormulaR1C1 = "0"
Range("C10").Select
ActiveCell.FormulaR1C1 = "0"
Range("C11").Select
ActiveCell.FormulaR1C1 = "0"
Range("C12").Select
ActiveCell.FormulaR1C1 = "0"
Range("C13").Select
ActiveCell.FormulaR1C1 = "0"
Range("C14").Select
ActiveCell.FormulaR1C1 = "0"
Range("C15").Select
ActiveCell.FormulaR1C1 = "0"
Range("C16").Select
ActiveCell.FormulaR1C1 = "0"
Range("C17").Select
ActiveCell.FormulaR1C1 = "0"
Range("C18").Select
ActiveCell.FormulaR1C1 = "0"
Range("C18").Select
Selection.End(xlUp).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("D8:F8").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("C8").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("I8").Select
ActiveSheet.Paste
Range("C26").Select
ActiveSheet.Paste
Range("I26").Select
ActiveSheet.Paste
Range("C45").Select
ActiveSheet.Paste
Range("I45").Select
ActiveSheet.Paste
Range("C63").Select
ActiveSheet.Paste
Range("A1").Select
' ************** HIDDING / AUTO-FIT OPERATION WITH PREMIUM SHEETS **************
Sheets("Hospitalisation").Select
Cells.Select
Selection.Columns.AutoFit
Range("C1").Select
Selection.EntireColumn.Hidden = True
Range("J1").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
Sheets("Maternity").Select
Cells.Select
Selection.Columns.AutoFit
Range("C1").Select
Selection.EntireColumn.Hidden = True
Range("G1").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
Sheets("Outpatient").Select
Cells.Select
Selection.Columns.AutoFit
Range("C1").Select
Selection.EntireColumn.Hidden = True
Range("J1").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
Sheets("Critical Illness").Select
Cells.Select
Selection.Columns.AutoFit
Range("C1").Select
Selection.EntireColumn.Hidden = True
Range("J1").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
Sheets("Major Medical").Select
Cells.Select
Selection.Columns.AutoFit
Range("C1").Select
Selection.EntireColumn.Hidden = True
Range("J1").Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
Sheets("Quotation").Select
Columns("D:D").Select
Selection.Columns.AutoFit
' ***************** COLUMN WIDTH SETTING *****************
Sheets("Hospitalisation").Select
Range("D8:G8,K8:N8").Select
Range("K8").Activate
Selection.ColumnWidth = 16
Range("A1").Select
Sheets("Maternity").Select
Range("D8,H8").Select
Range("H8").Activate
Selection.ColumnWidth = 16
Range("A1").Select
Sheets("Outpatient").Select
Range("D8:G8,K8:N8").Select
Range("K8").Activate
Selection.ColumnWidth = 16
Range("A1").Select
Sheets("Critical Illness").Select
Range("D8:G8,K8:N8").Select
Range("K8").Activate
Selection.ColumnWidth = 16
Range("A1").Select
Sheets("Major Medical").Select
Range("D8:G8,K8:N8").Select
Range("K8").Activate
Selection.ColumnWidth = 16
Range("A1").Select
Sheets("Census").Select
Range("C8:F8,I8:L8").Select
Range("I8").Activate
Selection.ColumnWidth = 12
Sheets("Quotation").Select
Range("C25:L25").Select
Selection.ColumnWidth = 16
' ***************** RE-PROTECTION OPERATION *****************
Sheets("Quotation").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Plan Features").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Census").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Hospitalisation").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Maternity").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Outpatient").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Outpatient - Family").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Critical Illness").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Major Medical").Select
Range("A1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Quotation").Select
Range("A1").Select
End Sub