Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Error when opening Excel 2000 workbooks

Status
Not open for further replies.
JJayUK

JJayUK

Programmer
Joined
Dec 18, 2001
Messages
57
Location
GB
Hi,

We're running Office 2000 (Recently converted) and one of our users spreadsheets was originally written in Excel 97. The spreadsheet has a VBA macro behind it which performs some imports and tidying before saving the sheet to a file using the ActiveWorkbook.SaveAs method.

When we try to open this newly saved Workbook we get an application exception error and it shuts itself down.

Has anyone else had experience with such a problem.

Any help would be appreciated.
Regards,
JJayUK
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
morechocolate
  • Locked
  • Question Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
2K
morechocolate
morechocolate
Andrzejek
  • Locked
  • Question Question
Outlook VBA - Trust access
Replies
3
Views
1K
hermanlaksko
hermanlaksko
f0rg3tfu1
  • Locked
  • Question Question
VBA Error in Excel
Replies
11
Views
2K
combo
combo
remeng
  • Locked
  • Helpful tip Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top