MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to export data from a form to be saved in a common folder

  Asked By: Meenachi    Date: Sep 05    Category: MS Office    Views: 2846

I'm new to VB, but I'm working on it. What I'm trying to do is
create a macro that records certain information from a form in excel
that I've already made. I want to export the specific information to a
public folder for the purpose of filing/saving data.

I'm planning on creating a button on the sheet that I press, and then
the information would be saved and backed up in the other folder each
time new data is entered into the form.

I'm reading about it all, but I'm not sure what to search for or what
questions to ask. I was hoping someone could tell me what
commands/skills that I need to know/learn in order to complete this



1 Answer Found

Answer #1    Answered By: Bama Cohen     Answered On: Sep 05

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

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

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!