open, copy sheet and save as a defined name

[vermaati]

Hi guys, i wonder if someone can help me with this piece of code please. it is a bit of aging code from the days of office 97/2000. it sometimes work and sometimes does not.

Sometimes it goes in a loop and excel is not responding. All it needs to do is open a sheet, copy certain information (cells from one to another, paste as test) and save as a defined name.

some optimizations necessary it would seem. What will be nice is if i can define the path where the document is to be saved? or save to current\quote?

here goes

Please Login or Register  to view this content.

[Norie]

Where would you want the file to be saved?

PS When posting code can you please use CODE tags?

[vermaati]

apologies. fixed now.

the path usually resides under the google drive/onedrive default folder, c:\users\%username%\onedrive/google drive.

it saves to a subfolder .\working

thanks for the reply