obj var vs automation
What is the difference between using an object
variable, as in this example:
Dim k As Object
Set k = Workbooks.Add
.Sheets(1).Range("E5").Value = "Hello"
Set k = Nothing
and using "Automation," as in this example:
Dim xlApp As Object
Dim xlWorkbook As Object
Set xlApp = CreateObject("Excel.Application")
Set xlWorkbook = xlApp.Workbooks.Add
.Sheets(1).Range("E5").Value = "Worl...Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...Custom Colors on Graph
Is there any way to use custom colors with Excel graphs?
The standard choices are limiting, and other Microsoft
titles all allow custom colors. Am I missing something
Excel uses a palette of 56 colors, and that's it. You can adjust these
56 to your heart's content, though. Pick Options from the Tools menu,
and click on the Colors tab. The bottom two rows are the ones used in
default charts (for more series, it keeps moving up a row). One by one,
select a color and click on the Modify button, to adjust the color. When
you like the colors, keep them...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <firstname.lastname@example.org> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...Up-side down Graph #2
How do I make an Up-side down graph. (with y-axis values shown on the
Double click the axis and on the scale tab check Values in reverse
order. Is that the upside down you want?
> How do I make an Up-side down graph. (with y-axis values shown on the
> opposite direction).
Andy Pope, Microsoft MVP - Excel
Thanks for the solution. its been a great help.
Andy Pope wrote:
> Double click the axis and on the scale tab ...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...Automated Attendance Sheets
I had posted this question a few days ago, and Dave P. replied on Oct 05
2004. let me rephrase the question.
A master sheet contains data for all employees shift details for all days of
the month . The sheet looks something like this
Name 01/10/04 02/10/04 03/10/04 04/10/04 05/10/04 06/10/04 .....
a D N D N
b N N O D
What I'd like Excel to do is this:
1. A menu which asks...Excel 2007
We have some engineers that have fairly intesive graphs with tons of
data points on them. When we open the Excel 2003 graph with Excel 2007
and try to print the graph there is no data line or curve. Our axis'
and titles show up, even our 2 pt colored vertical lines appear. Now,
when we take all the data from this 2003 excel sheet and create a new
2007 sheet and create the graph from the data it prints fine. Also the
2003 graph will print frin ewhen opened from excel 2003. We've tried
the convert tool in 2007 when opening a 2003 workbook and still no
graph. We have a multit...How to make odds ratio graph?
How to make odds ratio graph?
Would love to help but your cryptic message does not tell me what it is that
you want to do.
More details, please
Microsoft Excel MVP
"How to make odds ratio graph?" <How to make odds ratio
email@example.com> wrote in message
> How to make odds ratio graph?
...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...excel graphs line correctly, shows wrong value label?
I have a graph that is graphing the line in relation to the values on the x &
y axis correctly but its showing a value label that is totally wrong??? I
clicked on the line and checked where the line is refrencing its info from
and its from the correct boxes on my excel sheet, when I hold my mouse curser
over the plotted point at issue it says Value:58% which would be correct? HOw
do I make it display the correct value without always having to type it in by
hand (this is a template for many projects)?????????????? The other thing is
all the other posted values are correct on all line...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or
various other shapes than just squares and rectangles? Thank you ahead of
with a graphics editor
Microsoft MVP - FrontPage
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
| Is it possible to insert a picture and make it into a circle or an oval or
| various other shapes than just squares and rectangles? Thank you ahead of
> Is it possible to insert a pict...Setting up segmented bar graphs
I don't know if it can do it or if there is a program for it but I need
to know how to set it up in Ecxel. A segmented bar graph is when the
%'s are added up on top of one another.
Like I need male and female, and they answered yes or no. Well one bar
for male ,answers of yes and no %'s on top=100% and the same for
no 25% |
male...............Just in case
spiketheone's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...Graphing a Line Using the Equation
Is there a way to graph a line using the equation of the line?
try this url
see chapter 15 and refer to "charting a function"
tortoise25 <firstname.lastname@example.org> wrote in message
> Is there a way to graph a line using the equation of the line?
See PLOT manager
and Stephen Bullen's ChtFrmla.zip at
http://www...Is this possible
I want to make a list of the files in several different
folders. Is it possible to somehow "Copy and paste" just
the filenames into a list, in either Word or Excel or
Wordperfect. I am just trying to sort the files in
several different folders to weed out duplicates. There
has got to be an easier way then typing them all or screen
printing the lists and manually weeding them out. Any
Here is some code that will start in a directory and list all files in that
and any sub directories. It uses recursion to go through all the subs.
Just ch...Is this Possible ?
Have a newsletter document with text boxes that have no outlines but
internal gradient colour fills.
Is it possible that a macro could remove all colour fills in one hit just
leaving the text in place ?
Dim oShape As Shape
For Each oShape In ActiveDocument.Shapes
If oShape.Type = msoTextBox Then
If oShape.Line.Visible = msoFalse Then
oShape.Fill.Visible = msoFalse
should clear the fill from text boxes that are filled and have no border.
<>>< ><<> ><&l...Sharepoint exposed in visio automation
is sharepoint exposed in visio activeX control?
...Automating Model Spreadsheet
I am having a small problem. I have a small number of inputs (approx.
10) and have built a model (financial valuation) in excel that provides
me a small number of outputs (again approx. 10). But I need to run this
model on a continuous basis with a whole number of different inputs to
gain the end results. I believe that the easiest way to do this would be
within VBA. Could anyone help me on how I would go about in achieving
...Is Batch Marking Possible?
I am doing a mass mailing from Outlook. I will print 50 address labels per
day. Is there a way for me to batch-mark the contacts for which I print a
...Tax Invoice automated Tax number
I used Office 97 for a long while. In this Office Software Excell had the best Tax Invoice program or sheet. This sheet had a automated numbering system.
Who knows of this and can tell me why in the Office 2003 Software this is not available any more ... this is very disturbing
How can I use this Tax numbering system in the new Office 2003 - the numbers should automate themselves
...Refresh Graph Data
Is there a way to refresh a graph's data? I am trying to graph total loans
by month and starting with November. I want to add next month's without
having to create a new graph... is this possible?
> Is there a way to refresh a graph's data? I am trying to graph total loans
> by month and starting with November. I want to add next month's without
> having to create a new graph... is this possible?
The technique I use is to put a colored row of cells at the bottom of the data
with the message "Insert new row...How to increase the size of a Pivot Table Graph
I have created a very simple Pivot Table 3-D Pie Graph, but it shows on the
screen in a size of approxiamtely 2 inches by 2 inches (at 100% window size).
I click on the graph to make the four corner points highlight, but I can't
drag them to increase the general size of my graph. Can pivot table graphs
be increased in size, or are that fixed to one size?
did you use the icon on the pivot table toolbar to create the pivot graph?
mine always come out at full window size ...also works if i choose this
option after choose data / pivot table and pivot chart report and...Is it possible to make cmd window to flash?
I have an existing VC2003 windows console program. Now I want to add a alarm
feature to it, the simpliest way is to make the cmd window to flash. Can
this be implemented?
>I have an existing VC2003 windows console program. Now I want to add a alarm
>feature to it, the simpliest way is to make the cmd window to flash. Can
>this be implemented?
If the console is running in a window, I presume you can use the
FlashWindow(Ex) API. In newer OS's you can find the console window
handle using the GetConsoleWindow API. For older OS's here's...