Question about Microsoft Excel for PC
Hello, I recently upgraded my excel version from 32-bit to 64-bit. I currently use a spreadsheet that runs a macro that saves a file received via email each day to a local folder and then open it up for use. In the 32-bit my VB coding worked without any issue. Now however when I run the code I get the following error message: Run-time error Office has detected a problem with this file. To help protect your computer this file cannot be opened. I have to manually go into the directory, open the file and enable it to be opened in edit view. Below is the current code Public Sub GetAttachments_CURE Dim FileName As String Dim i As Integer Dim timestamp As Date Dim filecheck As Boolean Dim ASK As String Dim TRYBOOK As String Dim Txt As String Dim Itemcheck As Object TRYBOOK = ActiveWorkbook.Name filecheck = False Set Itemcheck = Nothing Set olkAPp = CreateObjectoutlook.application Set ns = olkAPp.GetNamespaceMAPI Set Inbox = olkAPp.Session.FoldersLondon MO - Rates.FoldersInbox i = 0 If Inbox.Items.Count = 0 Then MsgBox There are no messages in the Inbox., vbInformation, Nothing Found Exit Sub End If For Each Item In Inbox.Items For Each Atmt In Item.Attachments If LeftAtmt, 7 Picture And LeftAtmt, 5 image Then If LCaseAtmt.FileName Like *.xls* Then If Atmt.FileName = MO_London_Rates.xls Then If DirC:\Temp\CURE.xls Then Kill C:\Temp\CURE.xls End If FileName = C:\Temp\CURE.xls Atmt.SaveAsFile FileName Workbooks.Open C:\Temp\CURE.xls If MidRangeA6.Value, 45, 2 & / & MidRangeA6.Value, 42, 2 & / & MidRangeA6.Value, 48, 4 FormatNow, DD/MM/YYYY Then MsgBox The CURE file contains old data!!!, vbOKOnly + vbExclamation, OLD DATA!!! End If RangeA6:F300.Select Selection.Copy WorkbooksTRYBOOK.Activate SheetsCURE_Flat.Select RangeA6.Select ActiveSheet.Paste ActiveSheet.Calculate Exit Sub End If End If End If Next Atmt 'Line1: Next Item 'goto exitSub 'GetAttachments_exit: Set Atmt = Nothing Set Item = Nothing Set ns = Nothing ' GoTo Line1 'GetAttachments_err: ' Resume GetAttachments_exit 'exitSub: MsgBox NO CURE FILE PRESENT!!! End End Sub
I was like that when the problem exists when double-clicking in Windows Explorer. Then I get the message that the program isn't responding and have the option to close or wait. After a few moments Excel does eventually open and I can work on the file. I do not have the problem when I open the file directly form Excel.
Read here, perhaps this article will help you - Excel Restore Toolbox http://www.excel.restoretools.com/
Posted on Jul 17, 2015
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 05, 2014 | Toshiba Satellite Computers & Internet
May 19, 2011 | Rand Mcnally TripMaker 1999 Full Version...
Jun 10, 2010 | Microsoft Windows XP Professional for PC
May 06, 2010 | Microsoft EXCEL MAC UPGRADE 2008 Upgrade...
Apr 08, 2010 | Dell Precision Workstation 490 - MT -...
Feb 04, 2010 | Microsoft Computers & Internet
Jul 10, 2009 | Microsoft Office 2003 Professional Full...
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
155 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: