using vba in excel

J

jeff quigley

Hello

I have created an application which appends data into a microsoft excel
spreadsheet from an outside program and then does an automatic mail merge
into ms word for mailing envelopes. When I run the code I have excel and
word to automatically appear. I want to be able to save both of these to
different names as they are overwritten each time. However when i save them
and re-run the code a box always appears saying that the spreadsheet is
available for editing and to click read-write for editing. I have to
ctrl-alt-del and kill the Excel Process each time to use the code. If i use
appExcel.quit than i dont recieve this message but i want to be able to view
the document but not have the read-write message always appear so i use
appExcel.visible = true. Any suggestions?
quigleyj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top