excel vba run-time error 1004 saveas Creswell Oregon

We provide unique and tailored services for the wireless customer with competitive needs. We give clients the freedom to have the services and equipment above the norm which includes unlocked, rooted, flashed, and custom handsets. We also repair all equipment including but not limited to cellphones, computers, mps players, and other mobile electronics.

CellPhone Service, Repair, Activations and Consulation. Computer Service and Repair.

Address 1670 W 11th Ave Suite \"c\", Eugene, OR 97402
Phone (541) 933-5274
Website Link
Hours

excel vba run-time error 1004 saveas Creswell, Oregon

more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Is there any job that can't be automated? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 29th, 2011,02:13 PM #4 MarkE New Member Join Date Mar 2011 Posts 10 Re: run-time error '1004': incorrect How do you say "root beer"?

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 29th, 2011,05:25 PM #6 MarkE New Member Join Date Mar 2011 Posts 10 Re: run-time error '1004': incorrect Earlier this year, I ran into another product defect where Excel 2007 was only able to run one networked Microsoft Web Query - if you ran more, it would get the Anyway thank you so much for your help! For some reason JMMach was still causing the problem. –Riccardo Mar 11 '15 at 10:46 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted I

Basically, you should have either a reference to a workbook, or use the predefined ActiveWorkbook reference. EDIT: Solved thanks to Degustaf suggestion. Browse other questions tagged excel vba excel-vba or ask your own question. Alternatively, you may have edited the file's path or filename yourself.

Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel Even stranger, if I add a msgbox right before the problem code, now, I consistently get the error message "incorrect funcction". You guys have helped me out plenty of times in the past and I'm hoping you can do the same again for me! Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 16th, 2011,12:01 PM #2 mikerickson MrExcel MVP Join Date Jan 2007 Location Davis CA Posts 20,380 Re: run-time

The WbNew.SaveAs line is highlighted when I debug the code. So it's throwing something on the way out of the SaveAs routine. Truth in numbers How should I interpret "English is poor" review when I used a language check service before submission? When I run a VBA script, Excel gives me an error message saying "run-time error ...

Register To Reply 06-03-2009,10:14 AM #2 shg View Profile View Forum Posts Forum Guru Join Date 06-20-2007 Location The Great State of Texas MS-Off Ver 2003, 2010 Posts 36,739 Re: File I'd also recommend using ThisWorkbook instead, since the user might click on another book while code is running. but your profile shows you as using 2003 so unless you've upgraded that's not the problem... So, we can approach this as how can we copy this sheet to a new workbook, and get a reference to that workbook.

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. Join Date 1st September 2010 Posts 10,911 Re: Run-time error '1004' saving worksheet If it's related to your problem I can't see why not. Usually this works fine. Thanks Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 29th, 2011,04:15 PM #5 mikerickson MrExcel MVP Join Date Jan 2007 Location Davis CA Posts 20,380 Re:

Need book id. If this is your first visit, be sure to check out the FAQ by clicking the link above. Run-time error '1004': Microsoft Office Excel cannot acces the file 'G:\Reports\By Team\'. Register Help Forgotten Your Password?

Thanks in advance for your time. I prefer to use the full UNC path (\Thismachine...), in case the workbook gets used on a machine that doesn't have the mapped drive set up. Copyright 2004 - VBA Express But what happened to the clearer to read message explaining that I had a bogus directory?

It worked fine there. share|improve this answer edited Apr 14 at 5:36 answered Apr 14 at 4:47 Mike Benstead 413 Thanks Mike, much appreciated even now! –Riccardo Apr 18 at 9:11 add a Thus, the macros will not encounter this fault you run it. This can be done with VBA or manually.

I can save just fine to any folder on my C drive. Excel Video Tutorials / Excel Dashboards Reports Reply With Quote March 2nd, 2011 #7 mcousin View Profile View Forum Posts Senior Member Join Date 9th February 2011 Posts 112 Re: Run-time more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Microsoft confirmed that and logged it.

How? Mine's constant at that location. No, it does not include 'Incorrect function'. Would that be to test whether the problem is network related?

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 I found my problem was the security and mapping of the drive.