Depends on how the macro in Master.xlsm is written, it may not produce anything. –PatricK Aug 15 '13 at 1:00 add a comment| 2 Answers 2 active oldest votes up vote Is this the case? –varocarbas Aug 24 '13 at 13:36 What's the rest of your code? –enderland Aug 24 '13 at 13:44 @enderland "Rest of your code" Join & Ask a Question Need Help in Real-Time? MS Excel Creating a Cool Heat Map in Excel Video by: AnnieCushing This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside weblink
I was acutally programming a work-around in which I would use some cells in a spreadsheet, populating them with the values from my code and placing the formula in another and 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 Yes, it's public. 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
The macro may not be available in this workbook or all macros may be disabled. I then want to import them, run then and then remove them. Run-time error '1004': Cannot run the macro 'SeasonTicketAnalysis'. So at what stage does it actually import the .bas file?
Does a byte contains 8 bit, or 9? A file containing macros has to be stored as a macro-supporting format (e.g., XLSM). Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Vba Microsoft Excel Cannot Access The File An Array of Challenges #1: Alternating Arrays How would people living in eternal day learn that stars exist?
You’ll be auto redirected in 1 second. MS Excel Advertise Here 689 members asked questions and received personalized solutions in the past 7 days. Thank you very much Share Share this post on Digg Del.icio.us Technorati Twitter Mike H Reply With Quote « Previous Thread | Next Thread » Like this thread? So by copying my version to their Office installation, everything worked. (Note there was another version of the file in the Analysis directory called atpvbaen(1).xla which was getting in the way
but I can't see where your VBA actually accesses import_macro.bas. Run Time Error 1004 File Could Not Be Found Reply With Quote Apr 20th, 2015,05:25 PM #9 westconn1 View Profile View Forum Posts PowerPoster Join Date Dec 2004 Posts 22,070 Re: [RESOLVED] Excel Runtime error 1004 FileName could not be Why did the rebels need the Death Star plans? You should make the Excel to Open that file before trying to call that macro.
So upon further investigation, I found the creation date of my version of atpvbaen.xla to be much newer than my users'. Does the workbook name have any spaces in it? Run-time Error '1004' Cannot Access The File Join the community of 500,000 technology professionals and ask your questions. Excel Runtime Error 1004 Cannot Run The Macro Output integers in negative order, increase the maximum integer everytime How are there so many species on the space station 'A long way from anywhere V'?
Sorry, but I am very confused. have a peek at these guys a small leap forward in my VBA will follow; thanks again. –whytheq Aug 27 '13 at 10:39 | show 1 more comment Your Answer draft saved draft discarded Sign up The VBP was working fine and suddenly it strats popping up the error Runtime error 1004 The macro "Main" cannot be found. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required Run Time Error 1004 File Could Not Be Accessed
Stack Overflow Podcast #97 - Where did you get that hat?! If so, you need the syntax I posted. Cheers, Gray Reply With Quote Oct 3rd, 2008,08:43 AM #6 GrayS View Profile View Forum Posts Thread Starter New Member Join Date Oct 2008 Posts 3 Re: Excel Runtime error 1004 check over here Password Site Map Home Register Authors List Today's Posts Search Web Partners Search Forums Show Threads Show Posts Advanced Search Go to Page...
The time now is 09:04 AM. - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top Powered by vBulletin Version 3.6.4Copyright ©2000 - 2016, Jelsoft Cannot Run The Macro The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled Make a suggestion Dev centers Windows Office Visual Studio Microsoft Azure More... Cheers, Dave 0 Message Author Comment by:BROOKLYN1950 ID: 363672652011-08-14 Thanks for your comments, AM is variant which changes from file to file.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required User Name Remember Me? Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search Dmonentry_net My code so far (without the copy over portion) is this: Private Sub GetProposals() Dim myXL As Excel.Application Dim myXLS As Excel.Workbook Dim ws As Excel.Worksheet Set myXL = New Excel.Application
If you try to save it by relying on a wrong file type (like XLSX), you would get a prompt explaining the problem. You could try re-activating the workbook that contains the macro at the end of the loop. Why did the rebels need the Death Star plans? http://cdhca.org/time-error/excel-vba-run-time-error-1004-pivot-table.php Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2010,08:13 PM #3 BrighterLater Board Regular Join Date Sep 2005 Location Maidstone, UK Posts 112 Re: Application.Run
Not the answer you're looking for? Application.Run .Name &"!" &AM Dave 0 How to run any project with ease Promoted by Quip, Inc Manage projects of all sizes how you want. If the Ch’in dynasty was so short-lived, why was China named for it? Yes, it's public. > > Does anyone have a clue why this might be happening? > > Maury > Barb Reinhardt View Public Profile View message headers Find all posts by