Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open, update and convert 2007--2003 then close without any prompt
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 data link update prompt | Links and Linking in Excel | |||
Open and Close a Workbook to Update Links | Excel Discussion (Misc queries) | |||
Excel 2007 very slow to open or close | Excel Discussion (Misc queries) | |||
Cannot open Excel 2007 with Excel 2003 even after update | Excel Discussion (Misc queries) | |||
How to open a list of excel files and get update, then close it? | Excel Discussion (Misc queries) |