Re: Length limit for FileName within TransferText?

Perry,

I was not aware of any such limit. Do you mean the macro works if you try to export to a path/filename that is shorter, but not with the 144-character one?

--
Steve Schapel, Microsoft Access MVP

Perry wrote:
I have a set of queries that run fine. But when I attempt to run a macro to export each of these to a separate CSV file, I get an error of object not found. After trying several things, it appears that the length of the path and filename that was coded is too long. I am running Access2000 under a Windows2000 OS. Does anyone know if there is a limit to the length of the path & filename that can be used? The length I was attempting and failing with was 144 characters which does not seem excessive.
.

Relevant Pages

  • Re: Caching?
    ... And regardless of why I changed the filename, ... when I deleted the file altogether, the macro would not finish. ... Filesearch just might return the old-name of a renamed file. ... Public Sub ImportFiles() ...
    (microsoft.public.excel.programming)
  • Re: Help end the testing tedium please
    ... The new macro is crashing at: ... The filename and sheet name look fine. ... two arguments needed for "Consolidate". ... the file really were test1 thru test60, would the array statement need ...
    (microsoft.public.excel.programming)
  • Re: Help end the testing tedium please
    ... You didn't answer my questions as to whether, if a macro bombs, if the stuff ... Look at the utility worksheet in columns G and I like the code below ... The filename and sheet name look fine. ... that question that confuses you on the B = A thing: ...
    (microsoft.public.excel.programming)
  • Re: 64k row limit
    ... Seems it's not the macro, but an EOF character that is causing the hang-up. ... Dim ResultStr As String ... Dim FileNum As Integer ... FileName = Application.GetOpenFilename ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to insert an image file into Work AND have the file name d
    ... Selection.InsertAfter vbCr & FileName ... There's nothing the macro can do to find out what the others were. ... Picture> From File dialog, multiple-selected pictures don't get ...
    (microsoft.public.word.docmanagement)