VBA
Discuss AutoCAD ActiveX and VBA (Visual Basic for Applications) questions here.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

.Save not working for Excel

1 REPLY 1
SOLVED
Reply
Message 1 of 2
dlinford
409 Views, 1 Reply

.Save not working for Excel

I recently had to reinstall everything on a reformated hard drive. 

 

I had a vba routine that opens, edits and saves an Excel SpreadSheet from an AutoCAD VBA routine.

 

I'm working in AutoCAD 2014

 

I was working in Excel Office 2010 but now I'm in 2013.

 

The line

 

 

objExcel.save

 

no longer works.  It doesn't give me an error or anything it just doesn't save.

 

Any ideas?

 

Thanks,

David

1 REPLY 1
Message 2 of 2
dlinford
in reply to: dlinford

I just changed the line to

objExcel.ActiveWorkbook.Save

and it worked.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost