Trying to build a fixed width file for importing

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C48A0A.F421FA30
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am trying to build a fixed width file In Excel to import into another =
program.  The records are 252 (not sure what to call it) bits? of =
information long, in several fields.  When I build a couple of records =
for testing according to the file specs from the program, I am saving =
the file as an Excel "space delimited" .PRN file using Courier font. So =
far, so good.  However, when I open the file to check it using Notebook =
I see that the record has "wrapped" into two lines.  I open a similar =
file that was downloaded and created from an AS/400 (using Notebook) and =
the file does not wrap.  The test file that I am loading into the =
program is not being successfully applied.  My guess is that the =
"wrapping" of the record is the cause.

Would anyone know what I might do to save this record in an Excel =
spreadsheet without wrappping?

I sincerely appreciate anyone's help on this problem.

Thank you,

WF  
------=_NextPart_000_000C_01C48A0A.F421FA30
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I am trying to build a fixed width file =
In Excel to=20
import into another program.&nbsp; The records are 252 (not sure what to =
call=20
it) bits? of information long, in several fields.&nbsp; When I build a =
couple of=20
records for testing according to the file specs from the program, I am =
saving=20
the file&nbsp;as an Excel&nbsp;"space delimited" .PRN file using Courier =
font.=20
So far, so good.&nbsp; However, when I open the file to check it using =
Notebook=20
I see that the record&nbsp;has "wrapped" into two lines.&nbsp; I open a =
similar=20
file that was downloaded and created from an AS/400 (using Notebook) and =
the=20
file does not wrap.&nbsp; The test file that I am loading into the =
program is=20
not being successfully applied.&nbsp; My guess is that the "wrapping" of =
the=20
record is the cause.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Would anyone know what I might do to =
save=20
this&nbsp;record in an Excel spreadsheet without wrappping?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I sincerely appreciate anyone's help on =
this=20
problem.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thank&nbsp;you,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2>WF</FONT>&nbsp;&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_000C_01C48A0A.F421FA30--

0
someone913 (592)
8/24/2004 11:48:34 PM
excel 39879 articles. 2 followers. Follow

6 Replies
535 Views

Similar Articles

[PageSpeed] 7

First, this is pretty much a plain text newsgroup.  Most would appreciate if you
turned off the HTML stuff.

You have a few choices (try against a copy of your worksheet):

I'd either concatenate the cell values into another column:

=LEFT(A1&REPT(" ",5),5) & LEFT(B1&REPT(" ",4),4) & TEXT(C1,"000,000.00")

(You'll have to modify it to match what you want.)

Then I'd copy and paste to notepad and save from there.  Once I figured out that
ugly formula, I kept it and just unhide that column when I wanted to export the
data.

If that doesn't work for you, maybe you could do it with a macro.

Here's a link that provides a macro:
http://google.com/groups?threadm=015b01c32c5f%24b3d398d0%24a501280a%40phx.gbl

> WF wrote:
> 
> I am trying to build a fixed width file In Excel to import into another
> program.  The records are 252 (not sure what to call it) bits? of information
> long, in several fields.  When I build a couple of records for testing
> according to the file specs from the program, I am saving the file as an
> Excel "space delimited" .PRN file using Courier font. So far, so good.
> However, when I open the file to check it using Notebook I see that the
> record has "wrapped" into two lines.  I open a similar file that was
> downloaded and created from an AS/400 (using Notebook) and the file does not
> wrap.  The test file that I am loading into the program is not being
> successfully applied.  My guess is that the "wrapping" of the record is the
> cause.
> 
> Would anyone know what I might do to save this record in an Excel spreadsheet
> without wrappping?
> 
> I sincerely appreciate anyone's help on this problem.
> 
> Thank you,
> 
> WF

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
8/24/2004 11:54:53 PM
one way:

    http://www.mcgimpsey.com/excel/textfiles#fixedfield

In article <mtQWc.5913$T52.754@newssvr24.news.prodigy.com>,
 "WF" <someone@microsoft.com> wrote:

> I am trying to build a fixed width file In Excel to import into another 
> program.  The records are 252 (not sure what to call it) bits? of information 
> long, in several fields.  When I build a couple of records for testing 
> according to the file specs from the program, I am saving the file as an 
> Excel "space delimited" .PRN file using Courier font. So far, so good.  
> However, when I open the file to check it using Notebook I see that the 
> record has "wrapped" into two lines.  I open a similar file that was 
> downloaded and created from an AS/400 (using Notebook) and the file does not 
> wrap.  The test file that I am loading into the program is not being 
> successfully applied.  My guess is that the "wrapping" of the record is the 
> cause.
> 
> Would anyone know what I might do to save this record in an Excel spreadsheet 
> without wrappping?
0
jemcgimpsey (6723)
8/25/2004 2:52:41 AM
Thanks to you both for your input.  I'm afraid both of your answers are a
bit above my skill level in Excel.  I was hoping for a more simple solution.
I guess I'll have to buy a little help on this one.  I was hoping to be able
to do this myself.

Many thanks for your help.

WF
"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-124BA0.20524124082004@msnews.microsoft.com...
> one way:
>
>     http://www.mcgimpsey.com/excel/textfiles#fixedfield
>
> In article <mtQWc.5913$T52.754@newssvr24.news.prodigy.com>,
>  "WF" <someone@microsoft.com> wrote:
>
> > I am trying to build a fixed width file In Excel to import into another
> > program.  The records are 252 (not sure what to call it) bits? of
information
> > long, in several fields.  When I build a couple of records for testing
> > according to the file specs from the program, I am saving the file as an
> > Excel "space delimited" .PRN file using Courier font. So far, so good.
> > However, when I open the file to check it using Notebook I see that the
> > record has "wrapped" into two lines.  I open a similar file that was
> > downloaded and created from an AS/400 (using Notebook) and the file does
not
> > wrap.  The test file that I am loading into the program is not being
> > successfully applied.  My guess is that the "wrapping" of the record is
the
> > cause.
> >
> > Would anyone know what I might do to save this record in an Excel
spreadsheet
> > without wrappping?


0
someone913 (592)
8/25/2004 3:47:56 AM
This is a multi-part message in MIME format.

------=_NextPart_000_0048_01C48A3A.08094CE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

WF,

I can send you a workbook with formulas that will make a mirror of your =
sheet, properly padded to the field sizes you specify for each column.  =
If the cell contains text, it'll right-pad it with spaces; if a number, =
it left-pads it with zeroes.  If the cell has more characters than the =
specified field size, it lops it off, unless it's a number, in which =
case it says "Error." =20

Then you save it using the Text Write Program at =
www.smokeylake.com/excel, specifying no field delimiter. =20

The formula looks like this

=3DIF(ISTEXT(Data!A1), LEFT(Data!A1,FldLen!A$1) & REPT(" ", MAX(0, =
FldLen!A$1 - LEN(Data!A1))),  REPT("0", MAX(0, FldLen!A$1 - =
LEN(Data!A1))) & IF(LEN(Data!A1)<=3DFldLen!A$1, Data!A1, "~~~Err~~~"))

Your sheet is named "Data" and there's a sheet called FldLen that has =
the field lengths you want for each column in the first row. =20

I had a better one, but it was on the F drive of my old machine, I =
think.  That drive quit working.  =20

My "encoded" (wink wink) address is below.  Don't mention it in any =
posts -- the spammers would pick it up, and then I'd have to send my =
boys to your place.=20
--=20
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
=20
  "WF" <someone@microsoft.com> wrote in message =
news:mtQWc.5913$T52.754@newssvr24.news.prodigy.com...
  I am trying to build a fixed width file In Excel to import into =
another program.  The records are 252 (not sure what to call it) bits? =
of information long, in several fields.  When I build a couple of =
records for testing according to the file specs from the program, I am =
saving the file as an Excel "space delimited" .PRN file using Courier =
font. So far, so good.  However, when I open the file to check it using =
Notebook I see that the record has "wrapped" into two lines.  I open a =
similar file that was downloaded and created from an AS/400 (using =
Notebook) and the file does not wrap.  The test file that I am loading =
into the program is not being successfully applied.  My guess is that =
the "wrapping" of the record is the cause.

  Would anyone know what I might do to save this record in an Excel =
spreadsheet without wrappping?

  I sincerely appreciate anyone's help on this problem.

  Thank you,

  WF  
------=_NextPart_000_0048_01C48A3A.08094CE0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>WF,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I can send you a workbook with formulas that will =
make a=20
mirror of your sheet, properly padded to the field sizes you specify for =
each=20
column.&nbsp; If the cell contains text, it'll right-pad it with spaces; =
if a=20
number, it left-pads it with zeroes.&nbsp; If the cell has more =
characters than=20
the&nbsp;specified field size, it lops it off, unless it's a number, in =
which=20
case it says "Error."&nbsp; </FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Then you save it using the Text Write Program at <A=20
href=3D"http://www.smokeylake.com/excel">www.smokeylake.com/excel</A>, =
specifying=20
no field delimiter.&nbsp; </FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>The formula looks like this</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>=3DIF(ISTEXT(Data!A1), LEFT(Data!A1,FldLen!A$1) =
&amp; REPT(" ",=20
MAX(0, FldLen!A$1 - LEN(Data!A1))),&nbsp; REPT("0", MAX(0, FldLen!A$1 -=20
LEN(Data!A1))) &amp; IF(LEN(Data!A1)&lt;=3DFldLen!A$1, Data!A1,=20
"~~~Err~~~"))</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Your sheet is named "Data" and there's a sheet =
called FldLen=20
that has the field lengths you want for each column in the first =
row.&nbsp;=20
</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I had a better one, but it was on the F drive of my =
old=20
machine, I think.&nbsp; That drive quit working.&nbsp; =
&nbsp;</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>My "encoded" (wink wink) address is below.&nbsp; =
Don't mention=20
it in any posts -- the spammers would pick it up, and then I'd have to =
send my=20
boys to your place. </FONT></DIV>
<DIV>-- <BR>Earl Kiosterud<BR>mvpearl omitthisword at verizon period=20
net<BR>-------------------------------------------<BR>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"WF" &lt;<A=20
  href=3D"mailto:someone@microsoft.com">someone@microsoft.com</A>&gt; =
wrote in=20
  message <A=20
  =
href=3D"news:mtQWc.5913$T52.754@newssvr24.news.prodigy.com">news:mtQWc.59=
13$T52.754@newssvr24.news.prodigy.com</A>...</DIV>
  <DIV><FONT face=3DArial size=3D2>I am trying to build a fixed width =
file In Excel=20
  to import into another program.&nbsp; The records are 252 (not sure =
what to=20
  call it) bits? of information long, in several fields.&nbsp; When I =
build a=20
  couple of records for testing according to the file specs from the =
program, I=20
  am saving the file&nbsp;as an Excel&nbsp;"space delimited" .PRN file =
using=20
  Courier font. So far, so good.&nbsp; However, when I open the file to =
check it=20
  using Notebook I see that the record&nbsp;has "wrapped" into two =
lines.&nbsp;=20
  I open a similar file that was downloaded and created from an AS/400 =
(using=20
  Notebook) and the file does not wrap.&nbsp; The test file that I am =
loading=20
  into the program is not being successfully applied.&nbsp; My guess is =
that the=20
  "wrapping" of the record is the cause.</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Would anyone know what I might do to =
save=20
  this&nbsp;record in an Excel spreadsheet without =
wrappping?</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>I sincerely appreciate anyone's help =
on this=20
  problem.</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Thank&nbsp;you,</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial=20
size=3D2>WF</FONT>&nbsp;&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0048_01C48A3A.08094CE0--

0
nothanks4548 (968)
8/25/2004 4:25:32 AM
Earl,

Thank you for your generoursity.  I'll be in touch.

WF
"Earl Kiosterud" <nothanks@nospam.com> wrote in message
news:elulSuliEHA.704@TK2MSFTNGP12.phx.gbl...
WF,

I can send you a workbook with formulas that will make a mirror of your
sheet, properly padded to the field sizes you specify for each column.  If
the cell contains text, it'll right-pad it with spaces; if a number, it
left-pads it with zeroes.  If the cell has more characters than the
specified field size, it lops it off, unless it's a number, in which case it
says "Error."

Then you save it using the Text Write Program at www.smokeylake.com/excel,
specifying no field delimiter.

The formula looks like this

=IF(ISTEXT(Data!A1), LEFT(Data!A1,FldLen!A$1) & REPT(" ", MAX(0,
FldLen!A$1 - LEN(Data!A1))),  REPT("0", MAX(0, FldLen!A$1 - LEN(Data!A1))) &
IF(LEN(Data!A1)<=FldLen!A$1, Data!A1, "~~~Err~~~"))

Your sheet is named "Data" and there's a sheet called FldLen that has the
field lengths you want for each column in the first row.

I had a better one, but it was on the F drive of my old machine, I think.
That drive quit working.

My "encoded" (wink wink) address is below.  Don't mention it in any posts -- 
the spammers would pick it up, and then I'd have to send my boys to your
place.
-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"WF" <someone@microsoft.com> wrote in message
news:mtQWc.5913$T52.754@newssvr24.news.prodigy.com...
I am trying to build a fixed width file In Excel to import into another
program.  The records are 252 (not sure what to call it) bits? of
information long, in several fields.  When I build a couple of records for
testing according to the file specs from the program, I am saving the file
as an Excel "space delimited" .PRN file using Courier font. So far, so good.
However, when I open the file to check it using Notebook I see that the
record has "wrapped" into two lines.  I open a similar file that was
downloaded and created from an AS/400 (using Notebook) and the file does not
wrap.  The test file that I am loading into the program is not being
successfully applied.  My guess is that the "wrapping" of the record is the
cause.

Would anyone know what I might do to save this record in an Excel
spreadsheet without wrappping?

I sincerely appreciate anyone's help on this problem.

Thank you,

WF


0
someone913 (592)
8/25/2004 12:32:59 PM
You might want to make sure that wordwrap is not being set when viewing your
file.

"WF" <someone@microsoft.com> wrote in message
news:mtQWc.5913$T52.754@newssvr24.news.prodigy.com...
I am trying to build a fixed width file In Excel to import into another
program.  The records are 252 (not sure what to call it) bits? of
information long, in several fields.  When I build a couple of records for
testing according to the file specs from the program, I am saving the file
as an Excel "space delimited" .PRN file using Courier font. So far, so good.
However, when I open the file to check it using Notebook I see that the
record has "wrapped" into two lines.  I open a similar file that was
downloaded and created from an AS/400 (using Notebook) and the file does not
wrap.  The test file that I am loading into the program is not being
successfully applied.  My guess is that the "wrapping" of the record is the
cause.

Would anyone know what I might do to save this record in an Excel
spreadsheet without wrappping?

I sincerely appreciate anyone's help on this problem.

Thank you,

WF


0
8/25/2004 11:54:24 PM
Reply:

Similar Artilces:

importing bills/deposits calandar from Money 99 into Money 2004
For unknown reason, the conversion from 99 to 2004 Deluxe didn't go without a glich and I am importing data. Can do this for accounts and portfolios, but need help on importing the "scheduled" bills and deposits, without keying in each one separtately. Appreciate any help on this. In microsoft.public.money, bobs wrote: >For unknown reason, the conversion from 99 to 2004 Deluxe >didn't go without a glich and I am importing data. Can do >this for accounts and portfolios, but need help on >importing the "scheduled" bills and deposits, without &...

Importing web objects (?)
Hi, does anyone know if its possible to import a web chart in Excel (i.e. a web query). For example I would like in import one of the Google Finance charts to show up in excel. Google provides a link, but I can't see an easy way to implement this. Any help/suggestions would be greatly appreciated. Nelson On Jan 24, 9:28=A0am, Nelson <bni...@gmail.com> wrote: > Hi, does anyone know if its possible to import a web chart in Excel > (i.e. a web query). For example I would like in import one of the > Google Finance charts to show up in excel. > > Google provides a link, ...

Missing file
I'm getting an error message telling me I'm missing C:\Windows\system 32\mshtml.hlp. How can I get a copy of the file? The message appears whenever I try to save a picture from a newsgroup. Jeff -- "Never attribute to malice that which is adequately explained by stupidity." Richard Feynman Nobel Prize Physicist IE version? Jeff Stanton wrote: > I'm getting an error message telling me I'm missing C:\Windows\system > 32\mshtml.hlp. How can I get a copy of the file? The message appears > whenever I try to save a picture from a newsgrou...

Fix Publisher printing failure
I hope the deficiency in Publisher 2003, referred to in the following exchange of posts, will be remedied promptly. Or is it just a turf war between Microsoft and HP, conducted at both your customers' expense?? Br. Giovanni The text of the earlier posts follows: #1: I am trying to print a brochure with a four-way bleed. I set up for borderless printing on glossy brochure paper, but the program keeps defaulting to regular 8.5X11" letter paper and leaving a 3/4" white border. In 'page setup' under printer properties, I call for 8.5X11" borderless paper size, bor...

Style not importing correctly from template
I am using Word 2007. I am working on "Document A", and I want to import all styles from "Template 1." So, I follow these steps: 1. On Developer tab, click Document Template. 2. On Templates and Add-ins window, click Organizer. 3. On Organizer tab, I close the Normal.dot template on the source side. 4. I make sure the document name is showing on the target side. 5. I copy ALL the styles from Template 1 to Document A. When I open Document A, it does not retain all of the formatting details of the styles in Template 1. For example, Heading 3 does not come...

Excel file takes a long time to save
I have a 1,000 x 15 straight worksheet with no formulas - about 100K. I went to auto-format a pattern, but didn't select the area and if formatted the entire spreadsheet. It's since gone from 5 seconds to 60 seconds per save and I can't reverse this, even by changing the auto-format setting to "none." I'm backed-up, but the current version is about three hours ahead and it will take longer to retrace the work by hand. Any suggestions? Thanks, Ben Try resetting the last used cell. Debra Dalgleish has some techniques at: http://www.contextures.com/xlfaqApp.html#Un...

Autocomplete File Editor for NK2 file
Whew, At first I started writing to each person with a problem about this utility that I found to open and edit the NK2 file. I didn't know there would be so many so I thought I'd post this. The utility is called Owtlook File Editor It can be found at www.dcs-imaging.com/products.htm Good luck ...

Importing distribution list.
Hi, Hopefully have a quick easy question... One of our users has created a distribution list within Outlook 2007 with 80 odd external e-mail addresses. They now have asked us to move the distribution list from her outlook contact into the GAL. How do i do this without having to manually create a new distribution list and manually add each e-mail address. PS. we are running Exchange 2007 Thanks for any help For5six "For5six" <for5six@googlemail.com> wrote in message news:d3d8c245-010d-4e8a-bf55-5904579ae839@g1g2000vbr.googlegroups.com... > One of our us...

save only filtered results to csv/txt file
Excel 2000, Win98SE. I need to filter an xls file and then save only what is shown to a csv/txt file. The master xls file has new data added in a single import each day. Then I will have to filter the file 2 or 3 ways and save the filtered results to seperate csv/txt files, so I need to streamline the process. Also is there a means, comparable to scenarios, that I can use to set up different filtering combinations and then easily switch between them? Suggestions welcome. Thanks. -- Igor Igor You should be able to copy and paste the data to a new workbook and save that. Alternative...

How keep chart-datapoints displayed when column-width is set to zero
Hello there, my data basis for a chart has one column, that I don't want to be shown in the spreadsheet. However, when I set this column's width to zero, the correspondig data dissapear from the chart. How can I have both, a hidden column and its values shown in the chart at the same time ? Kind regards, H.G. Lamy H.G. - Select the chart, then select Options from the Tools menu, click on the Chart tab, and UNcheck the Plot Visible Cells Only checkbox. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ hglamy wrote: &...

import pdf table
What is the best way to inmport a table in a pdf document into excel? Check out: http://www.library.mcgill.ca/edrs/services/publications/how to/PDFtoXLS/PDFtoExcel.html#basicexports HTH Jason Atlanta, GA >-----Original Message----- >What is the best way to inmport a table in a pdf document >into excel? >. > Those directions are for university students that have Adobe Acrobat installed (not just the reader). Though there is a reference immediately above that does refer to the acrobat reader Most people do not have the full Adobe Acrobat software. With just the Acrob...

Excell2003 (SP-1) File > Save and File > Save As.. grayed out
Got a user who has Excell2003 and cannot File > Save or File > Save As... He can, however, ctrl-s to save spreadsheets. Any ideas? I"m clueless. JM ...

Microsoft File Password Recovery
Hi All A friend and I at work have a file that we cannot open because it was password protected and we can't remember the password. Is someone able to recommend some free file open password breaker software? Otherwise, could I send the file to someone to open the file? For clarity, it is not within the excel worksheet or workbook, it is a password to open the excel file! With thanks Nick well if it was a workbook/sheet password, i'd say www.straxx.com as it' a free password add-in, very effective too. but if it's not one o those passwords, what is it? external? v...

Multi-User Excel File on a Network Drive
How can I make an Excel file accessible to multiple users concurrently? With all able to make and save changes to the same file. Thanks, Mike "Mike" wrote > How can I make an Excel file accessible to multiple > users concurrently? With all able to make and save > changes to the same file. Tools / Share Workbook Jordon ...

How do I Insert 2C Mac EPS file into Publisher ?
In commercial printing we get a lot of logo's and other art that is created as a Mac EPS and I cannot seem to insert it into Publisher. What are the correct steps for doing this and for it to display. According to Pub 2003, you need a graphics filter to insert .eps files. The following is copied directly from the Help file: The Encapsulated PostScript (EPS) graphics filter (Epsimp32.flt) supports the Adobe Systems Encapsulated PostScript Specification versions 3.0 and earlier. The filter supports .eps images from Tagged Image File Format (.tif, .tiff) (Tagged Image File Format (TIF...

Multiple database files created
I have an Access 2007 database that resides on our company's server. The database tracks incoming and outgoing shipments and is used by several employees throughout the day. I've noticed that in the folder where the database resides several additional database files are created throughout the day with names like database.mdb, database1.mdb, database2.mdb, etc. Can anyone tell me why this is happening? The database was created with Access 2007 using the 2003 mdb file format, as most of the end users have Office 2003 applications. Ken Warthen kenwarthen@gmail.com 1. Turn off...

Public Folder File sizes
Hi We have a system whereby files from our students are routed to a public folder, so that everyone in the office can see them. However some of our more unenlightened students seem to be trying to send in emails with 9Mb attachments. (AGHHHH) The odd thing is that if they send them to a persobal mailbox, they seem to get thropugh, but if theu send them to a public folder, Exchange cant handle them, or at least we can see them being received, but then they are not delivered to the public folder. Is there something i need to do to get round this please? Thanks A Do you have Maximu...

my file still exists but is blank please help
I had a virus completely delete a file in my microsoft word 2000. It's old and I don't know what to do. The file name is still there but the text is blank, and I've tried several recovery progrms that haven't retrived it. Was hoping someone knew if word has its own back to retrieve things from and how to use it If the contents have been overwritten (and it certainly seems as if that is the case), there isn't anything you can do, I'm afraid. -- Stefan Blom Microsoft Word MVP "hanna" <hanna@discussions.microsoft.com> wrote in messa...

Compress an Excel File
I have an excel file that is 36 meg. Do you know how to compress the file? When I zip the file it drops to 3meg so I know it can be compressed. I beleive the file has become large due to the constent changes I need to make to the file. Help Please. Hi Mandy Maybe this will help? http://www.contextures.com/xlfaqApp.html#Unused You can use Rob Bovey's Code cleaner to clean up your code http://www.appspro.com/utilities/utilities.asp -- Regards Ron de Bruin http://www.rondebruin.nl "Mandy" <mangelo@arbys.com> wrote in message news:42c401c47fa1$ddc405d0$a401280a@...

cannot install outlook from outlook express (import stalls)
trying to convert from express but installation fails from start. other office features do function ie excel and word In news:E167009C-F5CD-4D0F-B08B-217C0FFE3E78@microsoft.com, outlook fails to install <outlook fails to install@discussions.microsoft.com> typed: > trying to convert from express but installation fails from start. > other office features do function ie excel and word Install and configure Outlook on this computer. Then, launch OE and *export* from there to Outlook.....do not *import*. ...

Help with econnect trying to create a contract for GP
Hi all, I am trying to use the serializer and create a contract/project and budget line items, i was wondering if anyone has some examples. When i use the serializer with contract, it drops off the pstat value in the xml document and then recive the error that a variable is empty. Thanks all ...

Closing multiple files independantly
When I have 2 seperate excel files open...and I click on the red 'x' on the top right on one of the files...both files close. How can I get it to only close the 1 file I'm clicking on? Thanks, Frank. Hi Frank, Look just below the red X; the three symbols (miminize, restore and close) are repeated but in a simpler format. These control a workbook while the top one control the Excel application. If you ever want to close all the file but leave Excel open, hold down Shift and open the File menu - look for a new item "Close All". Bernard "Frank DAlessandro" ...

Tidying up Office Data Files
My Office Data files are in a mess. I have discovered that I have Outlook (approx 0.8GB) and Outlook1 (approx 0.8GB) Mailbox (32KB) and Archive (0.35GB). I created Archive some time ago but have not archived recently. I don't know why I have 2 Outlook files - possibly created when I transferred data to a new laptop a few weeks ago. I would like to re-combine everything into 1 file so that I can start again and set up a proper Archive system again. How can I do this without risking losing files or creating duplicates or triplicates. As you will note the files are very big! Any h...

Opening a a a file handle as a file pointer
Hi all I have a file handle. I want to open it as a FILE stream so that I can use higher level operators like cin/cout and fprintf/fscanf. Can someone suggest me a solution? Obviously the process startup code converts the file descriptor is receives from parent for stdin,stdout and stderr. So there should be a function to do it. regards, Sudhakar "sudhakarg79" <sudhakarg79@discussions.microsoft.com> wrote in message news:ECF7527B-A036-48EF-B2FB-CA8985330D3E@microsoft.com... > > Hi all > > I have a file handle. I want to open it as a FILE stream so...

quotation marks after import
I imported my contacts from outlook 2003 into entourage. After import, the data under each field name has "quotation marks" . Is there something I missed in the mapping, etc.? You didn't do anything wrong. This is an unfortunate annoying side-effect of directly transferring information from Outlook into Entourage. Paul Berkowitz's "Export-Import Entourage" script set will transfer data between Outlook & Entourage, taking care of these issues. <http://www.scriptbuilders.net/> On 12/27/05 6:02 PM, in article 1135728164.100437.84780@g43g2000cwa.googlegro...