Raw XLS Spreadsheet to formatted XLS

[AuctionLamb]

Hi guys!!

I am getting a Excel spread sheet via FTP into an specified folder. Now.....I want to take that spreadsheet in that folder manupilate it to a specific xls way to DTS it to SQL Table? Help me to take load up the spreadsheet and format it to an new spreadsheet.

Information: The original xls I get is mixed up but I only want a certain data in it and formatted nicely. My main issue is to take one xls and move that data in my own way to the other xls.

 

[HarleyQuinn]

I would say that your best bet would be to record a macro of you formatting the data and then use the macro generated code in VB on the workbook after opening it using automation.

If you do a search on this site for Excel Automation you should turn up several examples of working with Excel form VB.

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[SkipVought]

Hi,

You might be better off in the VBA forum707 where there is more specific expertise on Excel workbooks.

You might also provide more specific information regarding the workbook you are statring with and your requirements for transforming it. You mentioned getting it ready to import or create a table AND prettying it up -- not necessarily the same thing.

Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}