What do I do? Here is the FAQ for this forum. + Reply to Thread Results 1 to 9 of 9 vb project can't be saved in a macro free workbook Thread Tools Show Printable All rights reserved. Marked as answer by pictureman Monday, April 16, 2012 6:42 PM Monday, April 16, 2012 5:00 PM Reply | Quote Moderator All replies 3 Sign in to vote To save the http://bovbjerg.net/cannot-be/web-project-ant-copyfiles-cannot-be-found.php
Is there an actual army in 1984? We are not affiliated with Microsoft. Furniture name for waist-high floor-sitting shelf cabinet thing Is it possible to hand start modern planes? Can this be done?
The file I am working on is a .xls file and I am saving it as the same. Donâ€™t forget to answer your question, you can accept the answer after a day or so. –Daniel B Apr 7 '15 at 10:05 add a comment| 3 Answers 3 active oldest It looks as if I need to add another line of code that confirms that the file is indeed supposed to be .xls, but where and how do I do this?
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jan 11th, 2009,02:43 AM #4 Joe Was MrExcel MVP Join Date Feb 2002 Location Central Florida, USA Posts 7,539 Thanks, vanhunk Reply With Quote 09-08-2014,01:52 AM #5 SamT View Profile View Forum Posts View Blog Entries View Articles Moderator VBAX Guru Joined Oct 2006 Location Near Columbia Posts 4,931 Location Amir Parmar 511,419 views 23:14 Date picker in Microsoft Excel - Duration: 3:05. The Following Features Cannot Be Saved In Macro-free Workbooks Excel 4.0 Function ThisWorkbook.SaveAs myfile & Path This line appears to have two errors: a) You have used 'path' when I think you meant 'mypath' b) The path should come before the file name
If I click yes the code works, if no it fails. The Following Features Cannot Be Saved In Macro-free Workbooks Disabled can the code be changed to only show the following alert?: "A file named '*********************************************' already exists in this location. Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. IntroToIS BYU 18,405 views 2:14 Excel Magic Trick 916: Remove Blanks In Data Validation Drop Down List 5 Examples - Duration: 23:58.
more suggestions ... Excel 4.0 Function Stored In Defined Names Register To Reply 07-15-2010,06:09 PM #8 mojo249 View Profile View Forum Posts Forum Contributor Join Date 05-09-2009 Location London, England MS-Off Ver Excel 2007 Posts 315 Re: vb project can't be Loading... Microsoft MVP - Excel Entia non sunt multiplicanda sine necessitate Register To Reply 07-15-2010,05:56 PM #6 2funny4words View Profile View Forum Posts Forum Contributor Join Date 01-05-2009 Location South Dakota, USA
Register To Reply 07-15-2010,05:37 PM #4 2funny4words View Profile View Forum Posts Forum Contributor Join Date 01-05-2009 Location South Dakota, USA MS-Off Ver 2003, and 2007 Posts 148 Re: vb project How to handle a common misconception when writing a Master's thesis? Macro Free Workbook Excel 2013 Why does Cutie act like this and lesser robots listen to it? What Does Macro Free Workbook Mean Edit: I believe I found the source of the problem.
Other than 4 command buttons that use codes to print, I don't need anything from the VB Project to be saved with the sheet. Parameters ... Show more Language: English Content location: United States Restricted Mode: Off History Help Loading... Not the answer you're looking for?
Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros vb project can't be saved in The Following Cannot Be Saved In A Macro-free Document Vba Project Microsoft Office for Developers > Excel for Developers Question 0 Sign in to vote "The following features cannot be saved in macro-free workbooks: .VB Project To save a file with these Sign in to make your opinion count.
Register To Reply 07-15-2010,05:43 PM #5 shg View Profile View Forum Posts Forum Guru Join Date 06-21-2007 Location The Great State of Texas MS-Off Ver 2003, 2010 Posts 36,835 Re: vb Find the rate of change at a point on a polynomial Forcing everyone to speak the same language Possible repercussions from assault between coworkers outside the office more hot questions question My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages Excel Macro-enabled Workbook Is it possible to be selective, i.e.
I gotta work on figuring out how to define it for mypath That said I followed your note on this step ThisWorkbook.SaveAs mypath&myfile and I'm still getting the VBA Alert message. However, when it gets to the “saving as” bit I get the following message box with options “Yes”, “No” and “Help”. The low setting opens workbooks with code without any warnings. Sign in to report inappropriate content.
Visit our UserVoice Page to submit and vote on ideas! share|improve this answer answered Apr 7 '15 at 11:43 Jones 6703931 add a comment| up vote 2 down vote Just to clarify, note that MySQL for Excel is a COM Add-in. Please Login or Register to view this content. Tiger Spreadsheet Solutions 106,139 views 6:49 Creating Simple Excel Macro Excel 2013 Beginners Tutorial - Duration: 7:05.
Register To Reply 07-15-2010,05:29 PM #2 mojo249 View Profile View Forum Posts Forum Contributor Join Date 05-09-2009 Location London, England MS-Off Ver Excel 2007 Posts 315 Re: vb project can't be Reply With Quote 09-07-2014,11:48 PM #4 vanhunk View Profile View Forum Posts View Blog Entries View Articles VBAX Contributor Joined Jun 2012 Posts 197 Location @holycow & snb, Thank you for It is not a good idea to name a procedure using one of vba's 'special' words. Close Yeah, keep it Undo Close This video is unavailable.
Please try the request again. Some people who download a lot of workbooks may want to be warned if a workbook contains code before opening, but as all the workbooks I use do have code this