 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008replacing value in formula from outside worksheet?
We know we can start up a spreadsheet from the command prompt: excel <spreadsheetname>. We've seen batch files which allow one to specify a replacable parameter in the batchfile from the command line. I'm trying to do something similar in Excel. Assume A1:A4 is populated with the names Bob,Ted,Carol,Alice, and I've written the following formula for Column B: =If((A1:A4)="Bob",1,0). this will return a '1' in B1, and "0" in B2-B4. Now, I want to change "Bob" to "Ted" from the command line. I"m looking for someway to identify a field as replacable, and to perform the replacement. Any suggestions? - Mike If I understand correctly your question, then you might want to use the find replace feature. > We know we can start up a spreadsheet from the command prompt: excel > <spreadsheetname>. [quoted text clipped - 11 lines] > > Any suggestions? - Mike I believe find/replace would change the data; I'm trying to replace a value in the formula - Mike > If I understand correctly your question, then you might want to use the find > replace feature. [quoted text clipped - 16 lines] > > - Show quoted text - No. try it, it can change the value of the formula as well. > I believe find/replace would change the data; I'm trying to replace a > value in the formula - Mike [quoted text clipped - 19 lines] > > > > - Show quoted text - You cannot do anything from the command line other than open a specific workbook. To make changes upon opening, you would require workbook_open event code in the workbook. Gord Dibben MS Excel MVP >We know we can start up a spreadsheet from the command prompt: excel ><spreadsheetname>. [quoted text clipped - 11 lines] > >Any suggestions? - Mike |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.