Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
write to external workbook from userform
from an excel 2003 userform, how could i write data entered, to an existing
external workbook? thanks! don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
write to external workbook from userform
Either add a save button to the userform or write a trigger for when an entry is changed. The value of the entered data can be accessed by -myControl.Value - where -myControl- is the name of the control that was used (for example -TextBox1-, the default name for the first textbox you add to the userform). To open a workbook, you can use -Workbooks.Open(filepath)-. To give yourself easy access to this new workbook, you can create a static variable as a workbook (-Static myWorkbook As Workbook-) and then assign the opened workbook to that variable (-Set myWorkbook = Workbooks(filename)-). Now you can do whatever you want with that workbook. Hope that helps, let me know if I confused you or if I completely missed your question. -- Raman325 ------------------------------------------------------------------------ Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748 View this thread: http://www.excelforum.com/showthread...hreadid=396571 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write cell info to external file | Excel Worksheet Functions | |||
write to external file | Excel Programming | |||
Write no closed workbook ? | Excel Programming | |||
External data references in a userform control | Excel Programming | |||
Write to closed workbook code | Excel Programming |