1004 Application-defined Or Object-defined Error Engagement
Contents |
Forums Excel Questions 1004 application-defined or object-defined error when launching. Results 1 to 8 of 8 1004 application-defined or object-defined error when launching.This is a discussion on 1004 application-defined or object-defined error when launching. within the Excel Questions forums, part of the
Vba Runtime Error 1004 Application Defined Or Object Defined Error
Question Forums category; I am not trying to run any code, but when I startup excel, runtime error 1004 application defined or object defined error excel I get this error, hit o.k. twice ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark run time error 1004 application defined or object defined error in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jun 11th, 2010,11:35 AM #1 motc777 New Member Join Date Jun 2010 Posts 3 1004 application-defined or object-defined error
Application-defined Or Object-defined Error Excel
when launching. I am not trying to run any code, but when I startup excel, I get this error, hit o.k. twice and then I can use Excel with no issues. Before when this happened I wiped off office down to the registry, but now it's back and I really don't want to go through that again. Any ideas? Thanks! Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 11th, 2010,11:39 AM #2 ribbs2521 Board
Application Defined Or Object Defined Error Vba
Regular Join Date Sep 2007 Location New York Posts 158 Re: 1004 application-defined or object-defined error when launching. Could be an add in. This happens even when you open a new book? If that's the case I would say it's an add in. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 11th, 2010,01:42 PM #3 motc777 New Member Join Date Jun 2010 Posts 3 Re: 1004 application-defined or object-defined error when launching. Originally Posted by ribbs2521 Could be an add in. This happens even when you open a new book? If that's the case I would say it's an add in. Disabled all add-ins and still getting the error on launch. Edit: Found the add-in. Just not understanding this one though. Last edited by motc777; Jun 11th, 2010 at 01:50 PM. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 11th, 2010,03:19 PM #4 ribbs2521 Board Regular Join Date Sep 2007 Location New York Posts 158 Re: 1004 application-defined or object-defined error when launching. Originally Posted by motc777 Edit: Found the add-in. Just not understanding this one though. Care to elaborate? Maybe someone on the forum could help figure it out. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 11th, 2010,03:32 PM #5 motc777 New Member Join Date Jun 2010 Posts 3 Re: 1004 application-defined or object-defined error when
object-defined error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you application-defined or object-defined error vb6 can post: click the register link above to proceed. To start viewing
Application Defined Or Object Defined Error 32809
messages, select the forum that you want to visit from the selection below. Results 1 to 12 of application defined or object defined error sss 12 Thread: Run-time error '1004': Application-defined or object-defined error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode http://www.mrexcel.com/forum/excel-questions/474050-1004-application-defined-object-defined-error-when-launching.html May 5th, 2005,12:05 PM #1 neilma View Profile View Forum Posts Thread Starter New Member Join Date May 2005 Posts 6 Run-time error '1004': Application-defined or object-defined error Hi, Another novice problem from me. I get this error message: Run-time error '1004': Application-defined or object-defined error This is the statement that is highlighted when the error comes up. ActiveCell.FormulaR1C1 = "=Average(R[6]C[-2]:R[myDatasecs+6]C[-2])" http://www.vbforums.com/showthread.php?337624-Run-time-error-1004-Application-defined-or-object-defined-error Here is the code block: Set currentCell = Range("Q11") For n = 1 To 10 currentCell.Value = myOscArray(n, 1) currentCell.Offset(0, 1).Value = myOscArray(n, 2) currentCell.Offset(0, 2).Formula = "=RC[-2]-RC[-1]" Set nextCell = currentCell.Offset(1, 0) Set currentCell = nextCell Next n Range("E6").Select ActiveCell.FormulaR1C1 = "=Average(R[6]C[-2]:R[myDatasecs+6]C[-2])" Range("F6").Select ActiveCell.FormulaR1C1 = "Mean Flow" Thanks in advance, Neil Reply With Quote May 5th, 2005,02:40 PM #2 VBAhack View Profile View Forum Posts Fanatic Member Join Date Dec 2004 Location Sector 000 Posts 609 Re: Run-time error '1004': Application-defined or object-defined error Suggestion - turn on the macro recorder (Tools->Macro->Record New Macro) and type in the formula you want in the cell. Stop the recorder and see what you get. Maybe you already did this....... VBAhack Reply With Quote May 6th, 2005,10:44 AM #3 neilma View Profile View Forum Posts Thread Starter New Member Join Date May 2005 Posts 6 Re: Run-time error '1004': Application-defined or object-defined error Yeah. I already did that. The problem is that the amount of data that is taken into the spreadsheet is of varying length. So, I can't use a set
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow http://stackoverflow.com/questions/34668900/run-time-error-1004-application-defined-or-object-defined-error the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run-time error '1004': Application-defined or object-defined error up vote 0 down vote favorite I read through a defined or few of the existing VBA questions with this error but I find that the error message is general and there are many, many ways to get it. My VBA code is below and I am trying to find out why all of a sudden it is not working when it used to. The lines which Excel highlights are between the 2 * which I do not actually have in the code :) defined or object Sub publishPDF() ' ' PublishToPDF Macro ' Macro recorded 01/07/2016 by Pczarnota ' Export to PDF SaveFolder = "S:\DataOps\InvValidatedFeed\" DocName = Range("D1").Value *ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=SaveFolder & DocName, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False* MsgBox ("Another one down!") End Sub excel vba share|improve this question asked Jan 8 at 3:09 pjczarnota 1 Does the path contained within SaveFolder actually exist? Do you have write permission on that directory? –Dai Jan 8 at 3:13 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote This must have something to do with the filename in D1, the reliance on the ActiveSheet property to define the parent worksheet of D1 or an illegal filename. Sub publishPDF() ' PublishToPDF Macro ' Macro recorded 01/07/2016 by Pczarnota ' Export to PDF Dim saveFolder As String, docName As String saveFolder = "S:\DataOps\InvValidatedFeed\" '<~~ access to the share or network drive? docName = Worksheets("Sheet1").Range("D1").Value '<~~define the worksheet holding the filename! If CBool(InStr(1, docName, Chr(46))) Then 'check for a period (full stop) 'remove it; the save type will add the appropriate one docName = Left(docName, InStr(1, docName, Chr(46)) - 1) End If ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=saveFolder & docName, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False MsgBox ("Another one down!") End Sub This works for me but I did not