Hello
With the help of this Forum, I almost finish my Relational Database Project exercise.
In my Db I have a Form with three textboxes and a one command button:
txtbx_plot : user enter a value
txtbx_from:user picks date1
txtbx_to : user picks date2
cmb: exports Query to Excel at "test2" carpet and creates a chart. This is my code:
Sometimes this code is spewing this error message: 'ERROR 438 Object doesn't support this Property or Method',Please Login or Register to view this content.
and then it highlights in yellow this line:
To fix the error I open Task Manager to force quit all Excel Application and delete the exported query file in test2 carpet path. Therefore, any time I run the code,Please Login or Register to view this content.
I must check that any Excel Application is not running in Task Manager and the same exported query file name is not in the test2 carpet.
How can I avoid error 438 when running my code?
How can I overwrite the exported query file name?
In addition, if the user makes a mistake in any textbox in the Form, how can I avoid my macro stops?
Trying to fix myself SUCH ERROR 438 I already studied the links below with no success
http://dailydoseofexcel.com/archives...ivex-controls/
http:////social.technet.microsoft.com...14?forum=excel
http://answers.microsoft.com/en-us/o...d-e6589dec213a
In spite of heavy googling, I am not able to find solutions to my problems.
Any help would be greatly appreciated.
Cheers
Bookmarks