Opening a .csv file

dan · 04-27-2006, 05:30 PM

Currently I save my daily data.csv file as "data" & TEXT(TODAY(),"mmddyy") &
".csv"
If I save it as "data.csv" & TEXT(TODAY(),"mmddyy"), I cannot open it in its
csv format.
Is there a vba code to open it in csv format.

**Bryan Hessey** · 04-28-2006, 01:09 AM

Under VB code you would simply open the file, however, you may find it easier to open the file via Data, Import External Data , or by File, Open and specify Files of all Types *.* - and import via the wizard using the defaults

A file is recognised (in this case) by its affix, ie, by .csv and if you change that to .csv060606 then the file format will not be automatically recognised. (note, this would not be considered good practice).

Hope this helps

--

Originally Posted by dan

Currently I save my daily data.csv file as "data" & TEXT(TODAY(),"mmddyy") &
".csv"
If I save it as "data.csv" & TEXT(TODAY(),"mmddyy"), I cannot open it in its
csv format.
Is there a vba code to open it in csv format.

dan · 04-28-2006, 09:20 AM

Currently I am doing it with .xls files, will you consider this not a good
practice.
I want to do the right thing. Thanks

"Bryan Hessey" <[email protected]>
wrote in message
news:[email protected]...
>
> Under VB code you would simply open the file, however, you may find it
> easier to open the file via Data, Import External Data , or by File,
> Open and specify Files of all Types *.* - and import via the wizard
> using the defaults
>
> A file is recognised (in this case) by its affix, ie, by .csv and if
> you change that to .csv060606 then the file format will not be
> automatically recognised. (note, this would not be considered good
> practice).
>
> Hope this helps
>
> --
>
> dan Wrote:
>> Currently I save my daily data.csv file as "data" &
>> TEXT(TODAY(),"mmddyy") &
>> ".csv"
>> If I save it as "data.csv" & TEXT(TODAY(),"mmddyy"), I cannot open it
>> in its
>> csv format.
>> Is there a vba code to open it in csv format.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile:
> http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=537029
>

**Bryan Hessey** · 04-28-2006, 08:30 PM

In a browser (My Computer, not Internet) look in Tools, Folder Options, FileTypes.
This is where the system shows what program will be used to open files of various types.

Using a system that changes .xls to .xls060606 (or other dates) will either mean that the system does not recognise your files, or that you register each 'type', in this case each file.

Others trying to view your files will also need to follow suit.

I presume that would indicate it is 'not good practice'.

Excel workbook names should end in .xls (etc), and Comma Separated Value file names should end in .csv

--

Originally Posted by dan

Currently I am doing it with .xls files, will you consider this not a good
practice.
I want to do the right thing. Thanks

"Bryan Hessey" <[email protected]>
wrote in message
news:[email protected]...
>
> Under VB code you would simply open the file, however, you may find it
> easier to open the file via Data, Import External Data , or by File,
> Open and specify Files of all Types *.* - and import via the wizard
> using the defaults
>
> A file is recognised (in this case) by its affix, ie, by .csv and if
> you change that to .csv060606 then the file format will not be
> automatically recognised. (note, this would not be considered good
> practice).
>
> Hope this helps
>
> --
>
> dan Wrote:
>> Currently I save my daily data.csv file as "data" &
>> TEXT(TODAY(),"mmddyy") &
>> ".csv"
>> If I save it as "data.csv" & TEXT(TODAY(),"mmddyy"), I cannot open it
>> in its
>> csv format.
>> Is there a vba code to open it in csv format.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile:
> http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=537029
>

dan · 04-28-2006, 11:00 PM

I looked in Tools, Folder Options, FileTypes
I did not find anything like (.xls060606) other than .xls
However, the icon for .xls060606 is unknown type, but
I can still open it with no extra effort in xls format.
I don't use this method for any other extension.
I believe someone suggested me so some time ago.
I have been doing that way at least a year and have no problem.
For .xls file, it does not affect any of its integrity.
I wish to hear from other comments.

"Bryan Hessey" <[email protected]>
wrote in message
news:[email protected]...
>
> In a browser (My Computer, not Internet) look in Tools, Folder Options,
> FileTypes.
> This is where the system shows what program will be used to open files
> of various types.
>
> Using a system that changes .xls to .xls060606 (or other dates) will
> either mean that the system does not recognise your files, or that you
> register each 'type', in this case each file.
>
> Others trying to view your files will also need to follow suit.
>
> I presume that would indicate it is 'not good practice'.
>
> Excel workbook names should end in .xls (etc), and Comma Separated
> Value file names should end in .csv
>
> --
>
> dan Wrote:
>> Currently I am doing it with .xls files, will you consider this not a
>> good
>> practice.
>> I want to do the right thing. Thanks
>>
>> "Bryan Hessey"
>> <[email protected]>
>> wrote in message
>> news:[email protected]...
>> >
>> > Under VB code you would simply open the file, however, you may find
>> it
>> > easier to open the file via Data, Import External Data , or by File,
>> > Open and specify Files of all Types *.* - and import via the wizard
>> > using the defaults
>> >
>> > A file is recognised (in this case) by its affix, ie, by .csv and if
>> > you change that to .csv060606 then the file format will not be
>> > automatically recognised. (note, this would not be considered good
>> > practice).
>> >
>> > Hope this helps
>> >
>> > --
>> >
>> > dan Wrote:
>> >> Currently I save my daily data.csv file as "data" &
>> >> TEXT(TODAY(),"mmddyy") &
>> >> ".csv"
>> >> If I save it as "data.csv" & TEXT(TODAY(),"mmddyy"), I cannot open
>> it
>> >> in its
>> >> csv format.
>> >> Is there a vba code to open it in csv format.
>> >
>> >
>> > --
>> > Bryan Hessey
>> >
>> ------------------------------------------------------------------------
>> > Bryan Hessey's Profile:
>> > http://www.excelforum.com/member.php...o&userid=21059
>> > View this thread:
>> http://www.excelforum.com/showthread...hreadid=537029
>> >
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile:
> http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=537029
>

**Bryan Hessey** · 04-29-2006, 04:18 AM

Another view can be found at http://en.wikipedia.org/wiki/Filename_extension

Originally Posted by dan

I looked in Tools, Folder Options, FileTypes
I did not find anything like (.xls060606) other than .xls
However, the icon for .xls060606 is unknown type,

it is unknown if it was not present in the list

but
I can still open it with no extra effort in xls format.
I don't use this method for any other extension.

certain filetypes (.Doc .xls etc) have internal filetype recognition.

I believe someone suggested me so some time ago.

I would check with that someone to see if they intended you to add the date to the filename (proper) rather than to the file extension

I have been doing that way at least a year and have no problem.
For .xls file, it does not affect any of its integrity.
I wish to hear from other comments.

. . . but it's your pc.

--

"Bryan Hessey" <[email protected]>
wrote in message
news:[email protected]...
>
> In a browser (My Computer, not Internet) look in Tools, Folder Options,
> FileTypes.
> This is where the system shows what program will be used to open files
> of various types.
>
> Using a system that changes .xls to .xls060606 (or other dates) will
> either mean that the system does not recognise your files, or that you
> register each 'type', in this case each file.
>
> Others trying to view your files will also need to follow suit.
>
> I presume that would indicate it is 'not good practice'.
>
> Excel workbook names should end in .xls (etc), and Comma Separated
> Value file names should end in .csv
>
> --
>
> dan Wrote:
>> Currently I am doing it with .xls files, will you consider this not a
>> good
>> practice.
>> I want to do the right thing. Thanks
>>
>> "Bryan Hessey"
>> <[email protected]>
>> wrote in message
>> news:[email protected]...
>> >
>> > Under VB code you would simply open the file, however, you may find
>> it
>> > easier to open the file via Data, Import External Data , or by File,
>> > Open and specify Files of all Types *.* - and import via the wizard
>> > using the defaults
>> >
>> > A file is recognised (in this case) by its affix, ie, by .csv and if
>> > you change that to .csv060606 then the file format will not be
>> > automatically recognised. (note, this would not be considered good
>> > practice).
>> >
>> > Hope this helps
>> >
>> > --
>> >
>> > dan Wrote:
>> >> Currently I save my daily data.csv file as "data" &
>> >> TEXT(TODAY(),"mmddyy") &
>> >> ".csv"
>> >> If I save it as "data.csv" & TEXT(TODAY(),"mmddyy"), I cannot open
>> it
>> >> in its
>> >> csv format.
>> >> Is there a vba code to open it in csv format.
>> >
>> >
>> > --
>> > Bryan Hessey
>> >
>> ------------------------------------------------------------------------
>> > Bryan Hessey's Profile:
>> > http://www.excelforum.com/member.php...o&userid=21059
>> > View this thread:
>> http://www.excelforum.com/showthread...hreadid=537029
>> >
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile:
> http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=537029
>[/QUOTE]

dan · 04-29-2006, 05:55 PM

Thank again, Bryan

"Bryan Hessey" <[email protected]>
wrote in message
news:[email protected]...
>
> Another view can be found at
> http://en.wikipedia.org/wiki/Filename_extension
>
> dan Wrote:
>> I looked in Tools, Folder Options, FileTypes
>> I did not find anything like (.xls060606) other than .xls
>> However, the icon for .xls060606 is unknown type,
> it is unknown if it was not present in the list
>
>> but
>> I can still open it with no extra effort in xls format.
>> I don't use this method for any other extension.
> certain filetypes (.Doc .xls etc) have internal filetype recognition.
>
>> I believe someone suggested me so some time ago.
> I would check with that someone to see if they intended you to add the
> date to the filename (proper) rather than to the file extension
>
>> I have been doing that way at least a year and have no problem.
>> For .xls file, it does not affect any of its integrity.
>> I wish to hear from other comments.
>
> . . but it's your pc.
>
> --
>
> "Bryan Hessey"
> <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> In a browser (My Computer, not Internet) look in Tools, Folder
> Options,
>> FileTypes.
>> This is where the system shows what program will be used to open
> files
>> of various types.
>>
>> Using a system that changes .xls to .xls060606 (or other dates) will
>> either mean that the system does not recognise your files, or that
> you
>> register each 'type', in this case each file.
>>
>> Others trying to view your files will also need to follow suit.
>>
>> I presume that would indicate it is 'not good practice'.
>>
>> Excel workbook names should end in .xls (etc), and Comma Separated
>> Value file names should end in .csv
>>
>> --
>>
>> dan Wrote:
>>> Currently I am doing it with .xls files, will you consider this not
> a
>>> good
>>> practice.
>>> I want to do the right thing. Thanks
>>>
>>> "Bryan Hessey"
>>> <[email protected]>
>>> wrote in message
>>> news:[email protected]...
>>> >
>>> > Under VB code you would simply open the file, however, you may
> find
>>> it
>>> > easier to open the file via Data, Import External Data , or by
> File,
>>> > Open and specify Files of all Types *.* - and import via the
> wizard
>>> > using the defaults
>>> >
>>> > A file is recognised (in this case) by its affix, ie, by .csv and
> if
>>> > you change that to .csv060606 then the file format will not be
>>> > automatically recognised. (note, this would not be considered
> good
>>> > practice).
>>> >
>>> > Hope this helps
>>> >
>>> > --
>>> >
>>> > dan Wrote:
>>> >> Currently I save my daily data.csv file as "data" &
>>> >> TEXT(TODAY(),"mmddyy") &
>>> >> ".csv"
>>> >> If I save it as "data.csv" & TEXT(TODAY(),"mmddyy"), I cannot
> open
>>> it
>>> >> in its
>>> >> csv format.
>>> >> Is there a vba code to open it in csv format.
>>> >
>>> >
>>> > --
>>> > Bryan Hessey
>>> >
>>>
> ------------------------------------------------------------------------
>>> > Bryan Hessey's Profile:
>>> > http://www.excelforum.com/member.php...o&userid=21059
>>> > View this thread:
>>> http://www.excelforum.com/showthread...hreadid=537029
>>> >
>>
>>
>> --
>> Bryan Hessey
>>
> ------------------------------------------------------------------------
>> Bryan Hessey's Profile:
>> http://www.excelforum.com/member.php...o&userid=21059
>> View this thread:
> http://www.excelforum.com/showthread...hreadid=537029
>>
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile:
> http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=537029
>