Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put Value in Close Excel
Hi,
I've found this wonderful code from John's website. Which retrieve a value from a closed workbook. http://j-walk.com/ss/excel/eee/eee009.txt However, I need a code to do the opposite. Eg: To Put or Write a value to a closed workbook. Is there a way? Thanks. JL |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put Value in Close Excel
you can't do that
your code would need to open the workbook then save/close it dim wb as workbook dim sWBname as string sWBname = "{full path and name}" set wb=WorkbooksOpen(sWBname ) ' do something to it wb.worksheets("Sheet1").Range("A1")=Date wb.Close True ' true saves, false doesn't save set wb = Nothing ' cleanup wrote in message ... Hi, I've found this wonderful code from John's website. Which retrieve a value from a closed workbook. http://j-walk.com/ss/excel/eee/eee009.txt However, I need a code to do the opposite. Eg: To Put or Write a value to a closed workbook. Is there a way? Thanks. JL |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put Value in Close Excel
Hi,
Opening and Closing Workbook takes a long time. I need to update 3000 closed workbooks.. :( Can't ExecuteExcel4Macro function be use to input data to closed Workbook ? Thanks. JL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
In Before Close Sub ActiveWorkBook.Close(False) repeat procedure | Excel Programming | |||
Not close thead when I close excel | Excel Programming | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |