Close various modules/codes windows
Whenever, I open the VBE (Alt+F11) I find most of the code windows already
opened and have to close each and everyone by entering Ctrl+F4 and finally
opening a single module on which I seek to work upon.
Any guidance, help and relevant idea by u experts in this regard shall
highly be obliged.
Thanx in advance,
--How many open VBA projects do you see in Project Explorer?
--Check out whether you have any projects getting opened during startup. If
so remove them from your Book.xlt in XLSTART
XLSTART folder usually located at
C:\Documents and Setti...Code to save Word-document do not work properly
I have this code:
Dim Wdapp As Object
Dim Navn As String
On Error Resume Next
Set Wdapp = GetObject(, "Word.application")
If Err.Number <> 0 Then
Set Wdapp = CreateObject("Word.Application")
For Each c In Range("A2:A200")
If c.Value = "" Then Exit For Else
Navn = c.Value
.... A lot of code for replacing bookmarks
Navn = Navn & " " & Date & &qu...How to view the form in GP afterchunk code is placed in GP folder?
After completing the chunk process, let me know how to view the form
prepared by us which was integrated to GP. In security options, I am able to
see the form prepared by me. But how to open the form prepared by us from GP.
Please send me info ASAP.
Thanx in advance,
Try adding your form to shortcuts.
> After completing the chunk process, let me know how to view the form
> prepared by us which was integrated to GP. In security options, I am able to
> see the form prepared by me. But how to open the for...event-driven code
Could someone help me to understand how to approach Event-Oriented
programming. I wanted to write an Example program using a row of three
buttons on top, and a row of three buttons on bottom. Only one of the
buttons on each row would be used, but there is a choice of the three for
each row. And there is one Static Text Control for each row that prints a
number that is assigned in each button function when any of the buttons is
clicked. Then the chosen number from each row is added to the other to get a
result that is printed in another a third Static Text Control. And this
process is initiat...Is there anyway to move a trendline behind the data series?
I'm using XL2002 with Windows 2000. I have a chart that I added a
trendline to, but it obscures part of my data series, is there a way
to move it behind the data series? If so, how? I can't figure it out.
You can use a thinner line, which would cut down on the obscurity of the
data. Or you could get the parameters of the curve fit, either from
LINEST (see Bernard Liengme's site for assistance if needed), or by
extracting the coefficients from the trendline equation (see Dave
Braden's technique). Use these parameters to determine X-Y data for
...Can't move emails to parent folder
I have a number of Outlook folders where I move messages to keep
organized. One of them is for client messages. It has several
subfolders. The structure looks like this:
Smith (contains 6 emails)
I was recently working on the Smith case. I moved 6 emails from the
inbox to the Smith folder (under Clients). I do this when I am working
on a case. When I am done, I move them to the Clients folder and
delete the case folder.
For some reason, Outlook ...Outlook Rules to move messages
I have been asked what happens if 2 rules that move a message to 2 different
folders are valid for more than 1 email.
rule 1: move an email with manchester in subject to manchester folder
rule 2: move an email with liverpool in subject to liverpool folder
what will happen if my email contanis both manchester and liverpool in the
You'll end up with one copy in the Manchester folder and one copy in the
This is why sorting your rules, settings exceptions and setting the "stop
processing rules" action is so important.
For ...Moving mailbox between 2003 Servers
Recently I moved a mailbox between 2 servers in the same
Exchange site. The mailbox moved rather quickly, showing
a status of 100%. However in the Task Wizard "Task in
Progrss" the 'State' column shows "Saving Changes to the
Directory" and this will run for hours, or days. The
mailbox appears to be on both servers simultaneously with
no properties available for either. Previously, I had to
stop the process, recover the mailbox on the source
server, Exmerge the mailbox data, blow away and rebuild
the account and import the data back in. Now, it's
hap...how do I make more then one line of pasted text not move to one cell?
Hello. How do I make one block of text I pasted not go in to 2 cells and if
I want to merge those 2 cells together in to one cell let's say merge 5d in
to 4d, is that possible? Thanks. Oh, I'm visually impaired so is this
possible with the keyboard? Thanks.
If you click on the cell but paste into the formula bar at the top
The whole text will go into the cell
On Wed, 26 Jul 2006 03:57:49 +0100, marrie <email@example.com> wrote:
> Hello. How do I make one block of text I pasted not go in to 2 cells =
> and if
> I want to merge those 2 cells together i...Change Query Object's Criteria via code
Let me try again:
TIA very much:
Is it possible to change and existing Query Object's criteria via VB code??
If so how might it be done?
...RECEIPTS: Hide up item look up code in receipt
My buyer and I are wondering, how would you change the receipt to
hide/not show the item lookup code in the receipt.
Any help would be appreciated.
its very easy to do so, make a backup of receipt.xml file under:
C:\Program Files\Microsoft Retail Management System\Store
Operations\ReceiptTemplates or whereever you installed the program.
Then open the receipt.xml file in notepad and find the
"Entry.Item.ItemLookupCode" and just cut from whole code whereever it
appears and then save the file. then again to to SO Manager program> Database
> Regi...cannot move mail to PST in outlook 2007
after upgrading to outlook 2007 from outlook 2003 i can no longer move any mail to my PST folders. i get message "Cannot move the items. The item cannot be moved. It was already moved or deleted or access was denied.". i can create a new PST folder but still cannot move any messages to it. Any help is appreciated.
EggHeadCafe - Software Developer Portal of Choice
Custom Self-Expanding Multiselect Winforms ListBox
You can't upgrade Outlook without corrupting your pro...Cant find the bugs in the code
I am grateful to any help and suggestions what to do!
Here ar the subs I expect to make the users able to copy and paste between
and within sheets. It doesn't work properly. Sometimes when I change som
parts, it works partly, but never completly:
- Not allow draganddrop
- On every change of a range or cell an new fresh format template sheet
be pastespecial(xlpasteFormulas) to be able to hadle merged cells in
-Not create a loop
- Keep the sheet1 protected
Please - what is wrong? i have tried to use less selection & activate code,
but i could't make it right eit...Source code of MS CRM
I have installed MS CRM 3.0 server on my server machine. I just wanted to
know that whether this installation provides me the COMPLETE source code of
There are some aspx files, but there is a little source code in them. If I
want to change something in the application beyond the limits of
customization, how can I do that? I know that it is not supported, but still
if I have to do it, is there any way to get the COMPLETE source code of CRM?
Thanks in advance
Source code of MS CRM is not publicaly available. It is the property of
Microsoft. Only aspx file...How do you create bar codes in excel?
I am trying to setup a spreadsheet that will print off bar codes. I need
them for an inventory tracking sheet.
Does any one know how to convert a part number into a bar code? I did it a
long time ago!!
You need a barcode font
remove CAPS in email address
"Bill G" <Bill G@discussions.microsoft.com> wrote in message
>I am trying to setup a spreadsheet that will print off bar codes. I need
> them for an inventory tracking sheet.
> Does any one k...mouse pointer in excel combo box
When using the combo boxin excel, when i click on the box to select options
from the draw down list, the pointer change to a hand icon ie like for an
How do i change the hand sign to a normal arrow icon ?
I've tried changing this in control panel under mouse pointer but this only
change the icon for windows ie when i clink on an internet link. it does not
change the hand icon when i use the excel combo box
...Event 1521 roaming profile
Upgrading a user to a new pc. The OS is changing from xpp to win 7 pro (SBS
2003 is server OS). Folder redirect is working for my documents. However
his roaming user profile (desktop) is not coming over. It goes to a default
local and doesn't save changes. The event is coming up as 1521. From what I
can tell DNS is working just fine. So it must be something with the user
profile. Anybody have ideas on what is behind this, and what must be done to
Thanks for your post.
Frist, I would like to explain the combination of Roaming User Profiles with...moving Exchange to another drive
I'd like to move Exchange 2003 from the C: drive to the D: drive.
How can I go about doing this?
If you mean the executables you'll probably want to do a reinstall. If you
mean databases and log files you can just change the path within Exchange
System Manager. For example, properties of the Storage group will let you
change the log file path.
"Glenn" <firstname.lastname@example.org> wrote in message
> I'd like to move Exchange 2003 from the C: drive to the D: d...Mouse flicker problems in MS Word, ,running windows 7.
I recently installed MS Office Home and Student on a windows 7 operating pc -
but everytime I start word my curser flickers in the screen area and i can't
click right or left. I don't know what to do to fix this problem. Any ideas
would be appreciated.
It isn't a Word problem, but my suspicion is either the printer driver is
corrupt or incompatible or missing. Make sure that you have the latest
driver for your printer and then delete and reinstall the printer.
Terry Farrell - MSWord MVP
"PR100" <PR100@discussions.microsoft.com> wrote in messag...moving outlook to new PC 'Operation Failed'
My new machine came with Office 2003 and outlook. I did
not want to buy this version so I uninstalled it and with
great difficulty, it got it installed. Now I can send
mail but when I try to receive mail, I get Operation
failed. When I set up the email account and I did a test
settings, The test email is sent but cannot come back
because opf the error. An suggestions?
...Excel crashing when copying formula with a wheel mouse
Does anyone else have this problem...
On utilising the edit formula = to place a cell address from one worksheet
into another I have no problem .... until I move my mouse wheel ... this
then causes a complete crash of excel losing all unsaved data.
If I resist the urge to touch the wheel then no problem ...it seems to
happen after about 2 - 3 successful "Copies"
It maybe a mouse driver incompatibility problem ..
" Live each day as your last , one day you'll be right ! "
While I...mouse wheel in VBA editor
Mouse wheel will not scroll up or down when I'm editing
code in the VBA editor for Excel Office 97. Wheel works
perfectly in every application except this one. I've
installed latest intellipoint drivers. Running XP Pro.
This might be the problem??
If you have the 5.0 drivers that might be the problem. I tried them but
went right back to the 4.x version, mainly because of the VBE mousewheel
The same thing happened to me - if you roll back to IntelliPoint 4.x as Jim
suggests, you should be fine.
MS MVP - Excel
www.lo...Moving Exchange 5.5 from NT 4.0 to a 2000 Member server without change the server name
Has anyone ever moved Exchange 5.5 SP5 currently running on NT 4.0 Server,
SP6a to a Windows 2000 Server, SP4 using the same computer name?
Can it be done?
Is there any documentation about how to go about it?
Try this article
> Has anyone ever moved Exchange 5.5 SP5 currently running on NT 4.0 Server,
> SP6a to a Windows 2000 Server, SP4 using the same computer name?
> Can it be done?
> Is there any documentation about how to go about it?
>...strange mouse behaviour on dialog called frm a tree
I have implemented a Tree in an SDI application and have implemented
functions to add/ delete/ rename nodes of the tree. When I have to
rename a node, I call a dialog to input the name from the user and make
the changes thereafter.
Everything worked fine when I call this dialog on rightclicking the
root or its child.Problem comes up on rightclick of a node on the third
level.The problem that I am facing is that when I call the dialog to
input the name on right click of the child of the child of the root,
the mouse does not seem to work on the dialog. It can still be handled
using the keyboard...Recurring Transfer on Event (like a trigger)
I've been using Microsoft Money for a few years now (currently on
version 2006), so I'm pretty sure this feature doesn't exist... but I
keep thinking how nice it would be and I haven't seen any posts on it,
so I wanted to bring it up.
It would be nice if there were a way to trigger a transfer on an event.
For example, I would like a recurring notification to transfer funds
out of my checking account into my savings account when my checking
account reaches a certain balance. Right now I try to estimate when
that'll happen and use one of the limited 'Frequency' op...