copy comments to word
I'm having difficulties writing code to copy comments to word.
I'm confused on the "Selection" and/or "Range" Values and how to use them
in this situation.
I need to be able to highlight a range of cells in excel...
Then, copy all the comments in the selected area to a word document.
I have ran across code that will copy the whole workbooks comments but that
is not needed for this.
Thanks for all the help.
The following code will copy the comments in the selected range to Word:
Sub CopySelectionCommentsToWord...Set Me.hiddentxt some value for Button on form txtdatabox exit eve
Hi O' knowledgeable fundis,
I would like to place an indicator value in a hidden txt box on my form in
the "On Exit" event of a field so that I can know which button triggered the
exit. Is this possible as I can't seem to find a way.
Any method of recording that activity would be great.
You have to be a little more specific. You want to trigger an event on the on
exit of a textfield and want to know what triggered it? Probably the on exit
event i presume.
But if i want to know which button was pressed or which control did
something i record it using the m...Get Month name from Date value in cell
I'm trying to get the month from a date representation as follows ...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 And Target.Cells.Count = 1 Then
Dim strDate As String
strDate = Format(Target.Value, "mmmm")
Range("A20").Value = strDate
The error I am getting is ... "Object Required"
on the ... strDate = Format(Target.Value, "mmmm") ...
by which I'm guessing Target.Value is not being seen as a date type ...
A...Can Excel send automaticaly e-mails depends on cell value
Hello, I have question about automaticaly sended e-mails by Excel. If I have
a some worksheet which is analyzing data, can Excel send automaticaly e-mail
to someone if result of analyze is wrong (out of limit for example). It means
Excel will send e-mail depend on cell value.
Thanks in advance. (sorry for my english)
You should be able to acheive your request without too much trouble i
you are familar with vba.
You will need to setup a macro to check the cells value and then us
excels mail tools to send the email.
Look here for some very good example
Say I have a picklist called 'Type', that has 10 values. When I open Account
ABC the Type = Customer.
Now I delete the value Customer out of the picklist.
Then when I open Account ABC, the value is removed out of the picklist BUT
all the accounts maked Customer now have a blank/null value displayed as the
picklist value. So the text label for Customer is gone.
However, if I query via Adv Find and use the integer value that represents
Customer, all the accounts still return.
Is there any way to delete a value out of the picklist and still keep the
text that was deleted as the...Outlook isnt saving my sent items
I have just noticed that Outlook hasnt been storing my sent items for the
past 3 weeks, does anyone know why this might have happened?
Thanks for your help
Check Tool/ Options / Email options
The check box "Save copies of messages in sent items
folder" must be checked
>I have just noticed that Outlook hasnt been storing my
sent items for the
>past 3 weeks, does anyone know why this might have
>Thanks for your help
Thanks for your reply,
but 'Save copies of messges in...Deactivate field based on other field value
What I need to do is have some of the fields on the form deactivated (grayed
out) untill the value in the preceding field is a certain value or text. I
can't use conditional formating because I would need to use the values in the
object fields to be the conditions. In this case I need a the value of a
different field to be the condition.
What is the best way to do this.
Thanks in advance.
YOu could place code in the before or after update to enable and disable the
I would have one function that updates all the forms controls and have each
of the other controls call the o...Picture of Item
Hi, We would like to store a picture of each item against the item code in GP
IV. So that when ever the Item is entered, a popup screen to show the image
so that users are confident that they have made the right choice. What would
be the easiest way to do this. Any ideas based on similar engagements would
I am not sure if there is a way to accomplish this without modify the system.
I have modified the Payable Transaction Entry screen to display bitmap
images of scanned invoice for the selected Invoice number.
Unless there is another way to do it, this process should not...Home inventory reporting
Does Money 2006 have any reporting capabilities for the home inventory
module? I've checked Money's home page, the faq for this group, but have not
found anything at all.
"Tom" <t.g.mcclellan at gmail.com> wrote in message
> Does Money 2006 have any reporting capabilities for the home inventory
> module? I've checked Money's home page, the faq for this group, but have
> found anything at all.
It does have a home inventory module. I don't use...ensuring two fields do not have same values
Good morning all,
I have a table that has a unique identifier key, ID, but there are two
other fields PNID and PLID that cannot be the same in more than one
ID PNID PLID
1 5 5
2 5 3
3 5 5 duplicated with ID = 1, so not
Is there any way to check for these inconsistencies within the table
properties, or would I have to create a query to ensure these
duplicates are not present? PNID and PLID are not keyed.
thanks for the help
Create an index on PNID and PLID and set its Uniq...Inventory price problems
A recent problem has ben found with inventory pricing. When a retail price is
changed, all items in all departments are changed to the same price. When
viewing the prices in inventory list, they are correct. Opening the
properties window shows a different price.
Oh - your issue reminds me of the really wicked pricing issue in 1.3.1003.
This issue effects both HQ and SO.
When you look at your item list - you see different pricing, but if you open
an item, modify (or maybe not even modify) pricing, then OPK to save and open
the next item, the next item will pick up the prior's price...copying attachments to a folder
Is there an automatic way to achieve this - rather than selecting each
attachment from a set ofmessages and copy and paste them to the
destination?? TIA //al
al jones <firstname.lastname@example.org> typed:
> Is there an automatic way to achieve this - rather than selecting each
> attachment from a set ofmessages and copy and paste them to the
> destination?? TIA //al
What version of Outlook? In OL2002/2003 I believe you can open the message,
select File | save attachments.
On Sun, 4 Dec 2005 00:33:31 -0500, Lanwench [MVP...Script running other scripts return values
I've got series of VB scripts that I run manually buy clicking on them,
Can't I have one script that runs all of them? I would want to check a
returned variable to is one script has a failure, the later one won't get
executed. Can't I just use the .Run method? How do I return a value from
one script, and read it in the other script?
"Bill" <email@example.com> wrote in message
> I've got series of VB scripts that I run manually buy clicking on...new vets-100a form
There is a new vets-100a form that is due in Sept 2009. GP currentyl
supports the old vets-100 form. Is GP going to supoprt the vets-100a form?
...Offline inventory and Physical Inventory
I assume that any inventory that is "Offline" in RMS can
be ignored when doing a physical inventory. Can anyone
The off line inventory is separate from the quantity on hand, so yes - it
should be ignored for the physical count.
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information
"Charles" <firstname.lastname@example.org> wrote in messag...Delete values and preserve formulae
I've made manual alterations to a Summary sheet, in the form
of inserting formulae. The sheet is worked on by an addin.
The alterations are to cells NOT operated on by the addin.
Say the range containing new formulae is M1:P54.
How do I clear values in this range, but preserve the new
formulae, before saving the sheet back to the original file?
My idea is that the addin will run as normal, and produce the
Summary sheet. However, for certain files, the Summary
sheet will contain additional formulae which will take the
values computed by the addin and do other things.
Outgo...better way to copy data from an embedded html box
i have some fields from a browser window pasted into excel. the become
shapes when pasted into excel. i give the shapes names starting with box 1
to box ?, depending on what's been pasted into excel.
when one shape is selected, it shows the following the the formula bar:
right now i have some code that will copy the data from the field:
With ws.Shapes("Box " & i)
SendKeys "^A", True
SendKeys "^C", True
this wor...Finding the low value of a range of values
i have the formula below to find the high value(columnC) between tw
times as shown in the 1 hour table at the bottom.
How would i need to modify this formula to search for the LO
value(column D),just swapping MAX to MIN and altering the references t
the C column to D is not enough,what else do i need to do?
TIME OPEN HIGH LOW CLOSE
15:50 1.8394 1.8396 1.8393 1.8396
15:45 1.8396 1.8396 1.8393 1.8394
15:40 1.8389 1.8396 1.8389 1.8396
15:35 1.8389 1.8391 1.8389 1.8389
15:30 1.8385 1.8393 1.8385 1.8389
15:2...ListBox do not display items from linked xls table
Please advise what may be wrong, access stopped to display items from
linked excel table?
In the same time, if I link access table it works properly.
I think it became after recent october updates, but I am not shure.
Thank you in advance
On Oct 18, 11:17 am, Sergey <sdol...@gmail.com> wrote:
> Dear Colleagues,
> Please advise what may be wrong, access stopped to display items from
> linked excel table?
> In the same time, if I link access table it works properly.
> I think it became after recent october updates, but I am not shure.
> Than...Copying FRx reports company to new machine
Just re-installed mas90/FRx on a new machine, but can't figure out how
to bring over my company, named VSI. Where are the files, or how do I
tell where it's located in order to hook in all the work I've done to
the new installation of FRx???
First, you should have just cut out the part about MAS 90. Yuk. :)
Do you still have access to the old machine? Without being able to log into
FRx from an existing machine, it's going to be difficult to determine where
the files were/are located.
Do you know if the files were installed on the c drive of the old machine or
on the net...Files in folder Windows.old in Vista
I have installed Ultimate on a Business version and then received the
Windows.old folder. I want to delete it but have found same working files in
old path than in the new. It appears that Windows updates the working files
in both folders. Are they mirrored or copies. I changed the name of one file
in old - corresponding file in the new folder received the same name. If I
delete files from Windows.old will they be deleted from current folder too?
"HBj" <HBj@discussions.microsoft.com> wrote in message
...home inventory software
does microsoft money contain a home inventory portion.
alone the same lines: does any of the quicken financial
software packages offer the home inventory portion.
home inventory is in money standard 2003 but looks like
2004 does not contain this feature. there might be more
free options with taxcut/turbotax purchase after first of
>does microsoft money contain a home inventory portion.
>alone the same lines: does any of the quicken financial
&...quantities on order by Item by store from HQ
We are currently on 1.20157 of RMS. I have 5 locations on Store operations
and HQ. We need to be able to see quaintly on order by store, by item.
Currently RMS lets you see the total on order for an item, but not how much
is on order for each location. Is it possible to get this information?
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...Total Account Value Makes No Sense
I have two CDs recorded in Money 2005 Investment Account. One CD is worth
about $11,000, the other about $29,000. To me, that means the "Total Account
Value" listed should be about $40,000.
Instead, I see $69,000. This is the sum of the smaller CD plus two times the
amount of the larger CD.
...Keyboard Shortcut for "Paste Values"?
Please help - the keyboard shortcut for "Paste" is
"CTRL-V". What is the shortcut for
"Paste Values" [i.e., the equivalent using the mouse to
click "Paste - Paste Special - Values - Ok"?]
I do not know one but there is a button for it.
Right click toolbar, customize, Commands, Edit, Paste Values (icon)
"Sam" <Sam@discussions.microsoft.com> wrote in message
> Please help - the keyboard shortcut for "Paste" is