Runtime errors

**toggel** · 06-23-2009, 01:23 PM

Hello I am currently writing a macro that will take one or more files that I choose and will copy them onto a template which will then generate a graph.
Since the files are saved in different formats I created an if loop that determines which file type it is then calls on the apporpriate subroutine.

Please Login or Register  to view this content.

which when i had just a message box in each sub routine it worked fine. Now writing the subroutines I am getting a error inside a the following subroutine.

Please Login or Register  to view this content.

now when i hit run/debug i get a run-time error '424': Object required

on either the line that starts with test_type or location.

how do i fix this error?

**toggel** · 06-23-2009, 01:32 PM

In what line are you referring to?

**shg** · 06-23-2009, 01:33 PM

temp is a local variable in the first routine. If it is to be used in other routines, it must be a module-level variable declared above all other procedures, e.g.,

Please Login or Register  to view this content.

**toggel** · 06-23-2009, 01:40 PM

I added the line

Please Login or Register  to view this content.

in both routines and now get a different run-time error.

In the same line I now get run-time error '91': Object variable or with block not set.

**shg** · 06-23-2009, 01:43 PM

It doesn't do you any good to declare it in the other routine; then both routines have a variable named temp, and they are completely unrelated. You need to declare it outside BOTH routines, and NOT declare it in EITHER.

**toggel** · 06-23-2009, 01:53 PM

Thank you very much for your help. As you can tell I am pretty much new to coding let alone vba.

**shg** · 06-23-2009, 01:55 PM

You're welcome. If that sorts it for you, would you please mark the thread as Solved?

You should see VBE Help for Understanding Scope and Visibility