Re: Select a Folder for Access 2007 Table Export

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Erick,

I would suspect the double backslash may be causing the problem. You
could either check for its existence at the end of the path or use the
FileSystemObject's BuildPath method.

' Requires reference to Microsoft Scripting Runtime (Tools, References)
Dim fso As New FileSystemObject

strPathFile = fso.BuildPath(strPath, strFile)

Also, I presume that where you have "file name" that that is only to
indicate the constructed file name and that the actual file name does not
include the quotes.

Clifford Bass


"Erick C" wrote:

The path that shows up is:
Y:\\"file name".xls
The file name shows up in the correct format that we modified before.
The file does not exist anywhere on the shared drive.
.

Relevant Pages

  • Re: Sharing Knife: Lakewalker Society questions
    ... There's certainly no reference to even the ... existence of a Europe-equivalent in the books, ... Dag asserts that no sailors have visited other continents at least since ... the Malice Wars, though they are known to have existed then, and been ...
    (rec.arts.sf.written)
  • Re: Let us be sure that we know what the problem is!
    ... Unlike Einstein and his cult followers, ... presuppose the existence of an absolute frame of reference. ...
    (sci.physics.relativity)
  • Re: "Measuring Our Absolute Velocity"
    ... reference is made here to the ether concept of Lorentz, ... speaking) a non-material absolute frame of reference that serves as medium ... pretending it has a real existence on its own is purely a creation of the ... with which Feynman explictitly disagreed (somewhere in his physics books, ...
    (sci.physics.relativity)
  • Re: OleDbconnection syntax
    ... As a rule of thumb I'd verify the existence of the file before trying to ... reference it (take out the DebugAssert and use If File.Exists(directoryName ... wrong with connections other than the string. ... If and using Assertions. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Programmatically determining selected index of combobox produces null error
    ... Which line is throwing the exception? ... You can check .SelectedIndex ... Something is causing a NullReferenceException ... Reference Chapters 13 and 11. ...
    (microsoft.public.dotnet.framework.adonet)