Word UserForm, Excel UserForm, they're both the same.
If you have to run from Word, you'll need to use Automation to talk to
Excel, something like ..
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlapp.Workbooks.Add
Set xlSheet = xlwb.Sheets(1)
You can then reference individual cells like this ...
xlSheet.Cells(_row_, _column_)
And, when you're done ...
xlBook.SaveAs ...
xlBook.Close
xlApp.Quit
If you want more detail, I suggest you ask in an Excel newsgroup - and
provide details about what is on your yserform and how you want it arranged
in a worksheet.
--
Enjoy,
Tony
> I am trying to find a method to populate an excell sheet with information
> that is entered into a Word userform that I have created. I am quite new to
> VBA and have had great difficulty in finding a solution. Can someone please
> point me towards the light!
Zoltar54 - 09 Feb 2006 16:01 GMT
Thanks a million, I'll give this a shot and follow-up in an excel group.
Z
> Word UserForm, Excel UserForm, they're both the same.
>
[quoted text clipped - 29 lines]
> please
> > point me towards the light!