manipulated a data file in excel
Is there any way to have a button in excel where when I click on it, i
will let me choose a data file (by pointing and clicking) that's comm
delimited and I can simply sum up an array of numbers and import tha
sum into a cell? I don't want to put the text file into th
spreadsheet, but rather just sum of the numers I want into a specifi
skinnydude's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1627
View this thread: http://www.excelforum.com/showthread.php...Mail Messages HTML Viewing
I am using win XP and Office 2002. When I receive
messages with html format i can only see the url's and
not the pictures. I have checked all the settings, I
have the box in options/mail format/internet
settings/html format checked to receive pictures and
still just the url. I runn norton and zone alarm but
can't see any settings in these that would restrict the
downloading of pictures. Any thoughts?
What are your IE settings?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual...MDBDATA files
I have a lot of files beginning with E000001-E0000F07
using 25GB of disk space. Yes I need to free up some disk
space. I have read article Q151214 but Im not sure if it
is ok to delete because I don't see the other log files
that are mentioned. Like (Edb.log),(Edb00000.log),
(Dlv.log),(Snd.log),(Dlvxxxx.log) or (Sndxxxx.log).
If you have any information that may help please email me.
Does your backup not work?
How about running an Exchange aware backup which will clear the logs for
"DBraswell (MDBDATA) @2si.com" <anonymous@dis...input a comma after 2 digits
i have for example this column in Access
and I want to put a comma after the first 2 digits
and look like this. I dont mind creating a new column
Bear in mind that the number 439965 needs its comma after 3 digits, where
23112 needs a comma after 2 ...
Now, if those aren't really NUMBERS (things you do math on), but just
characters that happen to be digits, that's a different matter.
You can check Access HELP for the use of the Left() and Mid() functions to
grab the first two charac...possible to show an XML file using CHTML?
I have a XML file, and it uses XSL to parse it to HTML. That XSL file
I just want to know if CHTML would be able to display the XML file and
parse it usign XSL just like internet explorer does?
Is CHTML basically an "IE plugin" that we use in MFC? If so then I'd
assume it would work.
I just want to make sure....
You can use CHtmlView to display it.
Or you can use the IWebBrowser control.
"Kourosh" <email@example.com> wrote in message
news:1147717929.593067.319000@v4...Files and Folders in C:\Windows
I'm trying to conserve space on a small HD on a laptop, and would like to
know if I can remove the following files and directories.
1) Numerous files and folders in C:\WINDOWS with various names that have
modified dates going back to the
installation date of XP.
2) There are numerous files and folders in the
'C:\WINDOWS\SoftwareDistribution\Download\' directory with long
alphanumeric names ( examples are shown below)
C:...I get a file in use message telling me that the file is locked ?
This is a one user computer and the file is not being used. The box
containing the error message says "FILE IN USE". If I reboot I can get into
the file once only before having the same error message. I have tried saving
the file under a different file name but that file acts the same. I have
checked permisions and that is not the problem either .....HELP!
...can't open file #2
I created publisher 2000 files on a windows98 SE COMPUTER. I saved the files
to disk. Just got a new Vista computer. I installed the publisher 2000 on the
new computer. The disk shows the files but publisher says it cannot open
them. Any hints?
artisan lampwork beads and jewelry
Try copying the saved files from the disk to the hard drive on your new
computer and opening them from there.
> I created publisher 2000 files on a windows98 SE COMPUTER. I saved the files
> to disk. Just got a new Vis...the webpage you are viewing is trying to close the window
We have an internal web interface for our helpdesk system. When we finish
working with a "call" it attempts to unlock the call and we get the message
as above. More often than not, we need to say YES to the message. Any ideas
how to get it to not appear?
Which security zone does the page/popup load into?
Hint: Is IE configured to automatically detect sites in the Intranet zone?
What 'call' software are you using? Have you attempted to contact the
"Keithmeister" <Keithmeister@discussions.microsoft.co...Migrate PST file
re: Outlook 2003
I realize the topic has probably been covered ad nausium but I still can't
find out how to solve this problem. Any help that can be given would be
greatly appreciated. I have just bought a new computer (Vista) I installed
Office 2003. I chose File/Open/Outlook Data File and pointed to the pst
file that was on the old computer. Outlook imported everything into a
separate "Personal Folders" list. I want the information all in the main
Personal Folders. How do I do this? Also because I've been transferring
the old pst folder to the new computer I ...Using Access Reports in other EXE file
I'd like to use access reports from any access version XP, 2000 or 97;
because of the easy way to build such reports.
Have you ever found or built any solutions permitting to reuse such access
reports objects in other exe files, developped in Visual Basic, Visual
Studio or even Delphi....
Thanks a lot for your suggestions
Most programming languages support launching an executable, so the Snapshot
Viewer executable would be a good choice for viewing reports exported from
Access as Snapshot (*.SNP) files. Access would not need to be installed on
the computer in order to view ...m_pDocument Doc/View unique id for each view
I'm using the standard mfc mainform with a doc/view. While I'm in the
view portion I need to track the actions taken individually and
separately for each view. So when when I click on view one I track
that in a separate place than view two.
I there a unique id or index for each view? Something like
<firstname.lastname@example.org> wrote in message
> I'm using the standard mfc mainform with a doc/view. While I'm in the
> view portion I need to track the actions taken...File:// Linking...
Why is it that when you link something in Outlook with file:// when clicking
on the link it returns the error
"Cannot find the file 'file://Q:\blahblahblah' (or one of its components).
Make sure the path and filename are correct and that all required libraries
"Cannot find the file "Q:\blahblahblah'. Make sure the path or Internet
address is correct."
It used to work before any service releases to Outlook 2000 were applied.
There are typically no spaces in the filename and if they are I usually
replace th...Using custom document peroperties to creat views in Public Folders
How do I use custom document properties to create views in public folders? I
came across an article for Outlook 2000. I tried doing this for Outlook 2007
but I am unable to. Please assist.
The article I came across was
http://office.microsoft.com/en-us/publisher/HA010549541033.aspx However this
only appears to work for 2000 not 2007. Hopefully someone can help.
> How do I use custom document properties to create views in public folders? I
> came across an article for Outlook 2000. I tried doing this for Outlook 2007
> but I am unable t...View Webpage
How can i view a HTML page in Excel, it should also be automatically update
in 60 seconds. Is this possible?
Please note that, that page contains images
That webpage is on our intranet website.
Though I am not certain this is exactly what you are looking for, try the
Data, Import External Data, then New Web Query...
In the dialog box that appears, browse the site. You will notice that at
certain areas of the page you will see an arrow. Just click the ones that
you want to import. Click import. Select the cell you want to import the
data into and click OK.
Hope...How to add a configuration file to a MFC project?
hi, I want to add a configuration file to a MFC project ,how an i get that?
and I have a command like the following line:
copy app.config $(ConfigurationName)\$(TargetFileName).config
Where do I need to put?
Any ideas would be appreciated!
Yes, I already know how to do it,thanks a lot!
"Ajay Kalra" <email@example.com> д����Ϣ����:%23ymi%23P%23yGHA.4176@TK2MSFTNGP06.phx.gbl...
> What does it mean? Do you want to perform copying as part of build
> In VS, you can do so in Pre-Build, Pre-Link and Post-Build steps. You can
> specify the...Cannot see public Folders #2
I am using Exchange 2003 on Windows 2003 and unable to view the Public
Folders, can anyone specify what all rights need to be given in order
that I can view the Public Folders.
Thanks and Regards,
...Emailing a worksheet #2
Using Excel 2003, every time I email a worksheet (by clicking on the "Email"
icon ) the receipant losses all the formating and makes it impossible to
decifer. I want the receipant, who may not have Excel loaded, to see the
actual worksheet (including lines/boxes) in the body of the email itself. Is
there any way?
...Forms in two differant views
Is there a way to use the same sub form showing two differant views within
the same Main Form. For example: Can I show on one tab a datasheet view and
on the other a regular form view.
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox
If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Me.DefaultView = 0 'Single Form
This should flick the form between datasheet and form views.
> Is there a way to use t...[ANN] Office 2004 update 11.2.3
The Office 11.2.3 update is out :-)
Time to update... You can either grab it thorough the link I gave (but
it goes over several lines which is sometimes a pain) or use the Check
for updates command in the Help menu of any Office app.
The update is available in multiple languages. The release notes on the
page I cited are rather extensive,
--- Mac:MS MVP (Francophone) ...Default dictionary #2
I use Outlook at work and I have set the default dictionary to English
UK but invariably it reverts to English USA and I have to manually make
it UK again. Can anyone tell me what I'm doing wrong and what I need to
do to make it stay as UK. The default editor is Word and I wonder if
that is the problem as in there is a setting for Default Language but
that seems to still hold USA instead of UK so I think this is where my
problem lies. I don't have the same problem on my laptop at home, the
default for Word stays as UK but I use OE for email.
Please remove spamtrap if replyi...Forcing a view to be the active view
I have an SDI application that has a splitter window with two views. The
first view is an CFormView and the second is a CView. I want the CFormView
to always be the Active view. Even if the user selects the CView.
How do I accomplish this?
Anders Eriksson wrote:
> I have an SDI application that has a splitter window with two views. The
> first view is an CFormView and the second is a CView. I want the CFormView
> to always be the Active view. Even if the user selects the CView.
> How do I accomplish this?
> // Anders
I'd ...OL98 start up view
I recently had to reinstall my WInXP and now my OL98 has a couple of
issues I'd like to fix.
I've set up my mail account (with POP3 and SMTP servers) but when I
try to use it I get a message saying that internet mail is not
registered properly. What do I need to do to fix this?
Also, I used to start up OL98 so that the first view was not Outlook
Today. How do I change that?
I guess I can't remember how to do things that I only do once every
Thanks for any suggestions!
You might want to have a look at this MS KB ...restrict file sync
Using Windows Home Server with an HP MediaServer and I've got two minor
1. The Server Console says I need to update the HP media collector software
on the client side but the client seems up to day (all HP updates are done)
2. I want to restrict the Media Collector to a certain file (F:/pictures)
but it will only specify which drives to sync (e.g. all of F:). I can't seem
to expand the drop menu in the mediacollector window beyond the root
Hi, this is the media center newsgroup, not the media collector group. You need
to repost in an H...Can't open more than one Excel file.
I'm using Excel 2002, W2k with all recent patches. When
I'm working on an Excel worksheet and I attempt to open
another Excel file the first one is closed when the second
one is opened. What do I do to retain the first one open?
Are you sure the first one is closed or just taken off the Taskbar?
If you go to Window(on the menu) do you see one or more files listed?
You may just need to go to Tools>Options>View and check "windows in taskbar".
Gord Dibben Excel MVP
On Fri, 30 Jul 2004 08:17:44 -0700, "Eppie"