Function in a Template revisited

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Boris Mohar (borism_at_sympatico.ca)
Date: 11/20/04 

Date: Fri, 19 Nov 2004 21:59:32 -0500

Hello again,

I corrected the problem and now my template gels saved correctly with the
function =(B1*20) in column C. When I open the template I get all zeroes
in column C which is correct since there is no data in column B yet.
Now I import data:

Data> Import External Data
My data is the tab delimited BOM text. I set it up so that there is a blank
entry for column C

The only imports available are Edit Text import and Data range properties.
Others are grayed out.

I select Edit Text Import and go with the defaults. At this point data gets
imported and the column C function gets overwritten with a blank.

What to do?

Regards,

Boris Mohar

 

Relevant Pages

  • Repost -Function in Template
    ... My data is the tab delimited bill of materials. ... The only imports available are Edit Text import and Data range properties. ... Why is data overwriting the implementation of the function? ...
    (microsoft.public.excel.misc)
  • Re: Function in a Teemplate
    ... Data> Import External Data ... My data is the tab delimited BOM text. ... The only imports available are Edit Text import and Data range properties. ...
    (microsoft.public.excel.programming)
  • Function in Tempalte
    ... My data is the tab delimited bill of materials I set it up so that there is a ... The only imports available are Edit Text import and Data range properties. ...
    (microsoft.public.excel.misc)
  • RE: Need to have a field always have 13 characters & insert leadin
    ... For direct entry or imports, I do not believe you can do the automatic ... padding of zeroes. ... pads those fields that do not have thirteen digits. ... always see of thirteen characters, why should they care about what is ...
    (microsoft.public.access.tablesdbdesign)
  • Reference?
    ... I trying to edit a project I haven't worked with in a long time. ... Namespace or type 'Core' for Imports 'Microsoft.Office.Core' cannot be found. ...
    (microsoft.public.dotnet.languages.vb)