can i create message for icon which create in DLL
how to call NOTIFYICONDATA and post message to the icon in
MFC extension dll?
I can create the icon, but i can not catch the message
which point to the icon.
my code in DllMain:
m_hIcon = AfxGetApp()->LoadIcon(IDI_DLLSTATUS);
but the callback function SetDispDlgProc() never be
called except Create, why?
"delu" <firstname.lastname@example.org&...Excel VBA Programming
I NEED HELP! I am fairly competent with MS Excel but now looking to develop myself in VBA but don't know abc of VBA! I did download a free manual from the following link but may be self study is not my cup of tea!:
may be if someone could send me a link for video tutorials on VBA that would be awesome!
Any help will be much appreciated!
Just go to Youtube and type in the search box "Excel VBA"
It's full of video tutorials.
"rraw75" <email@example.com/> wrote in message
n...Table not listed in Table Names / Table Descriptions window
I am missing a 3rd party table in the Table Names window. I'm trying to
view the table via the Tools > Resource Descriptions > Tables navigation but
my table does not display here. I can view the table under the SQL
Maintenance window (Tools > Maintenance > SQL). Does anyone know why it does
not appear under the Resource descriptions for Tables? I have other 3rd
party tables that appear here just fine.
Thanks in advance,
What module is it?
MCP-GP, MCT, MVP
East Coast Dynamics
I ch...Macro must return the name of the button
I want to a macro to display the name of the button (or object) from where I
am calling that macro. Anyone an idea?
What sort of button (userform, worksheet forms, worksheet control toolbox)?
(remove xxx from email address if mailing direct)
"Derek Brussels" <Derek Brussels@discussions.microsoft.com> wrote in message
> Hi there,
> I want to a macro to display the name of the button (or object) from where
> am calling that macro. Anyone an idea?
&...New Installation No Z report 0.00
New Installation No Z report 0.00
This is a new installation and the Z report has no detail. 0.00 all the way
across. Any ideas?
Check the database> registers> receipt format is there and also check
database> register has attached any receipt format. Make sure these things
first as it not setup by default.
> New Installation No Z report 0.00
> This is a new installation and the Z report has no detail. 0.00 all the way
> across. Any ideas?
Thank You Akber, this resolved the pr...Average various variable ranges
Hi, I posted this question before, but I cannot find the thread of it
anywhere, so I am posting it again. If it is duplicated, please forgive me. I
have 90 000 rows of data that is in the following format:
Time Duration Partition Utilization %
20/03/2010 23:56 900 86.3521441
21/03/2010 00:11 901 86.35425916
21/03/2010 00:26 899 86.35738494
21/03/2010 00:41 902 86.3596435
21/03/2010 00:56 901 86.36061494
21/03/2010 01:11 901 86.33145463
21/03/2010 01:26 912 86.33382161
Time Duration Partition Utilization %
20/03/2010 23:56 900 2.55062256
21/03/...Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
Check out Ron De Bruins "Send-Mail" tips:
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
> The email body should say: this has been submitted for cell B34 and...How do I add a formula to a range of cells
1) You can type a formula into a cell and then drag the that cell's fill
handle (solid square in lower right corner) to fill other cells with the
formula. You need to know about absolute and relative referencing - see Help
I the cell is part of a vertical table, double clicking the fill handle is
quicker than dragging it.
2) You can select a range of cell, type the formula and finish off with
CTRL+ENTER. This fills the selected range with the same formula - with
appropriate cell reference changes.
Microsoft Excel MVP
...Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
>I am using multiple monitors for work and it is great!
>there a setting that I can use so that it opens each new
>excel file in a new excel ...Time interval
I'm using outlook 2000 and can't seem to be able to set
the time interval. I've use "Customize Current View" to
set the interval to 15 min but when I create a new
calandar entry the Interval is 30 min. I must be missing
something but don't know what.
Open th e calendar in a 1 day view. Then right click the time column and
select your time from there.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
mrjondon <firstname.lastname@example.org> asked:
| I'm u...Windows Live Email Time Stamp
The windows live time stamp on all outgoing emails is 4hours later than the
actual time. PC time is setup with the correct time zone. Only happens when
using the online windows live email access. Can anyone assist?
v "dioncnr" <email@example.com> schreef in bericht
> The windows live time stamp on all outgoing emails is 4hours later than
> actual time. PC time is setup with the correct time zone. Only happens
> using the online windows live ...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
On Erro...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
>I want to insert a time when I start work and...Time spreadsheet
A B C D E F G H I J K L M N O
Date Line Start End RO Outside Internal Super. Training Property Shop LineDaily Monthly Time Time Number Labor Labor & Equip Maint Clean Up Labor Labor Labor
out Int A B C D E02/02/09 B 10:27 15:04 96554 0.19?4.62 0.19
INT 15:04 17:52 96598 0.12?2.80 0.31 B 18:22 19:04 96554 0.03?.70 0.34
INT 19:04 19:34 96598 0.02?.50 0.36 INT 19:34 23:12 96606 0.15?3.63 12.25? 0.51 0.51 0.51
In the above example I fill in columns A-E. The rest of the columns are
filled in by formulas. The problem is that the populated (?) times do not
a...How do I create a pivot table if the pivot table icon or menu ite.
If rhe pivot table icon ...??? Please clarify in the body of the message.
"Lynn@WS" <Lynn@WS@discussions.microsoft.com> wrote in message
...How to set tab order for a dynamically created CEdit?
Use SetWindowPos(...) and change the position in the z-order.
<firstname.lastname@example.org> wrote in message
> Anyone knows?
Ajay Kalra [MVP - VC++]
<email@example.com> wrote in message
> Anyone knows?
...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...Comments in Cells disappear after time
A colleague has a spreadsheet with lots of comments in the cells and
apparently after a while the comments 'disappear'. Does anyone have any
ideas why this happens? Could it be there is a maximum number of comments,
or do they have a life expectancy? The sheet is opened in Excel 2000 & Excel
2003 depending on the user.
Thanks for your help.
Comments don't normally disappear on their own. Perhaps your colleague
is accidentally deleting the rows or columns in which the comments
occur. Or comments could disappear if another cell, with no comment, is
dragged onto a cell ...Scheduled Integration via Integration Manager
I in dire need of help and would need to know if there is any way that I can
schedule integrations using integration manager. For example, my client
would want to update the price list via integration manager. Is there a way
for them to just enter a date to run the integration, and if possible a time
as well, then it will automatically run the integration at that specified
date and time?
Any workarounds, ways and step by step procedure on how to achieve that,
would be very very great.
The IM user guide covers that in detail. If you don't already ...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <firstname.lastname@example.org>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...How to do a mass download of names to Outlook address book
I have about 800 names and email addresses in an Excel
spreadsheet that I need to add to my Outlook address book.
Can anyone give me a hint on how to do this?
Save the Excel Spreadsheet as a CSV (Comma Separated Value) file and then in
the Address Box, Click, File, Import, Other Address Box, then click Text CSV
file and browse to it.
"Hal Segal" <email@example.com> wrote in message
> I have about 800 names and email addresses in an Excel
> spreadsheet that I need to add to my Outlook address book.
> C...graphing data
What is necessary to graph the number(s) in cell(s) when the number in that
cell(s) is/are generated from a formula in those cells?
Graph them in exactly the same way that would have done if the numbers had
been typed into the cells.
"mikaman" <firstname.lastname@example.org> wrote in message
> What is necessary to graph the number(s) in cell(s) when the number in
> cell(s) is/are generated from a formula in those cells?
...Copy filtered data
Let's say I have data in A1:Gxx. Now I use Autofilter to find all rows which has a "2" in column C. Let's say it leaves rows 1:4 and
8:10. Now I want to copy the filtered data in columns F:G and paste the values (not to an empty range which is easy) but to the same
cells in colums D:E.
Try Advanced Filter, excellent tutorial here from Debra Dalgeish, owner of
"Hans Knudsen" <Hans.Knudsen@mail.tele.dk> wrote in message