Formula to get data from files #3
Thanks for the reply.
Using your formula, I get the filename and the cell number in C, bu
how do I get the results of that cell number.
I need to type the name of the file in A and a certain cell of tha
file in B and have the formula go to that file and get the value o
greasybob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=792
View this thread: http://www.excelforum.com/showthread.php?threadid=26321
...Moving a master and sub project from one network location to anoth
I have created a master with four subprojects in a folder on the network.
However, I would like to move them to another folder. What's the best way to
do this and still retain the links between project?
Using MSP 03 SP3.
In article <E8A64CC0-DFE3-489C-BA35-3E17B969E077@microsoft.com>,
AnthemAZ <AnthemAZ@discussions.microsoft.com> wrote:
> I have created a master with four subprojects in a folder on the network.
> However, I would like to move them to another folder. What's the best way to
> do this and still retain the link...stopping columns for one page
I am creating a several page document in two column format. There is one =
page in the middle the I want to be a full width, but I can't figure out =
do this without making the previous pages also full page.
How do I "turn off" the columns for a page or partial page within a=20
In article <firstname.lastname@example.org>,
"email@example.com" <firstname.lastname@example.org> wrote:
> I am creating a several page document in two column format. There is one
> page in the middle the I want to be a ful...I keep getting the error message 'not responding' with Outlook?
I keep getting the error message 'not responding' with Outlook? So
ultimately it takes a long time to load then the message disappears. Does
any one know what this means? Have I got a bug somewhere that I need to get
Shazza wrote on Fri, 12 March 2010 07:33
> I keep getting the error message 'not responding' with Outlook? So
> ultimately it takes a long time to load then the message disappears. Does
> any one know what this means? Have I got a bug somewhere that I need to get
> rid of?
1- try to check your ad-dons may be one of th...Get paid while you get online!!
I found a great Internet company - Cashfiesta.com - that has created a
product everyone can benefit from. They pay you while you work or play
on your computer. All you need to do is keep their software - the
FiestaBar=99 - active while you are online. They even pay you when your
friends are using their computers.
Unlike other companies, Cashfiesta gives you control over how much
money you earn. They have an individual payrate based on the number of
Special Offers you sign up for. As some of these offers are free, you
can increase your payrate up to 33 times without spending a penny.
It's...Swaping data from one field to another in Microsoft CRM
Is there tools available out there to swap data from one field in CRM to
e.g. data from Address_line1 need move to Address_line2 and data from
Address_line2 to Address_line1
I am not sure about a pre packaged utility to do what you require but once
when we were migrating data from ACT to MS CRM and we encountered a similar
issue where we had to swap between two fields. We wrote a utility to take
care of this kind of situation. A SQL script may also do the same job.
Do you want to do it regularily or are you just looking at one time swap?
D...Hidden ActiveX gets focus
i have a MFC CDialog that contains several controls and ActiveX'es.
Depending on the configuration of the dialog, I have to hide an ActiveX (I
tried different ways like ::ShowWindow(...) or ::SetWindowPos(...) etc. to do
that). The ActiveX gets hidden as it should.
Let's say, I have the following tab order:
Edit1 (ActiveX) - Edit2 (ActiveX, hidden) - Button - Edit3 (ActiveX, hidden)
I jump from control to control by pressing the tab-key. What I expect is
that the focus jumps from Edit1 to Button and back to Edit1 and so on. But....
What really happens is that:
- Edit1 is foc...custom format or formula?? a tough one
have cols of data (one would be percent change) where I
would divide. I want all of the cells to display right
aligned. I also want to change the "division by zero"
result to be changed to a "-", and centered. I can do it
when I want a dollar sign or no sign...with an if statment
to change the div by zero and the accounting format.
I want to it to occur on the percent columns as well, and
can't figure out how...the "-" never comes out centered.
I think I just need a custom format but can't seem to get
...Can't get Vista recovery CD to recognize installation
I'm trying to get a Powerspec B647 Vista64 Business PC to boot. After
booting to the Vista Recovery CD and choosing to repair, the process
can't find any installed O/S.
So I press the Load Drivers button to load the B647 RAID controller
drivers, which I downloaded from Powerspec to my flash drive. After
pointing it to the "sataraid" folder, the system installs some
controllers and drivers but still doesn't find my Vista installation
afterwards. Even worse, the C drive letter is given to one of the
removable media drives.
After pressing the Next button I'...How to get the active document
Hi. How can I get the active document object (to clarify, the document
object associated with the view that has focus) in an MDI application? I'm
using a worker thread for communication and I need to tell the active
document about communication event that occur.
You can get the active document in MDI using GetActiveFrame(), checking its
validity and then calling GetActiveDocument on it. The only catch here is
that you are doing it in a worker thread. I think it should work there as
well because you are not using the (CWnd,handle) map of MFC that is not
valid in your thre...How do I get the data/xml/export option
My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?
One way would be to do a web query, first preformat the cells as text, then
do the query (data>import external data>new web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import
(No private emails pleas...multiple domain on Exchange 2000
I want to setup multiple domain on my Exchange 2000 like @abc.com and
@xyz.com and I want to setup the user for each domain like email@example.com and
firstname.lastname@example.org I have tried this but didn't find a way of doing this. I can
do this in few third party mail server like Mail Daemon. can any one help me
You'll need to use the "System Manager" program to edit the "Default
Make sure both @abc.com and @xyz.com are in the policy, and for each one
that the "exchange organisation is responsible for all mail deli...Sorting Multiple Columns Repeatedly
I've built a spreadsheet of employees in rows and attributes about them
I've recorded macros to sort on the columns (sometimes by one, two or
three columns per sort).
I began each macro by using CTL+A to select the whole sheet, then
clicked on Data>Sort to to do the sort.
I'm finding that the data is getting scrambled: that rows are not
Is there something about multiple subsequent sorts that would mess up
my data, even though each macro starts by selecting the whole sheet?
What am I missing here?
...How do I get my text wrap tools to work?
I've followed every instruction in the help files that I can find, and my
text wrapping features will not work in any format other than top and bottom.
My computer is new & has Publisher 2003. I've worked on Pub. 2000 & did not
have this problem. Is there a setting that I'm missing???
Right-click the text box, format text box, layout tab, select the text wrapping you
Did you edit the wrap points on your object?
Select your object, click the dog icon on the picture toolbar, select a wrap there.
It could be how your are arranging the objects and text box. Experime...How to get font information from clipboard #2
I am writing an image process program. I want to cut or copy some text
with font information from other software, such as MS Word, Excel etc .
In my program, the text will be draw on screen with same font. So I
need to get the font information from clipboard, what should I do?
...can't get ical into entourage
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
no matter what i do i can't get my calendar into entourage. i've got sync services set to delete entourage and replace with ical/contacts on my imac. my contacts are there, but i've never been able to get my calendar over. i gave up last june but wanted to see if there was any help so i could try to use entourage and then compare to ical/contacts/mail. <br><br>help!!!
On 2/8/10 3:25 PM, in article 59bb27cf.-1@webcrossing.JaKIaxP2ac0,
"Carol_Schultz@officeform...How to get totals
Hello all. I have a list I am working with in excel 2003. The columns I am
interested in are Employee, Overtime Code, Pay and Comp. There are
overtime codes. I need to total the pay and comp columns for each employee.
My problem is that if the OT codes are certain numbers, they will not be used
in the calcualtions. Like so:
EMPLOYEE OT CODE PAY COMP
Jones 1 4 0
Jones 6 4 0
Jones 5.02 0 4
Jones 18 2 0
Jones 9 ...2 users getting same email
Hi-I recently added another user to my outlook 2002 pro
account. The email is working for both-I tested sending &
receiving to each one-but both accounts are getting the
same emails. If I delete a message in 1 account, it is
deleted in the other account because it is the same
message. What can I do? Thanks!
ali <email@example.com> wrote:
> Hi-I recently added another user to my outlook 2002 pro
> account. The email is working for both-I tested sending &
> receiving to each one-but both accounts are getting the
> same emails. If I delete a...Outlook and multiple hotmail accounts
Hi. I have my normal hotmail account and one i use for
newsgroups etc. I have both accounts set up within
outlook 2003 as well as a single POP account.
Outlook seems to get confused with the hotmail accounts.
Sometimes one account's folders appear beneath both
accounts in the 'Mail Folders' panel. I have to restart
outlook to fix this.
And sometimes outlook reports 'incorrect password' for
one account which is perhaps outlook using the password
from the other account.
Are these known issues? Does outlook support multiple
html mail accounts? I am fully patched/s...how do I get this done
If anyone can help me with this I'd greatly appreciate it
If I have some data such as
Plan A 2.00 4.00
Plan B 3.00 5.00
Plab C 4.00 6.00
and also have
cost X what formula for X will look at the data abov
and return the value 2.00
pgruening's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2601
View this thread: http://www.excelforum.com/showthread.php?threadid=39368
A1...Apostrophe truncates line in reports
I have a GP8 add-in application that uses a stored-procedure to chunk up a
note field into 80 character records and strore them in a physical temp
table. The report reads from this table and displays the data.
This is working fine unless a user has added an apostrophe in their text.
If they do, the 80 char line is truncated at the apostrophe and no other data
for that line is displayed. The full line IS in the physical temp table, so
the sp is loading the data properly. It is only the report display that is
truncating the line.
Is there a way to prevent this - maybe surrounding the...How do I get rid of strange special characters?
I had a word article that I was going to insert into sql server in a text
field. So I replaced every occurrence of apostrophe by two apostrophes (sql
server doesn't like seeing single apostrophes in the middle of a text field).
What I didn't notice was that this replace doesn't work the way you would
expect (in Word). When you try and replace one apostrophe by two, you get a
reverse slanted character followed by an apostrophe. Since I didn't notice
this, I went ahead and inserted the word as text into a sql field, and now
my sql database is full of these charac...Problem with Exchange 2000 with multiple recipients in BCC field
our mail server is Exchange 2000 server SP3+post SP3 hotfixes on Windows
2000 server SP4. Users are having problems when they try to send mails that
have multiple SMTP recipients in BCC field. Sometimes messages are sent but
sometimes outlook gives error "the operation failed." If users get this
error, they are not able to send that message anymore, even if they create
new message and copy/paste message content from old message. Sometimes they
succeed if they remove some recipients but not everytime. This problem
occurs with Outlook 2000, Outlook XP and even with OWA (exc...Unbound form for data entry on multiple front ends
I'm using an unbound form to input data into a record via VB code that runs
once the last field on the form us updated. This code opens the table, writes
the data to the appropriate fields, closes the table, then clears the form
and moves the focus back to the top control of the form.
My question is, when I split this database into front and back end sides and
put the back end out on the server, will I run into issues with the VB code
if by some happenstance two users happen to trigger said code at the same
time? I designed this DB this way purposely to try to avoid those issues, an...How to get combo box selected index changed event in another page from the existing page in winforms
I am working on windows forms project. I have two winforms (window1 and
I have a combobox called cmbEmail in window1 and Textbox called txtName in
I want to retrieve some information into the txtName in window2 when I
selected something from cmbEmail in window1.
If I write code to retrieve something into the txtName (which is in window2)
in cmbEmail SelectedIndexchanged event in window1, I will get an error of
txtName doesn't exist in this page.
Can anybody help me to solve this problem..
Thanks and Regards