Ribbon Button not Working with my Referenced Workbook
Tue, 7 Oct 2008 08:31:01 -0700
I have a workbook named "Global Schedule" that my users open with Excel
versions 2003 and 2007. I have a 2003 Add-In that I reference which contains
all of the code to manipulate the Global Schedule.
If 2003 opens the Global Schedule I have code to add a custom popup menu
with some control buttons. These ...
|
VLOOKUP FUNCTION
Tue, 7 Oct 2008 08:22:04 -0700
Is there a way to return the next largest value using a vlookup function when
an exact match is not found? As of now, it keeps returning the value that
matches or the next smallest value. ...
|
Excel 97
Tue, 7 Oct 2008 08:10:01 -0700
I just got thrown a random assignment at work of making Excel spreadsheet
made in 97 work with Excel 2007. I have ZERO experience with any form of VB
(I have a C background).
First, is there anyway make Excel 2007 backwards compatible with Excel 97
code. This, of course, would be the simplest solution.
S ...
|
Copy Formula
Tue, 7 Oct 2008 07:47:02 -0700
I have a formula in a cell. The formula is: =150+200
I wish to copy that formula and place it in another workbook as =150+200 and
not the resulting value 300. How do I do this? ...
|
Should an automated version of Excel close?
Tue, 07 Oct 2008 07:35:14 -0700
I'm writing an application in C++ which will read a couple of
complicated text files and create an Excel worksheet containing data
extracted from these files.
In the process of testing, I got to the point where the program:
- used CoCreateInstance() to create an instance of Excel and obtain
an IUnknown ...
|
sum in range meeting criteria
Tue, 7 Oct 2008 06:45:01 -0700
hi,
i have a value in cell A10. i want to sum numbers in range B1:D8 where the
value in A10 value is equal to a value in range A1:A9. how can this be done?
thanks in advance,
geebee
...
|
Selective Ribbon miminise
Tue, 7 Oct 2008 06:41:01 -0700
Hi...
Is it possible to for a macro to disable the ribbon but keep the quick
access toolbar off which I want to use my own toolbar?
Cheers
Gordon... ...
|
|
|
Can VB execute VBA code?
Tue, 7 Oct 2008 06:37:00 -0700
My VBA macro runs slowly in Excel 2007. Will Visual Basic compile my VBA
macro into a faster application that I can somehow use with my Excel
spreadsheet?
--
TomThumb ...
|
lookup returning #N/A
Tue, 7 Oct 2008 06:20:01 -0700
i have the formula,
=IF(F21="","",INDEX(Densities!O:P,MATCH(F21,Densities!O:O,0),2))
This returns #N/A if the F21 string can not be found
It there anyway to get it to return 0 or empty insstead?
...
|
Excel 2007 Adding Template Sheets and Invalid Name Error (#NAME?)
Tue, 7 Oct 2008 05:46:00 -0700
I have a workbook (.xlsm) that gets built by adding in template sheets
(.xltx). There are numerous template sheets that can be added depending on
the needs of the workbook. Each template sheet refers to values found on the
the Master sheet by named ranges. The values on the Master sheet are unique
by workboo ...
|
