Open, update and convert 2007-->2003 then close without any prompt

J

jkeogh

Hi,
I have some vbscript that opens up an excel 2007 file which then runs ahead
and updates a load of data. What I need it to do is

Open and Run the macro
Save AS .xls file, overwritting the existing file (it will always be the
same file, in the same location)
The problem Im having is it needs to run overnight without intervention so
how can I have it run the save as and overwrite without prompting for
compatibility issues or file already exists?
Basically am after a way of opening and closing the file silently
any ideas greatly appreciated

thanks
 

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

Similar Threads

Opening XLS (2003) workbooks in 2007 (XLSX) 1
Need to close subprojects without Save prompt 2
close workbook without saving or promt to save 3
Cannot open 2007 excel files(.xls) as email attachments on Win. Vi 0
MS Word 2007 files taking too long to open after new internet connection 5
Remove Prompt to Open File as Read-Only (Excel 2007) 2
Excel 2007 1
Opening Office 2003 excel file in Office Excel 2007 1

Top