I have some code that does the following:
kills a spreadsheet if it exists,
opens a template,
saves it,
opens the spreadseet,
transfer data to it,
runs a macro
then I save it...
I am using the following to save the spreadsheet:
xlBook.SaveAs DirPath & xlsfname
xlBook.Close
I have two problems, one is that when I use xlBook.Save, I get a complie
error: wrong number of arguments or invalid property assignment...
the second is with SaveAs I get a excel dialog box stating "A file name
already exists etc...
how can I solve this
|
|