Error message when trying to show save as dialog 1

[abafuya]

I am new to VBA programming and am trying to show a saveas dialog to save an Excel file.
I tried Application.Dialogs(xlDialogSaveAs).Show
but I get an error message saying "Run-time error '438' object doesn't support this property or method"
I am programming using AutoCad VBA and have the excel reference on
What am I missing?

 

[PHV]

You should have created an Excel.Application object:
yourExcelAppObject.Dialogs(xlDialogSaveAs).Show

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[abafuya]

Thank you for your help!
I already had Excel as an object, I just changed Application to Excel as follows:
Excel.Dialogs(xlDialogSaveAs).Show
Now I just need to direct the user to the proper directory to save to.
I saw something about that in another thread so I will check that out.