Compile Error: Method or data member not found

[JustinC]

Hi All,




I am currently trying to learn how to export data from access to excel using vba.
I am looking at this example www.accessibledatasolutions.com/articles11/AccessToExcel.htm However, when I type out the exact same code I got this error "Compile Error: Method or data member not found" and point to If IsNull(.txtExportPath) Then.


I would greatly appreciate if anyone can point me and guide me to solve this error.


Thank You!

[Jim Connell]

The line you're failing on If IsNull(.txtExportPath) requires something to work with.

If the textbox is left blank you'll get the error you're experiencing.

Replace the line above with

If LEN(.txtExportPath &"") <1 then

Essentially this will test to see if the user has typed anything into the textbox. If not then the user will be asked to enter a path..
Jim Connell
Custom Software
978-392-3462
http://custom-software.biz
Home of the Access Wizard

[John_G]

Not quite.

From what I can see, I think the error message is telling you that you do not have a control called txtExportPath on your form.

If you do, try changing .txtExportPath to !txtExportPath.

It is not supposed to matter, but I have seen cases where Access does get confused between "." and "!", and technically, the "!" should be used when referring to form controls or recordset members.

John

[JustinC]

Hi All,

Thanks for your help. I put a ! in front of txtExportPath and when I compile another error appeared "Compile Error: Sub or Function not defined" and point to RunExcel (strFullName). May I seek your help to solve this error? Thank You!

[John_G]

It is because for Access the routine RunExcel does not exist; it is not in the code on the web page.

Note the following on that web page:


NOTE: The following code is for demonstration purposes only and is not a complete coding solution.

The web page does not have all the code you need - it is missing that routine (RunExcel). You will have to try to contact the web page author to get more information.

John