i'm Newb , Totally Newb to Excel :(
How do i make Excel Files that End up With .iqy
i need Excel to Extract Information From a website , like a income
statement of a stock , Balance sheet , cash flow statement of that
specific Stock !
is it possible that each team i Open the files it let's me type in the
stock Symbol that i need that information for ?
i don't know how to make this File !!!
Message posted from http://www.ExcelForum.com/
is that possible ?
Message posted from http://www.ExcelForum.com/
"Pivotrend >" wrote
> How do i m...Which Office X 10.1.5 duplicate fonts can be removed from which folders?
Which of these duplicate fonts can be removed from the
Applications/Microsoft/Office X/Office/Fonts folder AND/OR the
All of the following are duplicated in the two folders. Two of them, Times
New Roman and Verdana, also are in OS 10.3.3/Library/Fonts.
Comic Sans MS
Copperplate Gothic Bold
Copperplate Gothic Light
Edwardian Script ITC
Times New Roman
On Tue, 6 Apr 2004 04:42:59 -0400, Norman R. Nager, Ph.D. wrote
(in article <...launch app and read file by drag and drop
How do I get my application to open and read a file when
the file's icon has been dragged onto the application
icon? I can drop a file onto the open application and read
it, but I can't figure out how the application gets the
file name when the file's dropped onto the icon. I'm using
One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with ONLY local expenses.
Trying to get ALL expenses together, but eliminating the duplicates from new
list. Thinking B2=date. C2=name, E2=amount - - SO B2&C2&E2 on first long
worksheet and then the same on short worksheet... Bring BOTH over to new
tab and then stuck. Any ideas greatly appreciated, or another better way to
You could use excel filter:
Data - Filter - Advanced Filter - Unique records on...HELP! How to extract information in inbox/sentbox into a text file
Can any one tell me how to extract the information of new mails in m
inbox/sentbox, including the sender name, message subject and messag
time, into a text file
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
...Duplicate data from field into another field in same form?
Can I duplicate data from one field on a form into another field in the same
On our exhibitor entry form, the Program Contact info (fields for name,
address, phone, fax, email) is entered first. Mail Contact info is often the
same, but not always.
Is it possible to autopopulate the Mail Contact with the data from the
Program Contact, but allow me to enter new data if necessary?
If so, can you tell me exactly how?
On Fri, 23 Mar 2007 09:46:24 -0700, Andi <Andi@discussions.microsoft.com>
>Can I duplicate data from one field on a ...csv file download
I have 17 csv files that I download individually daily
from a website, can anyone tell me the quickest way to do
this ie some sort of automation.
Consider using the Microsoft.XMLHTTP object. With VBScript you could do
Sub GetCSV(sSource, sDest)
Dim oHTTP, oFSO, oTS
Set oHTTP = WScript.CreateObject("Microsoft.XMLHTTP")
Set oFSO = WScript.CreateObject("Scripting.FileSystemObject")
Set oTS = oFSO.CreateTextFile(sDest, True)
oHTTP.open "GET", sSource, False
Set oTS ...Money 2004 crash in mnyob99.dll with new file
I just upgraded to money 2004. Whenever I created a new file (via
File->New File), money crashes and the system (XP) reported the fault
was in mnyob99.dll. This means that I won't be able to create any new
money file at all. I also followed some earlier message by opening the
sample money file, it works, but then it still crashed when I tried to
create a new file.
I searched suport.microsoft.com and did not find anything that would
solve the problem.
Please help. Thanks.
MJ - I have a very similary problem installing money 2003, and the suggested
help provided to me in an earlier mes...Receiving duplicate emails
I have just recently created my email account in
Microsoft Outlook and now when I receive email I get the
same one 15 times (and that is no stretch!) Is there
something I have done wrong? How do I fix this?!
What version of Outlook do you have? What sort of mail account(s)? Do you
only get a single message many times, or all the messages many times?
This posting is provided "AS IS" with no warranties, and confers no rights
"Carrie" <firstname.lastname@example.org> wrote in message
news:email@example.com...Events copy and paste
I have a spreadsheet in which I want to automatically enter a date, and copy
from cells l1:l6 and paste in the same line as cell a2, a3, etc everytime
someone enters information in say cell a2, or a3, and so forth. result
should be cell d2 has a date and e2,f2,...have l1:l6 copied into it. Please
Adding the date to column D is no problem.
Transposing I1:I6 to E2 is no problem.
You want I1:I6 copied into E2:J2 then E3:J3 etc?
You will be overwriting column I cell in each row
Is that really what you want?
Gord Dibben MS Excel MVP
...Exchange 2003 log files #2
In C:\Program Files\Exchsrvr\MDBDATA\ i have many files like E000085D.log,
all that files are very old maybe 5-6 moth old logs, may I delete it
manualy? or Exchange must delete it himself?
Those are your transaction logs - do not delete them. The fact that you have
so many indicates that you aren't running online backups of the Exchange
stores using an Exchange-aware backup solution such as NTBackup on the
server....this is a must. The committed logs will be purged when this is
Armarn O.R. wrote:
> In C:\Program Files\Exchsrvr\MDBDATA\ i have many fil...Copy rows to master sheet
I have spent more hours than I care to admit trying to figure out the
code for copying rows that have updated date to a master sheet. I
have a command button on the bottom of four sheets that I want the
user to press and send information that has changed to the master
sheet. I want them to be in sequential order (no spaces).
Upon sending it, I want the changes to the cells to revert to the
original state. They are supply order forms. The only thing that
changes is the number of units that someone wants and the total price
for the units.
Sku# Item Name #Wanted Unit Pri...Cannot play some WMA files in WMP12
Most of my music plays fine, but some of the WMA's i have that were ripped
with a previous version of WMP will not play in WMP12 and also WMP cant read
the tags in the file properly.
You might have better luck reposting this on the Windows 7 Media forum:
This forum is aimed more specifically at problems with WMP 12.
Tim De Baets
Chops II wrote:
> Most of my music plays fine, but some of the WMA's i have that were ripped
> with a previous version of...File saved yesterday is blank today, how do I retrieve?
A file that I work on nearly everyday is now empty of any data. I saved
changes yesterday, and on opening today the worksheet has no data.
How can I retrieve a previous to yesterday version of this file?
Unless you have a backup process in place and can recover a copy from the
backup, the data is probably lost.
If you deleted a copy of it, you might find an older copy of it in the
You might do a 'Search' of 'My Computer' to see if you accidentally saved it
somewhere that you don't remember saving the final copy.
Sorry to be the bearer of ...Determine File Location
Is it possible (in VBA) to check and see where an Access file is being
If mdb/mde file attempting to be opened resides in C:\db then
'do something else
"alex" <firstname.lastname@example.org> wrote in message
> Is it possible (in VBA) to check and see where an Access file is being
> opened/accessed from?
> For example:
> If mdb/mde file attempting to be opened resides in C:\db...Duplicate, Duplicate, dupli ...
I'm new to the group, so hope I don't disgrace myself.
I have a list of names in the first column, and their respective postal
codes in the second. Unfortunately, many of the names, (and respective
codes), are duplicated... sometimes there are up to four of the same name,
(and code), under each other.
Is there a way to get rid up the duplicates and make a usable list please? I
can do it manually of course, but ..
Data>Filter>Advanced Filter. "unique records only" and "copy to another
For more on this visit Debra Dalgl...Adding only new files to a backup folder
I have a folder containing some five thousand files sorted in numerous
subfolders, totaling about 800GB so far and counting. I occasionally
add a new file to an appropriate subfolder.
So far I safegurd by copying the entire folder on a backup drive. Such
a task naturally takes long, long time (two days or longer) even
though only a small fraction of the files population is newly created
I am looking for a way that first compares the backup folder witht the
parent folder to isolate newly added files and then copies them to the
existing backup folder. This way I shou...Quit creating duplicate desktop icons when doing upgrades/hotfix
Upon any sort of upgrade or hotfix, RMS creates a whole new set of desktop
icons. What a pain! Pls fix. Ask if we want to create new desktop icons,
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/...How do I duplicate numbering on a raffle?
I am creating an event ticket but would like to number the tickets on both
the left and right sides of the ticket.
Create a data base with your numbers. Use mail merge for the tickets. You can
insert a mail merge field on both sides of your ticket.
When you merge have one ticket on your screen. What version Publisher are you
using. Some early versions of Publisher shows all the merge items the same in
print preview. This is a Publisher bug.
Mail, e-mail, and catalog merge
"Candi...Filegroup restore used to refresh database copy
I have TestDB1 comprised of 5 filegroups, which I've completed full/log
backups to restore as TestDB2. When data changes within one filegroup on
TestDB1, I've taken a diff' + tlog backup and tried to use it to restore on
TestDB2 so that same filegroup would be essentially refreshed. My execution
the last full, last diff', and tlog from TestDB1 but this doesn't work?
Why? Is there a way to do this ? Thx. -CqlBoy
What do you mean by doesn't work? Are you getting an error or different
results than you expected. Please provide more detai...Cannot write the contents of an Object to file
I would like to write the contents of a Collection of Objects to a
file, but I'm having a lot of problems. Can you help me? Here's a
simplified version of my code, which reproduces the problem:
Dim I As Long, Record As CRecord, Coll As Collection
Set Record = New CRecord
Set Coll = New Collection
For I = 1 To 26
Record.Linea(I) = "foobar" & I
Call WriteDataToFile("foo.txt", Coll)
-------------------...How to delete "non-identical" duplicate records in an Access table
How to delete "non-identical" duplicate records in an Access Table? Where
"non-identical" duplicate record means a record in the table that has
slightly different datum in one of the fields, but an identical duplicate
datum in the field that I am concerned with. For example:
SSN MRN CLIENT NAME
001-00-2222 11170419 Smith, Jane
001-00-2222 11170419 Smith, Jane T
001-00-2222 11170419 Smith, Jane Thompson
The data of these two records in the fields SSN and MRN are identical; but
"non-identical" in the CLIENT NAME field (notice...Can't open file in Outlook
I keep getting a message about:
"can't open file: X:\xxx\xxx.msg The file may not exist,
you may not have permissions to open it, or it may be open
by another program. Right-click the folder that contains
the file, and then click Properties to check your
permissions to the folder" when trying to open some
Now, the file is there, but it won't allow me to open it,
move it, or do anything to it, saying it has created a
sharing violation. What's wrong with Outlook 2000? This
is Outlook 2000 SP3.
...Automatically open excel file after log in
How can I automatically open the excel file when log in to Windows
Create a shortcut to the file and drop it into your Windows STARTUP folder
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
"Emkay" <Emkay@discussions.microsoft.com> wrote in message
Any clues on how I could get duplicate itemlookupcodes?? I found a few of
them recently. No SQL queries have been run to generate them and if I try to
create a duplicate itemLookupCodes I am stopped with a message telling me to
use a unique name. How could they have gotten in the database? Any clues,
boos or comments appreciated.
Thanks for all the help!
This is a multi-part message in MIME format.
As you mentioned, RMS Manager doesn't ...