Run-time error '1004'; Hopefully a simple fix


  • Is there something obvious missing that im getting this error?: http://i.imgur.com/fgxmTit.png

    [CENTER]Shop4Yoo E-Trader
    Ebay - Amazon UK - Amazon US - Rakuten
    [/CENTER]

  • Re: Run-time error '1004'; Hopefully a simple fix


    I would have thought the error message covered just about all the options. Have you checked the directory exists, you have permissions etc etc?

  • Re: Run-time error '1004'; Hopefully a simple fix


    Quote from Grimes0332;768367

    I would have thought the error message covered just about all the options. Have you checked the directory exists, you have permissions etc etc?


    Yes, the directory exists as i work in them everyday, Deleting, creating files etc so i have full permission to do everything.

    [CENTER]Shop4Yoo E-Trader
    Ebay - Amazon UK - Amazon US - Rakuten
    [/CENTER]

  • Re: Run-time error '1004'; Hopefully a simple fix


    Quote from Grimes0332;768370

    So the value of InvoiceMonth is?


    This at the top of the Code:


    Code
    ' Invoice Month
        Range("H4").Select
        InvoiceMonth = Range("'Information'!H4").Value


    Which in the cell is simply the word: March

    [CENTER]Shop4Yoo E-Trader
    Ebay - Amazon UK - Amazon US - Rakuten
    [/CENTER]

  • Re: Run-time error '1004'; Hopefully a simple fix


    Quote from Grimes0332;768376

    There are 3 lines where that error could be raised. Which one?


    These are the lines that are highlighted when i click debug:

    Code
    ActiveWorkbook.SaveAs Filename:=InvoiceMonth, _
        FileFormat:=xlCSV, CreateBackup:=False

    [CENTER]Shop4Yoo E-Trader
    Ebay - Amazon UK - Amazon US - Rakuten
    [/CENTER]

  • Re: Run-time error '1004'; Hopefully a simple fix


    That surprised me as the Export line is wrong - what is the actual content of InvoiceMonth?


    I agree with the previous comment. Quoting the last message sent clutters up the thread - just reply using the Quick Reply box after the last post.

Participate now!

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