6 Replies - 1332 Views - Last Post: 25 September 2012 - 06:19 AM Rate Topic: -----

#1 JackobzKoome  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 21-September 12

vb6 does not format the excel sheet as specified when exporting the se

Posted 21 September 2012 - 04:11 AM

Hi can anybody tell me why,when i export data from access using vb6 to excel i have formatted the cells that i want to be bold and have boarders in them,the first time when i run the project i works well but if i export another report it has no boarders and not formatted,i have attached the screenshot of the spreadsheet

Here is the screenshot

View PostJackobzKoome, on 21 September 2012 - 04:07 AM, said:

Hi can anybody tell me why,when i export data from access using vb6 to excel i have formatted the cells that i want to be bold and have boarders in them,the first time when i run the project i works well but if i export another report it has no boarders and not formatted,i have attached the screenshot of the spreadsheet

Here is the screenshot

it is supposed to be formatted like thisAttached Image

Attached image(s)

  • Attached Image


Is This A Good Question/Topic? 0
  • +

Replies To: vb6 does not format the excel sheet as specified when exporting the se

#2 JackobzKoome  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 21-September 12

Re: vb6 does not format the excel sheet as specified when exporting the se

Posted 21 September 2012 - 04:16 AM

[quote name='JackobzKoome' date='21 September 2012 - 04:11 AM' timestamp='1348225889' post='1706399']
Hi can anybody tell me why,when i export data from access using vb6 to excel i have formatted the cells that i want to be bold and have boarders in them,the first time when i run the project i works well but if i export another report it has no boarders and not formatted,i have attached the screenshot of the spreadsheet

Here is the screenshot

View PostJackobzKoome, on 21 September 2012 - 04:07 AM, said:

Hi can anybody tell me why,when i export data from access using vb6 to excel i have formatted the cells that i want to be bold and have boarders in them,the first time when i run the project i works well but if i export another report it has no boarders and not formatted,i have attached the screenshot of the spreadsheet

it is supposed to be formatted like thisAttachment Untitled.png

Was This Post Helpful? 0
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: vb6 does not format the excel sheet as specified when exporting the se

Posted 21 September 2012 - 07:02 AM

When you say "another report" are you talking about the same report a second time or a new report entirely?
Was This Post Helpful? 0
  • +
  • -

#4 JackobzKoome  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 21-September 12

Re: vb6 does not format the excel sheet as specified when exporting the se

Posted 21 September 2012 - 07:16 AM

View PostBobRodes, on 21 September 2012 - 07:02 AM, said:

When you say "another report" are you talking about the same report a second time or a new report entirely?

am talking about the same report a second time and any other report sharing the same code
Was This Post Helpful? 0
  • +
  • -

#5 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: vb6 does not format the excel sheet as specified when exporting the se

Posted 21 September 2012 - 07:20 AM

When you say "sharing the same code" you mean "sharing the same data"?
Was This Post Helpful? 0
  • +
  • -

#6 JackobzKoome  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 21-September 12

Re: vb6 does not format the excel sheet as specified when exporting the se

Posted 24 September 2012 - 04:30 AM

View PostBobRodes, on 21 September 2012 - 07:20 AM, said:

When you say "sharing the same code" you mean "sharing the same data"?

yes the same data,the data comes out correctly the problem is putting the boarder around the cells which do not work
Was This Post Helpful? 0
  • +
  • -

#7 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: vb6 does not format the excel sheet as specified when exporting the se

Posted 25 September 2012 - 06:19 AM

Well, it's clear to me that you're copying from two different sources here. There isn't just the "border" problem (FYI, a "boarder" is a person who pays to live in someone's house, sorry for our Byzantine spelling practices), the text is different in some of the cells. If you're always copying to the same range (not enough info here to determine that), then you're probably copying formatting to the cells along with data. I would look into whether you have a "paste special" in there somewhere.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1