Thread: Cell formatting when pulling into VB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Skeletonhat Skeletonhat is offline
external usenet poster
  
Posts: 1
Default Cell formatting when pulling into VB

I have an excel spreadsheet that im pulling into a VB flexgrid wit
ADODB.

But i have a collumn that has a header and sub header and then belo
that is several records of times.
When it pulls from that table, it formats EVERYTHING in that collumn a
a time thus nullifying the header and sub header.

I tried adding 'imex=1' to the extrended proporties but then "2:00 PM
becomes .58333333...

is there a happy medium? some way i can have each cell formatte
individually

--
Skeletonha
-----------------------------------------------------------------------
Skeletonhat's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27223

Reply With QuoteReply With Quote