Updating a fuzzy DB file location during Batch_Open - Cacher Snippet

8/31/2016 - 12:42 PM

Updating a fuzzy DB file location during Batch_Open

Updating a fuzzy DB file location during Batch_Open

Local Fuzzy DB Switch.vbs

' Modify source database location - Standard Fuzzy

Dim oDb As CscDatabase
Set oDb = Project.Databases.ItemByName("Master Supplier Data")
MsgBox oDb.ImportFilename
oDb.ImportFilename = "\\RICHARDJ2\Scansation Ltd\InvoicePacks\KTM 6-0 R2\SS_InvoicePack_Adv\Databases\MasterSupplierData2.csv"
MsgBox oDb.ImportFilename
oDb.ImportDatabase(True)
MsgBox oDb.DatabasePath
MsgBox oDb.TextFilename