Refer to sheets without using tab name??
Cell formulas that refer to other sheets usually look like
=Sheet2!A1 ' Get cell A1 from Sheet2
However, what if someone changed the name of the
Sheet2 tab to something like "ThisIsMyTab"??? Does that
mean I would have to manually change all possible formulas
to the following:
I'm mostly curious if there's a way to use formulas that
do not strictly rely on the names of always changing
tab sheet names.
The best way is to test it by yourself.
I...Using Repair Permissions
Using Repair Permissions comes up quite often on this list. I ran across
this on Apple Discussions today and thought I would pass this along.
You do not need to Repair Permissions on a regular basis.
There are only three occasions you need to do this:
1. When you have just installed something that required you to run an
Installer, rather than just copying some software to a folder. This should
be done for both Apple and non-Apple software. (Note Office 2008 will come
with an Installer this time)
2. When you have been working on your OS X files or folders while booted
from OS 9, or remote...Using More than 7 if functions in a formula
Help--I am totally new at this feature of spreadsheets.
I am trying to create a formula that needs more than 7 if functions i
I want to be able to type in a weight and it will automatically choos
the value that should be assigned to it. The weights range from 110 t
260. I have found out that you can only use 7 IF functions in
formula. I have put in the following formula up to the 7th I
function, but don't know where to go from here:
I have read something about VLooku...Preventing users from using preview pane?
Is it possible to remove the preview pane option from the
view menu or prevent the user from being able to use it?
You can set a policy to disable the menu command. The command bar ID should
be 5514. The policy templates can be found in the Office Resource Kit
http://www.microsoft.com/office/ork. You will want to download and install
the Office Core Tools to get the policy templates.
I don't think the policy is 100% bullet proof because it only turns off the
menu item(s). If the user already had the preview pane enabled it will still
be enabled when the policy is turned on.
Please let ...using screen...
I have problem with the query in the cascade combobox when the form name
Is there a way to replace the following using screen.activeform
[Forms]![frmCoFundReview]![Partner] => screen.activeform.[Partner] ?
Not that I know.
You could use a separate query for each form.
Each query would have the correct form name for the combo box.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"SF" <email@example.com> wrote in message
> I have probl...Use Richedit v2.0 with VC5.0/MFC4.2?
Hi. I'm using VC 5.0 with MFC 4.2 and would like to add the extra
functionality of the RichEdit v2.0 control. The supplied copy of
'RichEdit.h' supports v2.0, but if, (as recommended by MS in one of their
articles), I change the class name in the *.rc file from "RICHEDIT" to
"RichEdit20", then call 'AfxInitRichEdit2()', this function is not
recognised, so 'RichEd20.dll' does not get loaded. (Obviously
'AfxInitRichEdit2()' doesn't exist in MFC 4.2)
Is there a way to use RichEdit v2.0 under these conditions?
Any advice welcome,...ISSUE: Using VBA to Delete a Column
I'm using a VBA routine that creates a copy of a worksheet under a different
filename. The routine needs to delete column (D) before saving the new file,
however column D passes through a group of merged cells (A1 through D1).
When the command reaches this point:
the entire range of cells from A:D are selected. I could use the mouse to
manually select column D and delete it, but why wont VBA perform in the same
Here is the entire sub if it helps:
...Using search to find an email
If I do a search for an email in Outlook 2003 and choose all mail folders,
is there a way to see what folder the item was found in? It seems to just
show me the message, but not the location, so I don't actually know where it
If you add fields to the advanced search window, it will show you where the
item was found.
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, Sande...Replace using wildcards
I'm a newbie to Excel and this group so please excuse my ignorance.
I'm trying to do what should be a pretty simple find and replace. I want to
I have to include the type field in my search and the asterik's are part of
the text, not wildcards. The only thing I want to change is the base.
I put this in for the search criteria:
This finds all the lines I'm looking for so, so far, so good.
For the replace string, I use this:
base=differentbase*cntry=???*ty...Excel file in use error
This error occurs with spreadsheets which contain macros,
they cannot be ammended nor deleted by a network
administrator! any ideas????
...How to change account and password for services by using Powershell?
I would like to know how to use Powershell to change account and password
Being more specific, I would like to change the account and password for two
specific services using Powershell.
"Carlos Felipe Fran�a da Fonseca" <firstname.lastname@example.org> wrote in
> Hi all!
> I would like to know how to use Powershell to change account and password
> for services.
Can you be even more specific? Do you mean ...Destryoing modeless dialog in a modeless thread causes deadlock
I've created a user-interface thread to manage modeless dialog. I use
it to display comforting "Please wait..." messages to the user while
worker threads do lengthy operations (in this case, tasking robotics,
but that's not important).
So, here's a use case:
The user initiates a long process by selecting a menu item.
In the main GUI message handler, a worker thread is created to do
perform the operation.
The message handler returns.
The worker thread creates a user-interface thread, which creates a
Any time the worker thread needs t...Creating and pasting using VB
I need to create an email and paste some data already selected in excel
into the body. I have just started to attempt this so if I need to add
mapi or anything like that please let me know. Any help would be very
If you copy straight from an Excel sheet to an email, you will be pasting an
object and that can be a nuisance, particularly if you need to edit the
contents before sending it. I simply paste it to Word first, then copy it
from Word into the email. This may not suit your needs though. HTH Otto
<email@example.com> wrote in message
news:1145...Use text in a cell to reference a sheet
I'm trying to reference the text of a cell to reference another sheet.
D3 is a text cell that has contents of "Sheet4"
Is it possible to use the text in that cell to reference another sheet
(So the end result would be equivalent to "=Sheet4!A1" without havin
the sheet explicitly stated)
Of course, the example above does not work, so I tried various ways o
dereferencing the D3 cell to make it work - putting it in quotes
putting it in parentheses, using CELL(contents,D3), etc. I couln'
seem to come up with anything that would prop...how do i set up a HTML newsletter to use with a mass email tool
Not with Publisher. Pub doesn't do a simple HTML document.
MVP Microsoft [Publisher]
"virtuallysavvy" <firstname.lastname@example.org> wrote in message
A crystal ball would help you and maybe us.
This white space is for you to describe your problem and what programs
you might be using.
Wot's Your Real Problem?
I have created a newsletter in publisher and converted to .html. I now need
to download the html to the mass email tool that I use, but h...Using INSERT with joined Tables
I need to INSERT an additional address in my "ADDRESS" table for my students.
But I need to join the ADDRESS table with my "ACADEMIC" table which has the
Year/Term information to meet my criteria.
My CRITERIA is:
Admit Year must be = "2006"
Admit Term must be = "Summer1"
Admit Session must be = "01"
Address Type must NOT BE EQUAL TO "PERM"
I don't want to insert a new record for everyone, only those students who
meet the criteria above.
My SCRIPT looks like this:-
INSERT INTO [Campus6_test].[dbo].academi...Copying File using WebDAV
Can anybody plz tell me how to copy files using WebDAV. I want to copy files
go.asp from my localpath http://servername/webdav/go.asp to
It gives me error saying " The remote server returned an error: (403)
and here is my code
Dim Request As System.Net.HttpWebRequest
Dim httpResponse As System.Net.HttpWebResponse
Dim MyCredentialCache As System.Net.CredentialCache
Request = CType(System.Net.WebRequest.Create(strSrcURI), _
' Add the network credentials to the request.
'...OWA-SSL: Should I use 3rd party certificate or create own CA
My partner and I are debating the use of a third party certificate (like
Verisign) or the creation of our own Certificate Authority. We want our users
to access OWA via ssl.
I thought we should use third part certs because then we wouldn't have to
worry about browsers having or not having our public key. I thought we would
have to install that key on each machine that someone wanted to use to access
My partner thinks that we could create our own CA using Windows 2000 server
and create the certs. He believes that IE would already have the public key
for certs created by our M...USE TAXES
What is the best implentation to track Use Tax in Great Plains?
I don't know if this is the best, but here's what I do. I set up a credit
card called USE TAX using the comptroller as the associated vendor. When I
buy something from a vendor I calculate the use tax and then pay the tax part
using the credit card. The balance is what I really owe the vendor. GPlains
automatically creates a payable for me to the comptroller and I'm good to go.
> What is the best implentation to track Use Tax in Great Plains?
...Rule Changes Received Date Using IMAP
I have Outlook 2003 running on XP with the latest updates and service
packs. In Outlook I have an Exchange account and an IMAP account.
Whenever I try to run any rule on the Inbox of my IMAP mail, it changes
the Received Date listing to the current date on about half of my
messages. When I open one of these incorrectly dated emails, the date
shown in the message is correct and the date changes to the proper date
in the listing of emails. Also, if I remove the IMAP account and then
re-add it, the Inbox messages once again have the correct date. I've
searched the web over and have found ...Deadlock Problem
i m using SQL 2000
i have following table structure
create table mytab (Fid varchar(16) Primary Key, Picture_1 image,
Picture_2 image, Picture_3 image, Entry_time datetime)
Data base is hosted on a server with 2 quad core processors and 8 gb
Ram. more than 200 user insert data into the table through a front end
application more than 30000 records enter daily in this table. data base
is in Simple recovery mode. user experience deadlock during this
operation. there is no data fragmentation in the table as it is removed
How can the performance be increase...how to use StgOpenStorageEx
when i use StgOpenStorageEx(L"C:\\myfile.xml", .... ), it work well
but i use StgOpenStorageEx( lpszWFile, ), not work (see code below)
any idea? i convert CString to WCHAR incorrect?
void changeInfo(CString sFileName)
IPropertySetStorage *pPropSetStg = NULL;
IPropertyStorage *pPropStg = NULL;
HRESULT hr = S_OK;
WCHAR* lpszWFile = new WCHAR[MAX_PATH];
if ( cFile.Open(sFileName, CFile::modeRead) )
sFileName = cFile.GetFilePath();
LPTSTR lpStr ...Inserting the values of a formula using vb
Do you know where the error is below
Thanks for any help
With Worksheets("tblFaxMailBox").Range("F2:F" & LASTROW)
.Value = .Value
HI I found the error. I needed to add R1C1
> HI All,
> Do you know where the error is below
> Thanks for any help
> With Worksheets("tblFaxMailBox").Range("F2:F" & LASTROW)
> "= NETWORKDAYS(RC[-2],RC[-4],H...Select sentence using a variable
In Excel 2003 I'm trying to write a query sentence to get data from a dbf
table where table.date_mov is newer than a value (a cell in the worksheet
which I named as date_min )
How can I get it?
Done! no problem, I needed to sleep for a while!
> In Excel 2003 I'm trying to write a query sentence to get data from a dbf
> table where table.date_mov is newer than a value (a cell in the worksheet
> which I named as date_min )
> How can I get it?
...UK PostCodes > inserting values from Excel using Map
Guess I'm being thick.
Two colums, one postcodes, one data.
I want to use "MAP" to show the values geographically....
I've installed the "globe", having trouble finding the instructions....
can anyone point me in the correct direction?