Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Text to Formula
hi all,
looking for assistance on how to convert a text within a cell to a formula. i sucessfully created the text for a cell as follow: C:\Documents and Settings\jurgenC\Desktop\QA\[TestCases (FRD).xls]TestScripts!'E12 now i would like to convert this into a formula so that it reads: =C:\Documents and Settings\jurgenC\Desktop\QA\[TestCases (FRD).xls]TestScripts!'E12 the piece of code is as follow: Workbooks(sMaster). _ Worksheets("TestScripts"). _ Range("A1"). _ Offset(iRowD, iPriority + 4) = _ "'" & sLocation & "[" & Workbooks(sMaster). _ Worksheets("TestScripts"). _ Range("A1"). _ Offset(iRowD, iPriority + 3) & "]TestScripts!'E" & iRowS + 2 thanking you in advance for any help and your time. cheers.... ....jurgenC! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Text to Formula
jurgenC!,
Use this in your formula. Offset(iRowD, iPriority + 4).Formula = "=" & _ Rob "jurgenC!" <jurgen1967ATyahoo.com.au wrote in message ... hi all, looking for assistance on how to convert a text within a cell to a formula. i sucessfully created the text for a cell as follow: C:\Documents and Settings\jurgenC\Desktop\QA\[TestCases (FRD).xls]TestScripts!'E12 now i would like to convert this into a formula so that it reads: =C:\Documents and Settings\jurgenC\Desktop\QA\[TestCases (FRD).xls]TestScripts!'E12 the piece of code is as follow: Workbooks(sMaster). _ Worksheets("TestScripts"). _ Range("A1"). _ Offset(iRowD, iPriority + 4) = _ "'" & sLocation & "[" & Workbooks(sMaster). _ Worksheets("TestScripts"). _ Range("A1"). _ Offset(iRowD, iPriority + 3) & "]TestScripts!'E" & iRowS + 2 thanking you in advance for any help and your time. cheers.... ...jurgenC! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Text to Formula
hi Rob,
thanks for your time and input, not too sure if i am doing something incorrectly, but as soon as i add ' .Formula = "="& ' to the code, i receive the 1004 error (Application-defined or object-defined error). all is well if i only add ' .Formula ' to the code, but as soon i add the equal sign, the error will appear. cheers... ....jurgenC! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Text to Formula
I suspect there's a syntax error with the formula.
Using the old method, let it write a formula to the cell. Then manually edit the formula and put an = before the text. See if it accepts it. Rob "Rob van Gelder" wrote in message ... jurgenC!, Use this in your formula. Offset(iRowD, iPriority + 4).Formula = "=" & _ Rob "jurgenC!" <jurgen1967ATyahoo.com.au wrote in message ... hi all, looking for assistance on how to convert a text within a cell to a formula. i sucessfully created the text for a cell as follow: C:\Documents and Settings\jurgenC\Desktop\QA\[TestCases (FRD).xls]TestScripts!'E12 now i would like to convert this into a formula so that it reads: =C:\Documents and Settings\jurgenC\Desktop\QA\[TestCases (FRD).xls]TestScripts!'E12 the piece of code is as follow: Workbooks(sMaster). _ Worksheets("TestScripts"). _ Range("A1"). _ Offset(iRowD, iPriority + 4) = _ "'" & sLocation & "[" & Workbooks(sMaster). _ Worksheets("TestScripts"). _ Range("A1"). _ Offset(iRowD, iPriority + 3) & "]TestScripts!'E" & iRowS + 2 thanking you in advance for any help and your time. cheers.... ...jurgenC! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Text to Formula
Hi Rob,
how write you were (the error was between chair and keyboard <smirk). the '-symbol was in the incorrect location. once again a big thank you for your help and time. cheers.... ...jurgenC! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Text to Formula | Excel Worksheet Functions | |||
How to convert formula to text | Excel Worksheet Functions | |||
convert text into Formula | Excel Discussion (Misc queries) | |||
how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) | |||
convert text to a value to be used in a formula | Excel Worksheet Functions |