Member Avatar for Seba Sama
Seba Sama 0 Light Poster

Hi

I need to export some data from VB SQL query to an existing excel file, witch is a bill model. In the area where I use CopyFromRecordset are some merged cells, and all goes fine but the paste of data in those cells. If there are 3 merged cells and 3 columns only the value from the first column is pasted, like excel unmerges the 3 cells, paste data, then merge again keeping the leftmost data only...
Anyone knows a solution for this so I don't have to loop and code for handling of each column?

I gave the name "content" to the first cell in left-top of that area, and xlSheet.CopyFromRecordset rs works fine only if there are not merged cells.

Thx,
SebaSama

  • 1 Contributor
  • 0 Replies
  • 38 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.