Exclude first charachter
 

How do I exclude the "=" from my formula?
I'm using:
AAWGDFormula = ActiveCell.Formula
where my ActiveCell.Formula is
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599" to assign it
as a variable.

Instead of AAWGDFormula reading
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"
I want it to read
"[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"

Exclude first charachter
 

strFName = Right(strFName, Len(strFName) - 1)

StephanieH wrote:
How do I exclude the "=" from my formula?
I'm using:
AAWGDFormula = ActiveCell.Formula
where my ActiveCell.Formula is
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599" to assign it
as a variable.

Instead of AAWGDFormula reading
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"
I want it to read
"[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"

Exclude first charachter
 

Great. Thanks Dave.

"davegb" wrote:

strFName = Right(strFName, Len(strFName) - 1)

StephanieH wrote:
How do I exclude the "=" from my formula?
I'm using:
AAWGDFormula = ActiveCell.Formula
where my ActiveCell.Formula is
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599" to assign it
as a variable.

Instead of AAWGDFormula reading
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"
I want it to read
"[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"

Exclude first charachter
 

A shorter way is:

strFName = Mid(strFName, 2)



StephanieH wrote:
Great. Thanks Dave.

"davegb" wrote:

strFName = Right(strFName, Len(strFName) - 1)

StephanieH wrote:
How do I exclude the "=" from my formula?
I'm using:
AAWGDFormula = ActiveCell.Formula
where my ActiveCell.Formula is
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599" to assign it
as a variable.

Instead of AAWGDFormula reading
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"
I want it to read
"[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"