File Not Found In Macro

[SH_94]

Hi Community, 

i have build the workflow and macro as attached below but it prompt me an error message as per screenshot below:

May i know if anyone encounter this before and could you please assist me on this ?

Many thanks in advance

[SH_94]

Hi @atcodedog05 ,

I try the macro file and may i ask do i need to specify the sheet and how can i do that for this part?

Thank you

[atcodedog05 · Accepted solution]

Hi @SH_94 

It works for me and able to get both sheets. Refer attached workflow.

Also I could from your screenshot your system doesn't have enough processing space (Refer yellow highlighted below). You may want to close some applications and try again.

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

May i know how can i extract the information of sheet name and file name by using this macro?

Thank you.

[atcodedog05]

Hi @SH_94 

Try this updated workflow.

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

May i ask for the following screenshot, do we need to tick the replace a specific string? May i know what information need to put for the column under the replace a specific string? Can we put the same as the one in circle?

[atcodedog05]

Hi @SH_94 

May i ask for the following screenshot, do we need to tick the replace a specific string? Yes

May i know what information need to put for the column under the replace a specific string? Full path and file name excluding the sheetnames refer highlighted below

Can we put the same as the one in circle? Yes

These are placeholders. This macro wouldn't need any change it should work where it's placed with whatever input folder path you give.

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

May i ask if you know how to solve the error below?

Thank you