Member Avatar for tgifgemini
tgifgemini 12 Junior Poster


VB6 - Generate a new/blank sheet each time I execute my program.
Hello everybody,
can someone show me the best way I can programatically generate a new blank spreadsheet for my report.

Currently, I am populating a spreadsheet using access files (query). The spreadsheet template is located in my "C:\BiWeeklyPeriodProg.xls". This spreadsheet/template has pageSetup formating which I want to preserve and use over and over, but some of the underlines in the report body is acting wacky ( unable to go away) So I'd rather use a fresh spreadsheet and repopulate and reformat the underlines where needed.

How can I generate a new/blank spreadsheet and still save it as the same existing name:

"C:\BiWeeklyPeriodProg.xls"

?

Thanks all.
tgif

  • 1 Contributor
  • 0 Replies
  • 83 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.