Replies

I am writing some macros to reformat some Excel files and would like to remove some extra line breaks so that in a cell instead of:
Line 1
Line 2
I have:
Line 1 Line 2

I tried removing the line breaks by using:

Cells.Replace What:="vbCrLf", Replacement:=" ", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Cells.Replace What:="vbLf", Replacement:=" ", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False


But that does absolutely nothing. Anyone got any ideas on why this isn’t working, or how I can do it better? My VBA only gets used every couple years and thus gets very rusty.

Thanks Hans, I knew I had to be making some sort of dummy error. That works perfectly!

Hi Jerry-

Thanks for the tip. I will keep it in mind for the future.

Correct me if I’m wrong, but I think

should be

ul{
margin-left:15px;
padding-left:0;
}
works perfectly! Thanks so much for the help!

OK, thanks Hans!

OOO, Chocolate!

What tag do you guys use for code? I tried italics last time, but that doesn’t look the same.

Well, apparently I can use CSS! Just for the heck of it I pasted style tags above my HTML (since the code is not for an entire page there are no head or body tags), and it worked! Well, sort of. The
padding:0;
margin:0;
code takes the text outside of the left line of the box, while padding:1 makes it the same as it was. So, now I’m excited because I can use CSS, which we had always been told we couldn’t, but sadly, I still haven’t got my list working right.

Sadly, I cannot use CSS. I have access to the HTML source, but the software I’m using does not allow anything beyond basic HTML (very annoying!).

But when you open a pdf and view the first page, wouldn’t that download that page, or does showing the image on the screen have nothing to do with how it prints? I remember back last fall when we were trying to troubleshoot this problem, I’d open the pdf and view all the pages and try to print it, and the same pages would print blank, whether I viewed them or not.

But why would that cause mostly first pages of the articles not to print, since those (theoretically, at least) would load before the student would have a chance to view any other pages? It would make sense for the pages that didn’t print at the end of the article, though.

Interesting update on this problem: It hasn’t happened since last fall that I know of, but a student had about 4 of the 15 or so articles she printed tonight print out with blank pages and pages only half printed. Ironically, it was the first page of the article that usually printed blank. Thankfully, the Print to Image option still fixed it. It’s such a bizarre thing! (And doesn’t make the students–who pay for printing–very happy!)

Oh, and I think I tried to figure out a custom format for mm/yyyy in Access and couldn’t get it to work anyway. But, that was last year sometime, and being a Mommy has run away with my brain since then!

Sometimes a summary for the year is all the data I have–sometimes it’s broken out by month. So, I’m just throwing it all in the same place and then I can run whatever reports I want on the data. Nothing in the table will be looked at without going through a query first, so it’s easier for me to just throw it all into one place. That way I can search for all the summary data for 2006, or all the data for Jan 2006, or whatever else I want to do.

Yeah, it should leave the entries alone, but I would have sworn it wasn’t doing so. However, when I just tested it, it worked fine. Go figure. But, if it starts doing it again, I think putting the apostrophe there will be a quick solution. I had forgotten I could do that. Thanks!

(The problem with importing the column as date/time values into Access is that then Access changes them to mm/dd/yyyy instead of mm/yyyy. And, I can’t use a custom format because I have some rows that contain summary data for the year as just yyyy.)

Thanks for the suggestion. The problem with that solution, is that if I do that when I import the spreadsheet into Access, it changes the format to Date/Time, and mm/dd/yyyy, so then the data is screwed up again. My Excel solution so far has been to enter a date into the column, and then change the column format to text, which it will then respect. If I change it to text first, then it still auto-corrects the field. So, it’s annoying to have to enter a date twice, but it’s doable if there’s no other choice.