Balloons Not Available In 2007
Jul 10, 2007
We have a number of Macros written for Excel 2003. We have now upgaded to Excel 2007 and the macros no longer function. The main problem seems to be connected to the removal of the Office Assistant from Office 2007:
Assistant.On = True
With Assistant.NewBalloon
. Heading = "Reports Menu"
.Text = "Select your reports"
.CheckBoxes(1).Text = "Activity Schedule"
.CheckBoxes(2).Text = "Customer Schedule"
.CheckBoxes(3).Text = "Monthly Schedule"
.CheckBoxes(4).Text = "A3 Print by Customer"
.Button = msoButtonSetOkCancel
.Show
If .CheckBoxes(1).Checked Then
Module1.ACTIVITY_SCHEDULE_PRINT
End If............................
The above code falls over at the first statement with Run-time error '-2147467259 (80004005)': Method 'On' of object 'Assistant' failed. Has support for this object been removed from Office 2007 completely or is there a workaround that I can use?
View 5 Replies
ADVERTISEMENT
Jun 20, 2008
I am using validation to create drop down boxes that refer to a list on another worksheet. Does anyone know how to add a balloon to the drop down box that refers to another column in the corisponding row of the same worksheet?
View 9 Replies
View Related
Mar 5, 2009
I need to make a formula which can take a date formatted cell 01/01/2007, and take only the 2007 and compare that to a cell with general format with the txt 2007. If I use =RIGHT(A1;4) i get the date serial rather than the year... how can I pull out only the 4 digit year..?
View 3 Replies
View Related
May 22, 2009
I've been sent a document by a client which has come with an add-in which has automatically installed itself into the Ribbon. It's on the Add-In tab (obviously!) and the Command Group is named 'Custom Toolbars'. What's annoying is once I close the document, the Add-In stays there and I have a redundant tab with an irrelevant Command Group .
Now, I've done a bit of searching and how found a number of websites that give instructions on add-ins. However, the add-in that has come with the client's document isn't on the list and hence I can't remove it. I need to do to get rid of this? I've contacted the client, but they're suspiciously quiet about the whole thing.
View 4 Replies
View Related
Oct 27, 2008
find attached a File that is a Part answer to a Thread. The problem is the code in sheet 1 ("Amend Test") Button, does not seem to run in 2007, only on earlier versions.
View 4 Replies
View Related
Oct 6, 2009
My office converted to 2007 last night. I had created my own macro toolbar in 2003 with frequently used macros on it. How do I recreate this in 2007?
View 14 Replies
View Related
Feb 17, 2010
I have a piece of code that arranges a chart to fit the data it should show. The code used to work perfectly in the old Excel version, but after an "upgrade" to Excel 2007 I get "Automation Error" from the line where the scale type is set.
View 5 Replies
View Related
Apr 6, 2007
Formulas do not work now. Is there an updated version of the More Function for Excel 2007 that I need to get?
View 9 Replies
View Related
Jul 24, 2007
I've just had Office 2007 installed on my computer and I HATE the new Excel layout. Is there any way I can get the old look back - I liked the old customizable toolbars and I hate these new ribbons.
I know there's one customizable easy access toolbar. Is there a way I can get more toolbars and get rid of these dangblasted ribbons?
View 9 Replies
View Related
Dec 4, 2007
We have a large list of data with an autofilter on it. On column, R we want to show ONLY Blanks. Once we have the Blanks filtered, we put the word, TRADE (or any other word that you want). We finally select all the TRADE cell that were previously shown as blank and highlight them yellow. When we cancel the filter, all the rows in between are now highlighted yellow whereas in Excel 2003, only the rows that we highlighted when the filter was in place had the yellow highlighting.
There is a workaround that you can select each cell individually, apply a fill color, go onto the next cell, apply the color, etc but that is not efficient.
View 9 Replies
View Related
Jun 20, 2008
1. When I close the last open file, EXCEL stays open? why? what can be done?
2. When I open a workspace first after starting excel, the task bar does not show the files included. However, if I open another file first and then a workspace, all files are visible in the taskbar.
View 9 Replies
View Related
Jul 28, 2008
I am having trouble with the 2003 Alt keys in 2007 ..
I have 2 computers (work & home)
The work computer works fine ... when i use same files on home computer some alt key features wont work?
Example Alt E S T .... (paste special formats)
Any ideas .... I've looked at sharing / protection ... cant find anything to fix it....
It cant be protection because the paste special formats works fine with a mouse or the new 2007 Alt key commands?
Just about ready to remove and re-install...
View 9 Replies
View Related
Feb 9, 2009
When I noticed that FileSearch was missing after I updated to Office 2007, I decided to recreate the class and save it as a file to import anytime I needed to use it. I tried to use as little code as possible, so if there is some property you would need to add then you may have to add it yourself, but this will at least give you most of the funcitonality of the original Class without having to update your existing code too much.
You have to just reference the class and then it can still be used in a with block or however you are accustomed. Here are the two class files that I have, the first I named FileSearch (go figure):
Dim pLookIn As String
Dim pSearchSubFolders As Boolean
Dim pFileName As String
Public FoundFiles As New Collection
Public Property Get LookIn() As String
LookIn = pLookIn
End Property
Public Property Let LookIn(value As String)
pLookIn = value
End Property
Public Property Get SearchSubFolders() As Boolean
LookIn = pSearchSubFolders...................................
View 9 Replies
View Related
Jun 10, 2009
how to prevent that autocorrect "feature" in the Excel 2007 VBA IDE? It always deletes the last space I type after a second or so, i.e. moving the cursor to the left whenever I stop typing (to think for a moment or so).
View 9 Replies
View Related
Dec 10, 2009
I've just installed Windows 7 32bit and put my Office 2007 suite on. Everytime I open Excel I get an error message stating: Compile error in hidden module: modMenus
View 9 Replies
View Related
Jan 1, 2010
I have an Excel spreadsheet that I have developed into an over the top flight calculator/scheduling tool. I am using Excel because developing this prduct into a stand-alone program would be absolutely murder to get approved for use on my network.
Since Excel and Access has already been approved, I began coding this project there.
Now that my calculator functions are nearly complete, I am beginning to develop a database of airfields and other misc. flight data that I and others on my network can see and manipulate. To make my calculator funtion at 100% effectiveness, I will need to use VBA to open the Access DB and pull out specific data. I will also need it to open and display some Access pop-up forms that I have just developed. Does anyone know what code I would use for excel to display and retrieve Access' information?
View 9 Replies
View Related
Jun 29, 2007
I have downloaded Excel 2007 as a trial on to my computer (with Excel 2003 in another directory), when I load an excel file developed in Excel 2002 (containing macros) and try an open it with Excel 2007 the message "This workbook has lost its VBA, ActiveX controls and any other programmability-related features" - no problems in Excel 2003
My operating system is XP SP2
View 9 Replies
View Related
Nov 7, 2008
I have big Access file .mdb. I need to work with the file in Excel.
The Excel read the file and I tryed to save the file as .xlsx
I receive a message saying only 64k rows will be saved.
How can I translate the file to Excel 2007?
View 1 Replies
View Related
Nov 25, 2008
I am trying to make a timesheet in Excel 2007 with a formula.
I want it to read:
IN = 8:30 AM, OUT = 11:30 AM, IN = 12:30 PM, OUT = 4:30 PM
The total hours will be 8 because there is an hour for lunch.
And if I work a few hours one day and leave before lunch, I want the calculation to be right. I found a formula but it wouldn't add the lunch hour and I added a +1 in the formula but it makes the calculations wrong for when I work for only 2 or 3.
View 12 Replies
View Related
Jan 18, 2009
how to add rows which was so simple in earlier Excel versions, but now is bafflegab.
Even after several efforts to comply with what follows when at INSERT, all I got was to move cell I'm in one to the right with all other cells in the row following suite.
OF COURSE I had specified "entire row".
View 13 Replies
View Related
Jan 22, 2009
Excel 2003 used to have a feature where the user can select and set the print area. I do not see this feature in Excel 2007. So, how dow I set the print area in Excel 2007?
View 2 Replies
View Related
Jan 29, 2009
I use Excel 2007 which is creating a whole load of tmp files of the spreadsheet that I work on.
Is there a way tostop Excel from creating and saving the tmp files?
View 14 Replies
View Related
Mar 19, 2009
Originally Posted by Question
Create a well labelled pie chart on a separate worksheet to show the profit made by each of the Liverpool departments to the overall profit for 2006. On the labels show the percentage contributed by each department.
I want to create a pie chart in Excel 2007. The data is not next to each other in the columns. How do I create a chart so that it includes the legends as the various departments and the data shown as the figures given under 2006?
View 3 Replies
View Related
Apr 1, 2009
I have some schedules set up with multiple formulas and macros (originally setup in 2003) however when attempting to make this a 2007 file when I go to copy a sheet to create another schedule I get the message “A formula or sheet you want to move or copy contains the name “xx”, which already exists on the destination worksheet. Do you want to use this version of the name? To use the name as defined in the destination sheet, click yes. To rename the range referred to in the formula or worksheet, click no, and enter a new name in the Name Conflict dialog box.”
View 2 Replies
View Related
Jun 13, 2009
I occasionally see array and/or sumproduct formulas that incorporate symbols that I don't really understand in an array context.
These symbols include:
* (asterix)
| (vertbar)
. (period)
; (semicolon)
Also: are there other powerful symbols that have meaning in an array or sumproduct context?
View 3 Replies
View Related
Dec 18, 2009
I'm looking to disable the horizontal and vertical scrolling in 1 worksheet
Am i able to do this?
View 5 Replies
View Related
Dec 29, 2009
I would like to send a .xls file created in Excel 2007 to a user who will work with this file on a PC that runs Excel 2003. Will they be able to open and use a file created in a newer version of Excel?
View 5 Replies
View Related
Jan 9, 2009
I do a lot of validation of Workbooks (Excel 2000). To physically show that only specific cells are unlocked I use a combination of Defined Names and Conditional formatting which uses the old Excel 4 macro command "GET.CELL" as follows
View 4 Replies
View Related
Apr 27, 2009
I'm trying to load the following XML file in Excel 2007 (from Excel 2007 VBA Programmmer's Reference) and get the error "Strict Parse Error" when I do so.
View 3 Replies
View Related
May 5, 2009
I'm having a bit of an issue with OWC in 2007. I know they have been deprecated but I was under the impression, form many places including MS themself, that you could install them. I downloaded this file
http://www.microsoft.com/downloads/d...DisplayLang=en
and then the SP1 2007 file here
http://www.microsoft.com/downloads/d...displaylang=en
All seems to go well and there seems to be a appropriate .dll in c:Program FilesCommon FilesMicrosoft SharedWeb Components111033 by the name of OWCI11.DLL. However when I attempt to add a reference to that file in a VBA project in Excel (it's one that has an old broken reference to 2003 OWC) by browsing to that file it tells me
"Can't add a reference to the specified file"
What have I done wrong? Is what I am attempting, getting 2007 to use OWC, even possible? Note I did not write any of the code for this Excel Add-in so have very little idea about what OWC are for.
View 6 Replies
View Related
