Macro error on .xlsm

Help Activities
, ,
1

I have macro enabled in my .xlsm workbook and still getting below error.
image

image

2

hi @PALKUMARI_PATEL

Can you please go to The Macro Settings once again and check.

Options>Trust Center> Trust Center Settings > Macro Settings

image

This should work!

3

I have same settings and I also tried to Enable Excel 4.0 checkbox checked. Same error getting all time.

4

Can you share the Macro file Formula.txt as a screenshot here?

5

Qty_On_Hand Formula.txt (353 Bytes)

6

Did you pass parameters like this?

image

7

I am first reading the file and that read range I put like this in parameter.
image
FYI- read is the Datatable for read range

8

you need to correct this as
{“F2:F”+(read.Rows.Count+1).toString+“”“”}

9

Ok, I am reading an Excel by opening it. Any changes on that or it’s fine ? And after updating the formula I a getting same error.

10

that shouldn’t be an issue,
do one thing take your data in a normal xlsx file,
use Excel Application scope, read range and then invoke vba with your range.

Try that.

11

Ok, will try that and let you know. Can I use move file activity or Copy file with rename in xlsx ?

12

that might corrupt the file.

Can you try that manually first?

If that works then you can use Use the modern excel activities there you can save it as xlsx.

image

13

image
It copied into .xlsx but giving me this error.

14

What activity needs to use in excel modern ?

15

I manually created exl and still the same issue.
FYI- I am reading an excel without headers If I read it with headers It gives error of column name “A” already exist to data table.

16

Ok, I am reading an Excel by opening it. Any changes on that or it’s fine ?

18

Hi @PALKUMARI_PATEL ,

Please find the attached document i have updated the latest code with xaml and txt. go through it, if you have any doubts go throw below mentioned youtube link.

Link :- https://youtu.be/tsiy-JLrg28
Note :- This video will pop out by 22-Dec-2023 at 5 PM

New folder.zip (8.5 KB)

Channel Link:- https://www.youtube.com/channel/UCtx5wWVbY-NuCKclc6v7NOA

Regards,
Techystack

19

Hi @PALKUMARI_PATEL ,

I hope you got the resolution?

Regards,
Techystack

20

Can I use move file activity or Copy file with rename in xlsx ?