Inserting files into excel worksheets
Why is there no option for inserting an files into an existing Excel
worksheet similar to the option forinserting files into Word and PowerPoint
files. I work for a CPA firm and this would be a valuable feature feature.
"ccwies" <email@example.com> wrote in message
> Why is there no option for inserting an files into an existing Excel
> worksheet similar to the option forinserting files into Word and
> files. I work for a CPA firm and this would be a valuable feature feature...Excel 2003 Printing
How do I print multiple active worksheets in a workbook, twosided (duplex)?
I've done parsing where you have one delimiter such as a comma or
What if you have more than one?
sStr(0) = "3/9"
sStr(1) = "3/11 3/15-"
sStr(2) = "3/8+ 3/12"
sStr(3) = "3/9 3/15"
sStr(4) = "3/8- 3/10+ 3/15"
The strings above are Month/Day with some having an additional - or +
character next to it.
These dates are extracted from Excel cells as strings.
I need to break those strings down into individual dates.
So for sStr(4), I need to parse out "3/8", "3/10" and "3/15&...How do I align ( ) in excel?
The ending bracket will align nicely. Is it that you want to align these
negatives numbers in a column which also has positive numbers?
"jules" <firstname.lastname@example.org> wrote in message
This is done through number formats
The underscore character means leave a space the size of the following
The first part of format is positive numbers followed by negative followed
by zero followed by text
"Fred Smith" wrote:
> The ending bracket ...Excel 2007 #4
i have the first name in the cell of an e-mail list and i need to add the
(@etc.com) can someone tell me how to do this
mfm i need it to look like email@example.com
"David TW" <David TW@discussions.microsoft.com> wrote in message
>i have the first name in the cell of an e-mail list and i need to add the
> (@etc.com) can someone tell me how to do this
> mfm i need it to look like firstname.lastname@example.org
> please hel...Date conversions....Excel thinking too hard?
We have many programs (Access, SAP, etc.), that when they
try to export to Excel, Excel always tries to convert our
part numbers into dates.
For instance, we have a part number, 1944-1-5, that needs
to be exported to Excel as a text value, 1944-1-5, not
converted to a date, like 1/5/1944.
And no, putting quotes around it is not practical, since
we have thousands of part numbers.
I have successfully exported from Access using the
TransferSpreadsheet method in a macro or VBA (instead of
the standard "File | Export..." menu selection) without
the date conversion occuring. Ho...Excel report
I am new to Excel. I am doing a short course on it and have to write a
short one page report on how it can manipulate data. The problem is
all the books talk about excel in terms of examples.
What I need is some basic information on Excel in general, just someone
saying how good it is for modelling situations.
Can anybody send me a few line, please!
Message posted from http://www.ExcelForum.com/
"Steven >" <<Steven.email@example.com> wrote in message
> I am new to Excel. I am doing a short cour...Help with Excel Inventory Database
Is there a good example of a parts inventory database and reports that is
publicly available? I have an idea of what I need to do with the columns
for receiving and releasing parts, but I am not certain how to display the
current inventory for each part. Any help will be greatly appreciated.
Take a look at my Excel database tutorial at
"ridgerunner" <firstname.lastname@example.org> wrote in message
> Is there a good example of a parts inventory database and reports that is ...how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it possible?
how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it
"Daniel" <email@example.com> wrote in message
> how to parse <?xml version="1.0" encoding="UTF-8"?> with xpath? is it
No -- the xml declaration is not represented in the XML Infoset.
I have data in cells which is OCR`d from my phone bill, and
some of the info is corrupt. Where I should be getting eg. 17 Nov 14:49 for
date/time I am getting O17 Nov 14:49 or
C17Nov 14:49. The reason is that there are unreadable icon characters to
signify day or night.
1)How do I remove the faulty characters......they are always the first digit
in the date if they are there.
2)How can I seperate the date and time into two adjasent colums of cells
rather than their current format in one cell.
Any and all help greatly appreciated. John
You ca...How do i link Excel to Powerpoint slide show & see graph on wk she
I establish a link that shows on the screen but I want to be able to print
slide from powerpoint on Excel spreadsheet.
...Excel copy and paste
I have tried to copy a worksheet with several columns and
rows of data and paste to another worksheet but I lose the
formatting of the rows and columns and then have to
manually reformat (I've tried to use paste special but
this doesn't help)
Also with the same worksheet I filtered the data down to a
group of rows and would like to copy this to another
worksheet and hide the other data or delete it to send it
to someone else. Is this possible?
"Anne Girling" <firstname.lastname@example.org> wrote in message
news:a4f901c346d0$9bc1b110$a401280a@ph...mkdir command in excel 2003 on XP SP2
The mkdir does not work after the install of SP2 Why?
Maybe you're trying to create a subfolder to a folder that doesn't exist???
"zvi carmi via OfficeKB.com" wrote:
> The mkdir does not work after the install of SP2 Why?
It works for me just fine. What problem are you encountering? Any
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"zvi carmi via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in
message news:3e03c3efad8341d8a77eb841212c7e20@OfficeKB.co...Parse Nested Elements to Single DataGrid
I have been losing my mind trying to parse an XML document (with nested child
elements, not all of which appear in each parent node) into a DataGrid
object. What I want to do is "flatten" the XML document into a text
document with a single row for each parent node (that has all of the values
from all of the child nodes for that row)
The DataView within VS 2005 IDE displays my 15 or so child tables - and
knows that some parent rows don't have child rows in every relation - but
trying to get all the child tables to go with the correct parent row
programmatically is killin...I lost a document in excel, the whole document disappeared
I have had a document in Excel for over a year. I simply went in the get a
serial number, then exited out. Later I went back and the document is gone.
The file name is still there but nothing comes up.
Try opening the file and then:
(1) Windows | Unhide
If this does not work, try:
Windows | Arrange | Ok
"Excel Document Gone SSW" <Excel Document Gone
SSW@discussions.microsoft.com> wrote in message
>I have had a document in Excel for over a year. I simply went in...How can I import multiple tasks from excel?
I hope you can help me, because it is annoying to import each task, one by one.
File, Import doesn't work?
See http://www.slipstick.com/Tutorials/import/import.htm if you need help
importing from excel.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this newsgroup ...Parsing CSV
im using A file with records in my mfc application, i need to read*/write
records to the file anybody ahs a clue where should i start?
Take a look at CStdiofile and CString::Format() (for output) and
CString::Tokenize() (for parsing input). You can use ReadString() and
WriteString() to access the file line by line.
"fima" <email@example.com> wrote in message
> im using A file with records in my mfc application, i need to read*/write
> records to the file anybody ahs a clue where should i start?
>...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Excel number / date conversion
I've just pulled some data out of an ODBC connection into Access an
then exported it to Excel.
The dates are currently in the format 20031109. But the built in dat
convertor (from Format Cells) doesn't do anything, even if I convert i
to a 'proper' number first.
How can I convert this to 09/11/2003 so that I can do some date - base
arithmetic and work out difference in days
markperry's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2759
View this thread: http://w...Excel charts should allow "switching" series on or off
A plot (chart) of time series data may be used for many purposes. From my
use two reasons I use such plots are:
Studying individual time series trends; and
Overall impression of all results.
But when studying multiple time series data a chart can become cluttered.
It would be useful if individual series could be seleceted as visible or
invisible so that they could be evaluated without losing the total plot.
At the moment the only way to "unclutter" the plot is to remove the
temporaily-unwanted series but it can be time consuming to reconstruct the
Thi...Email from Excel #3
Is it possible to have Excel send an email if the value of a certain cell is
see your post in public.excel
"berj" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Is it possible to have Excel send an email if the value of a certain
bonjour a tous, & a tous les pro bien sur
es qu'il est possible ,que des l'instant on modifie le code VBA EXCEL
on incremente un compteur pour les mise a jour cela me semble plus
simple merci pour vos reponse
(change the xxxx to gmail if mailing direct)
"pounet" <email@example.com> wrote in message
> bonjour a tous, & a tous les pro bien sur
> es qu'il est possible ,qu...Error Message When opening Excel
I am using Windows VISTA 64 bit O/S
with Office Professional 2003
All of a sudden I started to get the following error message:
'One of your object libraries (Stdole32.tlb) is missing or damaged. Please
run setup to install it'
I am at a loss as how to correct this. I checked online and found some
instructions that were for Windows 2000
Those did not work for VISTA at all.
Thank you in advance for your support and suggestions,
It is telling you to do a "setup to install" on the Office product, did you
try that? Did you try doing a repair on ...MFC: Excel Automation Can't Quit from Excel. Please help...
Hi I use MFC Visual C++ 4.2.
I am automating Excel from my application.
My problem is I cannot quit the Excel after the automation process finished!
I checked it still exists on the Process lists and the most DANGEROUS is
everytime the automation function run, it create other Excel and so on. So it
must be out of memory soon.
I have used the app.Quit() method like all the people used but it DOES NOT
What should I do?
I happened to answer this on the office.developer.vba newsgroup. You most likely have
neglected to Release() the automation object.
On Wed, 3 Sep...ASP .NET 2.5 - VB - Excel 2003
This is my setup:
Application's front-end tools:
Visual Studio 2005, ASP .Net 2.5, VB, Excel 2003
Web server running Win Server 2003
I have a pre-formatted spreadsheet (that's why this cannot be done with a
..csv file) in Excel 2003. It needs to be populated with data retrieved from
SQL server with a stored procedure. After populated the resulting spreadsheet
file needs to be accessible to the web application's user in their local PC,
so (s)he can open it and add other data by directly editing the spreadsheet
outside the application.
How it works now...