Chr(34) giving error in code stage

soonerorlater

New Member
Hi guys,

I am using Code stage (Visual Basic) to work with some XML file content and i need to concatenate strings and also use double quotes in the output.
For this i am using Chr(34). But the code stage is not able to identify the "Chr"

Error:
Description: Compiler error at line 2: 'Chr' is not declared. It may be inaccessible due to its protection level.
Repairable: No

Can you please help me out? thanks
 
Last edited:

VJR

Well-Known Member
Hi soonerorlater,

Check adding namespace Microsoft.VisualBasic and then use Strings.Chr.
 
HI I have a similar issue, i have following text entered in my code to remove filter from excel but it states "not declared "instances at xlhandle,getworkbook, wbname and wsname.

Dim ws As Object
ws = GetWorkbook(xlHandle, wbName).Worksheets(wsName)

Dim table As Object
For Each table In ws.ListObjects
If table.ShowAutoFilter Then
table.ShowAutoFilter = False
End If
Next table

If ws.AutoFilterMode Then
ws.AutoFilterMode = False
End If
 
Top