C
colorado_cal
I have an Access 2000 database, and have written several Macros (scripts),
Many of which perfrom spreadsheet transfers into and out of the database.
The Transfer Spreadsheet Action Arguments includes the spreadsheet FileName,
which is supposed to be the Full Path Name. When I copy my database from one
windows folder to another, I want to automatically update all the FileName
paths to change to the same filename in the current folder., and was trying
to write a VB macro to do this.
Examining the CurrentDB object, I found in the CurrentDB.Containers an item
with Name "Scripts",. The Documents collection under this item have the
right script names...but I lose the trail trying to find the "Acrions" and
"Action Arguments".
Is there an eaiser way to have the TransferSpreadsheet items update to the
current directory path...or can you help me navigate the Currrent DB object
to get down to the FIleName attributes. Thanks! Cal
Many of which perfrom spreadsheet transfers into and out of the database.
The Transfer Spreadsheet Action Arguments includes the spreadsheet FileName,
which is supposed to be the Full Path Name. When I copy my database from one
windows folder to another, I want to automatically update all the FileName
paths to change to the same filename in the current folder., and was trying
to write a VB macro to do this.
Examining the CurrentDB object, I found in the CurrentDB.Containers an item
with Name "Scripts",. The Documents collection under this item have the
right script names...but I lose the trail trying to find the "Acrions" and
"Action Arguments".
Is there an eaiser way to have the TransferSpreadsheet items update to the
current directory path...or can you help me navigate the Currrent DB object
to get down to the FIleName attributes. Thanks! Cal