Object Error 438 Object doesn't support this property or method

  • Re: Object Error 438 Object doesn't support this property or method


    Hi bkat,


    While we are glad to have you here at Ozgrid please ensure you wrap your code with the appropriate tags and use meaningful titles. As this is your first post I have done it for you this time.


    The problem with your code is the way you're referencing cell H12 in Sheet1 is incorrect so change this line of your existing code...


    Code
    ActiveWorkbook.SaveAs "E:\bkk\mydir\dda\16-17\inv" & Sheet1("h12") & ".xlsx", FileFormat:=51


    to this:


    Code
    ActiveWorkbook.SaveAs "E:\bkk\mydir\dda\16-17\inv" & Sheets("Sheet1").Range("H12") & ".xlsx", FileFormat:=51


    Note this format does not allow code so you will lose the macro above.


    Regards,


    Robert

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!