re-install Money 2006 #2
How do I re-install 2006 without CD when I wipe my harddrive? I kept the
file and re-installed in on the drive, but I am getting a Trial Version
message that the trial period has expired -- but I purchesed the regular
In microsoft.public.money, mmekeel wrote:
>How do I re-install 2006 without CD when I wipe my harddrive? I kept the
>file and re-installed in on the drive, but I am getting a Trial Version
>message that the trial period has expired -- but I purchesed the regular
See http://support.microsoft.com/default.aspx?scid=kb;en-us...delete personal macro
I've created a macro in my personal wkbk,however, I dont know how to delete
the macro completely. I tried to delete from tool --> macro.... , a pop up
says I hav to unhide a wkbk to perform. For this, I dont really understand
which workbk its asking actually? The orginal one when I was creating the
The workbook to unhide is Personal.xls. You do that from the Window menu.
/On Mon, 21 Mar 2005 18:15:04 -0800, "kalz" <email@example.com>
>I've created a macro in my personal wkbk,however, I dont know how to delete
&g...Disabled Exchange 2K3 accounts starting to accept new emails #2
Hello, whenever I would disable a user account in Exchange 2003, it
would NDR any new email, unless there was a forwarding address in the
delivery options tab, which is how I wanted it to be. However, since
applying the security updates for February, the disabled accounts have
begun accepting new mail. Does anyone have any ideas why?
Feb. updates applied:
you are right, and I think that Microsoft want it to be that way from the
Read this articles
http://support.m...Time series #2
I have several tabs for different dates with data in it. Colomn
contains the time in format 13:30:30.
For my project, I require to know the number of data points in variou
time series, pls see below.
I tried countif and if function but could not come up with the results
PLS HELP. If I have to do it manually then I am dead.....
mohitmahajan's ...Errors #2
In the accounts list the balance shown on my checking
account is 287.24 less than what it is on the check
register. The check register is correct. The only check
of that ammount was written in 2002 if that means
anything. I am using Money 2004 Standard on a new
notebook. The error started after the first days of
software use. I have run both fix programs and nothing
repaired. Any help would be appreciated.
In microsoft.public.money, JamesLG wrote:
>In the accounts list the balance shown on my checking
>account is 287.24 less than what it is on the check
>register. Th...New Message Notification #2
I use Outlook 2003. When a new email message arrives, I
want either to have an icon show up in my system tray or a
box show up on my screen (you've got mail).
I have checked the box for the icon to appear, but nothing
I haven't found an option to choose for the box to appear -
and remain - on my screen.
In Outlook 2003, you can go to Tools-> Options -> E-mail Options -> Advanced E-Mail Options to find settings on e-mail notification. You can play a sound, briefly change the mouse cursor, show an envelope in the notification area, an...Can't Assign Macro (not grayed out but nothing happens)
This is not the case where the "Assign Macro" option is missing.
My Solution: Be sure at least one worksheet is open.
Right Click on Toolbar
Right click on Command Button or Menu Item, etc.
The "Assign Macro" option is there but nothing happens:
Hopefully this will help someone.
My handle should tell you enough about me. I am not an MVP, expert, guru,
etc. but I do like to help.
...Excel 2007 Bar and Line chart on 2 Axes
I used Excel 2003 to create a "bar and line chart on 2 axes" and now have
2007. I can't find where or how to create these charts using Excel 2007.
Can someone tell me how to do it?
Then Google "Excel 2007 chart"; look at a few sites
Then come back here with specific questions and we will help you get it
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Nancy" <Nancy@discussions.microsoft.com> wrote in message...Excel 97 worksheet with macros won't open in Excel 2000
I've got a workbook saved in Excel 97 that has some
embedded macros (not sure where-we don't really need
them). When trying to open from Excel 2000, get error
message "An error occurred while initializing the VBA
libraries (126)" and the workbook won't open. Any ideas on
how to make this work in 2000? Or maybe even find where
the macros are and get rid of them?
...e-mail 2 reports
Is it possible to email 2 reports as 2 separate attachments?
With outlook as an email client:
Arvin Meyer, MCP, MVP
"Samuel" <firstname.lastname@example.org> wrote in message
> Is it possible to email 2 reports as 2 separate attachments?
On Jun 21, 2:07 pm, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> With outlook as an email client:
> http://www.datastrat.com/Code/Outloo...Can 2 Union Queries Be used in Another UNION ??
I have created 2 separate Union Queries that work just fine.
Can these 2 union queries be used in Another Union query (that will
essentially combine the output of those 2)?
Thanks very much,
Message posted via http://www.accessmonster.com
Yes, as long as the two union queries are outputting data in the same
structure and as long as the query engine doesn't decide that the
combination of the union queries is too complex.
Have you tried to do this? If so, did it fail? And if it failed were there
any error messages?
Access MVP 2002-2005, 2007
Center for H...Repeating instructions in a Macro.
I have a Macro that clears any data on different 31 tabs and, due to my
lack of knowledge, I do this one tab at a time. The 31 tabs represent the
maximum possible days in a month. Here's a sample of my Macro:
' Clear the data on tab 1.
'-----------------...macro results wrong
I recorded marcos in a workbook. I then saved the workbook uder a ne
Naturauly I had to modify the macro ref file names to the new fil
I can now run the macros , however I get the wrong results.
i have this formular
in the orignal workbook it works fine when I copy an
autofill the fields
in that column.
In the new workbook the formular is right but th
resutant value is a
constant for all the auto filled cells!! eg. if th
cell A1 = 3 all the other
cells A2 , A3 , A4 are dispalying 3 enven the formula
Please help :co...Excel / VBA
I am trying to find how to add or remove the description displayed on
the "Macro" pop-up menu (Alt-F8). Generally macros recorded have a
banale description giving the time/date & username, others that I write
directly in the VBE have none.
Can anyone point how to add/modify this description?
Message posted from http://www.ExcelForum.com/
When the macro recorder fires up, the first dialog allows you to put
whatever description you want in, including none if so desired.
The value gets saved as comments, but changing the comments does not chang...Switchboard hangs when running a macro
Access 2003: I've recently discovered the Switchboard - a grand concept;
wish it wasn't so hidden...
When running a macro from a form, no problem. But when running the same
macro from the Switchboard, Access hangs. It seems to run all of the steps
in the macro, and finish, but then Access hangs. Any help would be
Thanks, Mike in Sugar Land, TX
On Mon, 30 Nov 2009 21:28:03 -0800, Switchboard newbie <Switchboard
My crystal ball is broken. Can you post some code, stripped to the
...Converting Crystal report from MSCRM 1.2
I have a client who has upgraded to V3.0 for CRM. They want to continue
using Crystal for their reporting engine because they have 40 custom reports.
Does anyone know how to easily accomplish this? I have created a new
connection to the new CRM Views in SQL, but I can't seem to figure out how to
easily replace all the fields that are currently in the report using the SSO
connection to my new connection.
Any help would be greatly appreciated.
many of the services such as rpttosql.com say they will only convert so
far. some even say they will only get the general lay...inbox repair #2
email@example.com <firstname.lastname@example.org> wrote:
And the question is???
...Trigger Macro on Open Spreadsheet
How can we force a macro to execute whenever a spreadsheet
is first opened?
do you mean the file? If yes either name your macro
or put your code in the workbook event
Beckie Davis wrote:
> How can we force a macro to execute whenever a spreadsheet
> is first opened?
...refund check #2
I have multiple customers requesting that the Refund Checks module be able to
create Manual Payment batches in Payables Management. Right now Refund
Checks only creates Computer Check batches.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/B...2 Formatting Questions
Can we, in the CRM forms, format dates to read into the “15 Aug 2005”
format? This is possible in reports, but by default, the forms use only
numbers for dates, but in any format.
Any ideas of how to track multiple currencies in the same application -
specifically USD and Canadian? I know a Microsoft CRM installation currently
supports one language. But aside from using a picklist to specify "USD",
"CAN", "MEX", or other I'm concerned about how their forecasting.
www.visalign.c...Outlook 2007 adding contacts issue #2
I apologize in advance if this has been answered, but I couldn't find it anywhere...
today I added contacts to outlook 2007...never had used it before on Vista ever...and closed out went to lunch...
came back, I cannot add any new contacts. All options to add a greyed out...
If I select file new.....adding contacts is there but greyed out...
any ideas on what to change?
Go to your contacts page and type CTRL + N. The new contact page will open.
Or on your contacts page, click New on the button that appears just below
the File menu item.
Or on your contacts pa...Solver Add-in #2
I have an Excel File (around 4.5 megs) with 28 sheets. using the Solver
add-in on the NPV function subject to a few restricting criteria.
Max iterations 100 Max Change 0.01 under the Tools --> Calculation menu.
Now when I launch Excel for the first time, I can click Tools --> Solver and
see the conditions et al. but exiting from the Solver once and then later on
trying to reaccess it through the same Tools --> Solver the Solver dialog
does not come up. I have to quit excel and restart it again to view the
Solver dialog. What could be going wrong here? Any ideas/suggestions?
No ...Macro or VBA
I am dumb, but would like to automatically trim down reports that we
get from our IT dept.
We have to delete redundant columns (A,B,C,D,E,G,H,J,K)from each
report. In other words, the only data we want to view is in F,I,J,P.
Can this done more effciently with a macro or VBA/
Could someone give me an example of either so that I could work from
start a new workbook
open one of those report workbooks
record a macro into that new workbook (not the report workbook) when you delete
the columns you don't want.
back to that new workbook
save it as a nice...Timesheet Problem #2
I am trying to populate a timesheet with dates depending on the start date
in B2. If B2 is the 16th of the month of Sept, I don't want anything to show
up on the calendar for the 31th (blank in other words). Here is the formula
I am using, but not working. Help. TIA
With seed date in cell $B$2 and using rows down to
leave the 31st blank. But show all other dates no exceptions
for weekends and holidays.
EOMONTH is in ...dates in excel #2
need help with the date function
this is the situation
i use excel daily to create a report. as this report is
printed out i just save changes made.
except at the weekend when i also make backups so that my
boss can send the report by email on monday mornings.
in the report we use the NOW function to display the date.
when we used to open the backups the date never used to
change ie if saturdays backup was opened on monday morning
it used to still display saturdays date.
now for some reason the date is automatically updating.
anybody know how to prevent this happening