Macros and saving .csv files

Before I can import data from a .csv file into a database, many columns
need to be formatted or values need to be replaced. Previously, this
manipulation used to be done manually and the import worked fine. I
have since recorded a macro to automate all the changes. But now the
import seems to be finding lots of empty records at the end and I have
to kill the import. How to save the .csv file so that blank rows are
not included in the import?

Try this..before you run the macro position the cursor to the row below the
last row containing data you wish to import. Press shift-ctrl-End at the same
time. Go to Edit clear All on the toolbar to clear all unused data. Run the
macro to create the csv. Hope this helps.
"whatageek" wrote:

> Before I can import data from a .csv file into a database, many columns
> need to be formatted or values need to be replaced. Previously, this
> manipulation used to be done manually and the import worked fine. I
> have since recorded a macro to automate all the changes. But now the
> import seems to be finding lots of empty records at the end and I have
> to kill the import. How to save the .csv file so that blank rows are
> not included in the import?
>
>

Try this..before you run the macro position the cursor to the row below the
last row containing data you wish to import. Press shift-ctrl-End at the same
time. Go to Edit clear All on the toolbar to clear all unused data. Run the
macro to create the csv. Hope this helps.
"whatageek" wrote:

> Before I can import data from a .csv file into a database, many columns
> need to be formatted or values need to be replaced. Previously, this
> manipulation used to be done manually and the import worked fine. I
> have since recorded a macro to automate all the changes. But now the
> import seems to be finding lots of empty records at the end and I have
> to kill the import. How to save the .csv file so that blank rows are
> not included in the import?
>
>

Try this..before you run the macro position the cursor to the row below the
last row containing data you wish to import. Press shift-ctrl-End at the same
time. Go to Edit clear All on the toolbar to clear all unused data. Run the
macro to create the csv. Hope this helps.
"whatageek" wrote:

> Before I can import data from a .csv file into a database, many columns
> need to be formatted or values need to be replaced. Previously, this
> manipulation used to be done manually and the import worked fine. I
> have since recorded a macro to automate all the changes. But now the
> import seems to be finding lots of empty records at the end and I have
> to kill the import. How to save the .csv file so that blank rows are
> not included in the import?
>
>

Thanks for pointing me in the right direction. Your response gave me
the missing pieces to the puzzle. The problem is fixed....thank you,
thank you!

Excel user wrote:
> Try this..before you run the macro position the cursor to the row below the
> last row containing data you wish to import. Press shift-ctrl-End at the same
> time. Go to Edit clear All on the toolbar to clear all unused data. Run the
> macro to create the csv. Hope this helps.
> "whatageek" wrote:
>
> > Before I can import data from a .csv file into a database, many columns
> > need to be formatted or values need to be replaced. Previously, this
> > manipulation used to be done manually and the import worked fine. I
> > have since recorded a macro to automate all the changes. But now the
> > import seems to be finding lots of empty records at the end and I have
> > to kill the import. How to save the .csv file so that blank rows are
> > not included in the import?
> >
> >