run time error 9 excel 2003 Richvale California

Your local technology provider, dedicated to bringing solutions for business & home users.

Address Paradise, CA 95969
Phone (530) 872-0707
Website Link
Hours

run time error 9 excel 2003 Richvale, California

Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. I get an error message: "Run-time error '9': Subscript out of range" which can be an indicator that the file name is incorrect. I have the following macro that is correct except for the SaveAs gives me an error if I click 'No' or 'Cancel'. ..... Any ideas appreciated.

Why is my e-mail so much bigger than the attached files? I have one column with the VBA error and others with an ID, what the problem is and how to fix it. Delete files within all directories in a directory more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us I shut down, restarted, and tried your code again.

Last edited by exec_gerbil; 01-04-2013 at 02:32 PM. WE are running Windows XP SP2 and Excel 97 Thanks in advance Rick Ask Your Own Question Using Vba - Don't Want To Just Overwrite On Saveas - Excel Excel Forum The time now is 11:01 PM. If I have helped, Don't forget to add to my reputation (click on the star below the post) Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) Use

there are no links in that tabsheet. It would now first check if the files are all ok to be imported. Browse other questions tagged excel vba or ask your own question. Someone else may have a better solution.

Code: workDays = Application.WorksheetFunction.NetworkDays(dater, eomDate, "Support!R[-32]C[-6]:R[-22]C[1]") The error reads: Code: Run time error '1004': Unable to get the NetworkDays property of the WorksheetFunction class. It gives me the error message when it gets to the last line. If your RITE 1624 file is in a separate Excel instance, then the instance that your macro is in will not be able to see that file (and it won't appear Excel Video Tutorials / Excel Dashboards Reports Reply With Quote July 27th, 2011 #2 jolivanes View Profile View Forum Posts Established Member Join Date 8th July 2004 Posts 690 Re: Unable

I really would like a simple command that activates FileList - surely that's possible (or does Excel "not know" that FileList is there if some other program opened it?). Thanks so much to all of you who've contributed - I've learned a few useful things along the way. Join them; it only takes a minute: Sign up Runtime Error 9 up vote 0 down vote favorite I am writing a Macro in VBA. I click 'No' and get the run time error 1004 ....

It's an annoyance since it only adds a couple of steps to getting a print. Register To Reply 01-10-2013,05:45 PM #6 exec_gerbil View Profile View Forum Posts Registered User Join Date 01-04-2013 Location Vancouver, BC MS-Off Ver Excel 2010 Posts 7 Re: Run Time error 9 If it's a excel-2010 file like you indicate, you may need to update your code to reflect the extension of your "RITE 1624" file (e.g. .xlsx for a 2010 Excel workbook, Let me give you a brief description of what happens: Panorama places a load of data (file paths, file names, cell specs, formatting specs, parameters, etc) onto the clipboard and opens

Not the answer you're looking for? Anyway thanks for the support! Code Golf Golf Golf deleting folders with spaces in their names using xargs Does WiFi traffic from one client to another travel via the access point? If it is the 'Sheets' line then the issue is with the sheet name.

share|improve this answer edited Sep 22 '11 at 22:58 answered Sep 22 '11 at 22:45 brettdj 38.9k1564111 All the users are using xl2003 and the error is not poping Check that the filename matches your file. This same code works fine in Excel 2004 on the Macintosh. Is it because I am prompted to enable macros whenever I manually open this book, or because I am not referencing a sheet?

E-mail: Download Link: Top 15 Excel Tutorials Excel Tutorials Free Excel Macros Keyboard Shortcuts Excel Forum Contact Subscribe for Free Excel tips & more! The macro tends to work for a little while - say 40 rows - but then returns a run-time error. It's only when I click on the file which is on the desktop and open it that way , do I receive the error There are no other files open at Try open "Tester.xls" from [File] - [Open], not double clicking the file icon.

Anyway, this is what I came up with. May I suggest that perhaps you 'activate' the book first by placing the code before your problem line, this will ensure that the correct book has the focus before it attempts Fix the Vlookup ... To prove this change the sheet1 name to Test and look in this window again...

Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? How does a migratory species advance past the Stone Age? There are several possible reasons: The file name or path does not extist. How to slow down sessions?

Jen Ask Your Own Question Macro To Save And Close But Ignore Private Sub - Excel Excel Forum Hi all I have a private sub in a workbook to clear a I have checked the form's (Name) is frmRevenue but I can't think what else it might be. 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 Can it be because I just use the generic sheet names or the total (real) sheet names?

Microsoft MVP 2006-2011 Office Development FAQ (C#, VB.NET, VB 6, VBA) Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET If a post has helped you then Please Rate 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 Why is the bridge on smaller spacecraft at the front but not in bigger vessel? Thanks Ask Your Own Question Solving For Xirr Last Amount. - Excel Excel Forum Okay, this isn't a question, but an answer that I decided to post. (figured I'd contribute for