excel 2003 runtime error 75 Churchville Virginia

Address 2209 N Augusta St, Staunton, VA 24401
Phone (540) 688-2215
Website Link

excel 2003 runtime error 75 Churchville, Virginia

I'm having a bit of trouble with the following code: Code: strSQL_strSSN = "SELECT DISTINCT strSSN FROM importData ORDER BY strSSN" Set rsSSN = New ADODB.Recordset Set cn2 = New ADODB.Connection Reply With Quote Sep 22nd, 2006,09:41 PM #19 randem View Profile View Forum Posts Visit Homepage Banned Join Date Oct 2002 Location Maui, Hawaii Posts 11,385 Re: [RESOLVED] VB Runtime error Our company has an Excel report that is generated by an application and is stored on a .jsp webpage. Developer Network Developer Network Developer Sign in MSDN subscriptions Get tools Downloads Visual Studio MSDN subscription access SDKs Trial software Free downloads Office resources SharePoint Server 2013 resources SQL Server 2014

Register To Reply 03-01-2012,03:44 AM #6 OnErrorGoto0 View Profile View Forum Posts Visit Homepage Forum Expert Join Date 12-30-2011 Location I DO NOT POST HERE ANYMORE MS-Off Ver I DO NOT Then I had to post status because of a personal hiatus. I have ensured that all modules have "Option Explicit" on the top (actually, i haven't checked if my forms have that; I'll do that now). Ask Your Own Question File Not Found Error - Excel Excel Forum The error that pops up has no information other than "File not found" in a dialog box with two

Join Now For immediate help use Live now! Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess! closed the file 6 reopened my file I thought to be clear I should say that the workbook itself is not locked nor are sheets protected, only the VBE is locked If I click "Debug", it goes to the VB Editor and shows that everything in the Project Explorer window is gone.

The sequence is something like this: 1. Just pull it up after starting Excel and use the buttons on the worksheet to enable and disable events. When I select debug, the object it cannot find is the userform that is automatically opened when the file is opened. Thanks for your help!

You do NOT have to pass |' | a filename to this routine, one is returned. |' | |' | FileExt$ is the file extension name you wish the |' | On my machine this application runs in both Excel 2007 and Excel 2010. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. Do any of the suggestions in this thread ( http://www.experts-exchange.com/Q_22993862.html#20395194 ) esp those from Rorya help?

I'll change the thread title to better reflect the issue. I have tried couple of other network locations but no luck. Version1 etc - if another copy of the file is already open? Sorry again, Saiju Paul C Excel Video Tutorials / Excel Dashboards Reports Reply With Quote Quick Navigation Excel General Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums: Forums

Take a moment to rate useful posts VB6 CodeBank: Glass Form & Tracing App , MouseWheel with Any Control , Form Previewer Utility VB6 Snippets: RTB: Disable Smooth Scrolling , Form: Many thanks in advance! I've attached my .xlsm file... In the excel macro, when the file is ...

An additional thing that it might be is the file name is hard coded in the code. Now the user gets the "Run Time Error 75 Path/File Access Error", upon clicking 'end' they still get the report, but it is an annoyance I'd like to correct. By editing these settings, you can change that. Featured Post IT, Stop Being Called Into Every Meeting Promoted by Highfive Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able

Register To Reply 02-29-2012,06:06 AM #4 snb View Profile View Forum Posts Visit Homepage Forum Expert Join Date 05-09-2010 Location VBA MS-Off Ver Redhat Posts 5,614 Re: OnTime - Crashes on once I close the VBA editor, the xls file is toast. If I run the program on 1 tool and save, Excel usually does not crash. Do you want to create this location?", vbCritical + vbYesNo, "Error") If a = vbYes Then MkDir "A:\KNITS\Season\" & Season & "\" & SeaYr & "\" & Category MkDir "F:\KNITS\Season\" &

Attached Files Score overlay2 - Copy.xlsm‎ (130.6 KB, 45 views) Download Last edited by Riggers; 03-05-2012 at 02:37 PM. However, it was next on my list. Can't find any code that would be addressing an invalid path via dir/open/etc., nor anything that appears to be wanting to interface the VBA Project. However, i have ensured that the users definitely have access to the network drive and the specific "log.inf" file.

Actually, I've never considered that: do you need a MkDir command for every folder level you create, or can you just use one command to cover it? Your comments about the differing responses for locked versus unlocked may provide the clue that a more experienced expert needs to provide an answer. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... The code I use for both is as follows: would working with the API calls create the problem?

Anyway, that's just pedantics really. When I get home tonight I'm going to try and recreate the simple workbook and single userform described by those other users to see if that errors too, although I'm not I suspect that autosave triggers the same crash. I need to track the usage of these reports.

Thanks. I'm sure I've seen a good discussion on potential issues of ActiveX controls but, now that I try to find it, it's eluding me. Register To Reply 03-01-2012,05:57 AM #11 OnErrorGoto0 View Profile View Forum Posts Visit Homepage Forum Expert Join Date 12-30-2011 Location I DO NOT POST HERE ANYMORE MS-Off Ver I DO NOT This occurs only when there is an execution error in the userform code module.

If it's an ActiveX issue, there may (?) be some clues in the Properties of any ActiveX controls used on Forms etc. Reply With Quote Sep 21st, 2006,04:23 PM #14 4x2y View Profile View Forum Posts Visit Homepage Frenzied Member Join Date Sep 2006 Location Egypt Posts 1,976 Re: VB Runtime error 75 If I try to open it from the existing window (even when I close this file and reopen it in the same window), I get "Path/File access error", and when I However I did not understand the language of the > 'work-around'. > > I greatly appreciate any ideas on how I can resolve this. > > Thank you.... > > >

If a file with the same name is already open the macro comes up with a Run-time error '1004' "You cannot save this workbook with the same name as another open Tony Bender, Apr 22, 2004 #10 Chip Pearson Guest Tony, You can use On Error logic to prevent errors from interrupting code execution. It refers to a range of cells that is formatted as a table with headings. Like DiplayAlerts = False, or something like that?

This application uses VBA Code and VBA Forms. Please connect to the network and reopen the file." End Sub Also, I have tried keeping an excel file in logs folder and tried updating the excel file for those users Remove Vlookup #N/A Error in Excel How to remove the #N/A error from Vlookup and replace it with a friendly message or a blank cell. So far I have debugged my code and copied my entire project into a new workbook, a version of which is attached.

Bpth machines are running Office 2007 Home & Student. But I would guess that such an error would throw EVERY time, not only some of the time. When I attempt to open the file, I get the following error: . Can anyone help please 0 Question by:Bunchil Facebook Twitter LinkedIn Google LVL 10 Active 6 days ago Best Solution bybroro183 hi, What happens if (can?) you "Load" the form before ".Show"ing

This error has the following causes and solutions: A statement, for example, Kill, Name, or Open, refers to a file that doesn't exist. To get a sense as to which > users were using which reports I added the following macro to this > application which logs the user name and the Excel workbook