VBA Question

[mottelecom]

OK, I've done research and reading for the past three days for something I think should be easy to do.... I created a workbook template, and am trying to accomplish the following:

When someone opens the workbook, a form opens up prompting for a Reference #, Description, and Name. With that information I would like to auto fill a field in the form that will name and save the document with \\network path\Reference# -Description.xls. I've created the form, but cannot get it to initialize. I have no idea how to create global variables that will populate the documents name and save it to a directory.

This seems like a simple taks, but Ive been trying to get it to work for several days.

HELP

Thanks

MOTTECH

 

[TomCologne]

Try this:

Private Sub Workbook_Open()
    UserForm1.Show
End Sub

Replace Userform1 with the name of your form.

TomCologne