Consulting

Results 1 to 6 of 6

Thread: Issue in activating the workbook with partial name

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Oct 2016
    Posts
    3
    Location

    Issue in activating the workbook with partial name

    Hi There,

    Below is my code, which i used to activate a workbook with partial file name but it it is showing error.

    Kindly help to get this issue resolved.

    Sub DRTN()
        ' DRTN Macro
        Cells.Select
        Range("Q1").Activate
        Selection.AutoFilter
        Selection.AutoFilter
        Range("Q1").Select
        ActiveSheet.Range("$A$1:$Y$1299").AutoFilter Field:=17, Criteria1:="IC1012"
        Range("P1").Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Range(Selection, Selection.End(xlToRight)).Select
        Range(Selection, Selection.End(xlDown)).Select
        Selection.Copy
        ActiveSheet.Previous.Select
        ActiveSheet.Paste
        Cells.Select
        Selection.Columns.AutoFit
        Columns("A:B").Select
        Application.CutCopyMode = False
        Selection.Delete Shift:=xlToLeft
        Columns("B:B").Select
        Selection.Delete Shift:=xlToLeft
        Columns("C:H").Select
        Selection.Delete Shift:=xlToLeft
        Selection.End(xlUp).Select
        Columns("I:I").Select
        Selection.Delete Shift:=xlToLeft
        Selection.Delete Shift:=xlToLeft
        Selection.Delete Shift:=xlToLeft
        Selection.Delete Shift:=xlToLeft
        Selection.End(xlUp).Select
        Selection.End(xlToRight).Select
        Columns("L:L").Select
        Selection.Delete Shift:=xlToLeft
        Range("I1").Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Range("C1").Select
        ActiveCell.FormulaR1C1 = "Invoice #"
        Range("D1").Select
        ActiveCell.FormulaR1C1 = "Invoice Date"
        Range("E1").Select
        ActiveCell.FormulaR1C1 = "Amount"
        Range("F1").Select
        ActiveCell.FormulaR1C1 = "Currency"
        Range("H1").Select
        ActiveCell.FormulaR1C1 = "Vendor #"
        Range("K1").Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Range("A1").Select
        Range(Selection, Selection.End(xlToRight)).Select
        Range(Selection, Selection.End(xlDown)).Select
        Selection.Columns.AutoFit
        Columns("G:G").Select
        Selection.Delete Shift:=xlToLeft
        Selection.Delete Shift:=xlToLeft
        Selection.End(xlUp).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Selection.End(xlToLeft).Select
        Range(Selection, Selection.End(xlToRight)).Select
        Range(Selection, Selection.End(xlDown)).Select
        Range("A1").Select
        Workbooks("*Dump Aging Report* " & ".xls").Activate
    End Sub
    Last edited by Aussiebear; 12-13-2024 at 10:58 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •