Adapting recorded macro to different amount of rows
If you record a macro for a regular process but you do not know how many
rows of data will be needed each month how do you change script to cater for
say a total being needed at end of the last rows.
iLastRow = Cells(Rows.Count,"A").End(xlUp).Row
Cells(iLastRow+1,"A") = ... your sum formula
(remove nothere from email address if mailing direct)
"yetti" <email@example.com> wrote in message
> If you record a macro for a regular process but you do not kn...Editing Text when using Publisher as a web page...
I'm using Publisher to document the status of current taskings in the office.
I'm trying to ger Publisher to allow people that pull up the web-page to add
and edit text on the web page so we can keep everything up to date. Right
now, someone has to come to me and tell me the changes, then I change the
info in the Pub doc, then I have to repost the web-page. Is there a way for
people to edit the text on the web-page when they pull it up. I have text
boxes in there now that people can edit, but the text doesn't update when you
close the page and re-open it. Please Help if you ...Custom Format #4
I am trying to do a custom format so that what is entered in the cell will automatically enter a dash.
All they will enter will be:
What format do I need to enter.
this is not possible as you don't enter a value. But if the user enter
(without a leading character) you could use the custom format
> I am trying to do a custom format so that what is entered in the cell
> will automatically enter a dash.
> All they will enter ...Installation of customer Microsoft CRM 3.0 for Outlook
Hi,I have a machine which belongs to the same domain that server CRM3.0, I
reached with the session administrator,
I launched the installation of customer Microsoft CRM 3.0 for Outlook an
error message posts myself:
"the user who carries out the program of installation does not belong to the
in spite of as I have say I reached with the administrator.
Did you logon to the local workstation as a local administrator? Or did you
logon to the domain? (When logging on you are able to select the domain from
the drop-down list).
Merijn van Mou...SQL Server 2000 Standard Edition vs SQL 2000 Personnel Edition
I am using SQL server 2000 standard Edition sp3 with Gp 9 Sp3, I am planning
to move GP with database to new server different hardware.
can I use sql 2000 personnel edition sp3 or should I use same old version.
I hope u understand my question.
Generally speaking, personal editions are not robust enough to support a
product like GP. I would stay away.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"MK KSA&quo...editting auto recovery
is it possible to change the auto recovery directory just for one document
and is also possible to ensure that the auto recovery file is not deleted
after the file is closed?
AFAIK this is not possible. But you may consider using the following
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
> is it possible to change the auto recovery directory just for one
> document and is also possible to ensure that the auto recovery file
> ...Missing News Button
Using MS Outlook 2003 I tried to place the news button in the GO menu.
Following the instructions in Outlook, I dragged the News button to the Go
menu. The news button was placed there, worked once, and now is missing. I
checked to see if it was located somewhere else but it is not. It does not
show up now in the Customize-Commands-Go commands box. Any suggestions?
To get the News command back, go back to the Programs tab in Control Panel |
Internet Options and change the default newsreader to Outlook Express. If
OE prompts you to make it your default newsreader the next time yo...Access 2007 Command Button no working
The following code for my "OK" command button, use to work in access
2000 but is not working in access 2007.
Private Sub Command13_Click()
On Error GoTo Err_Command13_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Data Input Form"
DoCmd.OpenForm stDocName, , , stLinkCriteria
When I click this button it is suppose to return a "data input" form,
but nothing happens when I click this button. ...Customize Outlook Today
I had some one ask me to fix their "Customize Outlook Today" as it had stopped
working. In Outlook 2000 it is the button near the top right of the page you get by
pressing the Outlook Today Icon in the Outlook shortcuts toolbar.
After trying for a while, I then tried to see if it worked on My PC... It didn't,
and nor did it work on ANY of the half dozen I've tried since. I know it DID work at
some time in the past,
but some Windows update or IE patch must have broken it.
I get the same result with Outlook 2000, SR-1 and SP-3 and both on Windows 98 and
An...template edit question, add more? edit template?
Operating System: Mac OS X 10.6 (Snow Leopard)
i'm using a resume template and it's beautiful, but only allows four job positions before it moves one the education, etc. <br><br><i>guess theres a way to do it on the pc version, but with mac, how do i insert an addition formatted block? it will only let me work within the template currently.</i> <br><br><i>hope that makes sense, thanks for the help!</i>
Mac or PC makes no difference � it's a matter of how the template is
constructed. With...BOM & Edit List
I created an Assembly transaction and printed it from the Assembly
transaction entry window before posting it.
In the posting journal that prints it does not print the Assemble cost,
extended assemble cost, Unit cost of the components and the extended cost.
But if i post the transaction then the same posting journal is printed with
Why does it not print?
Please let me know
It only pulls posted costs, like other Great Plains edit lists including
items. You will need to modify the report to include costs.
> I created...Command button filter on a subform
I have a form which is the main form frm_Projects bound to
I have subform on the main form subfrm_Risks which is bound to
The tbls are linked by field ProjectID
I would like to put a command button on the main form to filter by
month on the subform using the subform control Updated
I would like to filter by month...so I need to filter between dates in
My programming is virtually non-existent and I have tried finding an
anwer to this query everywhere but can't find one that works for
me.... please help! Many thanks
Okay, lets assume you are showing the ...How to edit entitys attributes directly?
I messed up with entity mappings and ended up with errror: attribute not found.
How can I manually remove attribute from entity?
Tried export -edit -import but it seems not to be the right way.
You will first need to remove the "bad" mapping that you created. Since it
is referncing the field, you need to do that prior to trying to remove the
field. You also need to remove it from any forms & views that may be
The customization Import will not remove fields (as you have discovered).
That is done as a safety feature to rpevent accidental loss of data (ima...Customization of CRM Activities List Page...
I want to display the creation date time column on Activities List page
in MS CRM. I didnot find any customization available for Sub links like
Also if some one can tell how to change the Status of an Activity.
activity views are not customizable in this release. Same story with
activities in general. Expect this to change in a later release of crm
Microsoft CRM MVP
"BizWorld" <firstname.lastname@example.org> wrote in message
news:email@example.com...Regarding button dosen't work
Regarding button dosen't work on none of the Outlook
client CRM forms. Problem is just on one machine. CRM 1.2
Try clearing the IE cache on that machine.
>Regarding button dosen't work on none of the Outlook
>client CRM forms. Problem is just on one machine. CRM 1.2
Thanks for reply but didn't work. Any other ideas?
>Try clearing the IE cache on that machine.
>>Regarding button dosen't work on none of the Outlook
Could you please tell me how to remove a linked
transaction within the budget planner. For example, I
have a double entry under the debt category.
...editing a drop down #2
that's not one of my choices.
kateweb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16301
View this thread: http://www.excelforum.com/showthread.php?threadid=276931
what do you mean by this .. is it greyed out on the toolbar or shows "any
if you'ld like to tell me where you downloaded it from i can go have a look
"kateweb" <firstname.lastname@example.org> wrote in message
news:kateweb.1fictb@excelfor...Macro to edit details
Hi, i am currently trying to create a macro regarding editing staf
details on a worksheet.......
therefore i recorded a macro and named it editstafflist, i highlighte
my headings...and then went to 'data > form' and then had to close th
form and then stop my macro. It wouldnt allow me to stop my macr
whilst the dialogue box was open. Anyways after stopping the macro
drew out a button and assigned this 'editstafflist' macro to it.
saved my sheet and then clicked on the button, but a error '1004' kep
occuring, can anyone please help me on this as i am rather stuck
I have been experimenting with the isv.config file to create links to
external websites etc but have a couple of queries.
Is it possible to create buttons in the isv.config file to link to various
areas of CRM. For example to create a button in the Case window called
"Resolve" which would link straight to the Resolve case window, or a button
that would allow me to create a phone call with in a case with one click?
Another quick question while I'm here: Ive changed the layout of some of the
forms in CRM successfully but is it possible to customize the Resolve Case
for...Help with assigning a macro to a commandbutton
I need to assign a macro to a commandbutton. I've recorded the macro
and tried the code below but I get a "Expected End Sub" error
Private Sub CommandButton1_Click()
' Openproductmix351 Macro
' Macro recorded 8/30/2003
Sheets("PRODUCT MIX 351").Visible = True
Sheets("351").Visible = True
What did I do wrong?
I think it should be:-
' Macro recorded 8/30/2003
Sheets("PRODUCT MIX 351").Visible = True
Sheets...Disable button on custom ribbon
Is there a vba command to disable a button on a custom ribbon?
On Wed, 26 May 2010 07:37:42 -0500, "JimP" <email@example.com> wrote:
Not a command, because the ribbon works with callbacks. So you can
call InvalidateControl on this button, which will then call back to
your getEnabled callback function, where you can set the Enabled
attribute to True or False.
Microsoft Access MVP
>Is there a vba command to disable a button on a custom ribbon?
I'm lost though. Can you provide some sample code assuming (MyRibbon and
MyContro...Setting caret in edit control & activating it.
Does anyone have any example code for setting and enabling the caret in an
edit control ?
Take a look at the CEdit::SetSel() member function.
Check Abdoul [VC++ MVP]
"Nicholas Kingsley" <firstname.lastname@example.org> wrote in message
> Does anyone have any example code for setting and enabling the caret in an
> edit control ?
If you are asking how to create & use your own caret in an edit control then
I have the following requirement for an assignment. Could u please help me
in creating xml document for this. I have images stored in c drive.
.. Create an xml document that models the image groups. Each grouping should
include the name and location of the images within the group.
• Create a web page that allows the user to select and display a group of
• Use the xml file to specify the groups of images the user can select.
• Allow the user to select a group of images.
• Display the group of images when a selection is made.
> I have the following requirement...Data collection Form Edit
We have a form which will be used almost daily, for data collection, based on
a query. During the test we found a typo in one of the field labels where a
brief description is included. Is there some way to edit the form?
(recreating it with all the custom lables is just too long a task).
Another issue on this topic, every time the form is sent, the messge reverts
to the default "Please fill out the form and retunr it to me". Can this
default message be changed?
Nothing in the help functions. Any advice, or deirection to a learning
resource will be appreciated.
Thanks is adva...moving an image (not re-sizing)
Have just started using publisher & have problem with using images. More
familiar with Quark & Adobe In Design. After creating picture box and
importing an image what I want to do is MOVE the image itself WITHIN the
picture box to place it where I want. Seemingly I cannot do this as the image
is constrained with the picture box and by moving the image the picture box
moves. Any ideas?
Many thanks, Gary
Gary C wrote:
> Have just started using publisher & have problem with using images. More
> familiar with Quark & Adobe In Design. After creating picture box and