Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2000 to excel 2003

Hi,

I have a excel file with VBA inside and it's working fine in excel
2000. But when I try it to excel 2003 I received a message like: error
1004 error defined the objet or the application and it does not work.
Could you help me.

Thank you,


Regards

Nathalie
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 618
Default Excel 2000 to excel 2003

Hi

it would probably help if when you next get the message you click on the
debug button and make a note of the line in yellow ... and then type this
into a post
it could be as simple as a reference missing under tools / reference but
without knowing your code or what it does it's a bit hard to say.

Cheers
JulieD

"Nathalie" wrote in message
om...
Hi,

I have a excel file with VBA inside and it's working fine in excel
2000. But when I try it to excel 2003 I received a message like: error
1004 error defined the objet or the application and it does not work.
Could you help me.

Thank you,


Regards

Nathalie



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Excel 2000 to excel 2003

Hi
you may post the relevant code which causes this error

--
Regards
Frank Kabel
Frankfurt, Germany

"Nathalie" schrieb im Newsbeitrag
om...
Hi,

I have a excel file with VBA inside and it's working fine in excel
2000. But when I try it to excel 2003 I received a message like:

error
1004 error defined the objet or the application and it does not work.
Could you help me.

Thank you,


Regards

Nathalie


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2000 to excel 2003

"Frank Kabel" wrote in message ...
Hi
you may post the relevant code which causes this error

--
Regards
Frank Kabel
Frankfurt, Germany

"Nathalie" schrieb im Newsbeitrag
om...
Hi,

I have a excel file with VBA inside and it's working fine in excel
2000. But when I try it to excel 2003 I received a message like:

error
1004 error defined the objet or the application and it does not work.
Could you help me.

Thank you,


Regards

Nathalie



Here is the code where the debug is pointing me:

'Sauvegarde des fichiers de configuration pour Actuate
Call ClearExcessRowsAndColumns
ActiveWorkbook.Worksheets("cimbcklg").SaveAs
Filename:="c:\cimini\cimbcklg.cim", FileFormat:=xlCurrentPlatformText
ActiveWorkbook.Worksheets("cimbcklg_act").SaveAs
Filename:="c:\cimini\cimbcklg_act.cim",
FileFormat:=xlCurrentPlatformText
ActiveWorkbook.Worksheets("general_act").SaveAs
Filename:="c:\cimini\general_act.cim",
FileFormat:=xlCurrentPlatformText
ActiveWorkbook.SaveAs "c:\cimini\ciminicraftot.xls", xlWorkbook
ActiveWorkbook.Saved = True
'Application.AlertBeforeOverwriting = AlertBeforeOverwriting
'Application.DisplayAlerts = DisplayAlerts
End Sub

Thank you
Nathalie
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 patch to view newer Excel versions (2003 and 2007) jmanuel Excel Discussion (Misc queries) 3 January 29th 09 05:11 PM
Opening files in Excel 2003 saved in Excel 2000 without data loss... [email protected] Excel Discussion (Misc queries) 0 January 29th 07 07:19 PM
Excel 2000 and Excel 2003 in Office 2003 Emon New Users to Excel 0 December 21st 06 09:11 AM
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? brigida3 Excel Discussion (Misc queries) 1 January 22nd 06 05:13 PM
Excel 2003 crashes loading excel files created Excel 2000 Jeff Lewin Australia Excel Discussion (Misc queries) 0 June 27th 05 04:20 AM


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"