RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

mailto:excel-macros@googlegroups.com] On Behalf 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 va

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

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 thef

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

The msdn link here OpenAsTextStream Method 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 BA

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 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 t

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 module... I use late binding for library references. The code that doesn't work is from msdn OpenAsTextStream Method

RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

acros@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 an

RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

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

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 t

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

groups.com 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 Script

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, but some quick thoughts for you-- File locking and permissions are controlled by the OS and