09-23-2015, 12:04 AM
This is really puzzling.
I output urls into excel as a new row for each url yet each url has a carriage return at the end?
This breaks the function, web, which doesn't see a single line, but two.
I tried replace and replacerx in quickmacros. I tried to delete the carriage return in excel but that doesn't work..In fact it doesn't even show up in excel. It only shows up in notepad and ms word when I copy the row and paste it there.
I did some more testing, I suspect it's "SetCell" that does this by default. Can you confirm? Is there a way to fix it?
I output urls into excel as a new row for each url yet each url has a carriage return at the end?
This breaks the function, web, which doesn't see a single line, but two.
I tried replace and replacerx in quickmacros. I tried to delete the carriage return in excel but that doesn't work..In fact it doesn't even show up in excel. It only shows up in notepad and ms word when I copy the row and paste it there.
I did some more testing, I suspect it's "SetCell" that does this by default. Can you confirm? Is there a way to fix it?