Search : in
By :

Excel won't opened saved .xlsx files

saints77, on Mar 13, 2009 5:28:54 pm GMT 
 Report this message to moderators

Hello,
I am wondering if it is a bug with excel or it is in my vb macro language, after opening a text file, and performing some initial table setups. l then save the file using a macro, but at the end of the macro, where l attempt to verify if the file has been saved. excel error of the .xlsx file being corrupt and not being able to open the file: runing XP fully patched: below is the macro l use to save the open workbook: TIA

Public Sub WbCopySaved()


Dim wbActiveBook As Workbook
Dim NewFileName As String
Dim fFilt As String

fFilt = "Microsoft 2007Excel Files (*.xlsx), *.xlsx,"


On Error GoTo CodeError


'Get a filename to save as
NewFileName = Application.GetSaveAsFilename(fileFilter:=fFilt, Title:="Save Copy of File")

If NewFileName = "" Then Exit Sub 'User chose Cancel

ActiveWorkbook.SaveCopyAs NewFileName
Set wbActiveBook = Workbooks.Open(NewFileName)
MsgBox "Saved as" & NewFileName
Exit Sub

CodeError:

MsgBox Err.Description, vbExclamation, "An Error Occurred"

End Sub


saints77

Configuration: Windows XP
Firefox 3.0.7

Best answers for « Excel won't opened saved .xlsx files » in :
Opening a PPS FILE ShowOpening a PPS FILE PPS, acronym for PowerPoint Show, is a tool created by Microsoft Office PowerPoint for distinguished presentations and slideshows. PowerPoint enables you to draft your own presentation within different display and design...
Create and Open a RAR file ShowCreate and Open a RAR file *How to create a RAR file *How to open a RAR file RAR is an archive file format that is used during data compression, error recovery and file spanning. RAR is the acronym for Roshal Archive, inspired by...
Open a MSI file ShowOpening a MSI file A MSI file is an installer for Microsoft Windows Installer. To install an MSI file format, download and install the following software on below link: Windows Installer