Re: using macros to import data

From: rocket (rocket_at_discussions.microsoft.com)
Date: 01/11/05


Date: Tue, 11 Jan 2005 00:09:04 -0800

thanks for the replies, the application is one a company I work for had
built, All I really know is it is MS compatible and has the macros function
in the tools menu.

thanks

"Fredrik Wahlgren" wrote:

>
> "rocket0612" <rocket0612@discussions.microsoft.com> wrote in message
> news:F9C823BC-3853-40E1-A649-A17EE8EF1274@microsoft.com...
> > I really only know the basics about macros and can use it to retreive data
> in
> > a spread*** to consolidate it, however, I am now wanting to expand my
> > knowledge a bit further and would like to learn about using macros to
> import
> > data from external applications but don't know where to start?
> >
> > any help would be appreciated
> >
> > thanks
>
> The answer depends on how the data can be made available to Excel. Do these
> applications have a name? Is it SAP, Hyperion, Baan? Do they offer some kind
> of programmatic interface. Maube they only produce data as a text file.
> Please tell more about the applications that provide the data.
>
> /Fredrik
>
>
>