Why 'SaveAs'? The macro should add to the data, provided your bookmark names are correctly represented in the code (in lower case). Saving will overwrite the original.
If you remove the Save line and leave the workbook open, is the data written to it?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
|