Hi,
I want to copy column B(DATE) and paste in a new notepad file. Again copy the same notepad content back to column B. I want to save notepad without saving.
I'm doing this to eliminate double click in every cell if I change the content to Date datatype.
VBA Code to copy excel column to notepad and vice versa.
-
udk -
May 12, 2021 at 10:31 AM -
Thread is marked as Resolved.
-
-
-
Why would you need to click in every cell? Select the cells and format as dates.
If it's an import of data then use Text To Columns to convert to dates.
Attach an example file, not an image.
-
It is an imported data. I want it to be in an automated day using VBA.
-
Quote
Attach an example file, not an image.
-
Please find the example file attached. Is that fine for you ?
-
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!