How to change path in Saved Import Spec (1 Viewer)

sumdumgai · Feb 26, 2019

Ran into a problem and need some help. I know it can be done but am having trouble finding VBA code that changes the path to an input file for a Saved Import Spec. I'm not familiar with XML but I believe there's a way to modify it with VBA.

Many thanks for any help.

sumdumgai · Feb 26, 2019

Would something like this be sufficient and effective:

Code:

    With CurrentProject.ImportExportSpecifications("spec name")
        startpos = InStr(.XML, "Path = ") + Len("Path = ") + 1
        endpos = InStr(.XML, "xmlns") - 2
        
        varSavedPathName = Mid(.XML, startpos, endpos - startpos)
        varnewpathname = "C:\Folder\Subfolder\file.txt"
        
        .XML = Replace(.XML, varSavedPathName, varnewpathname)
    End With

Can I always depend on the spec path being bounded by 'Path = ' and 'xmlns'?

NauticalGent · Feb 26, 2019

Good morning,

Give this a try:

https://www.access-programmers.co.uk/forums/showthread.php?t=301349

How to change path in Saved Import Spec (1 Viewer)

sumdumgai

Registered User.

sumdumgai

Registered User.

NauticalGent

Ignore List Poster Boy

Similar threads

Users who are viewing this thread