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
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. I don't see any mistake I could have made. If yes
The msdn link here OpenAsTextStream
Methodhttp://msdn.microsoft.com/en-us/library/hwfw5c59(v=vs.85).aspx
I deleted my previous post just to make a few changes as English is not my
first language and I was even confused reading a last time after posting.
--
FORUM RULES (986+ members already
Oops my mistake, Set f = fs.GetFile(y:\test2.txt)
I didn't specify the path, nothing related to flash memory and else...just
that msdn used filename to declare the path+file variable and I got
confused,to me filename means filename not file path...since the getfile
method is linked to thefs
Of bpascal123
Sent: Wednesday, May 02, 2012 1:26 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to
a text file
Hi Asa,
I don't think there is any issues with constant, undefined variable types or
else, i do use option explicit for each
Subject: RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a
text file
Hi Pascal!
Not sure what you mean by optical hard drive (HDs use electromagnetic
heads).
I have not had the chance to try your scripts, and I haven't relally played
with Scripting.FileSystemObject
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
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
@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
Hi Pascal!
Not sure what you mean by optical hard drive (HDs use electromagnetic
heads).
I have not had the chance to try your scripts, and I haven't relally played
with Scripting.FileSystemObject, but some quick thoughts for you--
File locking and permissions are controlled by the OS and
10 matches
Mail list logo