| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open excel file, enter values, save & close
I would like to write a macro that will open a designated excel file, (really
doesn't have to open it visibly, I just need to be able to insert items in the next empy row) Order Form.xls, find the first empty row, insert values in certain cells in that row based on values from the excel file that called the macro, save the Order Form.xls file, close (if opened) and return to the original excel worksheet. I have a function currently that does something similar into an access file. Are the methods similar? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open, Save and close Excel 2007 file with a cmd command | Excel Discussion (Misc queries) | |||
| Each time I close an Excel file, it asks if I want to save. | Excel Discussion (Misc queries) | |||
| File close excel does not ask me to save changes | Excel Discussion (Misc queries) | |||
| I can't save a file unless I close all excel instances or it's th. | Excel Discussion (Misc queries) | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Threaded Mode
