P.S. My comment about the constants may be important and relevant. The behavior of your code with undefined constants is quite possibly quite different than what your code appears to do. If you don't set a reference to the Scripting library, your constants will all be undefined.
If you use OPTION EXPLICIT at the top of your module, you will ge a compile error if you try to use undefined constants/variables. Always a good idea. You can define the constants yourself, as the Excel help file examples do. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Tuesday, May 01, 2012 7:42 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file Hi Pascal, Actually, my feeling is that your code is leaving a file handle open unneccesarily and you are having a file sharing/locking violation on FAT32 volumes -- since you only need to have one file handle open at a time, your code should be correctable (unless VBSCRIPT has some strange bug). Interesting thought about optics. One issue with any reusable media is that it has to be physically changed to store information. Current optical media receive more destructive changes and require more energy for those changes than magnetic media. I imagine the death of removable optical media like CD/Blu Ray, and being replaced by centralized internet storage and next gen flash media. Transmission of data might be more and more wireless, or when wired, more and more fiber-optic. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bpascal123 Sent: Tuesday, May 01, 2012 6:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file Hi, I meant magnetic hard drive...based on the fact both are rotational and that myself I was looking for my glasses while writing this post :) , I mixed them up... Btw, from latest experiments (i wasn't part of it, i'm not a scientist nor do i know about it in detail), nothing travels faster than light, then how magnetic drives can be faster than optical drives...and applied to flash memory.... I think sooner or later R&D will come back to optical storage maybe without rotation... Asa said it should be related to the file system (FAT32) and not the support itself... then I conclude the first code (code 1/2), doesn't support FAT32. exFat is the latest filesystem from Microsoft aims at flash storage devices. Pascal -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
