Here's an update for you -- the charts export properly in Excel 2003 but not in Excel 2002. Odd, I know, and I can't just use Excel 2003, because the client I'm writing this for only has Excel 2002 on their local machines.
Hi, everyone.
Question. I've got a macro that creates a text box in a chart, then exports that chart. The text box doesn't appear in the export if I export it during the macro. However, if I export the graph after the macro has finished running, the text box is included. Everything else...
I have no menus at all in the editor. And I have no idea how I did it -- I recently upgraded this machine from Office 2000 to Office 2003 and it may have been during that transition. I have menu bars in my main excel window, but not in my VBA editor window.....
Stupid question -- somehow, my menu and tool bars in the VBA editor in Excel got turned off. I can't figure out how to turn them back on. Any help would be greatly appreciated.
Aaron
Question for the gurus.
We have an excel file that we want to be able to "time bomb", so that it can't be opened without a password after a certain date. The file still needs to be able to be opened (if we have the password).
We've figured out one way to do it, but it requires that...
Hi.
How do I access/start the label wizard from Visual Basic? Or better yet, directly from a Switchboard.
I have a database driven by switchboard menus and I'd like for my users to be able to click on a button and get directly to the label wizard, as the size/layout of labels will be changing...
hi, everyone.
alright, this is a silly question, and I should know how to do this, but it's the holidays and my brain is fried.
when i'm inserting a hyperlink inside an excel sheet pointing to a cell or name (say, cell C41), once you click on the hyperlink, it takes you to cell C41, but cell...
Hi, everyone.
I'm in the process of setting up a form which has both a primary and subform embedded within it, linked based on a primary key of MemberID.
I also want to create a button that links to a different subform (a pop-up form). However, I need that subform to be automatically linked...
Hi, everyone.
I have a cell that looks like this:
Title
Text1
Text2
Text3
There are hard returns between each line.
I want to write a macro to edit only the second through fourth lines of the cell and change the font size on it, but I can't figure out how to only address part of a cell with...
Skip,
Thanks. PlotArea.Height is exactly the same for both -- it's the inside height (the part of the graph that has data, but not labels) that's different. I need that part to be the same, so we were trying to "fix" the inside height by alterint ght PlotArea.Height for both graphs...
Sorry, should have been more descriptive.
The code itself runs, but it doesn't actually fix the problem -- the two graphs don't end up with the same InsideHeight size, which is what it was originally designed to do.
Hey, guys.
I have two graphs that represent similar data for different organizations. I apply a custom graph type to the graphs and 95% of the time this works fine; I also stabalize the major unit, max & min on the axes, so they are the same for both grapsh Every once in a while, though, one...
Skip,
Heh. Sorry, should have made it clearer.
The problem is that Excel doesn't have the ability to do what I want. (I know how to change the format of the data labels).
If I have a chart that has negative values, and I put the X-axis labels on the chart, the labels overlay the bar, right...
Hi, everyone.
This is probably more of a philosophical point, but I'm curious how you all have dealt with it. I have a series of graphs with a combination of negative & postive values. I want to report both the value of the bar (-4.5%, for example) and have the label show. The problem is...
Cool -- that was what I was missing ("OLEFormat.Object")
Much appreciated.
Verb lets you open the embedded file in the original application.
Thanks again,
Aaron
Skip,
Actually, I tried that command, and the "Shapes" command rejects Verb, saying the object doesn't support the method, but it allows me to select the object and then run the Verb command. Makes no sense to me, but just thought I should let you know.
Thanks again,
Aaron
Mike and all,
Thanks for your help. Turns out there is an easy way to do this -- I just wasn't referring to the object correctly. This works, even on a hidden & protected sheet:
Worksheets("DataSheet").OLEObjects(2).Verb Verb:=xlOpen
Again, thanks for all your help.
Aaron
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.