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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.