ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Downloading data in Excel format (https://www.excelbanter.com/excel-discussion-misc-queries/182515-downloading-data-excel-format.html)

GKW in GA

Downloading data in Excel format
 
I have created some custom styles that I store in the BOOK.xlt template in
the startup folder. Whenever I create a new Excel workbook, using the NEW
DOCUMENT toolbar button or using the NEW option off the FILE menu, these new
styles are available in the new document. However, when I create a new
document by downloading data from 3rd party tools that permit downloading
into Excel format, they are not there. Is it possible to make these custom
styles available to a workbook I have created by downloading data or do I
have to re-create them in documents I create from downloading

Gord Dibben

Downloading data in Excel format
 
I think you are out of luck.

The third-party download to create a new workbook will use the default Excel
workbook.

Can you somehow create the new workbook from BOOK.xlt then pull in the data
using DataImport External Data?


Gord Dibben MS Excel MVP


On Fri, 4 Apr 2008 05:11:01 -0700, GKW in GA
wrote:

I have created some custom styles that I store in the BOOK.xlt template in
the startup folder. Whenever I create a new Excel workbook, using the NEW
DOCUMENT toolbar button or using the NEW option off the FILE menu, these new
styles are available in the new document. However, when I create a new
document by downloading data from 3rd party tools that permit downloading
into Excel format, they are not there. Is it possible to make these custom
styles available to a workbook I have created by downloading data or do I
have to re-create them in documents I create from downloading




All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com