| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving the contents of a worksheet table to an xml document when theuser closes the workbook.
How do you save the contents of a worksheet to an xml document when a
user closes the workbook. My first attempt was the following, but it didn't work... If ActiveWorkbook.Close Then MsgBox "Would you like to close the workbook?", vbOKCancel ActiveWorkbook.XmlMaps("dataroot_Map").Export URL:="Q:\Workforce \Test.xml" Sheets("Daily Workforce Data").Range("K1").Value = "=now()" End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel closes without saving | Excel Discussion (Misc queries) | |||
| Table of Contents Sheet in Workbook | Links and Linking in Excel | |||
| When saving a worksheet in excel message "document not saved" | Excel Discussion (Misc queries) | |||
| Saving a worksheet out of a workbook | Excel Programming | |||
| When saving add automatically contents of a specified cell in document properties | Excel Programming | |||
Threaded Mode
