Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open (or save to) other workbooks
I have been reading the help for excel and I cannot figure out why it,
seemingly, not accept to open and read data from another workbook without resourcing to COM or whatever other means. What I am looking for: I have this data entry form that once you click the OK button, it will record, or add: 1. In a workbook called main. 2. Based on the 5th item of the data entry form, will record to diferent workbooks, named according to the value in that 5th item. Hernan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to open, Update links, save and close workbooks | Excel Discussion (Misc queries) | |||
Save all open workbooks | Excel Discussion (Misc queries) | |||
Save and Close all Open Workbooks using VBScript | Excel Programming | |||
Auto open 8 workbooks in different folders, then save on close... | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |