OWA Error: The Local Security Authority cannot be contacted
I discovered that I am getting this error for users whom I restricted the
"Log on to..." Security Setting in AD to their own computers. How can I get
OWA to work without having to disable this security feature? I already tried
adding the NETBIOS name of the Exchange Server to the Log on to List, but
that didn't work.
...Set RN = Range(Cells(2, 1), Cells(r, 1)) error
What wrong with this. It create error. How can I improve to get rid the
Set RN = Range(Cells(2, 1), Cells(r, 1))
Too much missing information - has r been declared and what data type is it
and what value does it have. What property of the range are you trying to
store in the variable RN? What type of variable is RN and has it been
> What wrong with this. It create error. How can I improve to get rid the
> Set RN = Range(Cells(2, 1), Cells(r, 1))
&...Macros in excel 2000 #3
I have a macro which i need to use on different spreadsheets where the data
is of various lengths.
I need to get the macro to go to one cell below the last active cell in a
I have made the macro work for the first sheet where there are 1101 rows.
This is what the part of the macro looks like, i need the cell values
replaced with the code to go to the last active cell in row I and J and then
move down one-
Range("I1102").Value = "Over Two Days"
Range("I1103").Value = "Under Two Days"
Range("J1102").FormulaR1C1 = "=COUNTIF(R...how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel?
how do i get the name of a newly added sheet that i add with Sheets.Add in a
vba macro in excel?
variable = ActiveSheet.Name
'Rename current Sheet
ActiveSheet.Name = "Renamed14a"
ActiveSheet.Name = "D" & Format(Date, "yyyymmdd")
ActiveSheet.Name = "D" & Format(Range("a1"), "yyyymmdd")
ActiveSheet.Name = "D" & Format(Range("a1"), "yyyy_mmdd_hhmm")Also see http://www.mvps.org/dmcritchie/excel/pathname.htm...Saving a Macro Button on the Quick Access Toolbar in Excel
In Excel if a macro button is added to the Quick Access Toolbar it doesn't
always appear when someone else opens up the workbook. In 2003 there was an
"Attach" option so a toolbar could be saved with a workbook. Is there an
equivalent for the Quick Access Toolbar in Excel 2007?
Regards Ron de Bruin
"joedapops" <firstname.lastname@example.org> wrote in message news:927C1026-57C4-46A4-A4D4-C43C7A4A85D7@microsoft.com...
> In Excel if a macro button is add...Aligning rows of data from multiple data sets in columns
Have table of data
2001 2002 2003
Name # Name # Name #
A 23 A 33 A 29
B 20 B 22 B 29
C 15 D 36 C 12
D 33 E 20 E 48
G 19 F 12 F 19
Each year's data includes a name (A, B, C, etc.) and a number.
However, not all years include all names. How can I match up names in
each row so all "A's" appear in one row, "B's" in one row
etc. along with their correspond...Automation Security and unexpected program termination
I want to open an Excel workbook which I know is read-only (password
protected), and contains code. To load the file and to disable the code, I set
Application.AutomationSecurity = msoAutomationSecurityForceDisable, and then
open the workbook:
This works, but also the code execution stops without any error messages. Is
this the expected result of this sequence? The problem does not occur when I
do not alter the default automationsecurity setting.
why not open the workbook in read only mode?
...Anyone know how to set accelerator text for menu commands?
I have created a menu with text like this:
"Do something\tCtrl+Left Arrow"
When I run the program, this gets output in the menu as
"Do something CTRL+NUM 4"
Either Windows or the MFC has detected the accelerator and changed the text
of the accelerator part of the menu command for me - i.e. "Ctrl+Left Arrow"
has somehow become "CTRL+NUM 4". But I don't want this text. I prefer what
I had. Does anyone know how to stop this happening?
I can't see how it could possibly know what text you had there. It looks like it...how do i set up a spreadsheet to calculate fuel milage
i want to make a spreadsheet that take my total km and liters and converts
them to gallons and miles then calculates mpg
1 liter = 0.264172051 US gallon
1 miles = 1.609344 kilometers
A = Kilometers
B = liters
OK, I've probably overdone it with the significant digits, but there's your
"Dmds" <Dmds@discussions.microsoft.com> wrote in message
>i want to make a spreadsheet that take my total km and liters and converts
> them to gallons and miles then calculates ...server setting don't activate
I was using outlook 2003 and I didn’t find any problem to activate my account,
But when I upgrade to the version 2007 wish is already activated , when I
tried to set my same email account it don’t work
Thanks a lot
> I was using outlook 2003 and I didn�t find any problem to activate my
> account, But when I upgrade to the version 2007 wish is already activated
> , when I tried to set my same email account it don�t work Thanks a lot
You cannot activate e-mail *accounts* at the mail server using Outlook. You
have to do that with whatever means the e-mai...Macros for moving data to Access from Excel
Hi, I was wondering if someone could help me... I need to create a macro or
VB script that selects certain rows from a range of rows in Excel (if not
empty), and then Creates a new entry in Access, and pastes data in line by
line, until all the data is copied.
I receive several of these worksheets a week, so I need to be sure the
script copies to the end of the DB every time, and doesn't override any
previously entered data.
On Thu, 21 Feb 2008 09:08:02 -0800, ktoth04
>Hi, I was wondering if someone could help me... I nee...application wide font setting
Is there a way of defining an application wide default font?
Is somehow annoying to take care of this everywhere I draw
Not easily. It's easier to call
SelectObject(GetStockObject(DEFAULT_GUI_FONT)). The alternative would be to
make all your window classes CS_OWNDC and do the SelectObject only once.
This wastes a bit of memory on NT/2K/XP, and eats up system resources on
Tim Robinson (MVP, Windows SDK)
"Torsten Curdt" <tcurdt-REMOVE@web.de> wrote in message
news:bj4adj$everv$1@ID-37954.news.uni-berlin....Advanced Find 'Set' queries
Is it possible to use advanced find to perform any type of set query? Example:
have setup a m-m relationship to a contact type lookup table (tried using v4
m-m feature and older technique (xref table and m-1 relationships to contact
and lookup table). The issue of course is that you can't ask a question such
as 'give me all contacts that are contact type A AND contact type B since you
need to somehow define the set of records to look at instead of evaluating
them one by one. One approach that seems to work is to use the marketing
list functionality to add all contacts with co...Run Macro If Cell value = "Other"
Alright, I have a very simple macro at the moment that unhides a column
and adjusts the print area to suit.
What I need is a maco that will run this macro if the cell F4 = "Other"
from a drop down menu.
Seems painfully simple I just can't find where it is.
If Range("F4").Value = "Other" Then
(replace xxxx in the email address with gmail if mailing direct)
<email@example.com> wrote in message
> Alright, I have a ...Find duplicate, save in a list, delete duplicate using macro
I need to find a duplicate from ID col and if found, it needs to look
at the data in the associated row to compare if it is truly a
duplicate. And if it is (same Product and Acct #), the true duplicate
will be the one with later date. Then the duplicate that has the later
date record will store this info in a separate worksheet or area and
then delete the dupicate from the orginal list. Can this be done by
using macro? Thank you for your help in advance.
ID Date Product Acct #
1150 7/24/2009 102 53
888 12/30/2009 Gas 50
1150 11/4/2009 102 53
5524...help w/deleting rows if 2 conditions & calling macro from other bo
hi, i found the code below and it works when i'm in the same workbook but how
do i modify it so that i call from book 1 and it works on book 2. i also need
to add a second condition .... any ideas??
what i want to do is delete all rows that DON'T have "Attendance" in column
G and aferwards delete all rows that are "blank" in column J
the macro will be called from the master.xls BUT will work on another file
Dim myrange, MyRange1 As Range
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
Set myrange = Sheets(...Relative reference and macros
How do I say "go down one cell from where I am" in VBA code?
Followup to newsgroup only please.
"Alan" <firstname.lastname@example.org> skrev i en meddelelse
> How do I say "go down one cell from where I am" in VBA code?
> Thanks, Alan
In article <43WCc.126$Es5.email@example.com>,
"Alan" <firstname.lastname@example.org> wrote:
> How ...Trouble applying data set to other shapes #2
I posted this earlier, but it may not have been sent. So I am sending
I have put together a data set for one of the objects in my Visio 2007
Professional drawing. For simplicity, let's say that the shape is a circle.
I then want to apply the same data fields to another shape that's
already on my drawing. Let's say that this other shape, that does not
yet have a data set attached to it, is a square.
So here is what I am doing, but apparently I am making a mistake somewhere:
I click on the circle and look in the Shape Data Sets window, and I see
the name...Can I reverse order of set of cells if original is left to right .
We obtain data from an instrument into Excel in the opposite order from what
we need. Is there any way to reverse the order of the cells, not just
transpose from horizonal to vertical, for example, but to physical change the
order going from left to right to now going from right to left (not on a
graph but in the excel cells.)
Not sure I understand what you want, but you can Sort from Left to Right.
Go to Data|Sort. When the dialogue box opens, Pick Options in the bottom
Left corner. Then, switch to Sort Left to Right.
> We obtain data from an in...Importing macros from Excel97 to 2000
Every time I used to open a new file in Excel 97, my
macros were accessible. However, now that I "upgraded" to
2000, it seems as though I have to import my personal
macros every time I want to use them. (When I close Excel
and reopen it, they disappear again.) Is there any way to
save the macros so that they are available to all Excel
files every time I open Excel?
My guess is that Excel 2000 isn't looking at your existing personal.xls
file, because it's in a directory associated with the Excel 97 program.
When I upgraded to Excel 2000, I created a new personal.xls fil...e-mail set up
i am new to setting up an e-mail account. i purchased a new notebook and
wanted to change my existing hotmail account to be able to use outlook
express. i keep getting errors on my set up but dont understand can you help.
this is the last message i recieved:
The message could not be sent. The authentication setting might not be
correct for your outgoing e-mail [SMTP] server. For help solving this
problem, go to Help, search for "Troubleshoot Windows Mail", and read the
"I'm having problems sending e-mail" section. If you need help determining
the prope...Hosting Secure Site
Our business is in need of setting up a dealer portal website which needs to
interact with our internal SQL/App server. I know SBS is not the place to
host the site so setting up a virtual web server and putting it in some sort
of DMZ is the plan thus far. I'm planning on running the site securely
(https://) which will conflict with the SBS OWA and RWW. I'd perfer to use
the same static IP address so how would I go about setting up and accessing
the dealer site given that both will be on port 443? Could I just change
the port of the dealer portal? (eg. https://mysite...Setting a cell to not go below an X value, or above a Y value
This may be very easy to do, but I just don't have a clue, I've look a
most excel variables and they just seem to choose MIN and MAX fro
columns or tables.
What I want to do is I've got the sum adding up say cells A2 and A3 i
I want cell A4 to never go below 80, or above 200. (Formula in cell A
would be =SUM(A2:A3))
Anyone think they can help
Snakey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2785
View this thread: http://www.excelforum.com/showthre...How do I set up a digital signature for my e-mail account?
I would like to know how I set up a digital signature for my e-mails?
Do you mean a regular signature ?? Tools/options/signature picker ????
> I would like to know how I set up a digital signature for my e-mails?
Hello all, I am trying to write a macro that would set the row heigh
for every 66th row to 18.75. Any help would be appreciated, thanks
Message posted from http://www.ExcelForum.com
Try something like
Dim RowNdx As Long
Dim LastRow As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For RowNdx = 1 To LastRow Step 66
Rows(RowNdx).RowHeight = 18.75
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"cdegar01 >" <<email@example.com> wrote in...