Excel

[Sephozzy]

I'm bugfixing some app here but (unfortunately) have a very limited knowledge of VB. I have to open Excel and then save the file on a particular drive/folder. For this I have already found the following existing code:


With ExcelApp
.Application.Workbooks.Add
.Visible = true
.WindowState = xlMaximized
.DefaultFilePath = "o:\document"
End With




When we use this and press 'save' or 'save as...' the save file dialog shows up but it's positioned in the 'personal' folder instead of 'o:\document'.
Any way I can fix this?

Many thanks.


If anything in this post makes sense it was written by me, if not I don't know who wrote it

[zlatkoshmatko]

You can use
workbook.SaveAs Filename:=workbook.Name
It will work I think