Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel97 (w/ VBA) Template won't open in Excel2003

I'm helping a coworker with an excel spreadsheet which interfaces wit
an oracle (I believe) database. The template opens fine in Excel 97
yet fails to produce anything at all when it is used to create a ne
file in Excel2003. Excel simply acts as if you had clicked nothing a
all. The macros aren't loaded, and the page doesn't change.

If you need more info about the problem, please ask

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Excel97 (w/ VBA) Template won't open in Excel2003

Hi
Some questions
- is there any error message?
- What security level for macros is set
- Is there an Auto_open or Workbook_open macro. If yes could you post
the code



--
Regards
Frank Kabel
Frankfurt, Germany


I'm helping a coworker with an excel spreadsheet which interfaces

with
an oracle (I believe) database. The template opens fine in Excel 97,
yet fails to produce anything at all when it is used to create a new
file in Excel2003. Excel simply acts as if you had clicked nothing

at
all. The macros aren't loaded, and the page doesn't change.

If you need more info about the problem, please ask!


---
Message posted from http://www.ExcelForum.com/


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel97 (w/ VBA) Template won't open in Excel2003

No error messages, nor any response of any kind. Nothing in the even
logs either.

Medium Security level, such that it asks before running all macros.

Neither of those macros exist. Only three custom macros, whic
incidentally, are what I'm supposed to help them debug.

Thanks for the response

--
Message posted from http://www.ExcelForum.com

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Excel97 (w/ VBA) Template won't open in Excel2003

Hi
if you like email me your file and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany


No error messages, nor any response of any kind. Nothing in the

event
logs either.

Medium Security level, such that it asks before running all macros.

Neither of those macros exist. Only three custom macros, which
incidentally, are what I'm supposed to help them debug.

Thanks for the response!


---
Message posted from http://www.ExcelForum.com/


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel97 (w/ VBA) Template won't open in Excel2003

I checked with the leaders of the project, and they said that's a bi
no-no. Apparently there's information in the file that would not b
suitable to release. Can you give me any suggestions of things to loo
for

--
Message posted from http://www.ExcelForum.com



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Excel97 (w/ VBA) Template won't open in Excel2003

Hi
then very difficult to say. Some ideas:
- check the database connection
- try removing this database connection part and see if the template
opens afterwards
- check all used macros (if there're any)

--
Regards
Frank Kabel
Frankfurt, Germany


I checked with the leaders of the project, and they said that's a big
no-no. Apparently there's information in the file that would not be
suitable to release. Can you give me any suggestions of things to
look for?


---
Message posted from http://www.ExcelForum.com/


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
Error"cannot open template wizard" in excel2003 is appearing ? Balram Anand Excel Discussion (Misc queries) 2 July 14th 06 04:23 PM
Excel2003 from Excel97 JohnL Excel Discussion (Misc queries) 3 April 15th 05 11:41 PM
MS-Query code from EXCEL97 doesn't work in EXCEL2003 ?? ln54 Excel Discussion (Misc queries) 4 February 21st 05 08:12 PM
formula from Excel97 doesn't work in Excel2003,any ideas why? nic Excel Worksheet Functions 6 November 8th 04 04:40 PM
Opening Open File Dialogue box from Excel97 Scampa7[_5_] Excel Programming 0 November 19th 03 08:34 PM


All times are GMT +1. The time now is 12:44 PM.

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

About Us

"It's about Microsoft Excel"