Macros and saving .csv files

W

whatageek

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?
 
E

Excel user

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.
 
W

whatageek

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!
 
Top