Unable to open .xls file
I have Windows XP Home edition on my computer and I received an email with
some info that is an .xls extensoin. I have Windows Worksheet and wanted to
know how, if I could, look at this file? I also receive info with >pps
(powerpoint) and am unable to open these files also. ANy suggestions?
You may not have MSOffice. It's not part of Windows. It's a separate suite of
But MS does make a viewer for excel:
and one for powerpoint:
Hello all. is it possible to have mulitple tags on controls? I am attempting
to hide/show certain controls based upon a selection, and i figured out I
need more than one option.
AFAIK a control can have just one Tag, although you can change a Tag
programatically. However, there may be other ways to achieve what you want
to do, depending on the details. For instance, you could have the code look
at the first or last character in a tag, or its length, or the name of the
>Hello all. is it possible to have mulitple tags on controls? ...Old QuattroPro files
How do I open old QuattroPro files in Excel? I use Office XP
In the File>Open menu, Files of type, choose Quattro
"toridog" <email@example.com> wrote in message
> How do I open old QuattroPro files in Excel? I use Office XP
...How can I merge all my emails in outlook
How can I merge all my emails in outlook
On Fri, 9 Apr 2010 21:31:02 -0700, Gaston <Gaston@discussions.microsoft.com>
>How can I merge all my emails in outlook
Please ask in an Outlook forum. This group is for a different program,
Microsoft Access. The webpage can be confusing and may have misled you.
John W. Vinson [MVP]
"Gaston" <Gaston@discussions.microsoft.com> wrote in message
> How can I merge all my emails in outlook
...Merge Date Field
Can anybody tell me if it is possible to force a date merge field to display
the UK day/month/year format in Publisher 2003?
Its not the same as Word where you can display the field codes and force it
to show the required format.
Su <Su@discussions.microsoft.com> was very recently heard to utter:
> Can anybody tell me if it is possible to force a date merge field to
> display the UK day/month/year format in Publisher 2003?
> Its not the same as Word where you can display the field codes and
> force it to show the required format.
Is the date format s...merging the values of a field in a subreport
helloi am trying to prepare route cards for travels. I am preparing theseroute cards in an access reports. the route points, the stops oftravel, has been provided in a routeno-stop table. I am trying tomerge the values for a particular travel. for example, the table is asfollowsroute no: stops1 museum1 sports centre1 tennis court2 zoo2 city hallwhat i want is merging these values asfor 1: museum-sports centre-tennis courtfor2 : zoo-city hallis it possible and how?...Transferring Dialog/resources/files from one project to another.
I am in the process of writing an MFC dialog app. I would like to use a
couple of dialogs that i created in another VC++ 6.0 MFC Dialog project.
I am having difficulty copying these from one project to another. I have
tried to copy the .rc file and resource.h file into my application but i am
finding this does not import the dialogs that i want.
Does anyone know how to do this?
U�ytkownik "Macca" <Macca@discussions.microsoft.com> napisa� w wiadomo�ci
> I am in the process of...Find File
Can I create a macro that would go to the C: Drive and allow me to pick a
file and open it. I want to be able to choose the file after I hit the macro
The code below, throws the standard Open File dialog, allows you to find the
file, clicking OK captures the name in the variable fName, but does not open
it. The next line does that, using the name in the variable to identify the
file to open
Dim fName As String
fName = Application.GetOpenFilename()
Microsoft MVP - Excel
Southampton, En...pst file size limit #2
Is there a limit to the size your pst file can be?
2GB for the old format file (Outlook 97-2002) and theoretically 33TB for
OL2003 format PSTs
"TK" <firstname.lastname@example.org> wrote in message
> Is there a limit to the size your pst file can be?
Yes but it depends on version, in theory pre Outlook 2003 can go up to 2GB
but in practice tends to bomb out after about 1.5GB, Outlook 2003 is a
nominal 20GB but can go up to an estimated 32TB controllable via registry,
info here on the Outlook 2003 pst http://support.microsoft...Sending multiple files in multiple mails at once
The situation is the following: I have a ZIP which is to large to send by
mail in once and FTP is in this case no option.
So I remade the ZIP out of 5MB portions, ending with a large number of ZIP
Now I looking at a way to get the files send one by one, in single mail
massages, but I don't want to make each mail one by one. Does any one knows
a program for example, where you choose the file, set the recipients address
and maybe more and then hit a button and . their all gone.
Anyone any idea how to do this?
Thanks in advance.
I have a simple spreadsheet that started out 1.5 MB....then I started
adding working sheets and VLOOKUP's.,....next thing I know it comes
back saying 7 MB. I went back and copied, paste special, values of
the results of the VLOOKUP, but still the file size did not go down.
It should since I am virtually going back to the way it was in its 1.5
MB form. How can I reduce file size?
Thanks for any advice......
Message posted from http://www.ExcelForum.com/
Usually the cause of file bloat is that Excel thinks the file is bigger than
it really is.
You know the last...How to open previous version of Publisher file when I only have 20
Keep getting, "Publisher cannot open files from a different version". I
thooght there was some sort of converter or patch to do this.
Different version does not mean previous. Usually it means newer. There is no
patch or converter for this. You can ask the originator to save it as your
version or send it as a .pdf.
> Keep getting, "Publisher cannot open files from a different version". I
> thooght there was some sort of converter or patch to do this.
...money2003 merge files
Is there a way to merge two money files (.mny)into one?
"daveb" <email@example.com> wrote in message
> Is there a way to merge two money files (.mny)into one?
...outlook multiple e-mail selections
Within the past week, selecting multiple e-mails, deleting
multiple spam messages for instance, works differently
than before. Multiple selections now cause the selected
items to flicker rapidly and the cursor to turn into a two
headed spinning arrow while Outlook appears to process
each message in some fashion. This didn't use to happen.
Does anyone have any idea of how to fix this annoying
...How to browse folder and open xls file automatically in vba?
My Task now is to create excel macro that can:
1) User browse folder
2) Click folder--open then
3) Macro will automatically open all Excel file one by one
4) After open --- collect certain data
5) Close file
Anyone pls help for the VBA code.
Dim fd As FileDialog
Dim SelectedItem As Variant
Set fd = Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = True
If .Show = -1 Then
For Each SelectedItem In .SelectedItems
'...Closing an Excel file generates a .txt file
This seems to happen with only a few (10) files that have
Macros. When you close out of a locally stored excel file
(not saving it) a .txt file is generated. I have
duplicated this on Excel 97 and 2002. All the .txt file
contains is "updating menu". Does anyone know why this is
It sounds like there's a macro at work.
If you open one of those files with macros disabled. You can set your security
level to high in xl2002 by: Tools|Macro|security|Security level tab.
then open the workbook.
Then close it.
Does it still get created?
If no, then it sounds...how to point MAPI interface at Express, how to get email of sender
I receive many email requests to scan old computer museum manuals.
I manually paste fields from the emails in to a table of scan
I haven't done this since 18th Jan 2006 and i'm attempting to automate
the process to some extent to catch up.
Here is the code I've done so far:
Dim lngCount As Long
Dim lngIndex As Long
Dim dteReceived As Date
Dim rs As Recordset
Set rs = CurrentDb().OpenRecordset("ScanRequestEmails")
Set myOlApp = CreateObject("Outlook.Applicati...Mail Merge and Access format of telephone number
I use mail merge for a directory using Access for my data. The telephone
numbers that are formatted in Access (555) 642-5555 aren't retained but come
in to merge as 555642555 so I have to go to each one and put in the (xxx)
666-666. Is there anything I can do to retain the Access format of the tele
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"terry50" <firstname.lastname@example.org> wrote in message
news:12784D...2004 Download Help Files Don't Work
I recently downloaded the Money 2004 direct from the
Microsoft website (M12USWEB)and then purchased the
upgrade to the full Deluxe edition.
My problem is that the help files are not working. The
topics themselves show up in the help window, but when I
click on any topic (or question that I've input), the
window says "Unable to load".
I contacted MS support and they suggested I uninstall and
then redownload/reinstall and input my unlock code again.
I have tried this to no avail. The help files do not work
on my computer with either the trial version or the
upgr...How do you merge fields in a Publisher post card?
I am trying to print post cards to my students...4 per page. However, it
seems I am only to insert or merge their names and addresses using Microsoft
Word. My post cards in Publisher print 4 per page to the same student.
When you merge postcards there can only be one card on the screen. If you are looking
at print preview, it will reflect the same data on each card, this is a bug.
Mary Sauer MSFT MVP
"B C-ing 4 D Solution! �" <B C-ing 4 D Solution! �@discussions.microsoft.com> wrote
...Help! Master Project File
I have about 9 projects checked into Project Server. Management likes to see
them all in a single master project file, so I created a master project file
with all 9 projects inserted and published that. I also use this master
project file to control cross-project leveling.
In addition, each Monday I save a snapshot offline copy of the master
project file so we can compare the schedule on a week to week basis. The
problem I'm seeing with that is, when I open the older snapshots, they
refresh to the most current information. I therefore lose the historical
view of the sc...Update one text box based on another text box
I'm using Access 2007.
I have three date fields we use for follow up:
Then I have a text box I've named Status and a check box I've named Not
The idea is for us to enter a date in FU1 after the first follow up is
completed. Once the date is entered in FU1, the Status text box is updated to
read "First Follow Up". Same goes for FU2 and FU3.
If the Not Interested check box is checked off, the Status is updated to "Not
Interested". This all works.
My problem is if any of the dates are removed from any of the follow up date...Adding numbers from multiple worksheets using same format
Hi, I have a question about using Excel to add data from multiple
worksheets. I am a salesman and have a daily report I have to email in
(using an Excel worksheet) each night. The form is set up to hold one
pay period of data (or two consecutive weeks, Mon. through Sat.) The
form is set up to add the daily numbers for a given set of categories
on a weekly basis. There is a place for the sum of each category for
week 1 of the pay period and a place for the sum of each category for
week 2 of the pay period. Then there is a place where the totals for
both weeks are added together for the grand to...Thumbnails on file selector
I have a file selector routine to open an image in my database. The code is
Private Sub ImageWindow_DblClick(Cancel As Integer)
On Error GoTo ImageWindow_Cancel
Dim CR As String
Dim fd As FileDialog
Dim FileSource As Variant
Dim FileDest As Variant
CR = Chr$(13) 'Carriage Return'
FileSource = "C:\Integ Pro\Southmids Sportsters\Images\\No-photo.gif"
Set fd = Application.FileDialog(msoFileDialogOpen)
FileDest = "C:\Integ Pro\Southmids Sportsters\Images\"
.AllowMultiSel...Merged letter and made changes to merged letters. Final merged doc
Merged letter and made changes to merged letters. Final merged document has
date in field code and atty wants to change it from Jan 5 to Jan 4. She does
search and replace but the date automatically updates on print, even if we
change that setting.
"Serena K." wrote:
> Merged letter and made changes to merged letters. Final merged document has
> date in field code and atty wants to change it from Jan 5 to Jan 4. She does
> search and replace but the date automatically updates on print, even if we
> change that setting.