Hi Asa,
>
I don't think there is any issues with constant, undefined variable types
or else, i do use option explicit for each module... I use late binding for
library references. The code that doesn't work is from msdn OpenAsTextStream
Method <http://msdn.microsoft.com/en-us/library/hwfw5c59(v=vs.85).aspx>. I
don't see any mistake I could have made. If yes the code should not be
working at all.
The first module testy generates an error with this line:
Set f = fs.GetFile("test2.txt") 'Error : "File not found" ...on removable
flash FAT32 filesystem...OK on NTFS HD
The second module testz works with any storage devices and file system
without any issue. As you can see, it uses:
Set txtfile = fso.CreateTextFile("Y:\test1.txt", True)
The "True" parameter enables writing on the file (btw if you omit true, it
seems to overwrite a file without warning...
If I understand from your previous post, Fat32 might generate some issues.
File system library seems to have been there for quite a while as vbscript,
and other scripts... so I don't see myself to find such a simple bug, given
that flash memory is widely available and used. To go further with this, I
should experiment this: format a usb key with NTFS and run the testy script
from above. I don't know what I will get but from what you say in your
previous post, it should then work or it's a Vbscript bug...
Following this second discussion on storage technologies, I agree optical
fiber can transmit data the fastest. However I don't see flash memory last
for long since it was demonstrated not long that nothing we know about can
travel faster than light and flash memory is still accessing data using
semiconductors... After this my knowledge in this area becomes very weak...
:)
In my mind, what I would see possible to implement to store data is using
liquid crystal properties and access data using light to reach light speed
like with optical fibers but a laser is as fast as any other light, like
printer can come now with LED instead of laser beam... The thing is that
using LCD would always require some power to keep what is stored in memory
like with an LCD screen when off is blank or simply like with RAM... and
else I don't have any idea about the volume of data that can be stored
using liquid crystals. LCD currently store in very high definition 24 bit
per pixel...
Pascal Baro
--
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
