Posts by hockeynick1721

    Background: I am automating a task in which I filter a dataset on one field by many criterion. The field I filter on is a list containing numeric IDs ranging from 100 to 900. There is a specific list of 9 IDs I need to apply to the filter.

    Need: To apply multiple Criteria to AutoFilter via VBA.

    Dim x As Range
    With ThisWorkbook.Sheets(1)
        Set x = .Range("IncomingCriteria")
    End With
    With ActiveWorkbook.Sheets(1)
        .Range("A:H").AutoFilter Field:=1, Criteria1:=x, Operator:=xlFilterValues
    End With

    I have a .xlsm workbook that I need to save a copy of but without macros (.xlsx). I am saving it as an .xlsx and fileformat:=xlOpenXMLWorkbook but I keep getting an error stating incorrect function.
    I first start off with Activeworkbook.SaveAs Filename:=

    What am I doing wrong here?


    I have created a marco-enabled workbook in 2007 but we moved to 2010. I used the Calendar Control 12.0 in 2007, however we do not have this control installed in 2010. How do I install this control?

    Any help is appreciated.


    Hey guys,
    I have a series of Listboxes that need to be filled. I want to loop through them but I can't figure out how. My list boxes are named Listbox1, Listbox2, etc. I was trying to do Listbox(i) where i represents the listbox number and is a count of the columns.

    Here's my code.

    Hi guys,

    I have a data set that looks like this.

    Score -----6.51----6.72----7.85----8.21
    base size ---40------80-----100------25

    That is one question, I have about 100.

    I need to highlight the largest mean Score that has a base size greater than 30. In the example above "7.85" would be highlighted. Not 8.21 because the base size is less than 30.

    Does anyone know how to do this? It seems simple enough that I shouldn't have to write a macro to do it.

    Any help is appreciated.


    Currently this is my code

    Private Sub Workbook_BeforeClose(Cancel As Boolean)    
    Application.DisplayFullScreen = False
        Application.DisplayAlerts = False
        Application.DisplayAlerts = True
    End Sub

    I have Full Screen Mode on, but want it to be false once closed (not affecting other workbooks) and I don't want the save prompt to appear. And I want excel to close, not just the workbook.

    Re: Joining data with different DateTimes series in Excel or Access

    Thanks for sample. Helps so much in determining what you are trying to do and allows me to test.

    As long as all sheets have the same structure and there are only data sheets, this will work. Just paste it into a new module and run it.

    Let me know if you need anything else.

    Re: Help in understanding dynamic vs fixed type of code

    This should do the trick. As long as there isnt anything other than data rows 3 and down, it will be fine. Let me know if you need anything else.
    Remember to replace NAME with sheet name (keep the quotes).