Change the file name in Macro
I created Macro that open several workbooks (actually 17 of them) at
the same time like this;
Workbooks.Open Filename:= _
"H:\Month End Work\FY 2009\02-09 RUI SALES\01 - Feb09 CFW.xls"
Workbooks.Open Filename:= _
"H:\Month End Work\FY 2009\02-09 RUI SALES\11 - Feb09 CFW.xls"
Workbooks.Open Filename:= _
"H:\Month End Work\FY 2009\02-09 RUI SALES\21 - Feb09 CFW.xls"
It works fine till I have to use it for the following month. I have to
go back to my Macro and change manually the directory from 02-09 to
03-09 and file name from Feb09 to Mar0...2007 excel autofilter change back to 2003 autofilter?
Is it possible to change the 2007 autofilter back to like the 2003 autofilter
I see you have a response to one of your other posts -- in a different forum.
> Is it possible to change the 2007 autofilter back to like the 2003 autofilter
...Changing file in all upper case to upper and lower case
I have a file of names and addresses that were entered in all upper case. Is
there a fast way to change this file into upper and lower case? Thanks for
any help you can give me.
(No private emails please)
"Sagit" <Sagit@discussions.microsoft.com> wrote in message
>I have a file of names and addresses that were entered in all upper case.
> there a fast way to change this file into upper and lower case? Thanks
&g...Outlook 2007 ignoring "don't save changes" in calendar
I have a strange problem with Outlook 2007 and am hoping someone can assist.
It goes something like this:
- I create a meeting request for 3pm today (the time doesn't matter) and
send it to someone.
- I then open up that appointment/meeting in my calendar and change the time
- Before saving or sending the update I decide that I actually don't want to
change the time of the meeting.
- I press the X button to close the window and I'm asked whether I want to
save the changes and send an update, or don't save changes.
- I click don't save changes...Change Business unit for Team
Is there a way to move a team from one Business unit to another? I can't find one.
You can set the parent business unit of a team by using the SetParent method
there are examples for C# too
I hope this helps
Andreas Donaubauer [MVP f�r CRM]
MCP since 1999, MCSE, MCSA
"Ketil Samuelsen" <email@example.com> schrieb im Newsbeitrag
> Is there a way to move a team from one Business...Formula to sum in columns that change weekly
I enter a column of data weekly into a spread sheet and then total each row
for the last 4,8& 12 weeks. As the column numbers to be added change weekly
I have to change the formula weekly. Is there a way to do this
Assuming no blanks, this will total the last 4, 8 and 12 weeks in
In article <lf%Lb.3326$Zfirstname.lastname@example.org>,
"Robert L. Salisbury" <email@example.com> wrote:
> I e...DSUM not pulling the data
Using Excel XP.
I'm setting up a budget workbook, and one sheet (5 Year Strategic Plan) has
a DSUM in it under a column labeled "2007":
It shows "zero" as the value pulled, yet when I look at the sheet labeled
"Capital Projects", I see 2 values that should have been pulled (just dummy
data for now): $1500 on Jan 2007 and $2000 on June 2007.
$E$39:$F$42 corresponds to: Capital Timing
Buildings M...summarizing selected data on a grid
I have a grid that I use to define attributes. I want to
summarize only the selected "types" (i'm just using "x" to
select on my grid). For example, by taking:
A B C
Type2 x x
Type4 x x
Type5 x x
I want to output:
With similar output's for B & C. I could do it with if
statements, but it's a pretty big grid, so I have a lot of
blank rows. Is there a better way? Thanks.
Have a look at your post: I suspect it has not reproduced as yo
intended. The table of x's doesn't seem to match the scri...Can't enter data in query datasheet
I have a query (involving multiple tables) that I want to execute and then
use to enter/change data via the datasheet which results from the query.
On most queries, I am able to do that. One this one, I can't. What is the
criteria for determining what queries will allow data entry and which queries
What do I have to do to this query to allow data entry?
SELECT [4GateMeetingTimes].Time, ActivityTbl.Activity_ActivityKey,
ActivityTbl.Activity_Pl...Why am I getting an error every time I close an Office program?
Whenever I exit Excel, Word or PowerPoint 2007 (not Outlook), I get the error
message that Microsoft Office ***** needs to close. I've used the check
online for a solution and haven't come up with anything. I've run office
diagnositcs. I don't know what else to try.
...Updating data in MS CRM from other places
We use relationships extensively but find that when using Advanced Find we
can't define the joins necessary to create the set of Contacts required for a
marketing list. (I think it would be good if I could save an Advanced Find,
and then be able to use that within another Advanced Find - like a sub-query
- but that's another matter).
Anyway, as a quick solution, I have used queries in MS Access to identify
the list of Contacts required. I have customised, adding a new field to the
Contact table, and want to be able to set this field from in MS Access on
those Contact ro...how do i change the default directory in Outlook?
I do not use the My Documents Directory. The bulk of the files I save are
kept on a server drive which is backed up daily. I wish Outlook to default to
this server directory when I am saving. Outlook 2003.
Jeff Bryenton <Jeff Bryenton@discussions.microsoft.com> wrote:
> I do not use the My Documents Directory. The bulk of the files I save
> are kept on a server drive which is backed up daily. I wish Outlook
> to default to this server directory when I am saving. Outlook 2003.
One way is to change the definition of "My Documents" so that it points to
the server. A...OWA2003 "Change Password" button problems?
The following link:
describes how to change the urlscan.ini file to allow things to pass through
unaffected. However now that I've got the "Change Password" button to
appear, I get a "file not found" error when I click on it. I've used their
..ini file with a few modifications (to loosen it for my environment).
I think I understand that because I run Exchange 2003 on Windows Server
2000, that I have to allow .htr files. I've done this but it still doesn't
work. It says in one unqualified s...How to ensure recipient can't change message
Is there a setting I can put on a message I send so that the recipient is
prevented from changing any of the content, including attachments? Would
this apply even when the recipient forwards the message?
Use F1 help to read up on the topic of message sensitivity.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After furious head scratching, Hall asked:
| Is there a setting I can put on a message I send so that the
| reci...can i change plot area colors for different date ranges
if i want to shade the plot area of a chart diferent colors, for example gray
from Jan 1 through Fed 17, then white until March 10, is that possible? Will
want to change the shadinging preiodically and fairly frequently.
You should be able to use the technique explained on Jon's page
> if i want to shade the plot area of a chart diferent colors, for example gray
> from Jan 1 through Fed 17, then white until March 10, is that possible? Will
> want to change the shadinging pr...UserForm Data to Spreadsheet
Is it possible when writing Userform data elements to a spreadsheet to
specify exactly the cell you want the first piece of data to populate. I
have tried a number of methods which allocate the data to the first available
free cell or row but this is not exactly what I want to do here.
For example, I would like to specify Cell "C4" to receive the first piece of
data from the userform with subsequent pieces of data from that submission
populating "D4,E4,F4" etc. The next time data is submitted from the Userform
I would like it to start at "C5". Sorry for ...Forumla to change values on situation
I have a table of items with "value" "vat" and "total" Columns. I would
like to write a formulae to say
When value is less than 140.5 then change value to 85.5, vat to 14.96,
total to 100.46 Else no change.
so im guessings its something like:
If AX<140.5 then AX=85.5, BX=14.96, CX=100.46
Or i could just copy and paste the If Then statment down all the columns and
forget the increment. Hopefully you will see what im trying to do.
Thanks in advance, any help is much appretiated as always.
Ernest Lai...Customer Sales Data
Is there a way to merge duplicate names while at the same time adding the
sales entry associated with the name entry.
(Customer/Sales data was imported from Excel. If John Smith was a customer
4 times, there would be four "john smith" rows each with a different sales
purchase amount in a separate column. I am trying to combine the 4 rows into
a single john smith row but with the combined total sales amount of the 4
SELECT name, SUM(sale)
GROUP BY name
There is a rule for 'group by' or 'total' queries: ...Excel Import goes thru without any data
I have been importing excel data to Project for years and never seen this
problem. Today I was helping one of our users to import a list of assignments
from Excel to a project schedule. We opened the excel file and went through
the import wizard until we got to Finish. it went through but no data came
in. I tried the same excel and same project files on my computer and
everything worked fine. I did see that he did not have the "allow files with
legacy format to open", but when I checked it didnt help either. what ami
What did you ...Change Status by Worklfow not working!
I had a simple workflow to change account's status to active. The workflow is
an "On demend" one. The workflow is running succeeded. The line in workflow
isfor change record status is done. But the inactive account is not changed
No error found at all. The same workflow is working at another CRM
installation(with rollupdate 2). The one has porblem is on rollupdate 4.
Any help is great. Thanks
MS CRM consultants at Melbourne
Visit my CRM blog at http://melbournecrm.spaces.live.com/
...Forms - Call Data from Another Table
I'm used to using lookups and forms etc but need to do something that I
think links queries, VBA (completely new to) and forms:
I have a form for creating new applicants
I want to build a form that allows the user to search a contacts table on
FirstName, MiddleName, Surname; receive a list of matches and then either
1. Select one of the matches which would then populate the applicants table
2. Reject the matches and create a new record as normal
Can you anyone point me in the right direction?
Sounds like you are asking how to do callbacks.
Open a sub form ...change build of myClassLib to Release instead of Debug?
I created a class library (dll) in "Active Debug" mode. After testing
it out and seeing it works correctly I went to the Properties page of my
Project to the Build section and changed the configuration to "Release"
from "Active Debug". The Output Path says "bin\Release\"
But when I click on Build myClassLib -- it is still building it in
bin\Debug. How do I change this to bin\Release\?
*** Sent via Developersdex http://www.developersdex.com ***
Rich P wrote:
> I created a class library (dll) in "Active Debug"...[MFC + DAO] Data selection
I've connection to database ( .mdb file) In one of tabels i've some fields:
e.g like those:
idTab - Autonumering
idWho - Number
idOK - Number
idBad - Number
And what i want to do is:
const char pszIDTabFind = "idTab = %s ";
CString strId - ID taken from another table
str.Format( pszIDTabFind, strID );
RS.FindFirst ( str );
And what i get? An exception:/ !! Sth like : "Operation for this object is
not supported" Why i can't find any data? What's more if i search for
strings everything goes ok. Could You please tell me how should i...Pivottable data field
I have noticed that when a field with no values is inserted in the layout as
data, one of my pivottable shows this field as part of the pivottable, and on
another it is excluded.
Why the inconsistentcy?
...Global wage data field for employee card
We are a new CAN GP Payroll user and find that having to change each pay code
(REG, OT, etc) to their new wage without having it roll down from a master
field very time consuming and poses potetial problems if a particular code is
left out, calculated wrong, etc. Our previous payroll package was not as
good as MGP overall but had a nice feature where changes to salary were made
at the employee master card level and changes calculated and rolled down to
each associated pay code type that was relevant for that empoyee. In MGP
Payroll, if every employee in a company of 300 received a cha...