I am trying to save an excel workbook I create using VBA in Access 97. I want to save it to a specific directory with a specific filename. I don't see the parameters available to pass the save procedure this information and the saveAs procedure doesn't include a filepath parameter. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Use VBA In Access 97 to save excel workbook
- Thread starter btalon
- Start date
Directly from excel VBA helpfile:
expression.SaveAs(Filename, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodePage, TextVisualLayout)
expression Required. An expression that returns a Chart or Worksheet object (Syntax 1) or a Workbook object (Syntax 2).
Filename Optional Variant. A string that indicates the name of the file to be saved. You can include a full path; if you don't, Microsoft Excel saves the file in the current folder. Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
expression.SaveAs(Filename, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodePage, TextVisualLayout)
expression Required. An expression that returns a Chart or Worksheet object (Syntax 1) or a Workbook object (Syntax 2).
Filename Optional Variant. A string that indicates the name of the file to be saved. You can include a full path; if you don't, Microsoft Excel saves the file in the current folder. Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
