Write UserForm values to a closed workbook

[hellebore08]

Hi Everyone,

I'm sorry if the same has been asked before, but I haven't got a clue yet from searching.

So..

I have this Feedback Form (UserForm). I want the feedback form values to be written on a closed workbook. Say, "C:\EGD\Temp.xls". The UserForm is filled out by many users and, of course, the excel workbook is shared. After that, the workbook should be saved.

I can't get to work around 'ADO' functions posted in other threads.

My only problem is in the 'writing of values' part.

Any suggestions you may have are welcome. Hope you could help me on this one.

Thanks,
E-R Gabriel Doronila

 

[hellebore08]

Never mind.

I got my own answer. Thanks for nothing

 

[Norie]

Hellebore

I'm sorry no one helped but it is kind of hard when there's not much information.

 

[hellebore08]

I'm sorry that it doesn't seem to me like you tried to help. You could've at least posted a simple code. What I asked is clear enough, and no illustration is needed.

but that's okay.. really...