Is the "form in excel that I have already made" a User form  or an excel
spreadsheet?

What files do you want the public folder  to contain? One excel file for
each time you run your export  macro? One excel file which contains a new
set of data  or a new sheet  each time you export? One excel file which is
replaced each time you export? A text file (similar options)

How many data items do you want to export each time?

How are the data items arranged on the form? (Particularly if it is a
spreadsheet?)

The steps you will need to understand are:

- creating  the button  - see my reply on "How to add close button" You will
put something different in the sub.

- Opening or creating a file (Try recording your actions doing it manually
and then look at the recorded macro)

Extracting info from the "form" (ditto unless it is a userform in which case
you just refer to formname.controlname.value)

Writing data to a spreadsheet (unless your output is a text file in which
case look at write in vba help)

Hey, try it and come back to us if you get stuck!