excel runtime error 9 Coolville Ohio

Address 4882 Tick Ridge Rd, Vincent, OH 45784
Phone (740) 678-2627
Website Link http://www.tourohio.com

excel runtime error 9 Coolville, Ohio

In the latter, I have a macro containg only one line of code: VB: Workbooks("FileList.xls").Activate If you like these VB formatting tags please consider sponsoring me in support of injured Royal Project Explorer Folders Missing When you work in the Visual Basic Editor, the Project Explorer is usually visible, showing a list of all the open VBA projects. The time now is 04:14 AM. E-mail: Advertisements How To Solve A Run-time Error 9 Search Excel Forum Posts, Tutorials, Macros, Tips, and More New Excel Help Service!

All is well with 6 of the sheets, but when I use print preview on the other 2 I get a message: Run-time error 50290 Method 'FullName' of object '_Workbook' failed This causes the files to become unreadable, leading Windows to be unable to process the commands you need, leading to it showing the error. What kind of bicycle clamps are these? Method 'SaveAs' of object '_Workbook' failed.

I Know that I can change this value, so I don't need to do this. Share Share this post on Digg Del.icio.us Technorati Twitter Tom Urtis Microsoft MVP - Excel Reply With Quote Apr 4th, 2004,10:41 AM #8 dmcoffman New Member Join Date Jul 2002 Location I'm pretty new at this so I don't know what I need to do in order to solve this. It isn't - I've even copied the name from the file label and pasted it into the macro.

Do you want to replace it? I have tried every permutation of this line of code. How do I explain that this is a terrible idea? I would still recommend you take another look at the spelling difference between the sheet tab and the code.

Instead, you must use Dim or ReDim to specify explicitly the number of elements in an array. Many-many thanks!! Any ideas how to solve this, it is very annoying. Are independent variables really independent?

Is there a "Sheet1" in your workbook? I also met Werner vB but he could not have helped me here. Many thanks in advance. The user can then read what to do to solve the problem.

To stop the macro, click the End button. Why can't I select 'No'! 2) What other option do I have to display that the file is already there and select 'No' and not get the run-time error.? Worksheets("Data&Parms") can't be found in the wb that IS currently defined in wbMEgdF. Some background info - I am using Excel 2000.

Thanks! The workbook you are trying to save has the same as a None of these conditions are true. We are grateful for any donations, large and small! © 2016 Personal Computer Fixes. Yes you are a rocket scientist.

Thanks for any help you can provide since I'm new to supporting macros and it's been awhile since I programmed anything - I'm sure it's something very simple that I'm missing. We need your input to help create a new Live Online Excel Help service. Try using the For Each...Next construct instead of specifying index elements. Usually this works fine.

Macros tried available upon request. Save the Changes and Test the Macro On the VBE Toolbar, click the Save button, then close the VBE window, and return to Excel Run the macro again, and it should Show: Inherited Protected Print Export (0) Print Export (0) Share IN THIS ARTICLE Is this page helpful? Click the + or - button at the left of a project name, to open and close the list of objects for that project.

Workbook MEgdF.xls Worksheet “Data&Parms”, Column H: Input data in cells 1 to 21 Worksheet “Output”, Column F: estimated data in cells 1 to 41. If so, unhide it before opening the workbook the next time. To fix this problem, you can make the following change in the Registry. Helpful Excel Macros Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts - Delete all chart sheets and tabs in Excel using this macro.

Rating is available when the video has been rented. Our recommended virus scanner is a program called XoftSpy Step 4 - Clean Out The Registry Download this registry cleaner The registry is a big cause of the Runtime 9 error, thanks Don Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Apr 4th, 2004,11:01 AM #9 Tom Urtis MrExcel MVP Join Date Feb 2002 Location San Francisco, California USA I also hope that I am reading your statement 2.