Link to home
Start Free TrialLog in
Avatar of Peter Chan
Peter ChanFlag for Hong Kong

asked on

Problem to save file

Hi,
How to resolve
User generated image
due to SaveAs line below
    Set NewBook = Workbooks.Add
    With NewBook
        .Title = "Departure List (of People already left)"
        .Subject = "Departure List"
        .SaveAs Filename:="Departure List (of People already left).xls"
    End With

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial