View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
YP Guo YP Guo is offline
external usenet poster
 
Posts: 1
Default Why system asks me to save change even after I call save method(VB.NET)

Thank you, Bernie!
In fact, we may only set Saved property after call Save method.
Below code is worked.

ExcelForm = CreateObject("Excel.Application")
ExcelForm.Visible = True

exwbook = ExcelForm.Workbooks.Open("C:\template.xls")
exsheet = exwbook.Worksheets("template")

... ...

exwbook.Save()
exwbook.Saved = True


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!