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" <email@example.com> wrote i...Why does [group] appear after the filename in Excel 2003?
I upgraded from Office 2000 to Office 2003 this morning. An Excel document I
created yesterday in a shared network location that has never been touched by
anyone but me is now opening with [Group] status. I need to activate
Autofilter, but it is unavailable (greyed) on the Tools --> Filter menu. I
also can't locate a definition for this setting or how to turn it off, nor do
I have any idea why it is in this "group" mode. It is definitely not a
You may have more than one sheets selected simoultaneously. Righclick a
sheet tab and select ...Show Excel in two separate instances/two monitors?
I've recently been upgraded to two monitors (one of the few things IT
has done right around here!). But try as I might, I can't get two
Excel (2003) workbooks to show in two separate instances so I can put
one on each monitor! Any solutions?
open 2 workbooks -- click the Maximize button (so you are in resize
mode) --- drag a workbook by the titlebar to the second monitor...
(: have an awesome day :)
Remote Programming and Training
strive4peace2006 at yahoo.com
> I've recently been upgraded to t...How can I asign a number value to a text line in Excel?
tI have a Backgammon Club with Internal Club Rankings that are in Text. I
want my members to report their wins - 1st, 2nd, and 3rd place - in
tournaments to my web site . I would like them to imput: their nickname, date
of tournament, tournament Room #, tournament points played for, and host of
the tournament. I would further like the calculation to display any change in
Ranking as a text cell. Additionally, I want to show for the member, how many
more points are needed to get to the next levle and what that (Text)level
is. If there is a "what if" for this please advise.
Ri...Plot area of embedded charts unexplainably shrinks in Excel 2003 S
I am working on a large spreadsheet full of numerical data. It contains
several dozen bar and line graphs embedded across several worksheets. I have
a decent understanding of Excel and Excel graphs but do not use VBA.
The problem I have with Excel is that it sometimes – and unpredictably –
(vertically) shrinks the plot areas of the embedded graphs. This can happen
between opening the document and printing it. Other times, the plot area
would shrink if I click on the plot area with my mouse, and then click off on
to a cell in the same worksheet. The chart area remains the same siz...Getting an e-mail address
I got an e-mail that was copied to Someone Else. I would like to copy that
Someone Else (including its real address link) to a Word document that I have
that has addresses and titles. So I click on that name, open up properties,
and then try to cut that e-mail address from the properties - but I can't grab a
hold of it.
So I save it in my contacts, go there, and then am able to cut and paste it then
delete it from my contacts. Am I going through these contortions
...Send/Receive doesn't get Exchange 2000 mail
Outlook 2002 Send/Receive does not get mail from the
Exchange server as expected. If you open a previous
message the mail is properly retrieved from the Exchange
2000 server. Using Outlook 2003 Send/Receive works as
It's a problem with your NAT router and UDP:
"Gene" <firstname.lastname@example.org> wrote in message
> Outlook 2002 Send/Receive does not get mail from the
> Exchange server as expected. If you open a previous
> message the ...Is there a way to setup excel to prompt for a backup copy upon ex.
I want to automatically create a backup onto a disk each time I exit program.
It depends on which version of Excel as to how.
It is also preferred that the content of you request not be typed in the
Subject field. Please take advantage of the Message area, even for short
I am currently using 2000.
> It depends on which version of Excel as to how.
> It is also preferred that the content of you request not be typed in the
> Subject field. Ple...Sounds with Excel
Is it possible and how can I do this task with ExcelXp:
If the value of cell A1 on "my worksheet" in "my
workbook" is "1"-play any sound,
If cell A1 is empty-don't play sound.
For the next cell on the same sheet B1: if B1=1- play
sound different than the sound for the cell A1, if B1 is
empty-don't play sound.
If both cells A1=1 AND B1=1 play sound different than the
sounds for cell A1 and cell B1.
I'm running WindowsXP.
have a look at
> Hello Friends...Calculating dates
A quick question before i'm off to bed :)
I got several dates, all in the future. I'll just give an example, cause
it'll be hell to explain otherwise :p
I have a date (Belgian format) 26-07-2008 (= July 26th, 2008). Now I need to
know how many days have past from 26-07-2004 untill now. So, day and month
stay the same and year needs to change to the year before the current one.
Then count the days untill the date now.
I need this to calculate accrued intrest, should someone wonder (or if that
makes it easier to understand ;) )
Preferably, a short function (if possible) since it...My forms will not work with my email when I click submit.
Sending Form Data via E-mail, it will open up my Email but, the data is NOT
contained in the body of the e-mail message. The e-mail address I entered
for the ACTION attribute shows up. BUT NOT DATA IS CONTAINED IN THE BODY.
<FORM METHOD=POST ENCTYPE="text/plain" ACTION="email@example.com">
Name: <INPUT TYPE="text" NAME="name">
<INPUT TYPE="submit" VALUE="submit button">
why is my Email NOT working anymore and adding the data to the body of the
e-mail ...getting sql report 2005 web service to work
The error I am getting in sql reporting service 2005 is 'The selected
report is not ready for viewing. The report is still being rendered or a
report snapshot is not available. (rsReportNotReady)'.
There are lots of answers on the web and I have tried alot of them including
obtaining extract space.
The error I am getting is: " The report is still being rendered or a report
snapshot is not available.
I am using using windows-authentication to the datasource, and I am
wondering if I am not setting up the pass-through properly on t...display countdown timer in Excel
I'd like to display (in Excel 2003) a countdown timer in a worksheet (either
in a cell or a textbox or other control). I want the user to be able to see
the clock tick down from say 20 seconds to 0 in one second increments (or
decrements, I guess). Is there a function that will do this? If this is
somethingVBA can handle better, I can post this question in the programming
It has to be done through VBA.
You could write code or have someone do it for you.
That someone would be Bob Phillips who has a free downlaodable workbook with a
*First off:* I have created a spreadsheet that has a dynamic range an
*Next:* i know i can add options to the 'dynamic range' and my dro
down menu will add the option to its list.
*Problem:* How can I make it so the user can add data into th
validated data list/drop down menu rather than having the user addin
it into the dynamic range?
*Example:*this drop down menu indicates how often a system is updated
weekly, monthly, etc. etc... i don't want to restrict it, so i want t
make it so they can indicate their own time on how often those update
-...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." <firstname.lastname@example.org> wrote in message
> I was wondering if someone could tell me ho...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...why is the chart displayed only when the chart area is clicked on?
We used the chart wizard to create a chart. The chart area is greyed out and
the chart is displayed only when the chart area is clicked on. We tried to
create the same chart using a new workbook and we don't have this problem.
Use the menu Tools > Options. On the View tab in the Objects section
make sure Show All is selected rather than place holders.
> We used the chart wizard to create a chart. The chart area is greyed out and
> the chart is displayed only when the chart area is clicked on. We tried to
> create the same chart using a...Excel or Access?
I have server data that is about 200-300 rows/records and includes abou
25 columns/fields. Coworkers have suggested that this data shoul
reside in a database, such as Access, and then import/link to it fro
Excel for reporting purposes.
Does anyone have a recommendation/comment/suggestion on this? I a
comfortable using Excel as my "database" for this data that will no
grow much larger than it already is, and is easier for me to perfor
the reporting in Excel simply on another sheet.
Message posted from http://www.ExcelForum.com
Why fix what's not broken? ...get sql server schema to xml?
How can I get table/column schema of a sql server database? i want to
convert the entire schema into an xml file.
thanks in advance.
You can use a DataReader's GetSchemaTable method
"suzy" <email@example.com> wrote in message
> How can I get table/column schema of a sql server database? i want to
> convert the entire schema into an xml file.
> thanks in advance.
Oops, sorry for not posting the link... you can do it with the Connection
Object as well... here's a ...Messages in sent folder automatically gets deleted periodically on IMAP account
Windows Mail v6.0.6000.16386 using IMAP on Windows Vista Home Premium
Every once a while, my email messages in my "sent" folder for some reason
gets automatically deleted. Is there a way I can prevent this from taking
Other than accessing the account via POP3 instead of IMAP, no.
> Windows Mail v6.0.6000.16386 using IMAP on Windows Vista Home Premium
> Every once a while, my email messages in my "sent" folder for some reason
> gets automatically deleted. Is there a way I can prevent this from taking
...How to get the associated application for a document
I am populating a CMainFrame menu with some document files. I want each menu
item to display the icon for the associated application. For example,
if the document is .DOC, Microsoft Word icon has to be displayed near to the
I tried a lot of things, but without success...
The last thing I tried was this:
&fi, sizeof(SHFILEINFO), SHGFI_USEFILEATTRIBUTES | SHGFI_SYSICONINDEX
int iImgNdx = m_docImgList.Add(imgShell.ExtractIcon(fi....Automatic open locked excel file through access control
We know,Excel has prompt password
to open it files.
Is it possible to create a code that can
supplies the excel prompt password?.So that when we
open the excel file through our access control in a form,
the excel files can be opened automatically.But when the
excel files opened from its default icon,it will prompt a
On Jul 10, 8:43 pm, "shiro" <s...@play.com> wrote:
> We know,Excel has prompt password
> to open it files.
> Is it possible to create a code that can
> supplies the excel prompt password?.So that when we
> open the excel file throu...What defines an advanced level of Excel?
I was wondering if somebody could help me with this. I was looking at
applying for an office assitant job and it said I needed an advanced level
of Excel. I have been using Excel for some time now, although I recently
decided to do a short course starting from the basics to help identify what
I may be missing in my knowledge.
We didn't delve into complex formulars but covered all our basics and gave
our selves the background knowledge to explor further. I am all over the
place, such as inputing data, retreiving data from sources such as SQL
server, text files and so on. Formatt...Templates for Excel 2003
Is the only way to get templates now through Office On Line rather than
a direct download that works on my PC?
I don't want anything to do with Office On Line. I don't want to have
to download 2 Active X scripts just to get a template.
I tried downloading one directly, but I got a message that indicated
that I needed the Active X crap.