Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- B | C | D | E | F | G | H | I | J
- 1 1 | Bob |Jones |bjones| rep 1|Sales Report | Desc.| X | fnGenerateSalesReport
- 2 1 | Bob |Jones |bjones| rep 2|Revenue Rep. | Desc.| _ | fnGenerateRevenueReport
- 3 1 | Bob |Jones |bjones| rep 3|Customer List| Desc.| _ | fnGenerateCustReport
- 4 1 | Bob |Jones |bjones| rep 4|Stock Report | Desc.| _ | fnGenerateStockReport
- Dim ws As Worksheet, rng As Range, stRows As Long
- Dim c As Range
- Set ws = Sheets("AVAILABLE REPORTS")
- Set rng = ws.Range("B12:B12")
- Set rng = ws.Range(rng, rng.End(xlDown))
- stRows = rng.Rows.Count
- Set rng = ws.Range("I12:I12")
- Set rng = ws.Range("I12:I" & 11 + stRows)
- For Each c In rng.Cells
- If c.Value = "X" Or c.Value = "x" Then
- Debug.Print "> [" & c.Value & " (" & c.Offset(0, 1).Value & ")]"
- End If
- Next
- For Each c In rng.Cells
- If c.Value = "X" Or c.Value = "x" Then
- CallByName myReportGenerator, "GenerateReport", vbMethod, c.Offset(0, 1).Value
- End If
- Next
- dim reportHelper as Class1
- set reportHelper = new Class1
- CallByName reportHelper, c.Offset(0, 1).Value, vbMethod
- For Each c In rng.Cells
- If c.Value like "X" Then
- CallRelevantFunction c.Offset(0, 1).Value
- End If
- Next
- CallRelevantFunction ("rep 1", "fnGenerateSalesReport")
- Application.Run fncName
- debug.Print Sheet2.Cells(1,1).Value
- Day(Now())&Month(Now())&Year(Now())
- Debug.Print Evaluate(Sheet2.Cells(1,1).Value)
- 2792012
Add Comment
Please, Sign In to add comment