Radical color chages on importing a worksheet (Excel 2010)?

D

djo77399

I have a complex requirement in Excel 2010 that requires me to impor
sheets from multiple workbooks and collate them into a single workboo
for distribution. These other files have background colors in the row
alternating beige and no-color. There are group headers that ar
backgrounded in gray. The beige rows import as neon green (you can'
make this stuff up!) and the gray rows import as neon red. In othe
imported sheets, the beige background imports as black and the tex
(foreground) as red.

I have no idea what's going on, but this needs to NOT HAPPEN. I am usin
a VBA routine to do the work, but the same thing happened when I did i
with manual cut-and-paste.

If someone can help me out on this please! I have to get this thing int
production soon. I'm an experienced ABV/Access developer, but have ver
little Excel experience.

Thanks a million!

Dennis


PS: The Crystal reports Export function exports the report in "Exce
97-2003" format only. I need all formatting and colors to remai
identical to the source sheet when I bring the external sheets in
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top