Basic Error 68
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 01 Oct 2016 16:29:08 GMT by s_hv972 (squid/3.5.20)
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 can post: click the device unavailable vba register link above to proceed. To start viewing messages, select the forum that
Vba Dir Mac
you want to visit from the selection below. Results 1 to 10 of 10 Thread: Runtime Error 68 Device Unavailable
Device Unavailable Mercedes Radio
Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 19th, 2008,01:10 PM #1 Bob334 View Profile View Forum Posts http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/excel-run-time-error-68/34e2c6e4-2ffc-4fa9-ac3c-d77804501333 Thread Starter Lively Member Join Date Jul 2007 Posts 97 Runtime Error 68 Device Unavailable This is probably very easy to TRAP, can someone please help.... I am pointing to a device like DRIVE F [for example]. This may not be available on some computers, so if selected I want to TRAP this error so the program does not CRASH. How can I do this? Thank http://www.vbforums.com/showthread.php?523448-Runtime-Error-68-Device-Unavailable you for your help. PS: What drives are MOST available on computers other than c drive? I mean for CD ROM, DVD, etc.....I think drives D and E on everyones computer. Is this true. Thankyou. Bob Reply With Quote May 19th, 2008,01:22 PM #2 Teseng View Profile View Forum Posts Hyperactive Member Join Date Sep 2007 Location Tupelo, MS Posts 281 Re: Runtime Error 68 Device Unavailable Not sure about the first part, but i belive the most popular drives are C: D: and E: Depends on how many drives they're PC can hold really Reply With Quote May 19th, 2008,01:25 PM #3 Hack View Profile View Forum Posts Super Moderator Join Date Aug 2001 Location Searching for mendhak Posts 58,335 Re: Runtime Error 68 Device Unavailable Code: On Error GoTo ErrTrap 'your code here Exit Sub ErrTrap: If Err.Number = 68 Then Msgbox "The selected drive is not available at the moment." Else Msgbox Err.Number & " " & Err.Description End If End Sub Please use [Code]your code goes in here[/Code] tags when posting code. When you have received an answer to your question, please mark it as resolved using the Thread Tools menu. Be
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get https://www.experts-exchange.com/questions/10097707/Run-time-error-68-Device-unavailable.html Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Run-time error 68: Device unavailable Want to Advertise Here? Solved Run-time error 68: Device unavailable Posted on 1998-11-12 Visual Basic Classic 1 Verified Solution 11 Comments 1,616 Views Last Modified: 2012-06-22 I have a problem that's is driving me fool... This is my code: error 68 On Error GoTo TratarError If pedir_copia then frmDirectorio.fraCopia.Visible = True frmDirectorio.txtCopia.Text = "A:" frmDirectorio.drvCopia.Drive = "A:" frmDirectorio.dirCopia.Path = "A:" End If TratarError: If (Err.Number=68) Then MsgBox "Error", 16, "ERROR" End If Now, the problem... If I have a diskette in the A drive, all goes on right. But if I don't have a diskette inserted, I got the "Run-time error 68". I've basic error 68 tried to treat the error in this procedure, and in the event that ".Drive" generates, but I got nothing. Someone can help me, please? (sorry for my English) 0 Question by:amkhara Facebook Twitter LinkedIn Google LVL 3 Best Solution byfguerreiro_inix I've tested the folowing code and it works well. -------------------------- On Error GoTo ErrorRoutine File1.Path = "a:" Exit Sub ErrorRoutine: If Err.Number = 68 Then MsgBox Err.Number Go to Solution 11 Comments LVL 3 Overall: Level 3 Visual Basic Classic 2 Message Expert Comment by:traygreen1998-11-12 The error code will always execute because there is nothing to tell it not to. If the code is in a function put "exit sub" between the "end if" and the "TratarError:" If in a function put "exit function" between the "end if" and the "TratarError:" BTW: your English is better than quite a few anglos I know ;) 0 LVL 3 Overall: Level 3 Visual Basic Classic 1 Message Expert Comment by:vikiing1998-11-12 En lo posible, la rutina de tratamiento de errores debe hacer lo minimo indispensable. Si detectas el error 68, puedes bifurcar (via RESUME) a una seccion que trate ese error: On Error Goto TratarError bla bla bla End DeviceUnav: MsgBox("bla bla bla") Exit Sub Tratar