Find Jobs
Hire Freelancers

Excel VBA - Import Add-In code to XLS module & Reverse the process.

$30-100 USD

Cerrado
Publicado hace más de 17 años

$30-100 USD

Pagado a la entrega
I have an excel add-in with two subroutines that need fixing... or redesign. The two subs are independent of each other and perform the following functions: Background: The attached zip contains the following: 1) the [login to view URL] add-in code. 2) A sample XLS spreadsheet which makes use of the add-in code's function. This add-in code adds various financial functions which are called from within excel cells. All the functions work fine, and dont need touching. Only two subs, ImportEL and UpdateEL need work. They are connected to buttons which appear on the Users "Tools" menu within excel. Basicly I want users to be able to embed the AddInCode (the VB module within [login to view URL]) within whatever spreadsheet they want, so that they may send the spreadsheet to someone outside the firm and he can view it without having the excel Add-In installed on his machine (done with ImportEL()). Conversly, If the user does not want the functions to run off the code embeded into the XLS and wants the functions to be linked to the Excel Add-In installed on their machine, they have a button to do so: UpdateEL(). Sub ImportEL() The basic purpose of this is to place a copy of the Add-In's 'AddInCode' into the XLS Spreadsheet and allow the spreadsheet to be sent to remote users without the Add-In, and allow them to see and use the AddInCode's functions within the workbook. Currently, this subroutine deletes any current install of AddInCode module on the XLS. Then exports the AddInCode from the XLA to a temp file, imports it in the XLS, and deletes the temp file. Finally the Links are changed from external links to "[login to view URL]" to the current file name, and the entire application is recalculated. I can't get this sub to properly relink and refresh all the calculations within the sheet; calls to functions continue to have #VALUE in its field. More IN [login to view URL] ## Deliverables 1. A fully functional Excel Add-In (XLA format) which meets my requirments 2. Must be delivered within time frame. *-*-*-*-*-*-*-*-*--*-*-*-*-* REPLYS FROM CODERS: Top Coder! Bid Amount of $200.00 (USD ) Hello, I'm an developer located in Russia and am interested in bidding on your project. I think that it is possible to try to operate directly with VBA projects/modules. Certainly it can crash for the security reasons. Therefore at first it is necessary to see existing security level(VBA) Looking forward to you feedback... MY REPLY----------------------------------- The export features are fully working. Our macro security is set at medium (always) and "Trust access to Visual Basic Project" is enabled on all machines. That is not the issue I am having. My problem is linking the ALL the cells in the entire workbook to the user-desired Add-In Code, which may be a module embeded into the XLS or the Excel Add-In XLA. ## Platform Windows XP SP2 Office 2003 Pro; Excel 2003
ID del proyecto: 3674942

Información sobre el proyecto

5 propuestas
Proyecto remoto
Activo hace 18 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
5 freelancers están ofertando un promedio de $217 USD por este trabajo
Avatar del usuario
See private message.
$170 USD en 3 días
5,0 (48 comentarios)
5,3
5,3
Avatar del usuario
See private message.
$55,25 USD en 3 días
5,0 (47 comentarios)
4,5
4,5
Avatar del usuario
See private message.
$722,50 USD en 3 días
3,0 (7 comentarios)
3,5
3,5
Avatar del usuario
See private message.
$68 USD en 3 días
4,1 (2 comentarios)
1,5
1,5
Avatar del usuario
See private message.
$68 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
6
Miembro desde sept 24, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.