Thread: Replace data into closed workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel Héctor Miguel is offline
external usenet poster
  
Posts: 434
Default Replace data into closed workbook
hi, Berislav !

Is it possible to replace/change cell value into closed workbook from active workbook?

see Andy Wiggins' page: http://www.bygsoftware.com/Excel/sql.htm

you will need "UPDATE" and "INSERT" (downloadable sample workbooks)

hth,
hector.


Reply With QuoteReply With Quote