add-in

I am trying to export my worksheet to excel as a text file. I was told to use ADD-INS write to text; although I have no idea how to get "write to text" on my add-in tab. So instead what I have done is just save it as a text file although this is not what I want. I want a text file that has...

Hi, I have a workbook-level double-click event that I put into a certain workbook awhile ago. It checks if there is a record identifier in a certain format either in the target cell or in the current range, within the double-clicked row; if so it queries an SQL server to find backup...

I have an add-in I created but I want the user to periodically update it by simply saving over it. The problem is, it appear Excel can't be open to save over the add-in (it will prompt for a different name). Any ideas how to accomplish? Thanks

Hi there. I have an add-in I've been working on. There is a part of it that goes out to the internet and grabs data from a table. Since it is an add-in, if the user has really high security, they will get a security warning popup every time they open any workbook. What I'd like to do is NOT...

I put together a Excel 2016 spreadsheet using Power Query that brings in data from 6 different workbooks. Unknown to me, the file will be used with Excel 2013 without Power Query add-in installed. Will the file still work, with 2013, without Power Query add-in installed? If not, what can be done...

Hi everybody, I want to say that my experience with VBA is average. I cannot build full codes by myself, but I can modify most of the available temaplates for my own purposes. But lets jump straight to my (weird) question: I have developed a macro code which works absolutely fine from the...

Excel friends, I need your help! I ran the old Explode Addin in Excel 2016 then my Add-In Menu Tab disappeared anytime I unload the Explode Add-In. The only way the Addin menu tab appears again is I load Explode again. So, I want to get rid of the Menu Bar with the Explode icon and keep my...

Hi, does anyone have any knowledge of a decent add-in which can send values from an Excel workbook into an iOS app in real time? (I have Excel for iOS but it does not allow me to run another add-in that enables live feeds that I need) Many thanks

Situation I have a modestly complex workbook, with a lot of modules containing custom macros. The workbook also has a customized toolbar which links to a lot of these macros. The workbook is not connected to "linked" to any other workbooks. Most of the macros involve manipulations on the sheets...

Hi guys. I have developed 2 macros in Excel to remove blank lines and columns from an Excel sheet. I've save the two files as Add-in (*.xlam) in the default path for Add-in im my computer ("C:\Users\Adriano\AppData\Roaming\Microsoft\AddIns") I went to File/Options/Add-in/ and activate them. When...

Hi There, i am using Windows 10/64 and Office 16. when trying to use add-ins that have been made in Excel 2003, i get a message that "VBA Converter is required". searching the web, i got a "Hot Fix" which Microsoft indicated should resolve the issue. once unzipped, the HotFix has an...

I am trying to use an add-in to populate a combo box with an array. There will be 20+ workbooks using this item which is why I want the array in the code. The add-in is working fine for functions, but I cant seem to get the add-in to see the combo box. So far I have not found an answer in the...

Hi, I want to edit an add-in, by adding some shapes (Group) to exsiting one in the same sheet(15 groups they move from a position to another dynamically via the add-in), when I add group 16 manually to the sheet, and I run the macro it never moves but group3 moves instead of him the other groups...

I have an add-in named "FormatDataSourceTT.xlam" who retrieve data from a workbook "Riskmap_fyn_Conso.xlsx" from the worksheet "Ballot_votes"under add-in --> Click on “Risk assessment formatting”, choose “Using Resolver Ballot”, and then select according to the language, this add-in was created...

Hi There I have an Excel add-in that pulls data from the online accounting package, Xero, into Excel and the resulting data gets put in a table with a name like "XeroCoreTables_Invoices_08311f4f_3c8a_4066_9520_efce9b606a15". The add-in has a Refresh All and a Refresh Selected option. What this...

<gs id="28b0a239-72b7-439a-8a4b-ec6aaf77d1e8" ginger_software_uiphraseguid="ebb3d3e2-4831-4374-a900-d0c202674f4e" class="GINGER_SOFTWARE_mark">Hi I</gs> have created and a <gs id="b534475a-8789-4d1c-9010-9f1fbac4aac2" ginger_software_uiphraseguid="ebb3d3e2-4831-4374-a900-d0c202674f4e"...

How can I embed this class in an XLAM Add-In.. and make it work? Dize Class Private pSides As IntegerPublic Property Let sides(value As Integer) pSides = value End Property Public Property Get sides() As Integer sides = pSides End Property Public Function throw() As Integer throw =...