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
...error code 80070490 11-26-09
I've tried to fix this by re-installing my windows vista sp1 but i can't open
the "setup.exe" it says it can't find it when i click on it. anyone know of a
better way to fix the error or why i cannot open the setup?
Now format the HDD and do a clean install.
> I've tried to fix this by re-installing my windows vista sp1 but i can't
> open the "setup.exe" it says it can't find it when i click on it. anyone
> know of a better way to fix the error or why i cannot open the setup?
Well...did you try any of ...sending report to email by snapshot
hi to all! good day :)
Please help me send out a report to email with specific page only. i cant do
it n the argument using macro.
i tried sending out to email but i received all the reports.. i need only
the specific report or specific page..
thanks Eric :)
i am new to it please help me hint the sysntax develop a criteria to a
specific page... thank you in advance...
"Eric Blitzer" wrote:
> You can't do that in access but can't you develop criteria that would only
> produce that page.
> "victorluke" wrote:
> > hi ...Need Help
I have a user who sends out a info mailing everyday. It goes to about 500
people. Today, the users received the following error message for each
The client operation failed. Error is [0x80004005-0x0004b9-0x000501].
We run Exchange 2003 , XP clients, Outlook 2003.
80004005 = MAPI_E_CALL_FAILED. From the 4b9, I'd guess it was an error
looking up the membership of the group.
"ChrisH" <firstname.lastname@example.org> wrote in message
>I have a user who sends out a info mailing everyday. It goes to about 500
>people...the font changes colour on emails I send
I am sending an email and the font looks correct. When
the recipient receives it some of the text is bright
green. It doesn't happen on every email but when it
does, it is only on part of the text.
...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...Windows Live Mail Error ID: 0x800420CD
After using Windows Live Mail Desktop in Windows 7 Home Premium (64 bit) for
3 months, to access mail from AT&T, my wife's computer developed the
following error that results in a continous attempt to download messages,
counting up into the thousands, after receiving the messages that were
actually in her At&T Yahoo mail box (I checked via web to verify her settings
and see what was in her web mailbox). After the 15 new e-mails were received
by Windows Live Mail, it keeps on trying to receive thousands of messages,
but none actually show up in her In box and this will...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...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 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...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...Submit to SQL Server error
I am trying to submit changes to a SQL server database. I can query the
database fine. But when I try to add a button to submit changes there does
not appear to be an option for the database as a submit to location?
Anyone else have this problem?
Sorry wrong board to post this question.
"Jim Hutchinson" wrote:
> I am trying to submit changes to a SQL server database. I can query the
> database fine. But when I try to add a button to submit changes there does
> not appear to be an option for the database as a submit to location?
> Anyone else have this p...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?
...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...Block specific outbound email recipients
I would like to block outbound mail to a specific recipient. For example: I
have a user that likes to use email to chat with her friend. I can block the
incoming mail from the friend, but how can I block the outbound mail from my
user to her friend? This is on Exchange 2003 standard. I also have Symantec
antivirus for exchange and a watchguard firewall. The internal user should
still be able to send mail to other external users. Any ideas would be
Create a Contact with the friend's address as targetAddress, configure the
Contact to not receive email from an...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...Send Receive has 125 tasks that error in Outlook 2002
We have Outlook 2002 SP1, DSL line going to a POP server. Connection set to
send immediately and get email every 7 minutes. This problem started about
a week ago, without any changes to the system, that we know of (solid user -
This users send/receive status never seems to reach 100%. When I look closer
it has 125 tasks that it is trying to complete. The user only gets email
when they start Outlook. What are these tasks? How do I cancel them so the
users can send and receive normally.
I have Googled and seen others with this but haven't found a thread that ...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 ...Auto forward email rule
Not sure if this should be posted here or in an exchange forum so sorry if
this isn't the right place for it!!
We have Exchange 2003 on our server providing our company emails. We have
remote users who use Outlook clients (2003 or 2007) to send and receive their
company emails using pop3.
One of the users has a need to autoforward emails in his absence to another
of our employees, he tried using the Rules to set this up but it fails to
work unless he is actually in his email. This suggests it is a client side
rule? Or is it the server overriding / preventing th...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...MMC crashes when trying to create Protection Groups
I am having a issue with a secondary dpm server crashing when trying to
create a new protection group. We get the ID 998 message when expanding the
primary server. When trying to create a new pg it will crash and then close.
The secondary server is on Windows Server 2008, 32 bit. DPM has been patched.
This issue just started happening yesterday. The primary server is Windows
Server 2008 R2.
Can you please make sure both side DPM versions are same and are having the
latest QFE deployed with DPM 2007 SP1 or having DPM 2010 RTM version?
Th...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...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
"Naresh" &...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...