software

Currently I save my daily data.csv file as quot;dataquot; amp; TEXT(TODAY(),quot;mmddyyquot;) amp;
quot;.csvquot;
If I save it as quot;data.csvquot; amp; TEXT(TODAY(),quot;mmddyyquot;), I cannot open it in its
csv format.
Is there a vba code to open it in csv format.

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:
gt; Currently I save my daily data.csv file as quot;dataquot; amp;
gt; TEXT(TODAY(),quot;mmddyyquot;) amp;
gt; quot;.csvquot;
gt; If I save it as quot;data.csvquot; amp; TEXT(TODAY(),quot;mmddyyquot;), I cannot open it
gt; in its
gt; csv format.
gt; Is there a vba code to open it in csv format.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=537029Currently I am doing it with .xls files, will you consider this not a good
practice.
I want to do the right thing. Thanks

quot;Bryan Hesseyquot; gt;
wrote in message
news:Bryan.Hessey.26ykqm_1146201001.1981@excelforu m-nospam.com...
gt;
gt; Under VB code you would simply open the file, however, you may find it
gt; easier to open the file via Data, Import External Data , or by File,
gt; Open and specify Files of all Types *.* - and import via the wizard
gt; using the defaults
gt;
gt; A file is recognised (in this case) by its affix, ie, by .csv and if
gt; you change that to .csv060606 then the file format will not be
gt; automatically recognised. (note, this would not be considered good
gt; practice).
gt;
gt; Hope this helps
gt;
gt; --
gt;
gt; dan Wrote:
gt;gt; Currently I save my daily data.csv file as quot;dataquot; amp;
gt;gt; TEXT(TODAY(),quot;mmddyyquot;) amp;
gt;gt; quot;.csvquot;
gt;gt; If I save it as quot;data.csvquot; amp; TEXT(TODAY(),quot;mmddyyquot;), I cannot open it
gt;gt; in its
gt;gt; csv format.
gt;gt; Is there a vba code to open it in csv format.
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=537029
gt;

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:
gt; Currently I am doing it with .xls files, will you consider this not a
gt; good
gt; practice.
gt; I want to do the right thing. Thanks
gt;
gt; quot;Bryan Hesseyquot;
gt; gt;
gt; wrote in message
gt; news:Bryan.Hessey.26ykqm_1146201001.1981@excelforu m-nospam.com...
gt; gt;
gt; gt; Under VB code you would simply open the file, however, you may find
gt; it
gt; gt; easier to open the file via Data, Import External Data , or by File,
gt; gt; Open and specify Files of all Types *.* - and import via the wizard
gt; gt; using the defaults
gt; gt;
gt; gt; A file is recognised (in this case) by its affix, ie, by .csv and if
gt; gt; you change that to .csv060606 then the file format will not be
gt; gt; automatically recognised. (note, this would not be considered good
gt; gt; practice).
gt; gt;
gt; gt; Hope this helps
gt; gt;
gt; gt; --
gt; gt;
gt; gt; dan Wrote:
gt; gt;gt; Currently I save my daily data.csv file as quot;dataquot; amp;
gt; gt;gt; TEXT(TODAY(),quot;mmddyyquot;) amp;
gt; gt;gt; quot;.csvquot;
gt; gt;gt; If I save it as quot;data.csvquot; amp; TEXT(TODAY(),quot;mmddyyquot;), I cannot open
gt; it
gt; gt;gt; in its
gt; gt;gt; csv format.
gt; gt;gt; Is there a vba code to open it in csv format.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=537029
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=537029I 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.

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

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

dan Wrote:
gt; I looked in Tools, Folder Options, FileTypes
gt; I did not find anything like (.xls060606) other than .xls
gt; However, the icon for .xls060606 is unknown type,
it is unknown if it was not present in the list

gt; but
gt; I can still open it with no extra effort in xls format.
gt; I don't use this method for any other extension.
certain filetypes (.Doc .xls etc) have internal filetype recognition.

gt; 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

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

. . . but it's your pc.

--

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

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