Paul Hartland
paul.hartland at googlemail.com
Tue Apr 16 06:32:14 CDT 2013
Or replace the line Debug.Print strResult with msgbox strResult remember if you want to send the result to a text file you will have to write the strOutputLines to a new text file. Paul On 16 April 2013 12:29, Paul Hartland <paul.hartland at googlemail.com> wrote: > Is the result not displayed in the immediate window after you run it > (think it's something like CTRL + G) > > Paul > > > On 16 April 2013 14:22, <pedro at plex.nl> wrote: > >> >> Hello Stuart, >> >> sorry i missed that. >> I tried several thing and forgot it to place it back to its original. >> >> When i execute the macro, i get no errors, but nothing happens. >> >> I have added a test-file of the import file. >> >> May be you can try yourself. >> >> Thanks >> >> Pedro >> >> >> You still have "FreeFile ff" in there. As Lambert pointed out, that is >> not the correct VBA >> syntax. >> >> Replace it with "ff = FreeFile". >> >> (It's interesting that it complies - but if you examine the value of ff >> adter that line, you will see >> that it is 0) >> >> -- >> Stuart >> >> On 16 Apr 2013 at 12:46, pedro at plex.nl wrote: >> >> > I all did this and it did not work. >> > >> > I copied and past the functionname and brackets and now its working. >> > >> > But now i get an error: "invalid Filename or invalid filenumber", and >> yellow highlighted is "Open strFilename For Input As #ff" after debugging. >> > >> > ??? >> > >> > Thanks >> > >> > Pedro >> >> >> ---------------------------------------------------------------------------- >> >> ** T02-00423 14-01-02 pn: 01234567, gb: 01-01-22 m (91jr) aa testnaam- >> >> >> CONCLUSIE: >> Biopt schouder .... >> >> DIAGNOSES: >> huid*biopt*geen afwijkingen >> >> >> ---------------------------------------------------------------------------- >> >> ** T02-01350 06-02-02 pn: 07654321, gb: 01-01-68 v (33jr) A.W.G.J. >> schreurs-kellenaers >> >> >> CONCLUSIE: >> Huidexcisie linker ...... >> >> DIAGNOSES: >> huid*excisie*melanoom >> >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> > > > -- > Paul Hartland > paul.hartland at googlemail.com > -- Paul Hartland paul.hartland at googlemail.com