Device I O Error In Excel
Forums Excel Questions Device I/O Error - VBA Hacker? Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 16 Device I/O Error - VBA Hacker?This is a discussion on Device I/O Error - VBA Hacker? within the Excel Questions forums, part of how to remove div o error in excel the Question Forums category; Could someone tell me what would be causes for a " DEVICE I/O excel hide na Error" to appear? I have a file ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jun 23rd, 2003,02:19 PM #1 ChrisOK Board Regular Join Date Mar 2003 Location OKLAHOMA CITY Posts 524 Device I/O Error - VBA Hacker? Could someone tell me what would be causes for a " DEVICE I/O Error" to appear? I have a file that was shared and protected on a server. It was suspected that someone went into the unpassworded VBA editor and wiped out the sheets from the workbook- leaving only the "shell" of the file behind. Once done, you could not even "insert a new sheet" -- Now that the damage is done --- when you go to open the file - you get a simple: VBA Dialog Box which says: Device I/O Error Once you say: OK - then the file finishes opening - and it just looks like an empty shell. File name is at the top - but no sheets are present any longer. All options - such as SAVE AS and INSERT sheet are grayed out and inaccessible.... Luckily, I had a back up - but with the investigation - I need more info! I'm going to be meeting with our IT group to discuss the entire hacker situation today - and want more info on what would generate this error - other than a hacker getting into the file and destroying it. Or is it plain and simple: This error was generated (BECAUSE) someone accessed the VBA area and wiped out the guts of the file? If this is the case - great -- if not -- then I need more info -- Thanks! Need info ASAP -- Thanks Chris Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 23rd, 2003,03:52 PM #2 XL-Dennis Board Regular Join Date Jul 2002 Location Östersund, Sweden Posts 1,922 Re: Device I/O Error - VBA Hacker? Hi Chris, Hm, sounds strange however have You checked that the all the VBA-code is deleted or is some part still left and have been changed? I suspect that there still exist some garbish-code in the workbook. In my opinion there always exist at least one "smart a..." at the off
for 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 Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Getting a Device I/O error when opening or closing a userform after doing a "Save As" of the workbook. Want to Advertise Here? Solved Getting a Device I/O error when opening or closing a userform after doing a "Save As" of the workbook. Posted on 2007-06-10 Visual Basic Classic MS Excel 1 Verified Solution 5 http://www.mrexcel.com/forum/excel-questions/52820-device-i-o-error-visual-basic-applications-hacker.html Comments 573 Views Last Modified: 2012-08-14 I'm using Excel 2002. I have a workbook with a userform. At one point in processing, using VBA, I do a "Save As" of the workbook under a different name with the UserForm open. Then when I close the Userform, I get a "Device I/O Error". From that point on, everytime I load or unload the userform, I get that Error. It's an error message that has no Debug button, just https://www.experts-exchange.com/questions/22625111/Getting-a-Device-I-O-error-when-opening-or-closing-a-userform-after-doing-a-Save-As-of-the-workbook.html an OK, and after you click the OK, everything works like it should. How can I get rid of it? 0 Question by:cashonly Facebook Twitter LinkedIn Google LVL 85 Best Solution byRory Archibald If this happens no matter what workbooks you have open, it may be down to a faulty add-in or a workbook that opens whenever you start Excel. Try disabling all your add-ins and removing anything from the Go to Solution 5 Comments LVL 85 Overall: Level 85 MS Excel 85 Visual Basic Classic 28 Message Expert Comment by:Rory Archibald2007-06-11 Hi, What controls do you have on your userform and what code do you have in the userform's events, especially the Terminate and Deactivate events (if any)? It might be easiest if you could post a copy of the workbook at www.ee-stuff.com as this sort of error is notoriously difficult to diagnose. Regards, Rory 0 Message Author Comment by:cashonly2007-06-11 Actually, now that I dig into it more, it's worse than that. At first, I thought it was a UserForm issue, but actually, it occurs when I run ANY macro. I added this simple macro: Sub TestTest() msgbox "TestTest" End Sub It ran the Macro, showed the msgbox, then gave me the device error (twice actually), then returned to where I was in the workbook. I have even closed the workbook and re-
on when I open Excel for Office XP Device I/O error (Microsoft Visual basic) I hit ok and things work fine. Any ideas? , Dec 8, 2003 #1 Advertisements Mike A Guest You should http://www.pcreview.co.uk/threads/device-i-o-error-on-opening-excel.936933/ virus scan that file, especially if you downloaded it. If the file has a http://www.ozgrid.com/forum/showthread.php?t=22029 legitimate macro in it, there is probably a hard-coded path to a drive that does not exist on your computer. It should be pretty easy to fix. On Mon, 08 Dec 2003 06:14:02 -0500, wrote: >I get the following message on when I open Excel for Office XP Device >I/O error (Microsoft Visual basic) I hit ok and things o error work fine. Any >ideas? > Mike Argy Custom Office Solutions and Windows/UNIX applications Please post on-topic responses to the newsgroup To e-mail me, remove nospam from the address in the headers Mike A, Dec 10, 2003 #2 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username o error in and then you can ask your own questions on the forum. Sign Up Now! Similar Threads Multiple pages opening upon opening Chris Lillegard, Sep 1, 2003, in forum: Microsoft Excel Discussion Replies: 0 Views: 589 Chris Lillegard Sep 1, 2003 Opening an Excel 2002 worksheet in Excel 2003 Guest, Oct 22, 2004, in forum: Microsoft Excel Discussion Replies: 8 Views: 380 Guest Oct 25, 2004 excel 2002 opening excel 97 files as read only !!!! , Jul 19, 2005, in forum: Microsoft Excel Discussion Replies: 7 Views: 411 Jul 27, 2005 Opening Excel 2002 file in Excel 2000 problems Mark Christensen, Dec 1, 2005, in forum: Microsoft Excel Discussion Replies: 7 Views: 225 Dave Peterson Dec 1, 2005 how to remove the popup that reads, "the workbook you are opening contains macros" upon opening an e , Nov 14, 2006, in forum: Microsoft Excel Discussion Replies: 4 Views: 862 Debra Dalgleish Nov 14, 2006 Performance issue opening Excel 2002 workbook in Excel 2003 Jon Sherry, Dec 13, 2006, in forum: Microsoft Excel Discussion Replies: 0 Views: 243 Jon Sherry Dec 13, 2006 Error message opening query when opening file. Leo Rod, Mar 18, 2008, in forum: Microsoft Excel Discussion Replies: 0 Views: 465 Leo Rod Mar 18, 2008 Problem with opening Excel after opening Excel inside Microsoft Internet Contr
Way | Trading Add-ins For Excel | Convert Excel Into Calculating Web Pages Excel Web Pages | Produce Clean Efficient VBA Code Every Time | Build Automated Trading Models In Excel | Excel Web Pages | Excel Video Training Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts What's New? Advanced Search Forum HELP FORUMS Excel General Device I/O Error Excel Training / Excel Dashboards Reports 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 register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above. Click here to view the relaunched Ozgrid newsletter. Results 1 to 4 of 4 Thread: Device I/O Error Thread Tools Show Printable Version Search Thread Advanced Search July 27th, 2004 #1 Ranger View Profile View Forum Posts Long Term Member Join Date 25th January 2003 Location Scotland Posts 1,462 Device I/O Error Hi All, In the code of command button there are only two lines; Unload Me frmInternational.Show This workbook has been running happily for months, but now I get an error saying this selection method is not valid on the line: frmInternational.Show If I retype the line directly in front of it, remove the existing line and then run the code, it runs perfectly. Then when I shut down the Workbook, I get an Device I/O Error. Can anyone advise me on this please? Regards, Bill Excel Video Tutorials / Excel Dashboards Reports Reply With Quote July 28th, 2004 #2 Pesky Weasel View Profile View Forum Posts OZMVP Join Date 7th February 2003 Location Kewarra Beach, Cairns - TNQ Posts 1,055 Bill, Doesnt sound right to me. Could the workbook be corrupted? Have you recently changed Excel versions? Have you tried using the code in a new workbook? Regards Weasel Kind Regards Pesky Weasel "I have a plan so cunning, you could put a tail on it and call it a Weasel." EB Eag