Here is fix for Windows file problems
If you have installed a Windows update and started having problems opening,
closing, copying files, see:
A better solution is offered at
http://support.microsoft.com/kb/918165 "Problems in Windows
Explorer or the Windows shell after you install security update
Patricia Shannon wrote:
> If you have installed a Windows update and started having problems opening,
> closing, copying files, see:
> http://ww...QuickSell Import Bug
Hi, I am using QuickSell to import new items in HQ and have encountered a
problem. Whilst when adding new items the utility functions properly, when
editing existing items and using the Recently Changed mechanism to download
data to the stores, items which have been edited using QuickSell import do
Has anyone encountered the same situation and perhaps found a workaround?
...Fax Icon on my File menu and toolbar
I had a Fax Icon on my toolbar and also on the file menu. All of a sudden it
is gone and I want it back. Where did it go?
Was it a dedicated toolbar? Or was it just icons on a builtin toolbar?
If it was a dedicated toolbar, you may get lucky and find it under:
(just not selected)
But if it was on a builtin toolbar (along with the file menu), then maybe you
reset your toolbar--also under:
selecting a toolbar and hitting the reset button.
If that's what happened, I think I might try to find the Fax addin/workbook that
added t...exporting outlook 2000 pst files to a database
I need to export outlook 2000 to a database- attachments
and all. Is there a simple way to do this so you can search
and retreive messages and attachments in a database form?
You can export individual folders to access or excel to have them available
for searching. I have never tried to export my entire .pst file to access
or excel however.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
Jeff <email@example.com> asked:
| I need to export outlook 2000 to a database- ...Killer macro idea for business mailings
One of you programmers should write a macro to validate a city from zip
code. I receive excel files from response cards and a lot of people will put
some random letters for their city instead of the actual city name, or maybe
they'll put the wrong abrieviation for their state. It would be awesome if
all the zipcodes could validate the state field and change if necessary and
the same for the city fields too.
Okay, have at it :)
Okay, well good idea I think anyways, but it turns out that my columns just
weren't wide enough so it didn't display more then 2 letters.
...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Formatting a subtotal line with a macro
I already have in use a macro that runs a sort and subtutal function. I
would like to format the subtotal row using visual basic since there is
already a macro in place.
Look at this:
ActiveCell.Font.Bold = True
"DJDKAL" <firstname.lastname@example.org> skrev i meddelelsen
>I already have in use a macro that runs a sort and subtutal function. I
> would like to format the subtotal row using visual basic since there is
> already a macro in place.
This is what I've g...Can SUMPRODUCT be used for entire column?
This formula results in a numeric result:
but this formula results in a #NUM! result:
Which means I need to specify the length of the columns, which may grow over
time. Any way to do this for the entire column, without having to specify
the length of the column?
XL07 removed the limitation on array formulas (which SUMPRODUCT is, even
though it doesn't require CTRL-SHIFT-ENTER) and entire columns.
For pre-XL07, one can use
to get all but on...Using scanner in Word97
I want to scan a picture into word97 using my HP 4370 ScanJet. Could not
find option of "From Scanner" under "Insert" --> "Picture". Apparently I
must need some sort of Word97 Add-On. What and where is the add-on? Is it
on the Office97 CD? Same applys to Excel97.
Also, does microsoft sponsor a Word97 / Office97 discussion group? If so,
would appreciate a link.
"PSRumbagh" <PSRumbagh@discussions.microsoft.com> said this in news item
> I want to scan a picture ...Outlook receiving zip files
Why is it when I try to send zipped files to my address; it gets returned as service unavailable?
your Exchange dont allow you to send this! Please speak with your Domain
"Omar" <email@example.com> schrieb im Newsbeitrag
> Why is it when I try to send zipped files to my address; it gets returned
as service unavailable?
your Provider don�t supportet this part of file!
Gestern lief noch alles, ich habe nichts gemacht!
Bitte in der Newsgroup antworten, damit jeder d...Using later version of microsoft access
I've got access 2000 on my computer. When I go to open a database someone
sent me I get an error message :
this database is in an unrecognized format. The database may have been
created with a later version of microsoft access.
Is there any way I can open and use this file (short of upgrading to later
version of access)?
If you do not have Access 2002 or 2003, ask the person to save it in Access
2000 format for you.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at m...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ...unable to read file #7
Does anyone know how to solve this error? This is the
second time I have had the same error on the same file.
Last time I was able to recover from a saved copy and
updated fine. This time whenI opened the copy and updated
it, then saved it, I got the same error when I tried to
open it again, Now I don't have a good copy. I have
downloaded all avaliable updates and tried
running "Excel.exe /regserver>ok" This did not help. I
also ran defran on the drive.
> Does anyone know how to solve this error? This is the
> second time I have had th...SBS 2003 moving of users files
I run SBS 2003 and due to the amount of data on the users drive it has
become chokers and have installed a new 1tb drive to keep up with demand
I need to move all the data to the new drive but unsure of the process.
Is there an easy way of doing this? As it needs to be done asap
JimmyJames's Profile: http://forums.techarena.in/members/255792.htm
View this thread: http://forums.techarena.in/small-business-server/1357051.htm
You c...Importing AOL Email File Cabinet
Is it possible to tranfer a complete AOL Email File Cabinet into outlook?
AFAIK, no, but see if anything here will do it:
http://www.slipstick.com/config/convmsg.htm - check out Address Magic Plus
first, it can convert almost anything.
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
Outlook Tips: http:/...Problem with macro assigned to custom toolbar button
Problem with macro assigned to custom toolbar button
I am having a probelm with macros assigned to a custom button on
custom button. I am using excel 2000.
1. I have created a macro called "Jump" in a workbook named "Test1"
2. I then created a custom toolbar and added a custom toolbar button t
3. Through the customize dialog box I assign the Macro "Jump" to th
Everything works fine UNTIL.
If I do a SAVE AS for the workbook "Test1" and call it something els
like "Test2" and then close "Test2" an...Using Company Wide Mail Templates.
I do not know if i am at the right spot here, or if it is evne possible, but
i got the following question.
My boss would like me to make sure that every outgoing mail has the same
looks. It starts by adding a signature that is the same for everyone, except
with ofcourse personalized information. This was easily done by giving
everyone a signature.
The next question is however, to put the head of our website, also above our
mail. This means that every user that sends a mail, the mail will have a nice
header, underneath that header, the mail is typed, and then its ended with
the si...140 MB file went to 5.08 MB after editting 1 table
Hello All -
I need some ACCESS insight...please...
Several years ago, I built an access db to track my business
scheduling and accounts payable/receivable.
So this database is EXTREMELY IMPORTANT TO ME.
The file has grown to 140 MB.
Today I made a copy of the file and then edited my calendar table.
I removed all columns which had 2006 data (72 totals columns) - the
table had about 144 columns originally.
I then added 72 columns with 2008 headers. These columns are now
blank since I have not added any 2008 data yet. Afterwards, I looked
around and everything looks good - my 2007 data is the...a few basic question about resource files
I have an application that uses resource files to contain the string values
for each language.
I have created the required resource files in my project, but I don't speak
the languages I wish to have resources for.
What I would like to do, is somehow allow the end user to edit the resource
file themselves so they can set the string values as needed.
Is there a way to edit the resource files that ship with my application and
get installed ?
Is there a way to have external resource files (not embedded into my
application) that can be updated/replaced with o...Exporting contacts in a csv file
I am a mysterious problem exporting my contacts as csv file. The
resulting file has only 58 contacts out of almost 1200 contacts in my
outlook. These contacts appear to be the last 58 contacts added. (I
say appear because the attribute "createdon" is not exported so I
can't be exact. Why is this?
cinnamngrl <firstname.lastname@example.org> wrote:
> I am a mysterious problem exporting my contacts as csv file. The
> resulting file has only 58 contacts out of almost 1200 contacts in my
> outlook. These contacts appear to be the last 58 contacts added. (I
> say appea...is there a way to program my Excel file to do a loop?
If I want B10 to B17 all follow the change of the same number(copy cell),
let's say I put it in A1,
and C10 follows the change of A2(copy cell), and C11 follows the change of
A3(copy cell), and C12 follows the change of A4(copy cell),
then I have 4 variables in my calculations: A1, A2, A3, A4.
I want to loop each of the variables in a different set,
then I hope the whole worksheet will be able to refresh following the change
of A1, A2, A3, A4,
and then I want to find the very set of A1, A2, A3, A4 that gives the
smallest value of D10,
how do I program the whole procedure...Publisher can not save file
I recently started having troubles with my Publisher 2003. Whenever I go to
save my files now, using save as or just the save button, it gives me a
dialog box that says "Can not save file." It does that twice, then it
disappears. I also noticed that when it does this, it leaves the .tmp files
in the directory where I tried to save. I can change the name of the files,
and sometimes it will save it. Most of the time not though. I have NAV, and I
noticed that it was said there was an issue with Publisher and NAV. Is this
the same with the 2005 version, and is this anything anyone...Excel 2007 PC damages Mac Excel 2008 Files
Operating System: Mac OS X 10.4 (Tiger)
When I open a Mac Excel 2008 file on Excel 2007 and I can work with the file, however when the file is returned to the Mac, it no longer works correctly, leading to a crash as soon as I try to save or eventually it might change the file to look like a bunch of letters and characters. Here is the error report: <br><br>Microsoft Error Reporting log version: 2.0 <br><br>Error Signature: <br>
Exception: EXC_BAD_ACCESS <br>
Date/Time: 2010-01-15 17:05:56 -0600 <br>
Application N...Macros not performing correctly
I recorded a macro to place a vlookup formula in four cells that are side by
side. When I run the macro it only performs the first task, it does not go on
to do the other three. I used the tab key to go to the next cell while
recording the macro, I don't know if that's why it's not working or if it's
The script looks like this:
' EERates Macro
' Macro recorded 3/4/2005 by BCBSOK
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)"
ActiveCell.FormulaR1C...Dynamic Range Selection Using VBA
What I'm trying to accomplish is to be able to run a procedure that selects a
range based on a number provided in another cell. For example; if the number
10 is in cell A1, then cells A20:A30 would be selected when I run the macro.
If the number 6 is provided, then cells A20:A26 would be selected. Not sure
where to start, so any help is appreciated.
this may do what you want
"TEK" <TEK@discussions.microsoft.com> wrote in message