Macro Not Working
Hi can any please advise me why my Macro is not working
The Macro allows users to Input dates via a message box which shoul
then be input in cells B1, B2, B3 & B4 - but this does not happen - I
addition when I try to change the sheet name in the macro from Sheet2 t
another name i.e. mydata it displays an error
MyName = InputBox("Please Enter Date for Q1")
If MyName = "" Then
Sheet2.Range("$B$1").Value = MyName
MyName = InputBox("Please Enter Date for Q2")
If MyName = "" Then
E...Prohibited File Type?
If someone sends me a picture file as an attachment to an email message I
get shown "Prohibited File Type..file deactivated". I can see the pic in the
body of the message but can't open and view the picture file by clicking it?
Similarly if I try to attach a picture file to a message I send that also
same warning both before sending and to the recipient?
The files In question are jpg files.
Anyone advise please?
- do not allow attachments to be save or opened
- block images and other external content
Check (op....xls files opening in IE rather than xls
When opening files downloaded from the web, they are
opened in an IE windo rather than the appropriate Office
2003 tool (word, excel, etc.)
From a previous post:
There's a setting in Windows that you can change.
In win98, I can do this:
Start Windows Explorer
File Types Tab
scroll down to MS Excel Worksheet
click the edit button
There's an option to "browse in same window". Uncheck it.
That's where you can toggle the "confirm open after download", too.
How to Configure Internet Explorer to Open Office
Documents in the Appr...2007 compatibility pack not working
I have Windows 2000 SP4 running Office 2000 SP3. I installed the latest
2007 office compatibility pack (incudes SP1 and SP2), however I am still
unable to open Office 2007 files, specifically .xlsx and .docx. I have tried
repairing and reinstalling Office. I have downloaded and installed all the
Microsoft Security updates and Office 2000 Updates. I even uninstalled and
reinstalled the compatibility pack. Still no luck. I get the following
error when opening a Word 2007 doc. "There was an error opening the file".
Excel just says the file is an unrecogni...Working hours
Every month we make a list of our employees working hours.
monday 10.00 - 16.00 = 6h
tuesday 16.00 - 20.00 = 4h
how can i calculate the hours together, some employ can have only 30 hours
per week, now calculate by my fingers....sorry for my bad english
Day in Column A,
Start time in Column B,
End time in Column C,
Start in Row 2.
Make sure time entries are TRUE XL recognized times.
Daily total in Column D, using this formula:
Say weekly total is in D9.
Format D9 to Custom
And use this formula:...Hidden Folders and Files
I am using Windows XP pro, 2nd, service pack.
For some reason, I am now unable to see my hidden files and folders,
even though I was able to a short while ago. I don't know what I
have done to change this.
Under folder options I have selected "Display the contents of system
folders" and "Show hidden files and folders" However they are not
Any advise? Thanks.
> I am using Windows XP pro, 2nd, service pack.
> For some reason, I am now unable to see my hidden files and folders,
> even though I was able to a short ...How do I install when "file ZF561407.CAB can not be found"
...Excel 2000: File >> New menu command causes application crash
This is occurring on only one machine on a network!
After saving an emailed Excel template to a standard network location
for Microsoft templates, when selecting File >> New this installation
of Excel 2000 crashes ("Excel not responding" on Close program
dialog). On other machines there is no problem.
Have "repaired" Microsoft Office using that option from the
installation CD-ROM, have removed Excel from Office installation,
rebooted and reinstalled Excel. No change on the problem behaviour.
Everything else appears to be working just fine in this copy of Excel.
We ...Import animation slide
I have created a powerpoint presentation using my companies template slides.
I have imported a slide with an animation from another person's presentation.
However, the "picture" of the animation that came into my presentation
doesn't line up on the template slide properly. It overlaps our company
logo. I am unable to move this "picture" of the animation. Can that be
Bsed on your questions, there is either an image problem or an animation
problem, but it it unclear without seeing the slide. Let's assume it's an
Yo...FilesystemObject doesn't work anymore. How to fix?
I think that scrrun.dll is messed up (New technical term) somehow. But if I
knew what I am talking about, I wouldn't be bothering you folks.
This line: Set fso = CreateObject("scripting.filesystemobject")
causes this error message to appear:
Error: (null) Code: 8002801D
I've dragged scrrun.dll onto regsvr32.exe several times (just to be sure I
actually had done it) , each time getting the message: DllRegisterServer in
I'm running WinVista Ultimate 64bit, completely updated.
Does anybody have any ideas a...Duplicate detection upon import
Unfortunately, we use several different databases at my organization but in
order to manage our customers, we import records from these databases into
We have c360 for detecting duplicates once they're already in CRM. Is
anyone aware of a product that checks for duplicate upon import into CRM?
What method are you using to import the records and which records are you
We have a tool that checks for duplicates on import.
Jeff Loucks [MVP]
Come see our CRM presentations at TechEd and SMB Nation
on integrating other Micro...Importing Exchange Rates
We currently enter currency exchange rates manually into Dynamics GP9. Now
we are looking for a FREE automated option. Someone suggested we use a RSS
feed to get the info- we would then have to convert/prepare the data and use
Integration Manager to import the info into GP (not sure yet how to automate
Has anyone else done this before or have any other suggestions?
There is a sample Exchange Rate integration in Integration Manager. You
should review the source file and destination mapping details in this
integration to gain a sense of what data will be required for the
...Trouble getting Bill Pay to work with Money 2005
I upgraded from Money 2004 Deluxe to Money 2005 Premium
this evening. I had Bill Pay working in the 2004 version.
I went to enable the "Access your Money data on the Web"
option in Settings. It said that I had to disable Bill
Pay first before it would continue and that it would
enable Bill Pay again once the process was complete.
Unfortunately, now I can't get Bill Pay enabled again. I
can go to the Bills screen and see my scheduled bills,
but I can't do ePay through Bill Pay in Money anymore.
When I go to Manage Online Services, I see my bank
accounts that are ...a larger window to view the files
When I click on the "FILE, OPEN" menu items I get a dialogue box showing a
list of all the Excel files on my directory and then I can chose the file I
want to open.
Often, before I select which file I want, I need to resize the columns
(Name, Size, type, modified) within that dialogue box to look at various
properties and it would be ever so useful if there existed a Macro or
utility that presented the list of files in a somewhat larger window so that
I did not need to move the column widths each time.
Needless to say, this does not just apply to Excel but that is a prog I ...Unable to import Quicken file to Money
I am trying to import my QUICKEN 2004 data file
(QDATA.QDF) into Money 2004. I followed all the
directions and validated the QDATA file first, but
NOTHING imports. All I get are messages that
indicate "Your Quicken file contained invalid transaction
types". The only transactions I have are account
(Checking and Savings) transactions - debits and credits.
I have tried this a number of times, and downloaded all
updates to Money, but nothing ever converts. Can anyone
You can not import Q2004 into M2004. You'll have to wait a few more days
and then import it into M2...outlook cant find file MSOE.DLL
when i try to open outlook an error msg comes up - cannot
locate file MSOE.DLL. when i went to start, find,
folder/files and searched for it i found it. how can i
fix the problem please help.
If you're using XP, it should be in the Documents and Settings\User Name\My
Documents\Outlook Express. This implies that it associates with the user
who's logged into the system. Are you logging in as User Name in the above
example? If not, that's why it can't find it. Further help is available in
MSOE.TXT in the same sub-directory.
<firstname.lastname@example.org> wrote...get a list of file in a directory
what would be the best way to return a list of files in a directory.
I know in VB you could use the dir function, but what should
i use in MFC.
Doen anyone know of a class available where I could say return all the file
in a certain directory and its sub directories
Take a look at the CFileFind MFC class.
Check Abdoul [VC++ MVP]
"Dylan Franklin" <email@example.com> wrote in message
> what would be the best way to return a list of files i...Visio File Summary Dialog Box is showing wrong file name and size
I am using Visio 2003 ActiveX Control in my application using VB.NET
I am calling "visCmdFileSummaryInfoDlg" Command to open File Summary
Dialog Box. Dialog Box is open successfully but it always showing
Template file size instead of open file size in General Tab.
The information it shows is:
Type: Microsoft Visio Drawing
Size :(928 bytes)
Based on: Template - ValueStreamMap.vst
Can any one let me know about any property or way so that it shows
correct file size?
Can we assume that the new drawing has been saved to disk before you call
th...2 mirror files with :1 and :2
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of mirroring,
or changes being tracked, but track changes is turned off. Any help is
you've opened two windows of the same workbook (from the window /new window
menu) - just close one and then save - this should solve the problem
"DJR" <DJR@discussions.microsoft.com> wrote in message
news:F0F6BDF5-9DC2-486E-947C-ABBB6C4544...importing Outlook Express messages to Outlook 2003
In Outlook Express the displayed Sent and Received date
for messages sent out have the same date. The import
function in Outlook 2003 to import Outlook Express
messages changes the Received Date to the date/time of
Is there a way to retain the Sent Date as the Received
Date or is there a way to convert the Received Date of a
sent e-mail to be the same as the e-mail's Sent Date.
"rannoch" <firstname.lastname@example.org> wrote in message
> In Outlook Express the displayed Sent and ...Is there a work-a-round i can use for making a datagrid....
Hey all, I am trying to make a datagrid on a form that the user would input
info, and once completed, it would be put in correct area's of the workbook.
I cant use a datagrid as job doesn't alw downloads for net so i cant get the
update needed to alw me to use datagrids( see post sugj: "Missing Control In
Addin") is there a way i can use a text box or some other box or tool to do
When you say "form", do you mean UserForm or worksheet set up to look like a
data input form? If a UserForm, then yes, you can use TextBoxes, but you
didn't supp...money for notihng that works
What is $5 and 15 minutes when it can make you earn $100,000 ?
Not much, if you ask me...
You've probably seen a lot of those kind of messages over forums and
and the explanation for this can be given in two words: IT WORKS!
But how on earth, will you ask me, does it actually works? How is such a
This is a simple pyramid scheme. To explain it to you with realistic
lets take a simple example:
Imagine you folow the instructions given below, and post your message to
newsgroups (wich isn't much). 10 people read your message and also folow
ins...Outlook Data File Not Closing Properly
I always get the following error message when starting
Outlook 2002 (running Office XP and Windows XP) :
"The data file 'outlook' was not closed properly. The
file is being checked for problems."
I get this message everytime (whether I hibernate or shut
down) when I start Outlook. This checking of the file
can take anywhere from 30 seconds to 5 minutes and is
very frustrating. Anyone have any idea what the issue
is ? This started happening just after I installed XP
...Rules don't work for Spammer terms in Outlook 2003
I sure hope someone can help. It seems no matter how many rules I have set
up for the term "viagra" and it's derivatives to be sent to the junk folder -
I'm still getting them in the inbox. I've blocked every address they come in
on, and set a rule for each version (lower case, all caps, space between each
letter, etc) and for each of these rules the #&* thing still goes to me
inbox. The rules have always worked before and still do for other spam
terms, but for this one word it won't work to put the email in the junk
folder. PLEASE HELP - I'm...business contact manager will not import ACT! 2007
Just upgraded, but my new version of ACT! 2007 will not work. I tried
exporting to CSV but mapping was off.