Hello,

Like so many others, I am an Excel newbie. I was a mainframe COBOL
programmer in another life, but that was a few years back

My manager would like me to write an app that will take data from an
existing Excel spreadsheet (generated by our system), select only a
handful of columns, write out a new spreadsheet with the selected data,
and then the new spreadsheet will be used as input to a new Access
database that I will create.

1) How do I select which columns I want to export? I tried highlighting
the columns and then doing a "Save As..." but that just gave me an exact
copy of the original spreadsheet, with the columns still highlighted.

2) Is there a way to automate #1? I have no idea how often my manager
will want to run this, but i don't want to have to hand-prep the data
every time.

Thanks in advance for any help!

-Doug


--
dougb415
------------------------------------------------------------------------
dougb415's Profile: http://www.excelforum.com/member.php...o&userid=27452
View this thread: http://www.excelforum.com/showthread...hreadid=469638