invoking an add-in from a macro?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Time Sheet Hello All, I am writing a time sheet for work. C 11 thru I 11 has the actual hours worked each day J 11 has the total hours worked for the week (sum c11:I11). What I am trying to do is have J11 show only 40 hours if the work week was over 40 hours. I want to have the overtime hours in the cell below on J12. I have entered a formula in J12 as sum (c11:I 11 -40) this works good if there is overtime but shows a neg number if no overtime. Can anyone help with the formula in these two cells Thanks Gary Davis Tag: invoking an add-in from a macro? Tag: 60026
  - 2
    - adding values in a column I want to add currency values in column A and in column B, each time I add a new value, column B updates with the total. However, I don't want the last sum to be displayed down the entire column B. How can I hide that? Tag: invoking an add-in from a macro? Tag: 60019
  - 3
    - need to have cell fill when I select the cell I would like to have a cell either fill with a color or have an x inserted or something. It doesn't matter what goes into the cell. I need to set up a column with cells that when I click on them they change. I am trying to get out of having to type the word yes in every cell. Whatever goes into the cell represents the word yes. Tag: invoking an add-in from a macro? Tag: 60016
  - 4
    - =COUNTIF Problem Hello Using Excel XP. I am doing a baseball stat spreadsheet and I have pitchers names in column A and in column B I have a W (for a win) or L (for a loss). What I want to do is to check column A for a pitcher's name, e.g. "Schilling" and then to check column B for a "W. An example: A B --------------------- 1 Wells L 2 Schilling W 3 Clement L 4 Wells W 5 Schilling L 6 Clement W 7 Wells L 8 Schilling W Then I would have the stat set up like this: I would type "Schilling" in A10 and then I would like to have a formula in B10 that gave me the number of "W" in column B for "Schilling", which would be 2 in this instance. I've tried a =countif formula but cannot write it for two conditions. Any help will be apprecaited. Mike Tag: invoking an add-in from a macro? Tag: 59993
  - 5
    - Problem With Comments I am creating a large spreadsheet by hand with about 1000 rows by 30 columns. About half of the cells need comments, but after I use a few hundred comments they start to reassign to different cells. Example, I make a comment on cell A1, and then create a comment much later on cell C453, cell A1's comment box moves from being adjacent to cell A1 to being adjacent to cell C453 and has the comment I want for cell C453, but the comment points to cell A1! It appears that Excel X has some kind of limit on the number of comments on a spreadsheet. Is there any way to get around this? Tag: invoking an add-in from a macro? Tag: 59989
  - 6
    - Limit the sheet size How can I set the sheet size to, say, 40 cols x 60 rows? Tried setting all other col's to 0 width but panning still brings me into the uncharted grey region where they used to be. Thanks, rs Tag: invoking an add-in from a macro? Tag: 59987
  - 7
    - Floating headed cell I am setting up a spread sheet which has long columns, but when I am entering the figures well down the spread sheet I keep forgetting what column is what, can I have the header row float down the spread sheet with me all the time. Dave Tag: invoking an add-in from a macro? Tag: 59981
  - 8
    - #VALUE! on correct formulas I am using 'vlookup' and 'match' functions that result in #VALUE!, but when I hit function wizard, it shows the correct number value I am looking for and expecting in the result area. Apparently my syntax, etc. is accurate. Why, then, does #VALUE! show up when everything is ok? thanks, mike allen Tag: invoking an add-in from a macro? Tag: 59977
  - 9
    - Running a Macro depending on Validation List Selection Is there a way to run a Macro depending on the result of a validation list selection? I have a list of store names with specific number of techs. I select Shop A and Macro 1 Runs I select Shop B and Macro 2 Runs, etc. What I want to accomplish is depending on the value in a cell, it will run the specific Macro. Any help is appreciated and Thank you in advance for the help. Fester Tag: invoking an add-in from a macro? Tag: 59973
  - 10
    - Using either 'Conditional Formatting or VB' to color specific Cells All, I'm new to using macro's within Excel, please forgive my ignorance in advance! heh Does anyone know the best way to color cells within a worksheet based on data in other rows within the same worksheet? I've used Conditional Formatting but it only lets me use (3) colors. I need to use about 10 or so. Basically I have data in columns A - P, in columns AI:AJ I have data that I want to show as a specific color in rows A - P if it exists. Can someone give me an example that I can use and modify to do this task? Thanks -J Tag: invoking an add-in from a macro? Tag: 59972
  - 11
    - Error Handling in Excel Based App Hello: I am trying to handle exceptions in my code. Here the the code i have Code: Dim XLFileConn As New OleDbConnection 'New OleDbConnection object XLFileConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename & _ ";Extended Properties=""Excel 8.0;HDR=YES;IMEX=1""" 'New connection string Try Try XLFileConn.Open() 'Open a connection to the choosen Excel file Catch ex As Exception 'Code to detect and handle an exception generated by a connection error MessageBox.Show("Connection to File Failed - Invalid File, File type or Path was chosen.", "File Connection Error", _ MessageBoxButtons.OK, MessageBoxIcon.Error) 'If error occurs - Display message box alerting user about the error Exit Sub 'Exit Sub-Routine End Try I have built the file including the installer and stuff. I run the program and try to test the error handling by inputing a pdf file instead of an excel file, It gives me my message box and after i click OK, it then gives me a default exception handling dialog box and it gives me a quit or continue option. Do i need to clear some kind of error flag? Thank You Prasun Tag: invoking an add-in from a macro? Tag: 59969
  - 12
    - Different colour in drop down box? How? Hi All Have a cell A1 drop down list 1,2 & 3 on cell A2 if 1 then - if 2 then ! if 3 then x =IF(A1=3,"X",IF(A1=2,"!",IF(A1=1,"-",IF(A1="","")))) How do i make the background of cell A2 RED if X Orange if ! and White if - Cheers Paul T Tag: invoking an add-in from a macro? Tag: 59959
  - 13
    - Parsing Serial Numbers? I inherited a spreadsheet with computer serial numbers in it. For various purposes, I'd like to be able to parse these into 3 groups. The problem is that there are 2 formats, a 10 character format and a 12 character format. Each would be parsed differently. I looked for a parse function in XL and was very surprised that there isn't one. I thought I could to a test for the number of characters (Len function), and with an If statement, do 2 different parses based on the outcome. Is there no way to do this with a formula? Do I have to write a macro? I did look at Data, Text to columns, but it doesn't appear to accomodate this situation. Any ideas? Thanks in advance. Tag: invoking an add-in from a macro? Tag: 59958
  - 14
    - Copy Worksheet to Preserve Page Set Up I have a workbook with a very detailed worksheet that I want to copy onto addtional worksheets to run different scenarios. I can easily copy the worksheet but it doesn't preserve the detailed page set up for printing. How do you get it to copy the page set up too? Thanks Tag: invoking an add-in from a macro? Tag: 59957
  - 15
    - Count by Color on different worksheet Hello, Using Excel XP. Earlier in the group someone asked about =SUM colored cells and was referred to cpearson.com/excel/colors.htm. I went to the page and found the function to count the colored cells within a range (which I want to do). This is the code: Function CountByColor(InRange As Range, _ WhatColorIndex As Integer, _ Optional OfText As Boolean = False) As Long ' ' This function return the number of cells in InRange with ' a background color, or if OfText is True a font color, ' equal to WhatColorIndex. ' Dim Rng As Range Application.Volatile True For Each Rng In InRange.Cells If OfText = True Then CountByColor = CountByColor - _ (Rng.Font.ColorIndex = WhatColorIndex) Else CountByColor = CountByColor - _ (Rng.Interior.ColorIndex = WhatColorIndex) End If Next Rng End Function The function works for me if the range is on the same sheet. =COUNTBYCOLOR(A1:A10,3,FALSE) When I have the formula on one sheet referring to another sheet in the workbook it does not work (gives a value of always zero.) Can anyone help me make the formula work if the range is on another sheet. Thanks in advance. Mike Tag: invoking an add-in from a macro? Tag: 59954
  - 16
    - SUM IF Return Max Value Hello there, after a day of starring at it I'm convinced I need a little help. I was looking for a way to return the highest value (of Collumn B) to B3 that matches the criteria (name) stated in A3. The database (in another sheet) consist of 11 different names (in Collumn A) which all have 5 different values in Collumn B. This makes 55 rows. Thanks in advance! Tag: invoking an add-in from a macro? Tag: 59942
  - 17
    - the 'degree' symbol Does anyone have a good way of getting the 'degree' symbol into a series of cells? Either farenheit or celcius...doesn't matter...i just want the symbol. Dave French Tag: invoking an add-in from a macro? Tag: 59941
  - 18
    - memory issues when copy and paste We use Office 2000 w/ the latest service packs. When trying to copy and paste large amounts of date we get a "Not Enough Memory, Continue withouth Undo?" message. I found a MSFT article that explains a workaround. Do any other versions on MS Office such as Proffesional or XP correct this problem? Thanks for your help. JL Article ID : 313275 Last Review : September 9, 2004 Revision : 1.0 Tag: invoking an add-in from a macro? Tag: 59938
  - 19
    - Importing HTML List Hi, I'm importing a web page into Excel. The web page contains a table of file info such as PRIMARY | SECONDARY | FILE NO. I import all 3 columns OK, apart from some instances of file number. At times, the file no. translates incorrectly to a date e.g 10/3 ends up incorrectly as 10-Mar-1900 rather than remaining as 10/3 Has anyone any clues on how I can convert these instances back to a real "file number". Formatting as General or Text doesn't seem to do the trick. Tks, Kay Tag: invoking an add-in from a macro? Tag: 59935
  - 20
    - Convert ASCII to Hex Hi, I'm not very proficient in Excel, so this may not even be possible.... I do network administration and often find myself having to type in a WEP key in HEX which, especially on a PDA, can be a time consuming task. I was looking to have an excel spreadsheet (pocket excel to be specific) that can convert the ASCII text in one cell to HEX in another. A great "extra" bonus would be that you HAVE to use either 13 or 26 characters. Anyone know of a function that could accomplish this? Thanks so much, STS Tag: invoking an add-in from a macro? Tag: 59932
  - 21
    - huge file size Hi, i have an excel file which is 15KB in size, but after doing some formating it becomes 15MB after saving it. What could be wrong here? thanks Tag: invoking an add-in from a macro? Tag: 59931
  - 22
    - Right click menu Hi, is it possible to customise the right click menu, ie add or move items? Darren Tag: invoking an add-in from a macro? Tag: 59930
  - 23
    - Opening files in Excel 2003 Hello Everyone, I have this problem when trying to open a file in Excel. It takes along time to drill down down in the folder list. Any ideas? Thanks -Mark Tag: invoking an add-in from a macro? Tag: 59929
  - 24
    - automatically run a macro Hello, I have written a macro which operates by means of ctrl + Q. (This letter was merely an arbitrary choice!) The action is as follows:- 1. Enter new data in a cell then press <ENTER> 2. The data is then automatically compared with the contents of a cell on different sheet 3. If the new cell data is greater than or equal in value to that data in the cell on the other sheet then change the font colour of the new cell data to red and display the difference between the two cells in a cell in another column 4. Otherwise just display the new contents of the cell in a black font colour as normal and do nothing else I have the code to do all this in the macro but I want to make the code run automatically when I press <ENTER> after updating the contents of any one of several cells on a worksheet. I don't know how to do this by means of an IF function, as it requires several things to happen as the data in the cell is entered. Can anyone tell me how to do it? Thank you in advance for your kind help. Steve Tag: invoking an add-in from a macro? Tag: 59917
  - 25
    - HTML -> EXCEL cell formatting Hello, I would like to know if there's a way to control the formatting of an excel sheet created by a web page : contentType="application/vnd.ms-excel" <table><tr> and <td>... I have to display a string that looks like "01-02-04" which is NOT a date, but it appears on the excel web page as a date : 01/02/2004 Thank you, Sophie Tag: invoking an add-in from a macro? Tag: 59914
- Next
  - 1
    - Close Files WHEN Open Hello Everybody! I was wandering if someone could help me with the following: I have 3 files which open each other allong the way. For example. File 1 File 2 File 3 Working in File 1; at certain actions File 2 is opened. At other File 3 is opened. However, If I want to close, using a macro. I want to save and close all the files (File 1,2,3) but no other files which might be running. Those anyone have suggestions? Thanks in Advance! Tag: invoking an add-in from a macro? Tag: 59908
  - 2
    - Objects above cell Is there a way to get the object above a cell using VBA? Thanks in advance Tag: invoking an add-in from a macro? Tag: 59906
  - 3
    - Getting the longest lengh in range of cells I am trying to get the length of the longest cell in a range and use the array {=len(a1:a1)}. What happens is that it picks up the length of cell A1. Is there a way in a formula to determine the longest cell length in a range, or through VBA. Thanks in advance Tag: invoking an add-in from a macro? Tag: 59901
  - 4
    - Set Currency - WON in Marco Our company have a Korea Branch, I attempt to set a Macro for WON, but it does not work. When I run the macro, it reveals "?4,455". (if the cell is 4455) Attach please find the macro. Sub WON() ' ' WON Macro ' Macro recorded 2/16/2005 by Lok Tak Cheong ' ' Selection.NumberFormatLocal = "[$-412]#,##0_);([$?-412]#,##0)" End Sub Tag: invoking an add-in from a macro? Tag: 59897
  - 5
    - How can I remove the hyperlinks? Hi, I have an Excel column with e-mails but they are hyperlinked. So, I cannot edit them because it opens my e-mail server. How can I remove the hyperlinks? SantistaS Tag: invoking an add-in from a macro? Tag: 59896
  - 6
    - "Disk is full" error Hi, does anyone get the "disk is full" error in Excel 97 when saving file in the network server? the error occurred when saving whatever the file size is small or large. I am running Excel 97 SR-2 with Windows 98. The other ppl using XP does not get this error. THANKS Ben Tag: invoking an add-in from a macro? Tag: 59894
  - 7
    - vba to check presence of file and open/not open Hi, The problem:- vba to check the presence of a file then prompt user if file is to be opened or not. For some reason, when i click no, the program still open the file. Your help will be very much appreciated. Sub PegaToday() Dim sFile As String sFile = Dir("O:\MRS_reports\Setts\pega_outstanding_" & Format(Date, "yyyymmdd") & ".xls") If sFile <> "" Then MsgBox "Todays Pege is Ready" & vbCrLf & "" & vbCrLf _ & "Do You want to Open?", vbYesNo, "Ready or Not" If vbYes Then Workbooks.Open sFile ElseIf vbNo Then Exit Sub End If End If End Sub ...Comin' From Where I'm From Tag: invoking an add-in from a macro? Tag: 59890
  - 8
    - Tab Down? Is there a way to change the behavior of the Tab key so that rather moving to the next cell to the right of the current one, it instead moves down to the cell below the current one? I find that I want to Tab down more often than Tab right and the left hand is usually better situated to hit the Tab key than it is to move across the keyboard to find the Down arrow. SteveK Tag: invoking an add-in from a macro? Tag: 59882
  - 9
    - Comment and autofilter in cell of protected sheet It seems if I put a comment in a column header and turn on autofilter for the rows below, and then protect the sheet, the comment feature won't work. That is, when I hover over the cell with the comment (and the filter drop-down icon), the comment won't show - the mouse becomes the finger pointer anywhere over the cell. Is this a known bug? Tag: invoking an add-in from a macro? Tag: 59881
  - 10
    - Macro Toolbar Hello: I use Excel 2003 in XP I can't get the macro toolbar to become visible when I am recording a macro. I have right clicked on the top and cannot find the toolbar in the list. I want to use the option on this toolbar to set the range as relative instead of absolute. If I cannot get this toolbar to appear is there another way to set that? I am just starting out in the VBA Editor so am not quite sure what line or command to take out to achieve this. Thank You for Your Help Tag: invoking an add-in from a macro? Tag: 59875
  - 11
    - prevent data in cell if data in another Column A and Column B have data validation to allow a selection from a list. Basically the list is just a checkmark. Column A is YES Column B is NO How can I prevent a cell in column A to have data entered if column B already has data. In other words the user has to be prevented from entering data in both A1 and B1 Thanks, Keith Tag: invoking an add-in from a macro? Tag: 59870
  - 12
    - Pivot Table Request I tried to make a Pivot Table do the following: "Show me the right value - copy the value to a Temporarily worksheet" I tried the code shown below. How ever it keeps on giving me the same error in: ActiveSheet.PivotTables("PivotTable3").AddFields RowFields:="", ColumnFields:="Activity", PageFields:="ARF Code" Does someone see the error? Thanks in Advance! Sub Get_DATA_ARF() Dim cLastRow As Long Dim i As Long Dim iPos As Long k = Sheets("LookUp").Range("AM1").Value Windows("Kostenbeheerssysteem.xls").Activate Sheets("Table Combi").Select Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem Set pt = ActiveSheet.PivotTables(1) For Each pf In pt.DataFields pf.Orientation = xlHidden ActiveSheet.PivotTables("PivotTable3").AddFields RowFields:="", ColumnFields:="Activity", PageFields:="ARF Code" With ActiveSheet.PivotTables("PivotTable3").PivotFields("Hours") .Orientation = xlDataField .Caption = "Sum of Hours" .Function = xlSum End With ActiveSheet.PivotTables("PivotTable3").PivotFields("ARF Code").CurrentPage = "" & k & "" Next pf With ActiveSheet.PivotTables("PivotTable3") .ColumnGrand = False .RowGrand = False End With Sheets.Add.Name = "Temp" With ActiveSheet.PivotTables("PivotTable3") Sheets("Temp").Range("A1").Value = pf.Value End With End Sub Tag: invoking an add-in from a macro? Tag: 59861
  - 13
    - Debug Q I have the following code that enters Debug at the line that says "ActiveSheet.Paste". The target sheet i.e. E-Figures is not protected, can anyone see any reason for this? It states in the dialogue box "Paste method of worksheet class failed" Thanks Sub Generate_Reports() Sheets("Figures").Select ActiveSheet.Unprotect Password:="enter" Cells.Select Selection.Copy Range("A1").Select Sheets("E-Figures").Visible = True Sheets("E-Figures").Select ActiveSheet.Unprotect Password:="enter" Sheets("E-Figures").Select Range("A1").Select ActiveSheet.Paste Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Range("A1").Select Application.CutCopyMode = False ActiveWindow.SelectedSheets.Visible = False Sheets("Home").Select Range("A1").Select Mail_Reports End Sub Tag: invoking an add-in from a macro? Tag: 59860
  - 14
    - Why can I not lock a cell throught code? I have some code, whereby I am trying to lock a cell. I keep getting the message: Runtime error '1004': Unable to set the Locked property of the Range class. I dont know why this is happening. Can anyone help? Here is a sample of my code: ------------------------------------------------------------------------------ Private Sub Worksheet_Change(ByVal Target As Range) CalculateDates End Sub Private Sub CalculateDates() 'Application.ActiveWorkbook.Worksheets("Sheet1").Active Application.ActiveWorkbook.Worksheets("Sheet1").Unprotect Application.ActiveWorkbook.Worksheets("Sheet1").EnableSelection = xlNoRestrictions 'Application.ActiveWorkbook.Worksheets("Sheet1").ActiveCell.Activate If Range("AM50").Value = "Simple" Then Range("AM56").Locked = True '''''' ElseIf Range("AM50").Value = "Complex" Then Range("AM56").Locked = True '''''' Else Range("AM56").Locked = False ''''''' End If Application.ActiveWorkbook.Worksheets("Sheet1").Protect Contents:=True, UserInterfaceOnly:=True End Sub -------------------------------------------------------------------------------- Tag: invoking an add-in from a macro? Tag: 59859
  - 15
    - need help with msquery query i am using access 2000 database and an excel 2000 spreadsheet. the access data base also has linked tables to a SQLAnywhere database. the data that i need to pull comes from both a native access table and a linked table to the SQLAnywhere database. when just pulling data from the access table, using parameters to limit the data, i get the data that i selected. when i create a new query using both the data from the access table and the SQLAnywhere table, i am getting way too much data. The parameters from the msquery seem to not be working. can someone help me with this? Tag: invoking an add-in from a macro? Tag: 59855
  - 16
    - how to separation letter and numeral separation Letter and numeral If A1= asd123dsa, how to get the B1= asddsa, C1=123 Tag: invoking an add-in from a macro? Tag: 59853
  - 17
    - Conditional Formating - =SUM Colored Cells Hello. Win XP, Office Excel 2003 SP1 Pro. I use "Conditional Formating" to highlight some cells with color RED etc. Is there any way to SUM all RED cells and plase the sum in an another cell? Thanks for any help. Br Morten Tag: invoking an add-in from a macro? Tag: 59850
  - 18
    - VBA Code dosent run after close & reopen I have a complicated wooksheet, whereby I have created code to handle calculations. When I first create this page and test it, everything works great. But, as soon as I close and reopen the file, the worksheet doesnt want to run any code. Does anyone know why? If you require more info, such as the code, I can tell you. But it doesnt seem to be relevant to the problem. Tag: invoking an add-in from a macro? Tag: 59845
  - 19
    - Displaying Sheet Tabs Names in Cells Can anyone tell me if there is a way for me to display the Name of a Sheet Tab in a cell. Take for example I have 4 worksheets, labelled Shawn, Kevin, Mary, & Data. In data, I want it to show the name of the worksheets. So in Cell A4 I would like it to say Shawn, then in B4 I can put Shawn's data in. Is there a function or a formula that allows me to do this. Thanks for any help. Tag: invoking an add-in from a macro? Tag: 59835
  - 20
    - Deleting formula in cell if sum is 0 Hi, Was wondering if there is a macro which would be able to identify that the sum of 2 cells is 0 and therefore deleting the formula? Any help would be greatly appreciated Tag: invoking an add-in from a macro? Tag: 59833
  - 21
    - Subset of one sheet on another sheet I've been tasked to create an auction spreadsheet for my PTA to track what has been donated; whether it's for the silent auction, raffle, or live auction; and who wins it for how much. It needs to be as user friendly as possible, as I cannot guarantee that future Auction Committee member will be good with Excel. (A database would probably be better, but we don't have one.) Since in the course of planning the auction an item may be moved back and forth between the silent auction and raffle and live auction many times, I want to be able to automatically have another sheet that just lists Live Auction items and another that lists Raffle items and another for Silent Auction items. With this background, let me explain what I'd like to do and ask if it is possible. On the Inventory sheet I'd list the stuff that has been donated and have a column that would have the auction type, i.e. silent, live or raffle. Something like: A B 1 Desc Auction 2 Boat Live 3 Candy Raffle 4 Dinner Silent 4 Cruise Live There would then be three other sheets. One for each auction type. The Live Auction sheet would use some function to just list the items on the Inventory sheet that had been categorized as "Live". It should end up looking like: A B C D 1 Desc Item# Bidder Bid 2 Boat 101 3 Cruise 102 Is there a way to pull a subset of the rows from one sheet onto another and not have blank lines for non-matching criterion? In other words, I do not want for the Live Auction sheet to look like: A B C D 1 Desc Item# Bidder Bid 2 Boat 101 3 102 4 103 5 Cruise 104 where rows 3 and 4 are blank because they are not Live. Any help is greatly appreciated. Brian Bygland Tag: invoking an add-in from a macro? Tag: 59825
  - 22
    - CORRUPTED spreadsheet Help!!! My very important spreadsheet got corrupted and I had no backup. Is there any way to repair/recover in Excel 2000? At the moment attempting to open it gives me: "EXCEL caused an invalid page fault in module EXCEL.EXE at 0187:3004cc32." Tag: invoking an add-in from a macro? Tag: 59824
  - 23
    - Lists with Excel 2003 I like to organize my lists for dropdown data selection in a separate worksheet. I've been using an older version of Excel and could have lists in a different worksheet. It seems that Excel 2003 doesn't allow this. Or am I not doing something correctly? Thanks, Keith Tag: invoking an add-in from a macro? Tag: 59819
  - 24
    - Fill Color How can a custom fill color be used to fill cells? Thanks, keith Tag: invoking an add-in from a macro? Tag: 59818
  - 25
    - Fill Color How can I use a custom fill color? Thanks Keith Tag: invoking an add-in from a macro? Tag: 59817

I would like to record a macro which highlights some cells, then runs an
add-in. The add-in takes the highlighted cells and exports them to a new
file. However when I record the macro, it does not record the add-in step,
it only records me highlighting the cells. Is it even possible for a macro
to invoke an add-in?

Re: invoking an add-in from a macro? by Bob

Bob
Wed Apr 27 04:20:14 CDT 2005

Yes it is. You need to link to the add-in in the VBE (Tools>References),
and then click the add-in.

You can then call any routines in the add-in by name.

--
HTH

Bob Phillips

"JurgenBrea" <JB@_._> wrote in message news:d4nj1m$d7o$1@lust.ihug.co.nz...
> I would like to record a macro which highlights some cells, then runs an
> add-in. The add-in takes the highlighted cells and exports them to a new
> file. However when I record the macro, it does not record the add-in
step,
> it only records me highlighting the cells. Is it even possible for a
macro
> to invoke an add-in?
>
>

Re: invoking an add-in from a macro? by JurgenBrea

JurgenBrea
Thu Apr 28 15:00:48 CDT 2005

hmm... well I tried that. went to tools/references from the VB editor.
Then browsed for the xla. It freaked out and said it could not do it as it
had the same name as something else.... I know I should have put the message
in here but it's on my work computer and I'm at home now. Any thoughts?

"Bob Phillips" <phillips@tiscali.co.uk> wrote in message
news:eaN$cpwSFHA.612@TK2MSFTNGP12.phx.gbl...
> Yes it is. You need to link to the add-in in the VBE (Tools>References),
> and then click the add-in.
>
> You can then call any routines in the add-in by name.
>
> --
> HTH
>
> Bob Phillips
>
> "JurgenBrea" <JB@_._> wrote in message
> news:d4nj1m$d7o$1@lust.ihug.co.nz...
>> I would like to record a macro which highlights some cells, then runs an
>> add-in. The add-in takes the highlighted cells and exports them to a new
>> file. However when I record the macro, it does not record the add-in
> step,
>> it only records me highlighting the cells. Is it even possible for a
> macro
>> to invoke an add-in?
>>
>>
>
>