Copying Data from MS Word into Excel #2
Unfortunatley the Word documents aren't tabled.
OptionTrader's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1495
View this thread: http://www.excelforum.com/showthread.php?threadid=26583
Could you convert it to Tables in Word (Table>Convert>Text To Table)?
"OptionTrader" <OptionTrader.firstname.lastname@example.org> wrote in message
> Thanks Sue.
> Unfort...Problem with saving an XML file
I am trying to write to an Xml document. My xml file is present is in the
current working directory but whenever i try to make changes to the file and
save the change in the XML file (which i specify as a parameter to
doc.Save() method) it searches for the file in F:/WINNT/System32 folder...
Even if I specify the path explicitly to
"F:\Inetpub\wwwroot\WebApplication4\UserPass.xml" it gives an error.
I have specified the code below.
May I know if there is any way by which I nee to set the default path to my
XmlDocument doc = new XmlDocument();
string ur...Data Validation Lists
I have a question regarding the drop downs lists created using Data
Validation. Is there any way to make them so that when I type something new
into the box that it is automatically added to the drop down list? Thank you!!
Download a sample workbook from Debra Dalgleish's site.
Scroll down to DV0012 and download the workbook.
DV0012 - Update Validation List -- type a new value in a cell that contains
data validation, and it's automatically added to the source list, and the
list is sorted; a macro automates the list ...Money 2005 Installed, Bank Data downloaded.....
Can anyone tell me if there is a way to set a category for an institution and
have it change all transactions affecting the institution?
I downloaded 3 months worth of credit card and bank data. I would like to
avoid updating and categorizing every transaction in the account register if
I would like to know if you can categorize a transaction by the payee....
Any help would be a big help. Thank you.
You'll have to do that manually at first. Then, if you've set the options to
use auto-complete, it will remember the last category used for a given
payee. Check the editing t...Undoing a change that has been saved
I Have a database with close to 3,000 addresses on it. I put it in zip code
oreder then saved it and closed it when I reopened it and realized I had only
arranged the ZIP code and not the addresses that go with them. Is there a way
to go back and find an old one. Or to undo a change of the nature?
You cannot undo a change once the workbook has been saved.
Do you have a backup copy somewhere?
Did you ever send the file to a friend or co-worker?
Are you set up under Save options to "always create a backup"?
If so, you will have a backup of the save before th...Problem moving data from Access to Excel
Thought so to but to no avail. Still receive the same error. Excel VBA Help refers to the cell as
I have tried:
wkb.Worksheets("Sheet1").Range(lngRowIndex, lngColIndex) --> Returns Error 1004
Worksheets("Sheet1").Range(lngRowIndex, lngColIndex) --> Returns Error 1004
With wks("Sheet1").Range(lngRowIndex, lngColIndex) -->Returns Error 438 Object doesnt support
this property or method
Thanks for your help.
Reply Only To The Newsgroup
"Dou...Rules; Can they be Saved/Moved
Can the rules, you create, be saved off somewhere, so you can apply them to
second outlook on another computer?
Are these stored in the Registry?
Rules storage varies based on version of Outlook and type of account. What
version of Outlook are you using?
" JCO" <email@example.com> wrote in message
> Can the rules, you create, be saved off somewhere, so you can apply them
> second outlook on another computer?
> Are these stored in the Registry?
Outlook 2002 that came with OfficeXP, alt...retrieve data
How do you retrieve data from an external source?
I have an access DB off-site sitting on a remote web server. I do have
access to it. How do I retrieve data
off it and use it in a local Excel spreadsheet? So that
I can format a customize report rather than build a web page.
have a look at 'Data - Import External Data - Import Data'
you can select your Access database and the respective datasource
> How do you retrieve data from an external source?
> I have an access DB off-site sitting on a remote web server. ...Printing Specific Data
I made a database for a delivery company and when I click the print button on
my database it prints all the addresses we have stored for a specific
client... My boss now tells me that we need to print a "Dispatch Service
Ticket" for our drivers.
How would I go about making a report that only prints the addresses needed
for that delivery?
Would I need to create a form that has checkboxes and when checked it shows
the addresses I want to be printed?
It is very hard to tell you what to do without knowing what data you have in
How many add...Get all Parent Child data of a table
I have a table that have two column one is ParentID and other is ID .
ID Parent ID
I need to do waht is : If i said i need all parent, child for ID 1 than it
should return 1,2,3,4,5,6
If i say to get data for ID 5 than it should return 5
If i...Resource File does save WideChar ?
I'm testing with a small windows program using VC7.1. I have inserted a new
string table and set the language to "Chinese (PRC)". I also entered some
Chinese characters in the string table using IME. But the string table shows
those Chinese chars as "?" What should I do so that the string table stores
the Chinese chars?
I tried to define the UNICODE, but it did not make difference.
Thanks in Advance.
I've never done this, but there is an issue between what it "shows" and what it actually
contains. What do you find in the .rc file?
...Save Dialog Box for Smartphone 5.0
I am developing an application to enable user to save file with
desired file name, I can get a save dialog box in Pocket PC 5.0 using
GetSaveFilaName API, but it dont work for Smartphone 5.0.
Is there any way to get Save Dialog Box in Smartphone 5.0 using VC++.
I would realy appriciate any help.
...Data Migration Framework for 3.0
Can somebody tell me if the data migration framework is available for
3.0? If yes can it be used for data migration from 1.2 to 3.0?
If No, when will it be made available.
firstname.lastname@example.org a =E9crit :
> Can somebody tell me if the data migration framework is available for
> 3.0? If yes can it be used for data migration from 1.2 to 3.0?
> If No, when will it be made available.
According to the Microsoft beta support, the DMF released date has just
been pushed to about until 90 days after GA.
...Customization auto populate account lookup from contact data
I am customizing the CASE form on 3.0. I have added the system attribute
called 'responsiblecontactid', (Schema Name) which is a relationship that
creates a lookup to Contacts.
This is how the CSR's will begin the form, by collecting the caller's name
and associating them with their contact record, which we hope is in the
Next, once we find the customer's CONTACT record, I'd like to then
automatically hook into the onChange() event to populate the CUSTOMER
attribute, (schema Name = 'customerid') which is actually a relationship that
crea...I can't add minutes & seconds on imported data
I have used Abby Finereader OCR software to scan a phone bill into
Excel 2000, for the purpose of adding the time spent talking to
various phone numbers.
The OCR software works fine, and I get a column of numbers which
represent the minutes and seconds similar to
The trouble is that I cannot add them as they are. They always add to
zero. I converted the cells format to Custom [h]:mm:ss but they still
will not add.
I then created a helper column, and used the Concatenate function to
add "00:" in front of each of each of the existing values. The column
looked l...Data Consolidation #3
I hope someone can help me. I have a list of about 30k PCs for a
Enterprise Dollar estimate thing. I need to find out how much money
each Business Unit has in PCs. I have a list of PCs, Cost Center, and
Device Type, but like I said I have about 30k of them. I need to find
out how I can tell Excel to look for how many instances of each there
are per Cost Center. Any ideas?
Make a Pivot Table. Drag the Cost Center into the left or top. Double-click the heading
and set it for count. Drag it again into the data area. This is a bit different in earlier...duplicate data in column
I created a spreadsheet with three columns from data pulled that may not be
correct. One of the columns is MAC address which I know there are duplicates
in this column.
Based off the 500 rows, I am trying to figure how can I find out where a MAC
Address is in the MAC Address more than once. I have found that the MAC
address which is tied to a device could be in two locations and I am trying
to narrow where it might be since the place we get all the data is never
Excel Format example of the file
Location Number MACAddress
DC1 21 00A0F8610E1C
DC1 20 00A0F8610E...Query Wizard - Filter Data
I regularly use an MS Access query as a external data source for
pivot table. The Access database was recently upsized to SQL Serve
2000. Now when I try and use the MS Access query as the external dat
source I get a funny issue. In the query wizard, when I try and filte
the data using the dropdown box, the data behind the column I am tryin
to filter on does not appear - the dropdown is empty
Other useful info: the Query joins 3 tables
jameshalligan's Profile: http://www.exce...Lost all outlook data! Where can i find it back
I have a laptop computer with W2k and i have officeXP in
it which installed over Office2000.
It have all worked OK for some time, until today i just
lost everything out of Microsoft Outlook. Lost contacts,
inbox, outbox, all mail accounts, notes...........
Is it possible to find it in some file somewhere on
There must be some file outlook keeps all data in.
Do a search for a .pst file. This is the file outlooks keeps all the
contacts / emails and what knots in.
"Logni� Stormsson" <email@example.com> wrote in message
news:02ea01c3c8ed$4...how to show the weekly change and monthly change from the source of daily updated data ???
Hi all~! I have to update the price of different bond daily a
*Mar 5 Mar 6 Mar 7 Mar 8 Mar 9 Mar 12*
BOND 1 101 103 105 104 107 109
BOND 2 156 160 170 166 168 168
BOND 3 85 88 87 85 86 8
how can i achieve the daily and weekly change as following (if i onl
update the spread as above in one spreadsheet and then have th
analysis on another new spreadsheet, accordings to the date selected)
*Mar 5* daily change weekly cnahge
*bond 1* *101 * + 1 +5
*...Text Box on Report won't hold user data entry after loosing focus...
I have created a report in Access 2007. This report needs to
display records between two dates entered by the user. I put two text
boxes on the report so I can enter the start and end dates - I set
them to use an input mask of 'short date' format. The problem is that
when I enter anything in these text boxes, as soon as the field looses
focus, the text is cleared out - thus the text box is left blank. I
have a button on the report that calls the requery method of the
report and also, as a test, displays the values of these text boxes in
a msgbox, but it also shows they are blank. Wh...Save as JPEG problem
I have created a document in Publisher 2002 and want to
save it as a JPEG image 24x36 inches.
I have noted that the text that is on the document does not
look clear when viewed at 100% size. Edges ragged, etc.
Does anyone out there know if there is any way to specify
the resolution of the file?
Any other thoughts on how I can solve this?
You cannot specify the resolution of the file in Publisher 2002.
In Publisher 2003 you can specify a resolution up to 300dpi. You have 3
choices in Publisher 2003, 96 DPI which is what you get in Publisher 2002,
then there is 150 DPI and 3...Print sorted data
I'm want to sort data frfom various worksheets and that this data be printed
all in one page, actually if the information is from five diferent
worksheets, the print out comes out in five diferent pages.. I'm using
Microsoft Office 2003.
Maybe you can use this
Regards Ron de Bruin
"Joseph Solis" <Joseph Solis@discussions.microsoft.com> wrote in message news:186904AC-D5B4-41D6-8ED6-961D5AB77479@microsoft.com...
> I'm want to sort data frfom various worksh...Data Form
I'd like to have the Data Form appear automatically on opening a
spreadsheet, rather than going through Data | Entry from the toolbar.
This is to be used for data entry into a simple club membership list.
Can this be done, and if so how?
Private Sub Workbook_Open()
This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code f...How can i do those three steps automatically :Filter data, sort the order, copy & paste to another worksheet
i have a Sheet "1" it contains four columns "Country", "City", "TEL#" &
"CONTACT PERSON" with hundreds records.
I want to filter the data where it shows "U.K." in the column "Country" and
copy those records to the desired rows in another Sheet "2", where those
records are presented of "City" in ascending order automatically.
Now I have to sort the data by "City" firstly, filter the record by
then copy & paste to another worksheet.
I have tried the "Filter&quo...