Re: Is it possible to load the excel file by using external table without converting it into csv comma delimited file

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to load the excel file by using external table without converting it into csv comma delimited file

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 12 Jul 2006 03:14:31 -0700
Message-ID: <1152699271.159588.62430@b28g2000cwb.googlegroups.com>

Markku Uttula wrote:
> Charles Hooper wrote:
> > Rough example code of a macro to dump the contents of the Excel
> > spreadsheet to a file deliminated by "<CELL>":
> > Public Sub ExportSpreadsheet()
> > Dim intResult As Integer
>
> ...
>
> Ouch, my eyes - the goggles, they're doing nothing!!
>
> Sorry, I'm rather allergic to (any incarnation of) VB :)
>
> --
> Markku Uttula

Visual Basic for Applications (Excel macro). There is nothing wrong with VB, especially since native code compilation was introduced several years ago. You would be suprised by what can be written in VB: MRP applications, OCR applications that decode barcodes from poorly scanned 100 dpi documents, and even macros.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Jul 12 2006 - 05:14:31 CDT