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 Mike Lewis 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
Dec 18, 2001
57
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
588
remeng
remeng
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
607
morechocolate
morechocolate
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
464
hermanlaksko
hermanlaksko
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
332
combo
combo
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
323
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top