 |
|
|
|
Next: Links: Add-ins not working
|
| Author |
Message |
External
Since: Aug 03, 2006
Posts: 44
|
(Msg. 1) Posted: Wed Jan 24, 2007 2:31 pm
Post subject: Linking CSV file
Archived from groups: microsoft>public>excel>links (more info?)
|
|
|
Hi
I run W2K with Excel 2K.
I have a workbook that links to a file on a server. The file on the server
is a file that is downloaded from a mainframe in a CSV format. Also, although
this file is a csv format it has been setup to download with a .XLS extension.
For my workbook link to this file to work correctly, I have to open up the
csv file and save it as an true Excel file. If I do not do this then the file
on my computer does not automatically update the links.
Is there anyway I can have my links to automatically update correctly
without having to save the csv file as an Excel file?
Any help is much appreciated.
John |
|
| Back to top |
|
 | |
External
Since: Sep 27, 2005
Posts: 994
|
(Msg. 2) Posted: Thu Jan 25, 2007 1:21 pm
Post subject: Re: Linking CSV file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi John,
Not really, but you could automate the opening of the csv file whenever you
open your Excel workbook. Also, it's not a good idea to mis-name the csv
file's extension. This makes no difference to how Excel processes the file,
but it's misleading, since any app capable of reading a text file (eg Notepad,
Word) can also read csv files, but not necessarily Excel (xls) files.
Cheers
--
macropod
[MVP - Microsoft Word]
"John Calder" <JohnCalder.TakeThisOut@discussions.microsoft.com> wrote in message
news:A01558AE-021B-4B48-A3DE-B84CFBC302CE@microsoft.com...
| Hi
|
| I run W2K with Excel 2K.
|
| I have a workbook that links to a file on a server. The file on the server
| is a file that is downloaded from a mainframe in a CSV format. Also,
although
| this file is a csv format it has been setup to download with a .XLS
extension.
|
| For my workbook link to this file to work correctly, I have to open up the
| csv file and save it as an true Excel file. If I do not do this then the
file
| on my computer does not automatically update the links.
|
| Is there anyway I can have my links to automatically update correctly
| without having to save the csv file as an Excel file?
|
| Any help is much appreciated.
|
| John |
|
| Back to top |
|
| |
External
Since: Aug 03, 2006
Posts: 44
|
(Msg. 3) Posted: Thu Jan 25, 2007 1:21 pm
Post subject: Re: Linking CSV file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks for your response. I am not exactly sure how to open the csv file
automatically from my workbook but I will ask the question in another work
group. As for naming the csv file with a xls extension I am afraid I dont
have any control over that so I will have to work with what I have got.
Thanks again
John
"macropod" wrote:
> Hi John,
>
> Not really, but you could automate the opening of the csv file whenever you
> open your Excel workbook. Also, it's not a good idea to mis-name the csv
> file's extension. This makes no difference to how Excel processes the file,
> but it's misleading, since any app capable of reading a text file (eg Notepad,
> Word) can also read csv files, but not necessarily Excel (xls) files.
>
> Cheers
>
> --
> macropod
> [MVP - Microsoft Word]
>
>
> "John Calder" <JohnCalder.TakeThisOut@discussions.microsoft.com> wrote in message
> news:A01558AE-021B-4B48-A3DE-B84CFBC302CE@microsoft.com...
> | Hi
> |
> | I run W2K with Excel 2K.
> |
> | I have a workbook that links to a file on a server. The file on the server
> | is a file that is downloaded from a mainframe in a CSV format. Also,
> although
> | this file is a csv format it has been setup to download with a .XLS
> extension.
> |
> | For my workbook link to this file to work correctly, I have to open up the
> | csv file and save it as an true Excel file. If I do not do this then the
> file
> | on my computer does not automatically update the links.
> |
> | Is there anyway I can have my links to automatically update correctly
> | without having to save the csv file as an Excel file?
> |
> | Any help is much appreciated.
> |
> | John
>
>
> |
|
| Back to top |
|
| |
External
Since: Dec 12, 2005
Posts: 105
|
(Msg. 4) Posted: Thu Jan 25, 2007 11:11 pm
Post subject: Re: Linking CSV file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi John,
If you use Data -> Import External Data and point to the csv file as the
external data source, then you will have a data range that can be refreshed
at any time.
Ed Ferrero
> Hi
>
> I run W2K with Excel 2K.
>
> I have a workbook that links to a file on a server. The file on the server
> is a file that is downloaded from a mainframe in a CSV format. Also,
> although
> this file is a csv format it has been setup to download with a .XLS
> extension.
>
> For my workbook link to this file to work correctly, I have to open up the
> csv file and save it as an true Excel file. If I do not do this then the
> file
> on my computer does not automatically update the links.
>
> Is there anyway I can have my links to automatically update correctly
> without having to save the csv file as an Excel file?
>
> Any help is much appreciated.
>
> John |
|
| Back to top |
|
| |
External
Since: Aug 03, 2006
Posts: 44
|
(Msg. 5) Posted: Mon Jan 29, 2007 6:59 pm
Post subject: Re: Linking CSV file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks Ed !
But I run Excel 2000 and when I select "Data" I dont get "Import External
Data" as an option.
My options are;
Data
Get External Data
Import Text File
Thanks
"Ed Ferrero" wrote:
> Hi John,
>
> If you use Data -> Import External Data and point to the csv file as the
> external data source, then you will have a data range that can be refreshed
> at any time.
>
> Ed Ferrero
>
> > Hi
> >
> > I run W2K with Excel 2K.
> >
> > I have a workbook that links to a file on a server. The file on the server
> > is a file that is downloaded from a mainframe in a CSV format. Also,
> > although
> > this file is a csv format it has been setup to download with a .XLS
> > extension.
> >
> > For my workbook link to this file to work correctly, I have to open up the
> > csv file and save it as an true Excel file. If I do not do this then the
> > file
> > on my computer does not automatically update the links.
> >
> > Is there anyway I can have my links to automatically update correctly
> > without having to save the csv file as an Excel file?
> >
> > Any help is much appreciated.
> >
> > John
>
>
> |
|
| Back to top |
|
| |
External
Since: Dec 12, 2005
Posts: 105
|
(Msg. 6) Posted: Tue Jan 30, 2007 6:04 pm
Post subject: Re: Linking CSV file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi John,
In Excel 2000, use Data -> Get External Data. Other steps are the same.
Ed Ferrero
www.edferrero.com
> Thanks Ed !
>
> But I run Excel 2000 and when I select "Data" I dont get "Import External
> Data" as an option.
>
> My options are;
>
> Data
> Get External Data
> Import Text File
>
>
> Thanks
>
>
>
> "Ed Ferrero" wrote:
>
>> Hi John,
>>
>> If you use Data -> Import External Data and point to the csv file as the
>> external data source, then you will have a data range that can be
>> refreshed
>> at any time.
>>
>> Ed Ferrero
>>
>> > Hi
>> >
>> > I run W2K with Excel 2K.
>> >
>> > I have a workbook that links to a file on a server. The file on the
>> > server
>> > is a file that is downloaded from a mainframe in a CSV format. Also,
>> > although
>> > this file is a csv format it has been setup to download with a .XLS
>> > extension.
>> >
>> > For my workbook link to this file to work correctly, I have to open up
>> > the
>> > csv file and save it as an true Excel file. If I do not do this then
>> > the
>> > file
>> > on my computer does not automatically update the links.
>> >
>> > Is there anyway I can have my links to automatically update correctly
>> > without having to save the csv file as an Excel file?
>> >
>> > Any help is much appreciated.
>> >
>> > John
>>
>>
>> |
|
| Back to top |
|
| |
External
Since: Mar 03, 2007
Posts: 9
|
(Msg. 7) Posted: Fri Apr 27, 2007 12:13 am
Post subject: Re: Linking CSV file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
John, did you ever solve this problem? I download
my bank account files
in CSV but IE won't give me the option to save or
run, they just automatically
open up in IE html format.
"John Calder"
<JohnCalder.RemoveThis@discussions.microsoft.com> wrote in
message
news:AA0E7D58-2908-4B29-B475-9B625BD956B1@microsoft.com...
Thanks Ed !
But I run Excel 2000 and when I select "Data" I
dont get "Import External
Data" as an option.
My options are;
Data
Get External Data
Import Text File
Thanks
"Ed Ferrero" wrote:
> Hi John,
>
> If you use Data -> Import External Data and
> point to the csv file as the
> external data source, then you will have a data
> range that can be refreshed
> at any time.
>
> Ed Ferrero
>
> > Hi
> >
> > I run W2K with Excel 2K.
> >
> > I have a workbook that links to a file on a
> > server. The file on the server
> > is a file that is downloaded from a mainframe
> > in a CSV format. Also,
> > although
> > this file is a csv format it has been setup to
> > download with a .XLS
> > extension.
> >
> > For my workbook link to this file to work
> > correctly, I have to open up the
> > csv file and save it as an true Excel file. If
> > I do not do this then the
> > file
> > on my computer does not automatically update
> > the links.
> >
> > Is there anyway I can have my links to
> > automatically update correctly
> > without having to save the csv file as an
> > Excel file?
> >
> > Any help is much appreciated.
> >
> > John
>
>
> |
|
| Back to top |
|
| |
External
Since: Jun 28, 2007
Posts: 5
|
(Msg. 8) Posted: Thu Jun 28, 2007 4:05 pm
Post subject: Re: Linking CSV file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
HI,
I NEED TO KNOW THAT I AM USING OFFICE2003 FOR THAT HOW CAN I DOWNLOAD CSV
FILE AUTOMATICALLY IN EXCEL & CAN I UPDATE AUTOMATICALLY
HELP REQUIRED
THANKS
AVINASH
"Bubey" <catlovr2 DeleteThis @hotmail.com> wrote in message
news:%23kyNpJIiHHA.3412@TK2MSFTNGP02.phx.gbl...
> John, did you ever solve this problem? I download
> my bank account files
> in CSV but IE won't give me the option to save or
> run, they just automatically
> open up in IE html format.
>
> "John Calder"
> <JohnCalder DeleteThis @discussions.microsoft.com> wrote in
> message
> news:AA0E7D58-2908-4B29-B475-9B625BD956B1@microsoft.com...
> Thanks Ed !
>
> But I run Excel 2000 and when I select "Data" I
> dont get "Import External
> Data" as an option.
>
> My options are;
>
> Data
> Get External Data
> Import Text File
>
>
> Thanks
>
>
>
> "Ed Ferrero" wrote:
>
>> Hi John,
>>
>> If you use Data -> Import External Data and
>> point to the csv file as the
>> external data source, then you will have a data
>> range that can be refreshed
>> at any time.
>>
>> Ed Ferrero
>>
>> > Hi
>> >
>> > I run W2K with Excel 2K.
>> >
>> > I have a workbook that links to a file on a
>> > server. The file on the server
>> > is a file that is downloaded from a mainframe
>> > in a CSV format. Also,
>> > although
>> > this file is a csv format it has been setup to
>> > download with a .XLS
>> > extension.
>> >
>> > For my workbook link to this file to work
>> > correctly, I have to open up the
>> > csv file and save it as an true Excel file. If
>> > I do not do this then the
>> > file
>> > on my computer does not automatically update
>> > the links.
>> >
>> > Is there anyway I can have my links to
>> > automatically update correctly
>> > without having to save the csv file as an
>> > Excel file?
>> >
>> > Any help is much appreciated.
>> >
>> > John
>>
>>
>>
> |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Microsoft Office