LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?

Have the following situation:
An .xla file will import a Sub from a text file and then run it like this:

Dim strSub as String

'some code here to get the Sub imported
Application.Run strSub

Now it is possible that in this imported Sub are variables that are not
defined publicly, so there
will be a compile error, variable not defined.
As this is not a runtime error I am not sure this error can be handled
gracefully, but I would be interested
in any suggestions how this could be done.


RBS

 
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 10:20 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"