im trying to open and close a notepad using vba, the following code works to open, but no idea how to close it, I already tried fso.close and fso.quit but error raise, do you know how to achieve this??

I’m trying to concatenate the following column A row 1 with column B and loop till row 207 and insert into another column and additional rows before going on to row 2 of column A and so on. The data is as follows

I’m trying to concatenate the following column A row 1 with column B and loop till row 207 and insert into another column and additional rows before going on to row 2 of column A and so on. The data is as follows

I’m trying to concatenate the following column A row 1 with column B and loop till row 207 and insert into another column and additional rows before going on to row 2 of column A and so on. The data is as follows

I have a table called “Sales Tracker”
I did an auto filter and got my results.
now i want to transfer the visible fields to my array called soArray
the first time i go thru the cells it works fine and i get the 4 fields
i need into the array,
however, after the first time i get a “Run-Time error’9′: Subscript out of range”
what am i doing wrong?
any help or push would be appreciated, thank you
below is my code

I have a table called “Sales Tracker”
I did an auto filter and got my results.
now i want to transfer the visible fields to my array called soArray
the first time i go thru the cells it works fine and i get the 4 fields
i need into the array,
however, after the first time i get a “Run-Time error’9′: Subscript out of range”
what am i doing wrong?
any help or push would be appreciated, thank you
below is my code

I have a table called “Sales Tracker”
I did an auto filter and got my results.
now i want to transfer the visible fields to my array called soArray
the first time i go thru the cells it works fine and i get the 4 fields
i need into the array,
however, after the first time i get a “Run-Time error’9′: Subscript out of range”
what am i doing wrong?
any help or push would be appreciated, thank you
below is my code

I have a table called “Sales Tracker”
I did an auto filter and got my results.
now i want to transfer the visible fields to my array called soArray
the first time i go thru the cells it works fine and i get the 4 fields
i need into the array,
however, after the first time i get a “Run-Time error’9′: Subscript out of range”
what am i doing wrong?
any help or push would be appreciated, thank you
below is my code

I have a table called “Sales Tracker”
I did an auto filter and got my results.
now i want to transfer the visible fields to my array called soArray
the first time i go thru the cells it works fine and i get the 4 fields
i need into the array,
however, after the first time i get a “Run-Time error’9′: Subscript out of range”
what am i doing wrong?
any help or push would be appreciated, thank you
below is my code

I know I m a pain but I have spent the last few hours trying to covert the below code over to google script. with very little luck.