Solve ignore error in excel

I have data in excel number but type=general. But I want ignore error. (choose ignore error all column G)

image
Ex input.xlsx (8.0 KB)
Please guide me to solve it.

@fairymemay - please check this post …

@prasath17 I copy from your code. But show error as below.

image
image

@fairymemay - macro should be in all lower case …because you look at your first line of code it is “Sub macro()” …which is the one you are invoking…

image

Make sure you are setting are ok too…

@fairymemay - Please find the starter help here… ConvertStringtoNumber.zip (62.3 KB)

This is two methods…

  • Using Invoke VBA
  • Using Invoke Code

image

Both have been tested and working…So depend on your requirement please choose.

Hope this helps…

@prasath17 I use invoke VBA.
But Same error.

image

image
some data input that I want convert ans VBA code as below.

macro2.txt (141 Bytes) input.xlsx (9.1 KB)

Please guide me about it.

@fairymemay - I am not sure how to proceed here …I gave 2 working codes …

If invoke vba is throwing error …please try the other method.

@fairymemay - When I used your code…I also got the error…The corrected it to straight quotes " " from Smart quotes “ ” and it worked perfectly…

image

Please try and let me know…

@prasath17 I​ change​ quotes to " " ----> It’s​ run​ completed​ but​ show​ error (green same)
not ignore error.

image

@fairymemay - please show or share the xaml.

Please add Read and write range in your xaml if not already there.

@prasath17 My .xaml Main.xaml (5.4 KB)
macro2.txt input.xlsx (8.4 KB)

I want ignore error and write in same file as below.
image