Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default Error : Invalid Data

Have you tried to open the workbook with Macros Disabled? This might let
you in and edit the module, if it is still a problem I suspect that the file
has been corrupted somehow and the lesson always save a backup copy of a
previous version of working code before making changes will be learn't - we
have all done it!!
Cheers
Nigel

"Ajit" wrote in message
...
I have an excel sheet with forms and lot of VBA code. I modified some

code, saved it and tested it ...it worked fine. I closed it and now when i
try to reopen it. It gives me an error : Invalid Data. If i try to go in the
particular Module where i made the changes it does'nt let me go in...with
same error (though i can view all other modules and code. I also tried
exporting it ...but again Mr. Invalid Error is on the gate and does'nt allow
me to do anything.

I have a slightest idea that the template might have been corrupted, but

no idea why...could anyone help me understand it(if possible). (I did not
use any new variables)

And any ideas.....what should i do(except redoing it).





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---
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 "invalid data source reference" for pivot table Manny Excel Worksheet Functions 6 April 5th 23 02:58 PM
Error Alert for Invalid Data doesn't work for data selected in col genegal Excel Worksheet Functions 0 January 25th 10 04:17 AM
Invalid Cell Reference error Ravi Excel Worksheet Functions 3 August 19th 08 09:47 PM
Invalid Data error Ajit[_4_] Excel Programming 0 March 5th 04 03:21 PM
invalid picture error Liam[_2_] Excel Programming 0 October 15th 03 07:18 PM


All times are GMT +1. The time now is 05:15 PM.

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"