Excel Macro #2
I need to create an Excel Macro tha will import a series
of txt files, one below the other, automatically. The
macro will be run every two weeks and each txt file will
have additional rows. What I want to know is how to
automatically position the curson to the next open cell in
column A after the previous txt file was imported. Can
"Robert Blankenhorn" <Blankenhorn.B@cpcnet.co.richland.oh.us> wrote in message news:email@example.com...
> I need to creat...Recurring Appointments #2
I am trying to set up recurring appointments in CRM 4.0. I have created two
custom attributes and inserted them on the appointment form. The first
attribute is a picklist with Yes/No for Recurring appointment (Default value
is NO) and the second attribute is for the number of recurrences.
I am aware that I can create a workflow which confirms that the Recurring
appointment is Yes and creates a new appointment.
I would like to ask if someone could please assist me with the number of
recurrences. I need to fire the workflow for each number of recurrence. I am
not quite sure how to d...SMART Regression installation
Operating System: Mac OS X 10.4 (Tiger)
So I am taking a statistics class. Our textbook comes with a disk and instructions to install SMARTReg, which provides additional regression features for Excel. (Yes, I do have the analysis tool-pak installed.) However, the installation is for windows (it is an .exe file). I went to the website listed in the ReadMe file: www.gierus.ca/alex/smartreg but it is definitely not related to this program. <br><br>Is there a Macintosh version of this add-on available that anyone knows about? <br><br>Thanks. <br><...1 account, 2 computers and 2 email addresses
I've got one broadband email account on two networked computers, both
using Outlook 2000. I want each computer to receive their own
respective emails, however, both computers are receiving emails from
both accounts. I just double checked Outlook on this computer and
under Accounts, only the account I created for this computer is there.
Why am I still getting the other emails? And how do I filter so that
each computer gets it's own respective mail? Thanks.
Phrank <Phrank> wrote:
> I've got one broadband email account on two networked computers, ...Linear Programming
In Excel how do you set up a 3 variable linear programming
problem on a spreadsheet with a a number of constaints
See the tutorials and examples at www.solver.com.
Or, search your drive for the file solvsamp.xls, which is installed when
Solver is installed and which has a 3-variable nonlinear example that is
easily converted to linear.
"Franklin" <firstname.lastname@example.org> wrote in message
> In Excel how do you set up a 3 variable ...Division 2 numbers
Hello I want generate at random numbers in 2 columns that results division
was be only integer example:
6/2=3 or 4/2=2 or 9/3=3
i will be do that in visual basic
thx for help
E-mail odczytasz po kliknieciu na: http://cerbermail.com/?Sa8ZdOqkxK
Nr gadu-gadu: 36786
Dim myRng As Range
Dim wks As Worksheet
Dim MaxNumber As Long
Dim MinNumber As Long
Dim maxResult As Long
Dim minResult As Long
MaxNumber = 25
MinNumber = 3
maxResult = 10
minResult = 2
Set wks = ActiveSheet
...linear and exponential graphs and x,y intercepts
I have two lines one linear (y=mx+c) and one exponential (y=c^bx) and
they intercept each other. I believe it is possible to calculate where
the lines intercept. Although I can do this by graphing the data, it
takes time and allows for user error so a calculation would speed
things along greatly.
So for the first line using the equation y=mx+c the numbers for the
13kPa line are y=0.0021x+9e-16
And for the exponential line (y=c^bx) which we produce to using the
myograph is y=0.0022^0.0046x (^=Exp)
I know that the two lines intercept at 1613. But no matter what I try
I can&...Public folders in OWA #2
I had a problem earlier this week with getting OWA to work, finally got it
working, when i added the defualt app under IIS. But when it comes up now if
you go to public folders it shows it as a Directory rather than the normal
outlook contacts look....you can browse it all the way to the contact, like
Wednesday, October 05, 2005 8:51 AM 893 Bob Ponder.EML
Sounds like you modified something in IIS Admin, then had those settings
propagate down to the Public vdir. The only way I've ever been able to fix
the view problem you are mentioning is to reinstall...GWAT #2
Can anyone help me with this question please?
What is the GWAT in 5.5 called in 2003 and why is it better?
Thanks in advance
GWART = Gateway Address Routing Table. Exchange 200x uses link state
routing instead of a GWART.
This article will help:
For Exchange news, links and tips, check:
"Slipper1" <email@example.com> wrote in message
> Can anyone help me with this question please?
> What is the GWAT in 5...transfer data range from criteria in 2 combo boxes
i have 2 combo boxes "com1" and "com2"
i want the value in "com1" to help me decide which columns to target and i
would like "com2" to decide which rows to target from another worksheet
example: if the value of "com1" was "red" and the value of "com2" was "5/1/10"
then i can return C5-C35 from "sheet2" into "a1-a31" in the original sheet
example: if the value of "com1" was "blue" and the value of "com2" was
then...Money 2008 #2
Are they making a UK version as we have not had one for some time, I use 2006
version which was last they produced for us.
I'm not aware of any new one at present. The last UK version was 2005.
On the Money support page, it says: "Note: Money 2006, 2007, and Money Plus
are only supported in the United States and Japan. Money 2005 is supported
in countries outside the United State and Japan, including France and the
United Kingdom. Money 2003 and 2004 are no longer supported. Please contact
the appropriate support center for your product."
Which implies to me, that Money ...printing problems #2
When some of my coworkers print timelines, the arrows show up but notthe
text of the milestones. We use different kinds of printers or print to
Adobe. Has anybody else seen this? What's the fix.
What version of Visio? Are all service packs installed? What operating
system(s)? Which printers are successful and which ones are not? Are all
printer drivers up to date?
"Sherrie" <firstname.lastname@example.org> wrote in message
> When some of my coworkers print timelines, the arrows show up but notthe
> text of the mi...Outlook Favorites Won't Save, Messages wrong on Outlook Today #2
Re-posting a message from a couple of weeks ago, hoping for better
luck this time. I have Outlook 2003 running on XP Pro.
Original message, with some additional info in brackets:
A few days ago, I lost all my favorites. Also, the Messages section on
Outlook Today no longer shows the number of unread messages, and if I
click on a folder under Messages, nothing happens.
For the Favorites, once I add them back in, it works fine until I
reboot, and then they are gone again. I do close and re-open Outlook
after adding my folders, so it should be saved properly, and it appears
to be working w...PostMessage #2
I have a Dialog based application .
I want to post message from this dialog to another class which is alos
part of the same application.
Say When I click a button,this dialog posts a message to another
How should I achieve this?
how should I know about the class recieve that particular message?
Pls guide me with sample code.
First off, you're going to be posting to a window not a class even though it
kind of looks that way since the class/object has the code that handles the
message. You can do this by using the CWnd PostMessage() or SendMessage()
funcitons. Yo...Owa login problem #2
Initialy there was an error ASP 0115 Errors in IIS
This what I 've done ;
Click Start, point to Programs, click Windows NT 4.0
Option Pack, click Microsoft Internet Information Server,
and then click Internet Service Manager.
Expand Internet Information Server.
Right-click the computer name, and then click Properties.
In the Master Properties drop-down list box, click WWW
Service, and then click Edit.
Click the Home Directory tab, and then click Configuration.
On the Process Options tab, click to clear the Enable
Debug Exception Catching check box.
Click OK to close the Application C...Microsoft CRM 1.2 Unspecified Error
I have an installation of Microsoft CRM which was running fine until a
problem with the domain controller running on an HP server, for some reasons
the domain controller refused to boot properly until I found out that an HP
service was causing the error, the HP service was disabled the the DC was
fine, after that MSCrm refused to come up, the Security service refused to
start and was coming up with an Unspecified Error. I checked the
dependencies and nothing related to the HP service that was disabled. Any
help would be appreciated
When i forward an email to someone theres no problem, but
when i close the original message, it is gone in the
inbox folder meaning it is automatically deleted how can
i stop that, i didn't change any of the defaul settings
of the microsoft outlook, i hope you can help me with my
problem as soon as possible. thank you.
It might not be gone. Check your view. View, Currnet View. Make sure it's
not set to Unread messages.
Author, Special Edition Using Microsoft Outlook 2003
***Please post all replies to the newsgroups***
&...outlook background #2
How do I limit users choice of using backgrounds?
Turn off HTML mail, please!!!!
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Mike asked:
| How do I limit users choice of using backgrounds?
...problem launching excel #2
I am using MSOFFXP ...
I cannot get excel to come up by double clicking on my file....I hav
to launch the excel program, click on open find the file and the
even if excel is running minimized clicking on a file in the explore
will not open that file...the only way for me to open my files is b
going through the excel program...
my word program works as advertised...
Message posted from http://www.ExcelForum.com
try the following:
goto 'Tools-Options-General " and uncheck "Ignore other
Exit Excel and try a...TO: #2
This is a multi-part message in MIME format.
When I hit the (to) button in order to add a e-mail address some of the =
address are with last name first and some are with the first name first. =
I have entered them all the same and would like for them to be arrange =
by last name the same as they are in the contacts part of outlook. I =
was under the impression that the address came from the contacts part of =
Ron =...cell reference #2
I have a list of numbers in column A. I wish at the bottom to return the
maximum value in column A using =max(a1:a100) but i also want the cell
reference of this value. how can i do this.
Use the MATCH function - it will give you the relative position of the
maximum value in your range, and as this begins at A1 then this is the
same as the row. If you have two maximum values, however, it will only
report the first occurrence.
Hope this helps.
lees news wrote:
> I have a list of numbers in column A. I wish at the bottom to return the
> maximum value in column A using =m...copy range #2
is it possible to perform one after another:
copy range then clear another range and finally paste copied range to its
it stops when paste as seems like clipboard is empty
Without knowing what you're really doing, sometimes you can just change the
order and you'll be fine:
> is it possible to perform one after another:
> copy r...CRM Mobile 1.2 and territory codes
By default when choosing Terrirtory Code as a criteria in a CRM Mobile
Accounts form the only choice is "default value". How can this list be
populated with the correct value of Territories?
...Sharing Folders #2
We have several csa's that need to answer email sent to our customer
service email address. How can I allow them to all view the messages
and respond using their own email address? I also want to know how
many messages each of them responded to each day. Any suggestions?
Thanks in advance.
CableGuy <email@example.com> typed:
> We have several csa's that need to answer email sent to our customer
> service email address. How can I allow them to all view the messages
> and respond using their own email ...Offline Public folders #2
Is there a way to get the Public folders offline so I can
have access to the contacts,calendar and stuff from the
office on my laptop even when I am not connected to the
Exchange Server in my office? This way I can syncronize my
public folders whenever I am in the office and have access
to the info at home.Any help or pointers in the right
direction would be greatly appreciated.The version ou
Outlook is 2002 and Exchange Server is 2000.
Drag the PFs in question to the public folder "favorites" in your folder
view - then you can select them for offlie use in ...