excel vba runtime error 1004 document not saved Dingle Idaho

Address 878 N Washington St, Afton, WY 83110
Phone (307) 880-9985
Website Link

excel vba runtime error 1004 document not saved Dingle, Idaho

Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Browse other questions tagged excel vba runtime-error save or ask your own question. How is the Heartbleed exploit even possible? Suggested Solutions Title # Comments Views Activity Dat formatting in a formula 2 22 17d Date generator for it to show Days Left for due date. 11 39 15d Excel sending

Assuming that range will always be a date, replace: ActiveSheet.Range("D14").Value with something like this: format(ActiveSheet.Range("D14").Value,"YYYYMMDD") Feel free to use a different format than "YYYYMMDD", but make sure you do not use Jul 31 '13 #14 reply P: 29 rahulwagh The issue was with the VBE7 DLL. Jul 31 '13 #13 reply Expert Mod 2.5K+ P: 4,994 zmbd You should NEVER use an OLD version of a library with new versions of the software. 1) The next person The other option would be if there was a macro that checked for a file already being open with the same name and if so asked them to close it, before

so I dont understand why I get that message. Is the mass of an individual star almost constant throughout its life? The code appears to be working on my machine but not on the persons who uses the spreadsheet daily. MSOfficeForums.com is not affiliated with Microsoft LinkBack LinkBack URL About LinkBacks

Any idea? Interestingly I get the same error if I use 'file-open' and highlight more than one workbook? Copy the line VB: Application.StatusBar = False and paste back just before the 'Exit Sub' line. Hope you can help me.

Is it Nothing when you hover over ActiveWorkbook? –JimmyPena Jun 22 '12 at 14:59 Using a msgbox to print the name of the ActiveWorkbook, it is CategoryName & "" Rather than update each graph to point to a different set within a static set of data, t… MS Excel Advertise Here 769 members asked questions and received personalized solutions in Thanks in advance! /Carl Ask Your Own Question Runtime Error 1004 - Select Method Of Worksheet Class Failed - Excel Excel Forum Hi all, I have a document with a 'consolidate' I do get the compatability error message (which I don't get on the 'original/parent' workbook) there is a not about format errors, though I'm not sure that's the source of the

Choose a different name etc." Apart from the confusion caused to the user seeing the macro error message. The issue was with VBE7 DLL. Pleas Advise. Worth a try though if you are still having problems.

Once you select End on the error message box it goes to the Save As prompt or closes. Do you think this error is being generated because the consolidate function is trying to open multiple workbooks cuncurrently? Actually it's called attention to detail!! Join Date 1st September 2010 Posts 10,911 Re: Printing to PDF, Error 1004 Document not saved http://www.cpearson.com/excel/errorhandling.htm Basic primer on error handlng above...

The time now is 18:24. I'm completely mystified... What's puzzeling though is when I get the error, I press debug and then run macro, and it does it and continues until the next error which could be a while Bryan Ask Your Own Question Contact | Privacy Policy | Disclaimer | Terms Copyright© 2016 TeachExcel.com Register Help Forgotten Your Password?

However, when I use LockXLS protection software to protect the file, it turns it into an exe file. Version1 etc - if another copy of the file is already open? here is the save code. Document not saved." when exporting to PDF with VBA I think I actually figured out what is causing this.

What are Imperial officers wearing here? Again, many, many thanks Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread Why is absolute zero unattainable? Please take our survey and let us know your thoughts!

Jul 24 '13 #1 Post Reply Share this Question 14 Replies Expert 5K+ P: 8,435 Killer42 I think you have the syntax slightly wrong. I have had not trouble with macros that save documents to a cell reference file path - the error appears isolated to the Save to PDF command. I found some similar, but nothing that pertained specifically to my problem. Would this code conflict if I have 2 copies of the same workbook up at the same time and try to run this code in one?

It appears that it wont save the pdf at all as the pdf file does not get created or shown on screen. Hi all, I am running the Macro below to export to pdf a document. The document may be open, or an error may have been encountered when saving. Originally Posted by Andrew Poulsom Maybe the unqualified Cells property is the cause of the error.

I am basically importing data from Access to Excel and this line is the last line of the code. SEO by vBSEO ©2011, Crawlability, Inc. Jul 31 '13 #11 reply Expert 5K+ P: 8,435 Killer42 I'd call that a short-term workaround, rather than a solution. Make all the statements true Security Patch SUPEE-8788 - Possible Problems?

When I go to debug it it highlights a particular section. What is that the specific meaning of "Everyone, but everyone, will be there."? However, the data from Access is not imported so I am assuming it is an important part of the code! There is some problem with the VBE7 Dll i.e.