vba macro day 2
Yesterday we had the folowing below conversation, but I am confused what you mean by your second part that I need to handle the argument something like............
Public sub workbook_open()
but you would need to handle the argment, something like
Sub Macro18(sh as String)
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"itsme" <itsme@discussion...Build is slow.
The environment is 6.0 vc++.
When one DLL has 1700 source codes.
Build is slow.
debug start takes time.
Please teach a good solution.
Buy a faster computer. ;)
"teratera" <firstname.lastname@example.org> wrote in message
> The environment is 6.0 vc++.
> When one DLL has 1700 source codes.
> Build is slow.
> debug start takes time.
> Please teach a good solution.
"teratera" <email@example.com>...List Listbox items in column by macro
Hi all, I got two listboxes on a spreadsheet and in those listboxes I
got data like (see below)
I need macro on a button which should match listbox1 items with
listbox2 items and then list matched items one time in column A and
list unmatched items as normal in column A. So the result in column A
should look like as below
Please can any frined can help me on this.
...Macros with unknown table lengths
I'm relatively new to macro programming with excel, and I'm having
trouble dealing with variable length data. Every week I get a
spreadsheet that has data in columns A through J, and rows 1 through
somewhere around 3000 plus or minus a hundred or so, and 3 sheets. I
need to take the data from sheets 2 and 3 and append them to the
bottom of sheet 1, as well as put a formula into column K and copy it
down to the end of the data. When I tried to record a macro doing
this, it always saves a cell address for the last row in this
particular spreadsheet, so it won't work on next wee...Slow Navigating Folders for attachments!!
Using Outlook-2002. Recently, since about a month ago, when I try to save
attachments or attach files to messages and attempt to navigate to the
folder of interest (after I click on the attach button), navigation is VERY
slow - like if I click on a sub-folder, it may take over a minute for that
sub-folder to open. It doesn't matter if other apps are running, or if I'm
just changing to a different drive, or to the root directory. Everything
It renders it useless :-(
...How to apply a macro to a protected cell
In Excel 2002/2003 when you protect your sheet you have some options.
You can also protect your sheet with code like this
all macros are working then (97-2003)
.Protect Password:="ron", userinterfaceonly:=True
Regards Ron de Bruin
"greensl" <firstname.lastname@example.org> wrote in message news:BE149290-3561-48C2-83A7-FF5EBB1EFA24@microsoft.com...
...Unable to record macro
When recording a macro an 'Unable to record' message appears when I try to
record a formula. Here is the formula that seems to cause the problem:
Anyone know why this should happen?
Thanking you in advance.
Sorry that is a typo error, even with the correction the error message still
"PC" <p...Add column to database diagram with macro
I'm trying to write a macro that will automatically add a column (with
a specific name, data type, and notes) to the selected table in the
I tried recording the macro, but nothing got added to the code.
Any ideas how I would do this?
the problem is that the database tools are add-ins and the code is closed.
<Ben.Bawden@gmail.com> wrote in message
> Hi all.
> I'm trying to write a macro that will automatically add a column (with
> a specific name, data type, and notes) to the sele...Word 2003
It takes sometimes 10 seconds when I press crtl+c (copy) or crtl+x (cut) in a
text inside Word 2003. Even if it is only one word it takes a lot of time
just to copy or cut or paste it.
That does not happen in Excel or Power Point only in Word.
Please can anybody help me to solve this very annoying issue?
Thank you very much indeed,
From reading other postings on this forum, it seems that poor AddIns can
cause this latency.
I have also found that doing a clean up of the temp files seems to help as
Hope this helps
...Slow Slow Slow
When I click between different emails in my inbox, it takes ages for it to
appear on the display. My internet connection is super fast. I have recently
had to reinstall Office XP and I think a setting has been changed somewhere.
I have an anti-virus but it never slowed it down like this before. To put in
perspective, I've had 120 spams today and its took 37 minutes to delete them
because of this problem. I have ran a virus check and its fine. Any thoughts
on a registry tweak??
Carl Sheldon <email@example.com> wrote:
> When I click between differe...slow loading, slow updating
I am using MS Money in a non-standard application.
I am maintaining ledgersin checkbook fashion for 100 accounts, each set
up as a separate checking account. Each of those has 3 transactions set
up as automatic bill pays. Other than that, there are very few entries,
averaging 6 per year at most.
The program takes about 5 minutes to load.
Corrections, such as posting bill payments, takes approx 10 seconds to
cycle through: Open, edit, enter, wait........ Open, edit, enter,
I am not doing any online updating or anything like that.
Is there anything I can do to speed this ...Automatic Reply #2
I am trying to set up an automatic reply to e-mails while
I am out of the office for Microsoft Office 2000. Could
someone please tell me how I can do this. Thanks!
Do you connect to an Exchange Server? If so, select Tools | Out of Office
Assistant. You need to make sure your Exchange administrator has enabled
automatic replies to the Internet for this to work with messages coming in
from the outside, however.
If you don't use Exchange Server, check out this article:
PATRICK REED [Outlook - MVP]~~~~~...BMP to JPG #2
My sofware is storing screen snapshots to a BMP file. I would like to
transform BMP to JPG to save disk space. Does anyone know of some good code
that can transform bmp to jpg?
there are many Freeware Libaray available for doing this, you can check
Visit me at http://alok.bizhat.com
"I think this will Help"
"Oyvind Hansen" <firstname.lastname@example.org> wrote in message
> My sofware is storing screen snaps...Last Date Included in Campaign #2
May i please seek some clarification on the purpose of this field and when
it is updated and not updated,
I would appreciate some advice.
This field is automatically set to Today's date whenever a Campaign Activity
is distributed to the Contact/Account/Lead in question.
So when a Phone Call Campaign Activity is Distributed to a group of 5
Contacts - each of the 5 Contacts 'Date Last Included in a Campaign' is at
that point set to Today's date.
Kind Regards, Paul McQuillan.
"Snow White" wrote:
> May...Macros not displaying in Run Macro dialog box
I have an Excel 2000 spreadsheet that when opened in Excel 2003 the macros do
not appear for selection. Everything is fine when opened with Excel 2000.
I've set the macro security to medium and low, but no avail. Any ideas?
You're positive that the workbook opened in xl2003 (successfully)?
And you don't have "macros in" pointing at the wrong workbook?
(Maybe changing "macros in" to "all open workbooks" on that dialog will help.)
> I have an Excel 2000 spreadsheet that when opened in Excel 2003 the macros do
> not appea...Unexpected behavior #2
I am having a unique intermittent problem I am hoping someone can hel
me with. I have a large Excel VPA application that has several button
on the "Config" sheet that execute different VBA scripts. There ar
also a large number of drop down list boxes. On a fairly regular basi
an unusual behavior occurs, when you click on a drop down box one o
the buttons (always the same button) magically moves to the drop dow
box that was clicked. Once this happens the first time, every time yo
click on a drop down box the button moves to that box. You can clos
and reopen the file and it will conti...CRM Update Rollup 2 05-16-07
I noticed some CRM blog posts that slated a release for the 2nd update rollup
yesterday. Obviously (and expectedly), this has been delayed. Anyone out
there know when we can expect to see this?
No details yet
Microsoft CRM MVP
"MD" <MD@discussions.microsoft.com> wrote in message
>I noticed some CRM blog posts that slated a release for the 2nd update
> yesterday. Obviously (and expectedly), this has been delayed. Anyone o...Slow Viewing e-mails
Suddenly it's very slow to view e-mails in Outlook 2002.
Any kind of e-mail, with or without attachments. It
worked fine until a few days ago. Anyone have any ideas?
Found an answer to the problem in another post. Simply
turning of the Messenger Integration fixed everything.
>Suddenly it's very slow to view e-mails in Outlook 2002.
>Any kind of e-mail, with or without attachments. It
>worked fine until a few days ago. Anyone have any ideas?
On 25 nov 2003 Johan wrote:
> Found an answer to the problem in another pos...LookUp in macro?
I'm building a database to process sales leads and orders. Data from
the leads AND orders are stored in the same table ("Orders"). I use a
"Lead" form to add and edit the lead information (which happens to be
only a small part of the information used in a potential order) and
this goes into the "Orders" table. When a lead turns into a sale,
I've built a macro (button-activated from the "Lead" form) to open the
"Process Sale" form so I can enter the rest of the sale information
into the "Orders" table.
Every order has an au...User Authentication #2
I am having problems with one of my users. When he was using CRM he jsut
left his desk for five minutes came back and saw that he was having an
"Authentication Error". Since then I have reassigned roles and even
deactivated and activated his users. Unfortunately the problem continues.
Please urgently respond with solution.
did you anything with his account in AD?
Please also be more specific about error details - which version of CRM
are you using, set show developers error on, etc.
Faiz Amir wrote:
> Dear All,
> I am having problems with one of...Formula to count no. of months between 2 dates
What is the formula to display the number of months between 2 dates?
Have a look at this site:
„Melissa” ezt írta:
> What is the formula to display the number of months between 2 dates?
On 23 Mar, 08:27, Melissa <Meli...@discussions.microsoft.com> wrote:
> What is the formula to display the number of months between 2 dates?
I forgot to mention I am using Excel 2000.
I us...why GetFieldValue() is so slow
I get connected a vfp6 dbf file, and the total record number is about
50000, I want to export specified field value ( most of their type are
string), and the result is correct, but it works toooooo slow, and I
find the function GetFieldValue takes most time.
my code is:
for(index=0; index < m_ListDest.GetCount(); index++)
if(strVal == "" && m_isFilter)
...Outlook 2003 Pro with XP Pro Too Slow with McAfee 2004
I just bought a new high-end brandname laptop with XP
Pro. In it, I:
- installed Office 2003 Pro,
- installed McAfee Internet Security Center 6.0 2004
(including Firewall, AntiVirus, Privacy Service,
- downloaded and installed all latest MS and McAfee
by the books. Hoping to lessen intra-computer response,
I opted out some sub-features in McAfee. The
installations were easy. Without McAfee, Outlook 2003
was fast, reliable. After installing and working with
McAfee, Outlook 2003 is miserably slow in most operations
(send/receive, clicking on ema...macro query disable download failure
I have a macro which retrieve different queries from the web.
It happens that a resource at that moment isn''t available.
If this happens the querie gives a message which said unable to open
This message i don't want to display (other routines herefor).
I use "Application.DisplayAlerts = False" but this won't help.
Can anybody help me with this problem.
...lost news command #2
I was trying to set up outlook for newsgroups. When I tried to add news to
the go menu it dissapeared and I cannot seem to get it back. I ran detect
and repair and also tried to reset the toolbar, but nothing helped, and news
is still missing from the go menu customize box.
Outlook 2003 11.8118.813 SP2. I woulld like the option of launching it from
the go menu, but the command is lost. Could you give me other examples of
launching the news reader.
"Russ Valentine [MVP-Outlook]" <email@example.com> wrote in message