Importing into Excel from a Text file
We have a text database of about 7,000 rings. It is in a fixed format.
Unfortunately some where we have about 4 or five rings whose format is
screwed up. We figured by importing to Excel, we should be able to find
where the records are to fix them. But, we just can't get the following
format to import into excel. If anyone can help us, we sure would appreciate
Each record begins with Begin Product
Each record endswith EndProduct
a semicolin seperates each record
Also there are para symbols at the end of every line
Herer are a...hyperlink to existing excel file
When I create a hyperlink to an existing excel file and then click on it,
explorer opens to the folder that the file is in instead of the excel file
opening. Just to test I pointed it to a word document and the doc file
opened fine. How do I get a hyperlink to open the excel file? Thanks.
Are you sure it isn't to the folder instead. Only way I can reproduce that
is if I select the folder instead of the file when I create the hyperlink.
As expected if I use a hyperlink to a particular file it will open..
"purplehaz" <firstname.lastname@example.org> wrote i...Removing characters from cell
Hope someone can help me with this one....
I have text in column "A" a list of parts like the following.....
Is thier anyway of removing the dots in front the part number?
I dont want the points moving after the the main part of the number.
Do you part numbers all start with nhg?
If yes, you could select column A
And keep hitting the replace all button until all are fixed.
> Hope someone can help me with this one....
>...C# Net GridView LinkButton open a new page
In my C# .Net framework 2.0 web application, I have a GridView which has the
I would like to have the click event for the LinkButton then it will open a
new web page( not redirect).
...Save for Web (.htm) file
I have two similarly structured XLS file. One file "A" is much
longer...perhaps 2000 rows long...when saved as a htm file it is around
500KB. I take another XLS spreadsheet that looks like the same
structure...rows and colums...only about 560 rows...when I save this as
webpage .htm it ends up being 11.2MB. What the heck happened? How do I get
it down in size. There is no apparent reason why a smaller file ends up
being 11 time larger that the smaller file when saved!
...Unable to open Windows XP
When I try to open my Virtual PC Windows XP on my Powerbook G4 it
comes up with an error that Windows could not open successfully. I try
to open it in safe mode and all of the other options available and it
still comes up that I am unable to open Windows. Any ideas how to fix
this or what the problem is?
You'll probably get faster & more thorough assistance if you post to
But they'll need much more specific information about VPC & OS X versions,
update levels, etc.
On 9/19/07 11:55 PM, in article
11...point exchange to a different priv1.edb file
I have a snapshot of my priv1.edb file on a different drive. I know that
exchange 2003 lets us me the priv1.edb file to a different location if the
file isn't already there.
Is there a way to have exchange point to a different priv1.edb and use it?
On Thu, 5 Oct 2006 21:31:01 -0700, Han <Han@discussions.microsoft.com>
>I have a snapshot of my priv1.edb file on a different drive. I know that
>exchange 2003 lets us me the priv1.edb file to a different location if the
>file isn't already there.
>Is there a way to have exchange point to a differ...External Link-help!
Hi there, I am trying to get rid of an external link to
my excel spreadsheet that I created. When I email the
excel file to a coworker, the file asks to update links.
But, I want to get rid of all the links so that when
others open it, the message will not come up. Under the
Edit menu, the Links option is not highlighted. Somehow,
the external link got embedded into the file, and I need
a solution to delete it out. My job is depending on this
I could really use some help!
Try Bill Manville's addin. It'll find those pesky ones.
Findlink.zip ...!!HELP!! OWA ans Outlook do not synch
OK so I rebuilt my SBS 2003 server and used Exmerge to exmerge all my users
mailboxes out. Successfully exmerged them back into Exchange. Had to
recreate new profiles on the users workstations but all appears to be good.
One slight problem. For my external users who use Citrix and log onto the
Citrix server desktop they cannot use Outlook there. I do have a case open
with Microsoft regarding this issue however my immediate issue to resolve is
why I can log on as a user here in the office, open Outlook and all their
mail is there. However when I use OWA the mailbox is incomplete. Does no...forgot password?please help
I FORGOT MY PASSWORD ON MY MICROSOFT MONEY 2000 BUSINESS -
PERSONAL I TRYED EVERY NAME AND NUMBER FOR 2 DAYS
> I FORGOT MY PASSWORD ON MY MICROSOFT MONEY 2000 BUSINESS -
> PERSONAL I TRYED EVERY NAME AND NUMBER FOR 2 DAYS
That's got to be VERY FRUSTRATING!
Not only that, but your CAPS LOCK KEY is stuck!
I'm sorry for you!
I have a hyperlink set-up for a netwrok file. It works fine, but when the
file is copied the hyperlin chages to the folder that the file has been
original link - L:\folder\folder\file
Changes to - C:\file
How can I get it to keep the original link?
...getting a single line from a file
I was wondering if someone could tell me how to read a single line from a
text file. I tried using getline, but my MFC program does not recognize the
getline function. Nor does it recognize <string> or <string.h> or using
namespace std. So is there another function that I can use in MFC?
Take a look at the CStdioFile MFC class.
Check Abdoul [VC++ MVP]
"R.H." <email@example.com> wrote in message
> I was wondering if someone could tell me ho...need a bit of help.....
I have generated a form that shows money amounts. yet i want two colums
that separates the dollar amount from cents. I have for example colum
*H* as the dollar amount and colum *I* as the cent amounts. Now i have
tried Format Cell to set it up but it doesnt work. for example i tried
the custom format for the dollar amount and it rounds it. and if
there's an amount of 1108.83 the cell will show 1109. so it does not
show the true value amount. i also tried the same approach with the
=RIGHT(H1,2) but with the left and Mid but still didnt work, because i
would have to enter the same amount o...Help! page range prob in print
I worked on print.Everythings working perfectly except
one problem.ie. When i set the PageRange option to 'ALL'
option and press print button..instead of displaying only
the pages which has information ..its displaying that all
pages from 1 to 65535 r going to be printed.
How do i remove this problem?
I thing you may failed to set the maximum number of pages to print.
Check CPrintInfo::SetMaxPage(nMaxPage); method
FIGHT BACK AGAINST SPAM!
Download Spam Inspecto...MSP 2007 resources help
1. What the constraint A<B,C means and how can I entering in the MSP?
2. I have 3 kinds of human resources. Lets say for example, kind A are
engineers. I have 8 of them and everyone is costing 1500 Euros/month. Task A
needs 4 engineers. How can I assign them to the task and add the appropriate
3. I have 3 machines as a resource. Each machine has a usage cost of 3000
euros per task and function cost 2400 euros per month. How can I assign them
in the appropriate tasks? And how can I distribute their cost?
Thank you in advance
How can I add or remove link from “My Work” under workplace, like Calendar
And where the file sitelog.xml??
I have a client that overwrote an excel sheet. He did not
have autorecovery on. Is there any way to recover this
johnf202 at hotmail dot com
"mark" <firstname.lastname@example.org> wrote in message
> I have a client that overwrote an excel sheet. He did not
> have autorecovery on. Is there any way to recover this
Backup file is pretty much his only option if one exists. Has he perhaps sent the file anywhere
else that he can get a copy back from, or if so he could possibly still have a ...File Size #4
Using Windows XP and Office 2007
Is there a reason that Publisher files keep growing in size? We have a
weekly bulletin with some static information and some information that
changes from week to week.
On Monday, we open last week's publication, delete the no-longer-relavent
text boxes and pictures, and add new text boxes and pictures for the current
week. That has been our standard practice. I just noticed that the file
size is increasing exponentially which leads me to believe that even though
I delete things, there is still some sort of "ghost" material left in the...Preventing Excel files from being moved or deleted
What permissions setting is used to prevent users from moving or deleting an
Excel file on a network?
This is more of an network operating system setting question.
I would think putting the file on a share that the users only had readonly
access would be enough.
But this would mean that the users could still copy (not move) the file.
And they wouldn't be able to update the workbook.
> What permissions setting is used to prevent users from moving or deleting an
> Excel file on a network?
All explained in Start>Help and Support "p...How to open a msg attachment?
Someone sent me a msg attachment and I am trying to open it. When I open it
all I get is a blank message. This supposed is to be a distribution list
and I am using Office 2003.
Any ideas, Thanks.
Ask the sender to resend, this time creating the message in rich-text =
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"SA&qu...Windows Easy Transfer won't load files?
I ran Windows Easy Transfer on my laptop with Windows 7 RC1 to save and move
my profile data because Win 7 RC is shutting down. I am trying to install the
Windows Easy Tranfer data to Windows Vista Business. Each time I try it won't
read the file but keep asking for the drive with the data to be loaded. I
tried a test by moving the the data (.MIG) files out of the folder I saved
them to and put them in the root of the drive but that didn't help. I tried a
test of copying the files to the root of C: and now it actually sees the file
for the short test at home I trying in t...Can't open some mail after upgrade
We upgraded our server to Exchange 2003. After the
upgrade our clients using Windows 2000 and Outlook 2000
do not seem to be able to open mail that has been
forwarded more than once and contains attachments. I can
forward the same piece of mail to someone using an
Outlook 2003 client and they can open it, but the client
using Outlook 2000 cannot view the mail, preview the
mail, forward the mail or even see or save the
attacment. The error is: "Can't open this item. Could
not complet the operation because the service provider
does not support it."
Any help...publisher 97 won't import a file graph of acceptable quality.
To MSFT: Let me try this again. I have Pub 97 that I must use
for writing a manual. I try to import a black and white graphic-a chart,
in jpeg or gif or whatever,but the graphic is of such poor quality that it
can not be used. This only happens in my Publisher program. I have tried to
change the adapter accerleration reading, but it does not help. Does anyone
else have this problem with the older version of Pub 97? Do you have this
problem with later versions of Publisher? Any ideas are appeciated.
Check your graphics filters. Might have some corruption going on.
They are in a folder sim...List of File Extensions
Is there a list somewhere that contains the file extensions used in Office
2003 applications? I need to backup files before re-installing my OS. These
include files that store settings, customizations, macros, Outlook address
...Making Design Gallery Objects available to other files in publishe
I created some custom objects and saved them to the Design Gallery, and they
did appear under My Objects. However, I saved the file and opened up a new
one and to my shock My Objects was empty. I opened the earlier file where I
created and saved the objects and they were still there.
Does this mean that the Design Gallery if file-specific and not saved in a
Publisher Application file for use in other .pub files? Perhaps that is the
default setting that can be changed later.
Please help me on this matter.
Thank you in advance for your support.