excel vba runtime error 1004 saveas Country Club Hills Illinois

Address 143 Kraml Dr, Burr Ridge, IL 60527
Phone (630) 920-8844
Website Link http://datacommsales.net
Hours

excel vba runtime error 1004 saveas Country Club Hills, Illinois

Why would a password requirement prohibit a number in the last character? Is it possible to have a planet unsuitable for agriculture? More About Us... Advanced Search Forum HELP FORUMS Excel General Run-time error '1004' saving worksheet Excel Training / Excel Dashboards Reports If this is your first visit, be sure to check out the FAQ

Join Date 1st September 2010 Posts 10,911 Re: Run-time error '1004' saving worksheet Does the error message include 'Incorrect function'? Browse other questions tagged vba excel-vba csv runtime-error save-as or ask your own question. share|improve this answer answered Mar 10 '15 at 17:05 Degustaf 2,2762725 add a comment| up vote 3 down vote This is a year old, but I'll add something for future readers Page 1 of 2 1 2 Last Jump to page: Results 1 to 10 of 11 Thread: Run-time error '1004' saving worksheet Thread Tools Show Printable Version Search Thread Advanced

You would need the xlsm extension. Register To Reply 07-14-2009,12:34 PM #6 c4tin View Profile View Forum Posts Registered User Join Date 03-10-2009 Location Wisconsin, USA MS-Off Ver Excel 2003 Posts 6 Re: File SaveAs causing run-time Someone (or you yourself) has the open open in another instance of Excel. Just to sever the workbook's relationship to its network path.

Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not The error is if I save the workbook as a macro enabled template and then use my code to save as XLSM Thanks again Reply With Quote 10-29-2011,05:18 AM #7 Andybuck86 I can save just fine to any folder on my C drive.

After if fails and you save locally, you could do a Dir() on the original path to verify that it is indeed reconnected; if not, there's no point in trying to Thanks - Mike Excel Video Tutorials / Excel Dashboards Reports Reply With Quote March 1st, 2011 #4 cytop View Profile View Forum Posts . Is it "eĉ ne" or "ne eĉ"? If anyone know's of some kind of workaround I would be happy to try it out.

If you're having a computer problem, ask on our forum for advice. How to handle a senior developer diva who seems unaware that his skills are obsolete? Excel Video Tutorials / Excel Dashboards Reports Reply With Quote March 1st, 2011 #3 mcousin View Profile View Forum Posts Senior Member Join Date 9th February 2011 Posts 112 Re: Run-time asked 4 years ago viewed 12745 times active 4 years ago Get the weekly newsletter!

Your name or email address: Do you already have an account? Players stopping other player actions Is intelligence the "natural" product of evolution? The following shortcuts will backup your worksheet in seconds: Ctrl+O, [highlight the filename], Ctrl+C, Ctrl+V, [ X ]. DécioC posted Oct 13, 2016 at 11:28 AM Loading...

Stay logged in Welcome to PC Review! I have the following code as a module in my workbook Option Explicit Sub Save_Password() Application.DisplayAlerts = False Dim Open_Password As String Dim New_File_Name As String New_File_Name = Sheets("QryData").Range("J32").Value & "\" Why does argv include the program name? Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd.

C:\Users\Mike\AppData\Roaming\Microsoft\Excel\DIARY(version 1).xlxb If so the solution is (as stated above by others) to save your file to its correct path and file name. Ozgrid is Not Associated With Microsoft. If the network connection is lost, you can't save the file to the network path at all; so I guess the error occurs when the connection was lost but subsequently restored. CurrentWorkbook.Sheets("My_Sheet").SaveAs Filename:=SaveToDirectory & "My_Sheet" & ".csv", FileFormat:=xlCSV I will warn you to resave the workbook to its original name afterwarsd, if it is staying open, but you already have that in

My current code is as follows: Option Explicit Sub Save_Password() Application.DisplayAlerts = False Dim Open_Password As String Dim New_File_Name As String New_File_Name = Sheets("QryData").Range("J32").Value & "\" & Sheets("QryData").Range("J31").Value Open_Password = InputBox("Please There are several possible reasons: The file name or path does not extist.The file is being used by another program.The workbook you are trying to save has the same as a Can an ATCo refuse to give service to an aircraft based on moral grounds? The answers above are 100% valid but sometimes it helps to know what is causing the problem so you can avoid it, fix it earlier or fix it more easily.

Then you are coercing it back into a Long in order to compare it to vbNo, a Long constant. When the following command runs (inside a macro) and I selec 'yes' from the dialog box when it says "the file already exists do want to replace it?" - that's fine. Ozgrid Retains the Rights to ALL Posts and Threads Register Help Remember Me? I tested it with the same name and file extension that I am using in my vba and it works.

File Format Name - FileFormat Value Excel 2007-2010 Binary Workbook (.xlsb) - 50 Excel 2007-2010 Workbook (.xlsx) - 51 Excel 2007-2010 Macro-Enabled Workbook (.xlsm) - 52 Excel 2007-2010 Macro-Enabled Template (.xltm) You can automate the identification of erroneous hyperlinks in a helper column, say column Z and using the formula =OR(ISNUMBER(SEARCH("Roaming", Link2Text($C2),1)),ISNUMBER(SEARCH("Roaming", Link2Text($D2),1))) where Link2Text is the UDF Function Link2Text(rng As Range) Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. About the only definite thing to say is it happens in XL 2007 if you use Save As without specifying the file format...

No copy necessary. Do you want to replace it?" If my answer is "no", I receive the error message "Run-time error '1004': Method 'SaveAs of object '_Workbook' failed". Solve and naming variables New tech, old clothes Why is absolute zero unattainable?