Results 1 to 4 of 4

Thread: Problem opening Excel file with VBA code

  1. #1
    Join Date
    Jan 2009
    Posts
    150

    Problem opening Excel file with VBA code

    As part of my job I made an Excel application using forms and a lot of VBA code. Outside I get errors opening it. After minor modifications (modification of protective sheets, etc. ..) the file opens, seeking enforcement of macros, and after validation macros ... big crash, Excel closes (asking if you want to send an error report). On my PC, with the same version of Excel (2003 SP3), no worries ..... I registered under another name the file and it opens properly again!

    Have you ever noticed such kind of problems? Do you have any solution or suggestions?

    If I need to share the file (2MB) but I am not able to managed the identify of a specific part.

  2. #2
    Join Date
    May 2008
    Posts
    2,389

    Re: Problem opening Excel file with VBA code

    I have spend a good time or fiddled a lot with VBA in Excel, but I have never encountered this kind of behavior.

    Since you renamed the file, you still meet the same problem at the time of opening? Does it works properly for a new file or once met the problem if you open another file with the VBA macros does the same problem is applied to it? Can you post a copy of error messages that you receive, if any?

  3. #3
    Join Date
    Jan 2008
    Posts
    1,521

    Re: Problem opening Excel file with VBA code

    Have you monitored any changes on your files? Enabling macros => exit files => risk of infection => to fix this a good antivirus is required! Install MalwareBytes, it is awesome as well as effective but free.

  4. #4
    Join Date
    Jan 2009
    Posts
    150

    Re: Problem opening Excel file with VBA code

    Firstly, after renaming, no worries. The trouble is that I'm doing updates, including info on my spreadsheets and often when I put in production on some PC that I run excel. I have not seen any systematic link and that is the worry. Not just the new files, old version opens without problem. The error message is blank without further info.

Similar Threads

  1. Getting error when opening excel file using a VB script
    By Madri in forum Software Development
    Replies: 4
    Last Post: 18-07-2012, 06:27 PM
  2. Replies: 6
    Last Post: 17-02-2012, 01:18 PM
  3. Opening file type .tsv with Excel
    By Damned 2 in forum Windows Software
    Replies: 5
    Last Post: 12-01-2012, 11:12 PM
  4. Opening WK1 File in Microsoft Excel 2007
    By $horizon$ in forum Windows Software
    Replies: 3
    Last Post: 11-01-2012, 06:07 PM
  5. Opening an Excel file in VB.NET
    By Braze in forum Software Development
    Replies: 4
    Last Post: 26-01-2009, 09:03 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,905,677.48054 seconds with 17 queries