excel vba runtime error 462 Crouse North Carolina

Im Todd Causby, the owner of DTC Computers. I have been working on pcs most of my life. Even before starting DTC Computers in 2010 I helped countless people and businesses with there computer and network problems.

Address 213 Kiser Dairy Road, Dallas, NC 28034
Phone (704) 898-5573
Website Link http://www.dtc-computers.com
Hours

excel vba runtime error 462 Crouse, North Carolina

Thank you Reply With Quote Jan 3rd, 2012,06:21 PM #11 Earlien View Profile View Forum Posts Thread Starter Member Join Date Dec 2011 Location Brisbane, Australia Posts 43 Re: [VBA Word/Excel] 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 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 I'm copying a range of cells from excel and pasting into the active word document as an enhanced metafile.

Dave Reply With Quote 11-15-2006,12:03 AM #13 SammyB View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Oct 2006 Posts 8 Location SOLVED: Runtime Error 462 Can't No, part of the code which I didn't post opens mergeadata.xls and then clears the previous day's entries, before copying and pasting the new entries. Reply With Quote 11-14-2006,02:08 PM #8 mdmackillop View Profile View Forum Posts View Blog Entries View Articles AdministratorVP-Knowledge Base VBAX Grand Master Joined May 2004 Location Scotland Posts 12,873 Location Happened Visual Basic does not release this reference until you end the program.

Run a Macro at 4:30PM every day - Automatically run an Excel macro at a certain time. I have tried the following variations with no success: Code: XL_Wb.Range(Cells(First_Row, First_Col), Cells(Last_Row, First_Col)).Select XL_Wb.Worksheets(1).Range(Cells(First_Row, First_Col), Cells(Last_Row, First_Col)).Select XL_App.Application.Workbooks(1).Worksheets(1).Range(Cells(First_Row, First_Col), Cells(Last_Row, First_Col)).Select XL_App.Application.Workbooks(1).Sheets(1).Range(Cells(First_Row, First_Col), Cells(Last_Row, First_Col)).Select Note that the above code Don't know if it will solve the problem, but it would appear to simplify the process. I have tested the stored procedure in SQL and it runs fine (after about a minute), so I know that this error is coming from VBA.

or suggestion. Register Help Remember Me? The macro does this one at a time. abbaddon223 View Public Profile Find More Posts by abbaddon223

02-20-2013, 01:06 AM #4 pr2-eugin Super Moderator Join Date: Nov 2011 Location: Bournemouth, UK Posts:

Not the answer you're looking for? Thanks! Sub Open_FundNoteTemplate() Set Wordapp = CreateObject("word.Application") Wordapp.documents.Open "\\lon0306.london.schroders.com\dfs\data\dta\SIM_SPF\Investment\Investment Selection\Fund Research & Documentation\__FUND NOTE TEMPLATES\YYYY-MM-DD Fund Note - Fund_Name.doc" Wordapp.Visible = True End Sub ...however since switching to Office 2010 I get When I run Monday's Macro everything is fine, but when I run Tuesday's macro I get a Runtime error 462 saying it can't find the datasource.

Regards MD MVP (Excel 2008-2010) "Provide sample data and layout if you want a quicker solution." - MD To help indent your macros try Smart Indent Please remember to mark threads Each word document contains 1 table, with the same layout: 2 columns, 20 rows. As Nothing, wrdApp.Close, ...) Hope that helps, Regards, Max share|improve this answer answered Jun 15 '11 at 9:45 JMax 16.5k84469 add a comment| up vote 0 down vote or you can Are there 2 Winwords running?

Did Sputnik 1 have attitude control? I have looked on the internet without much sucess. My current macro stops as soon as word is opened as if there is no communication link between Excel and Word. DB Reserved Words checker Connection strings ..

You currently have 0 posts. Close the current word document, then open the next one in the folder and repeat above steps So if I had 200 Word documents, then 200 rows would be imported into This could explain why doing the ReSet works. My code is as follows: Sub PasteToWord() Dim WDapp As Word.Application Dim WDdoc As Word.Document Set WDapp = GetObject(, "word.application") Set WDdoc = WDapp.ActiveDocument Sheets("TDS 2000").Select ActiveSheet.Range("a1:h65").Copy With WDapp .Selection.PasteSpecial link:=False,

Also, i guess I have a second question: If that value is Null, then how do that trigger this loop? Thanks again for your time. Reason: Problem resolved Reply With Quote Dec 13th, 2011,03:07 AM #2 westconn1 View Profile View Forum Posts PowerPoster Join Date Dec 2004 Posts 21,925 Re: [VBA Word/Excel] Error 462 when running Help! -- Michael J.

Andrew and Colin, I owe you both an ale. Edit: Nvm, worked it out . Thanks Ask Your Own Question Use Vba To Copy An Excel Range Into Word And Resize - Excel Excel Forum Hello Everyone, I've been working on this one for the past Simple Excel Function to Extract a Word or Text from a Cell Excel function that makes it easy to extract a word or text from a cell in Excel.

You currently have 0 posts. Does anyone have any ideas as to what I may have missed. The code is: (the error is the second line) Code: If Executive.Cells(4, 14) > 0 Then Retirement.Cells(17, 7) = Retirement.Cells(17,6) / Executive.Cells(4, 14) The debugger says that the value of Retirement.Cells(17,6) This macro works perfectly fine on most sets of data, however on larger sets, I get a Timeout expired '-214721871 (80040e31)'.

Have a look here : http://support.microsoft.com/default.aspx?kbid=178510 You could also have a look here : http://www.tek-tips.com/viewthread.cfm?qid=756598 And finally : you should avoid using the with block with a Word Application object you The part of code where I use Excel looks like this: Dim ark As Excel.Workbook Dim xlSheet As Excel.Worksheet Set ark = Excel.Workbooks.Open(FileName:=scexcel) Set xlSheet = ark.Worksheets("Sheet1") a = Sheets("Sheet1").Range("B" & I assume it's because I'm not closing them after the last line of code? For example, the orginal excel file was on the old server named Jerry, in .../reportpro/excel.xls The new server is named George and although the directory structure of the new server is

This Time number format means that inst Open a Word Document from Excel - This Microsoft Excel macro will open a Microsoft Word document from excel. What is the most expensive item I could buy with £50? Code: oApp.ActiveDocument.Close oApp.Quit Set oApp = Nothing Set myMerge = Nothing __________________ Regards, Paul Eugin To view links or images in signatures your post count must be 10 or greater. Thanking you in advance for your assistance.

Automatically open each Word doc (1 at a time). Reply With Quote 11-14-2006,07:33 AM #4 fumei View Profile View Forum Posts View Blog Entries View Articles VBAX Wizard Joined May 2004 Posts 6,713 Location OK, let me run though this. Thanks Ask Your Own Question Open Word Document From Excel Vba - Excel Excel Forum Hi all I'm trying to open a word document from excel using VBA. There is a USER folder, but the Excel files were never there and are not there.