+ Reply to Thread
Results 1 to 6 of 6

Run time error 1004 method save as wont work and I dont know why!

  1. #1
    Registered User
    Join Date
    09-25-2014
    Location
    denver co
    MS-Off Ver
    2013
    Posts
    5

    Run time error 1004 method save as wont work and I dont know why!

    Hey guys,
    Okay so i had this code up once before and I had changed one this to fix it and it fixed for a short time. Well now its giving me a new error and I need to know why.
    What im trying to do is make it so my workbook copy and save the invoice as one specific cell that does not have any forbidden characters then clear the cells, Then finally change the invoice number up by one. Here is the code I am using and when i run the debug the save as line is what is highlighted. Please help me out

    Please Login or Register  to view this content.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Run time error 1004 method save as wont work and I dont know why!

    What is the Range("A15").Value?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Run time error 1004 method save as wont work and I dont know why!

    Its working fine here in my machine, what is the error ur getting
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Run time error 1004 method save as wont work and I dont know why!

    Well, you are currently running a code (a.k.a. macro), aren't you ?

    Then you are trying to save the file in macro free Excel file type :

    Please Login or Register  to view this content.
    You should save the file in macro enabled file type (.xlsm, FileFormat:=52)

    For further information, look here : link
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  5. #5
    Registered User
    Join Date
    09-25-2014
    Location
    denver co
    MS-Off Ver
    2013
    Posts
    5

    Re: Run time error 1004 method save as wont work and I dont know why!

    Thank you it was the type of file i was trying to save as

  6. #6
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Run time error 1004 method save as wont work and I dont know why!

    You are welcome, I thought you will never comment back.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] runtime error 1004 method save of object _workbook failed
    By madhatter40 in forum Excel General
    Replies: 1
    Last Post: 06-22-2013, 07:30 AM
  2. [SOLVED] runtime error 1004 method save of object _workbook failed
    By madhatter40 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2013, 03:37 AM
  3. [SOLVED] run time error 1004 method save as of object _workbook failed
    By johnsmith2004ad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2013, 02:02 AM
  4. Run time error 1004 method save as of object 1 "_workbook" failed.
    By json_79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2012, 02:41 AM
  5. Runtime error 1004/ Save As method help
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2006, 12:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1