Inserting charts into many workbooks
I'm using Excel 2007 and am pretty new to VBA. I have a folder with 40
or so workbooks- all with the same worksheet table format. The worksheets
are huge (20 000 + rows, 50 or so columns). I need to open a workbook, make
several fully formatted graphs, then insert the same graphs into every
workbook , updated them with that workbooks' data.
Any ideas on code for this?
This isn't fully automated, but it will save some time. In one workbook,
create the chart and format it to your specs. Then paste the chart into
another workbook, and use the utility linked to i...Setting series values on Excel Chart
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as i...web address help
whats the web address for outlook so i can sign on? I
have it stored on my home computer but dont have it here
Outlook doesn't have a web address unless you use an Exchange server.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
<email@example.com> wrote in message
> whats the web address for outlook...HELP!! Viewing email images
I have just recently switched to using Outlook rather than
Outlook Express as my email program.
I now find that any image attachments (.jpg, .bmp etc.) I
receive are not visible onscreen as they used to be in
I have to click on each attachment icon to view...
It's annoying, especially if I get a series of pics...I
have to manually ope each one...
Does anyone know how to set Outlook so that it shows me
these images onscreen???
...help installing exchange 2000 in one of 3 sites
I have a domain cotoso.com installed and configured as AD for 3 companies
interlinked together. and + a total of 3 DC in 3 different sites that are
connected by VPN. i have exchange installed in each site connected on the
same domain contoso.Local(+ E-mail -->contoso.com) + hosting their own
companie domain name such as x.com or y.co or z.com for each company.
I have a routing link configured + 3 administrative groups in exchange
system manger for each company.
one DC in one site that also has exchange 2000 installed on it has to be
changed because of poor performance. now i'm ...Need help getting this code to compile under VS.NET 2003 (compiles under VS6.0).
I'm tasked with converting a LARGE project from VS6.0 to VS.NET 2003. Here
is a VERY scaled down version of an error I'm getting. I must be getting
rusty, but the way to get around this compiler error is just not coming to
If you need to compile this, just create a Win32 console app and specify to
add support for MFC, then copy this code into the cpp file and press
class CLogItem : public CObject
virtual BOOL CheckConflict(CLogItem* pItem) const;
struct MapEntry; //forward declaration..
typedef CArray<MapEntry, MapEntry&> CMapEntryArray;...arrows along a line
Is it possible to add arrow points along a line at intermittant locations
.... not just at the end.
If you have a definite number of arrows that you want, do this:
1. Draw a line segment
2. Copy it several times, placing them all end-to-end
3. Select all the segments and choose Shape > Operations > Combine
4. Apply arrowhead formatting.
Or, you may need a custom line pattern instead. Look here for more info:
A detailed tutorial from MS:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/devref/HTML/DVS_10_Managing_Styles,_Formats,_and_...help!! smtp protocol error occurred
exchange 2000 srv/windows 2k srv
smtp protocol error occurred when trying to send mails.
Still waiting for some relavent information so we can
help you solve your problem.
>exchange 2000 srv/windows 2k srv
>smtp protocol error occurred when trying to send mails.
I had that problem, I telneted into the servers that the error occurred and
found I was on a blacklist. Had to sumit to an open relay test, and bam, no
...To write living will do I need special format
I just need to change and update a living trust
You should consult someone with the appropriate legal knowledge in the
jurisdiction in which you are domiciled.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"belladonna" <firstname.lastname@example.org> wrote in message
> I just need to change and update a living trust
I was migration my Exchange 2000 to 2003 I do my forest prep and domain prep
But i can't create mailboxes ???
some documentation please...
What actually happens? What error do you get?
For Exchange news, links, and tips, check:
"A.dian�" <Adian@discussions.microsoft.com> wrote in message
> I was migration my Exchange 2000 to 2003 I do my forest prep and domain
> But i can't create mailboxes ???
> some documentation...I get COMException while exporting chart on IIS 6.0.
I have this code that works perfectly on my development machine when I
deployed it at customer site it gets exception. Here is the error and my code:
Exception from HRESULT: 0x800A03EC.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Exception
from HRESULT: 0x800A03EC.
An unhandled exception was generated during the execution of the c...Help ! formatting data to text
I am creating data in an Excel spreadsheet. I then want to get that data
into a simple text email. I have some problems and questions...
1) how do I get the columns of data to line up evenly when I copy the data
to email text ? Keep in mind I need to be in simple text format, not HTML
or rich text.
Every time I do this, all columns become chaos and are unreadable.
2) Is there a simple way to automate the creation of an email from an excel
file ? this is less important to me.
Thanks in advance
#1. I think it may have to do with what email client you use, too.
I copy and ...chart line style problem
I am making a scatter chart (with lines) in Excel 2007 under
Vista. I can select a line style, for example, long dashes.
However, if I try to change the axis (change from "automatic" to
"fixed" on the horizontal axis), the line on the chart immediately
becomes solid again. The legend still shows the proper dashing.
I can get the dashing partly back by making the line thinner,
but only where the variation is fastest - regions where
the derivative is near zero are still solid even for thin lines.
I'll appreciate any help!
I was not able to reproduce this.
Can you...How can I stop charts from refreshing when changing source data?
My problem is, that I am working with a lot of data and when I change some of
the ranges all charts in my view refreshes and it takes much time. My pc is
aP4 3GHz, 2GB RAM so that should not be the bottleneck. Is there any way to
force the charts not to update all the time?
...form and query problem. please help.
All tables are linked with weak entities. However, when i enter data on the
form I can't get it to let me enter more than one partipicant without access
generating a new invoice id. however i need one invoice to many participants.
It wont work and i have no idea what to do at this point. in addition the
workshop will not let me add workshop to invoice. this is a small mdb and i'd
like to email it to anyone who can assist me with the relationships as I
think this is the problem but I don't know what to do. please help me.
invoiceNO - autonumber
wo...how do I remove fx from the function line, can't enter data
I have the fx displayed just under my toolbar, and I can't enter or change
data in any of the cells in the file. I can't get the red X, the Green check
mark, or the black = sign to appear. There are very few areas that are not
"greyed out" under the headings at the top. This situation applies to all of
the excel files on this computer. I have Excel 2000. Please help.
Can you move the cursor around anywhere in the spreadsheet?
> I have the fx displayed just under my toolbar, and I can't enter or change
> data in any of the c...suggestion needed !!!!!!!!!!
In my company the want to calculate phone calls done by each sales
person at the end of the day. Please give me suggestion how to
A quick solution would be
1) Create an advance find view based on the criteria you are looking for ie.
Activity of the type phone call, Status = completed
2) Export the list to Excel (Dynamic pivot table/worksheet)
3) If pivot : Drag and drop relavent fields
3) If worksheet: filter by date and use sum.
The advantage of dynamic excel report is it updates itself when ever you
open the sheet.
Hope this is helpful
http://venkatbendalam...Integration Manager need a registration key for test company?
Can anyone tell if I need the registration key for IM if I am doing some
Test company (World Online)?
Also, can I specify the company database in IM for the data to import to?
Please advise. Thanks
You do not need a reg key for the Two Company, and if you are using the
standard adapter the data will integrate into the Company that is open in
Great Plains. You can Specify which database you want to integrate into by
using the SQL Optimizer. You do not need great Plains open for this adapter.
> Hi all,
> Can anyone tell if I nee...Newbe help with a lookup
I’m trying to make some modifications to a salary matrix and
I’m having trouble with a lookup.
In column A I have a series of numbers from 0 to 30 representing pay
grade steps where 0 represents a new employee and 30 represents an
employee having completed 30 years of service. In column B I have an
annual salary for each of the corresponding pay grade steps.
I want to take a new salary and find the closest salary in column B and
return the corresponding step number.
For example if the new salary is $73,415.13 and the matrix shows step
15 is 73,205 and step 16 is 73...HELP
We have an application that is used by over 8000 people worldwide. One
of our users is just starting to have the following problem:
Run-time error '-2147467259(80004005)':
Method 'Add' of object 'CommandBarControls' failed
I have read that this problem can be caused by trying to open the file
in Internet Explorer. The user has told me that she has tried opening
MS Excel and then the .xls file and she still gets the same problem
when the file is trying to open. She is the only one that has had this
problem. Could there be something wrong with her Excel settings or som...Inconsistent Chart Sizing Into PPT
Can't get charts to paste into PowerPoint with consistent size. To test, I
expanded (using the corner handles) two charts to exactly fill the screen.
When I copy/paste each chart into an individual slide in PowerPoint, one is
noticibally larger than the other. Is there a way to make the charts the
same size and paste the same size?
I have an article on this in the works, due out in about 24 months, the
rate I'm going.
A. Use embedded charts, and use Copy Picture (hold shift while selecting
Edit menu, os Copy turns to Copy Picture) with On Screen and As Picture
B. ...Charting dynamic range
Ok let me say i fully understand how to name a range and in the source data
use the formula =sheetname!rangename
Problem arrises when my macro that runs an advanced filter with the source
data and add data to the bottom of the range the chart reverts back to it's
initial data source =sheet1!$a$4:$b$15
so even though it accept the named range intitailly once the advanced filter
runs it almost ommits the named range. I am using 2007 and i never had this
problem in 2003.
What suggestions do you have for me?
...Default font in charts
Is there any way to change the default font in charts? ie, I'd like every
axis and title to be 16pt Times New Roman right off the bat. Thanks.
"Alex" <Alex@discussions.microsoft.com> wrote in message
> Is there any way to change the default font in charts? ie, I'd like every
> axis and title to be 16pt Times New Roman right off the bat. Thanks.
Set up a chart the way you want it to look. Right-click in its chart area
and choose Chart Type. Click the Custom Types tab and hit the "set as
default...Help with keeping inventory.
I was wondering if someone might be able to help me. I'm trying t
come up with a way to keep inventory of product.
Basically what I need is to keep track of the current inventory of
items... and what I'd like is for different users to be able to ope
the worksheet and enter the NUMBER OF PRODUCT they are removing at tha
time.... and for the total inventory of each item to be adjuste
accordingly. The only catch is - I'd like to be able to use the SAM
CELL always -- that is - I want only one cell to be the one that i
used to enter the amount of inventory being o...Dynamic chart labels
I am using a dynamic bar chart and want to add a label to an individua
data point. Is there a way to do this so that the label follows th
data point as the chart updates
danoPosted from http://www.pcreview.co.uk/ newsgroup acces
A datalabel will follow the datapoint and update as appropriate. To add
data labels to a series, double click the series and click on the Data
Labels tab. To add data labels to a single point, select the series then
the point (two single clicks), then double click on the point, and again
click on the Data Labels tab.
Jon Peltier, Microsoft Ex...