No VB Skills & "Invalid outside call" Error with Excel Import

[Shiseiji]

Hi All. I miss when I could simply have the appplication record my steps and save it as a macro. I sure wish Big Brother Bill had left in something like "Lower level programming for non-programmers." . . . I can pick my way through reading basic VB, but I've learned I'm not going to be a programmer. "Can't put in what God (or genitics) left out." So when it barfs, I usually don't know why.

I'm trying to use Ken's code (http://www.accessmvp.com/kdsnell/EXCEL_Import.htm ) to create a macro to import an Excel file to an Access table. I've created a module named "M_API" with the Getz code. I created a module with Ken's "Browse to a single EXCEL File and Import Data from that EXCEL File via TransferSpreadsheet (VBA)" named "M1_Import_EDW" Then I created a macro named "M1_Import_EDW_Excel" to run the module.

When I debug I get the "Invalid outside call" error on: blnHasFieldNames = True

I must be missing something really basic as this code has been around for a long time. But I have no idea what. I get the same error Getz's code.

TIA

Ron

[Hawkeye16]

You're just setting a variable's value in that line, I am not sure why you would get that error. Maybe someone who has used this will have some insight...

[Shiseiji]

Thanks Hawkeye, I "thought" I understood the Dim, but . . . appriciate the comment.

R

[Hawkeye16]

The line you typed above is separate of the DIM line.

The DIM is just telling the program what kind of information the variable is going to hold. If you do not DIM something it can be a variant and hold many different types of information (depending on what you set it equal to) but it can cause errors if you are not careful so defining it at the start is a better approach.

In this case it is set as a Boolean which can take True or False, which is what the line you are getting the error on is doing, trying to set the value of the boolean variable.

[Shiseiji]

Sorry, my poor communications. However your explanation is the best I have read! I was making a poor joke of my limited skills and what little I do know: Dim blnHasFieldNames As Boolean

Which I set as "True" per the comment:
' Change this next line to True if the first row in EXCEL worksheet
' has field names

An example of what I can read but not program on my own.

R