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...RPC over HTTP problem #3
My network configuration: DC1, DC2 and MX (MS Exchange 2003, sp1). All of
them Windows Server 2003.
What was done:
In the registry on dc1 and dc2 was created a new key: "NSPI Interface
protocol sequences" with value: ncacn_http:6004.
MX was promoted to be a GC.
Installed RPC over HTTP windows component.
MX was changed to be RPC-HTTP back-end server.
On the MX Default Web Site was installed cerificate from the local authority
running on DC2.
On the RPC virtual directory anonymous access and integrated windows
authentication were disabled.
In the registry of MX the key
HK...Problems saving a worksheet with Links
Does anyone know how I can resolve this issue ... I have a directory which
contains 129 worksheets which have links to external data (in a Master
Spreadsheet) -- I need to copy these files into a New Directory, but kee the
Master Spreadsheet (which they are linked to) in the original location. If
I do a simple Cut & Past, the Reference Link to the Master Spreadsheet gets
moved to the New Directory (where the file does not exist), but if I open
the worksheet (in the original directory/location) and Save As to the New
Directory, the worksheet saved in the New Directory maintains its link t...Insert an autofiltered range into another tab
I'm am having an issue when trying to insert a range from an autofilter on
one sheet to another. The range has to be inserted above rows that have data
in them. When I use the insert.shift:xldown, it only moves down the first
Dim rngE As Range
Dim lngLastRow As Long
Dim mgrval, lobval, shtval As String
mgrval = "myself"
lobval = "dept"
shtval = mgrval & "-" & lobval
Sheets(shtval).Copy After:=Workbooks("Mybook.xls&quo...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...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?
I am using Outlook 2002 on an XP platform.
I cannot get Outlook to check for Email at regular intervals. I have the my
Outlook set to Send and Receive all my accounts every 10 minutes but nothing
happens. The only way I can receive Emails is by manually using the
Send/Recv button or pressing F9.
Can anyone offer any help.
In case it is relevant I am using Norton Internet Security 2003.
Not sure it it Yor problem, but Outlook has some problems
with Noroton Antivirus runing and chekking e-mails. As far
as I know, Outlook may stop recieving e-mails from POP3
servers due to very le...Excel problem #3
I am attaching an excel file where i have a problem
In the file are 2 sheets, Main & second
I want to get data from second sheet to the main sheet by a formula by
which the amount in the total column will be posted in the second sheet
falling under various dates. I have done for 6 sept 2003 by way of
I do not know any formula by which i can do this automatically
Please help me
Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=444742
Message posted from http://www.ExcelForum.com/
one way: ...Sync net folder problem
I am sharing my calendar to my workmate with net folder.
My PC is Win XP and Office 2000 and my workmate's is Win
98 and also Office 2000. I always find that My calender
can't be updated from my workmate when I return office
after I've taken my notebook for a few days. Can't net
folder sync. data offline? Thx. your attention.
Net Folders uses e-mail messages to send updates between computers so
naturally you would have to be connected to your e-mail to get any updates.
When you leave the office and are not connected you won't get any updates
but as soon as ...auto forward problems
I setup a 'contact' for 5 existing users in Exchange 5.5
Administrator. I give the contacts the desired SMTP
address where they want their mail forwarded to. I set
the corresponding 'contact' as the 'alternate recipient'
for each of the 5 as detailed in Q255697. 2 of 5 work,
the other 3 do not. When sending to each of the 5, 3
return undeliverable stating "A configuration error in
the e-mail system caused the message to bounce between
two servers or to be forwarded between two recipients."
Adam SK wrote:
> I setup a 'con...Exchange 2003 with SP2 problems...
I installed the SP2 for exchange 2003 server tonight, and I'm getting
some problems. I added the registry key to increase the DB size to
30GB per the instructions, but I don't get a confirmation in eventid
1216 as it says I should. In fact, the message in eventid 1216 looks
mised up. See insert:
The Exchange store '16384' is limited to First Storage Group\Mailbox
Store (ATL-SBS) GB. The current physical size of this database (the
..edb file and the .stm file) is %3 GB. If the physical size of this
database minus its logical free space exceeds the limit of First
Storage Gro...Active Directory/Exchange problem
Before I joined my current employer the admin here upgraded from
Exchange 5.5 to Exchange 2000(Box A) and then added another Exchange
2000 box to the organisation(Box B)and migrated the data in Box A to
Box B. Box B is now the working exchange server and Box A is no longer
The problem is that if I actually shut down Box A I can add a new user
to Active Directory but I am unable to modify a users email/smtp details.
mail can still be transferred with no problems which would lead me to
believe that Exchange is Ok but there is some sort of Active Directory
link between the two bo...small problem
hi every body;
i wrote a program that it has error ;plz help me :(
static void Main(string args)
Console.ForegroundColor = ConsoleColor.Red;
for (int i = 0; i < 1008; i++)
Console.BackgroundColor = ConsoleColor.DarkCyan;
move(); // ***********error is for
here***********************************************...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?
...Insert Static Date as part of Macro
I've built a nice macro, but I want it to insert the date it is run in an
empty cell within the macro's range. When working within a spreadsheet, Ctrl
+; returns the system date, but I can't figure out how to put that command
into a macro.
The macro recorder editor shows that the system recognizes the entry as the
current date, not a function that returns the current date.
The now() or today() functions are both dynamic ... they change with the
system date. That's not acceptable in this situation. I need to seen when
the macro was run.
Thanks for any help,
di...save as version 2003 problem
I'm working in vba in Access to create and save an Excel file. All's good
except that one of the workstations this is runnign on is using Office 2007.
I'm developing in 2003 and all the other workstatiosn they have are using
2003. It's very important that the files be saved in 2003 format.
When I do this, it runs fine and saves as 97/95
objExcelBk.SaveAs sTempPath & sExcelFileName, xlExcel9795 ','56 = xl
I read online in a forum post that "56" is the correct code for saving as
2003 but that's when the code is written in 20...How to insert a URL with spaces into message body
Is it possible to insert a URL containing a space into a
message body from a mailto hyperlink without using
This link will insert the URL '<http://www.micro
soft.com>' (with a space between the 'o' and the 's') into
the message body. However, the brackets will be visable
If I remove the brackets, only the 'http://www.micro'
portion will be hyperlinked. The 'soft.com' portion wi...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...Can't insert rows
I am using Excel 2007 and have just loaded a spreadsheet created in a
previous version which is running in Compatibility mode. When I try to
insert a row I get an message "Cannot shift objects off sheet".
How do I insert rows on this sheet? No problem with another workbook loaded
at the same time which was created in 2007.
See if this helps
"Cannot shift objects off sheet" error message when you hide columns in
(there's no email, no snail mail, but somewhere should be gmail in my...Hidden log on problem
On our XP Home laptop I have 2 users on the welcome screen, while my admin
account uses (ctrl alt del) x2.
All is fine until it goes into standby when I am in admin. Then on wake up
the welcome screen comes back, but (ctrl alt del) x2 does nothing. I can't
see a way to get back into my account without rebooting. Is there another
way (opening one of the other accounts is as slow as rebooting)?
On Mar 30, 9:26=A0am, "spamlet" <spam.mores...@invalid.invalid> wrote:
> On our XP Home laptop I have 2 users on the welcome screen, while my a...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...show last data point in chart
I am charting a range of observations/data points. Is
there a way to make the last data point show up
differently on the chart (different color/shape)?
> I am charting a range of observations/data points. Is there a way to make
the last data point show up differently on the chart (different
Click the charted data once to select the entire data series. Pause. Click
the single point to select it. Then use the Format menu.
Thanks for your reply.
Well, that would work if I knew which point on the chart