Hi.I try to open a blank Excelbook from a form in Access with VB-code. When the user click "save as" in Excel I would like the default folder in Excel to change to a specified catalog. When I use Word, this works perfect
This is for Word:
y = Customer
x = ProjectName
Set mobjWordApp = New Word.Application
With mobjWordApp
.Visible = True
.WindowState = wdWindowStateMaximize
.Documents.Add
.Options.DefaultFilePath(wdDocumentsPath) = "t:\proj\" & y & "\" & x 'Words default path
End With
Can some one help me with this?
Regards
Magnus
This is for Word:
y = Customer
x = ProjectName
Set mobjWordApp = New Word.Application
With mobjWordApp
.Visible = True
.WindowState = wdWindowStateMaximize
.Documents.Add
.Options.DefaultFilePath(wdDocumentsPath) = "t:\proj\" & y & "\" & x 'Words default path
End With
Can some one help me with this?
Regards
Magnus