Column name with LF and copy sheet with macro

Hi friends

① i have a select query as below
DT.Select(“AAB = '”+item.ToString+"’").CopyToDataTable

But actually the column name has LF, its
image

How can i change the query.

②How can i copy a sheet with macro to new excel file with macro enabled.
When i used copy, its buttons on that sheets are not working

Hi

For this
We can use link query like this in a assign activity [quote=“oshan, post:1, topic:190823”]
have a select query as below
DT.Select(“AAB = '”+item.ToString+"’").CopyToDataTable
[/quote]

dtb= (From p In dta.Select
Where p(Column_Index).ToString.Equals(“StringValue”)
Select p).ToArray.CopyToDataTable()

Then for this

Did we try with MOVE FILE activity where in the destination path we can the new file name instead

Cheers @oshan

1 Like

Thanks a lot for your great support always, i will try this and get back

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.