View Single Post
  #6   Report Post  
Posted to microsoft.public.vb.ole.automation,microsoft.public.excel.programming
Dmitriy Antonov Dmitriy Antonov is offline
external usenet poster
 
Posts: 2
Default Using VB6 and OLE to add a new column to an existing Excel worksheet


"Dmitriy Antonov" wrote in message
...

wrote in message
oups.com...
Greetings,

Is it possible to programmatically add a new column to an existing
Excel worksheet using VB 6.0 and OLE? Or VB 6.0 and ??? It's OK if the
added column becomes the new "A" column and shifts all previously
existing columns over one. I 'haven't been able to google up any
coding examples that do this. Examples are always welcome.

TIA,

Steve


Check here, maybe this is what you are asking for:
http://support.microsoft.com/kb/285332

Check References within that article for more links.

Dmitriy.


Oops. I accidentally misplaced my reply. It applies to another post (the
one, which is just above it) - so please disregard it here.

Dmitriy.