Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSaveAs MS Project to MS Access
I am trying to save a MS Project File to MS Access based on user input,
so i can't specify an exact path. I need to save the data from Project to Access (using FileSaveAs). Here is the piece of code that does not work. Thanks in advance: FileSaveAs Name:="<" & AccessFName & "<\" & ProjectFName, FormatID:="MSProject.MDB8" 'FileSaveAs is a problem, I get a run-time error 1101 - Value is not Valid The code works when i specify a path, AccessFName = Access File Path & File Name ProjectFName = Project File Name |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSaveAs MS Project to MS Access
Why not post this in a project or Access group - choose the one that
corresponds to the application where you are writing the code. -- Regards, Tom Ogilvy "Ski" wrote: I am trying to save a MS Project File to MS Access based on user input, so i can't specify an exact path. I need to save the data from Project to Access (using FileSaveAs). Here is the piece of code that does not work. Thanks in advance: FileSaveAs Name:="<" & AccessFName & "<\" & ProjectFName, FormatID:="MSProject.MDB8" 'FileSaveAs is a problem, I get a run-time error 1101 - Value is not Valid The code works when i specify a path, AccessFName = Access File Path & File Name ProjectFName = Project File Name |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FileSaveAs MS Project to MS Access | Excel Programming | |||
Trust Access to Visual Basic Project | Excel Programming | |||
Excel FileSaveAs dialog freezes when used via automation from Access | Excel Programming | |||
Large project ideas, maybe should use Access? | Excel Programming | |||
Allow access to visual basic project | Excel Programming |