Rampant Lion
11-06-2010, 03:17 PM
I am new to VBA, userforms and AddIns and need help. I have Excel 2003. I am trying to develop a userform that users can select the input files they want to process, then launch the addin, which will process them. I keep getting a: 'Compile Error: Sub or Function not defined' and need help to get this to work.
I have attached the userform file...and apparently cannot attach more than 1 file. The AddIn is TestAddinCall.xla, which started as a .xls file and I ran code to save it as an addin in C:\Documents and Settings\Jay\ApplicationData\Microsoft\AddIns. In the attached file, I selected this addin to be linked to this VBAProject. Thanks in advance for your help...
Jay
I have attached the userform file...and apparently cannot attach more than 1 file. The AddIn is TestAddinCall.xla, which started as a .xls file and I ran code to save it as an addin in C:\Documents and Settings\Jay\ApplicationData\Microsoft\AddIns. In the attached file, I selected this addin to be linked to this VBAProject. Thanks in advance for your help...
Jay