Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a file name from within string
Similar to my last post, I want to be able to change a parameter
within a calculation. I have tried to modify code that I used for a similar event from before but I am stumped. The code is as follows: - Dim extract As String ActiveCell.FormulaR1C1 = _ extract = InputBox("Please enter Version Control Master file", "File Name") ActiveCell.FormulaR1C1 = _ "=+'[& extract &]Static Summary'!R9C3-'[Version Control Master 20070815.xls]Static Summary'R9C3" Basically I am calling cell C9 from one sheet whose name changes daily and subtracting the value in C9 on the other sheet which does not change. Responses/guidance gratefully received. Thank you Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a file name from within string
One way:
ActiveCell.FormulaR1C1 = _ "='[" & extract & "]Static Summary'!R9C3-'[Version Control Master 20070815.xls]Static Summary'R9C3" In article .com, wrote: ActiveCell.FormulaR1C1 = _ "=+'[& extract &]Static Summary'!R9C3-'[Version Control Master 20070815.xls]Static Summary'R9C3" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a file name from within string
Je,
Tried your suggestion , comes up with a debug error. I also tried this: - ActiveCell.FormulaR1C1 = _ "='[" & extract & ".xls""]Static Summary'!R9C3-'[Version Control Master 20070815.xls]Static Summary but that just debugs too. Mark On 18 Sep, 13:18, JE McGimpsey wrote: One way: ActiveCell.FormulaR1C1 = _ "='[" & extract & "]Static Summary'!R9C3-'[Version Control Master 20070815.xls]Static Summary'R9C3" In article .com, wrote: ActiveCell.FormulaR1C1 = _ "=+'[& extract &]Static Summary'!R9C3-'[Version Control Master 20070815.xls]Static Summary'R9C3"- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Use pic location string to call up picuture in cell? | Excel Discussion (Misc queries) | |||
Call UDF by String Name | Excel Programming | |||
How do I call a dynamically created String in a VBA Sub | Excel Programming | |||
sub call with string | Excel Programming | |||
Excel4 Call to get Function String | Excel Programming |