Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default How to make error handle for mis-typed variable?

The imported text files don't normally have public or even private
variables, although they could have.
I think I will go with may latest reply to Peter T's post.

RBS

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
"RB Smissaert" wrote in message
...
In fact checking all the variables doesn't even catch everything as there
could be wrongly
named functions and/or subs.


This is the core of the problem and I don't think it has a satisfactory
solution. Unfortunately you are working in the dark.

I wonder if there might be a way of importing not just the sub but also
all
globally declared variables. That might alleviate the problem.

--

Vasant



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
how do i make a hyperlink that adds text typed to the end of it? jmsleos Excel Discussion (Misc queries) 0 April 1st 08 05:19 AM
How do I make the auto fill handle to input data from left to righ Jason Excel Discussion (Misc queries) 2 March 12th 08 10:27 PM
"Windows cannot find ___.xls. Make sure you typed the name correc annnicho Excel Discussion (Misc queries) 9 September 14th 07 03:26 AM
How to make it so only specific words can be typed in a cell inspirz Excel Discussion (Misc queries) 2 March 29th 07 12:24 AM
formula typed contains an error associates Excel Worksheet Functions 1 June 11th 06 05:47 PM


All times are GMT +1. The time now is 02:58 AM.

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"