Fermé

Debug "[url removed, login to view]" error in VBA for Mac 2011

My macro works as designed on Excel in Windows but on Mac Excel 2011 the two ".close" commands trigger an error.

The macro is part of an add-in. If the attached code sample is not enough to solve the issue, I can provide the add-in with a signed non-disclosure agreement.

Compétences : Excel, Mac OS, Visual Basic pour les apps

Voir plus : sample non disclosure, non disclosure sample, non disclosure agreement sample, error vba shared workbook, vba check workbook closing, excel vba update workbook, vba error 40036 sheet, excel vba error

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #8474194

13 freelance ont fait une offre moyenne de 27 $ pour ce travail

zExcel

A proposal has not yet been provided

70 $ USD en 1 jour
(204 Commentaires)
7.2
Vlzinch

Hello! I work with VBA for last 5 years and have created hundreds of different scripts, I have reviewed PDF, but You are right, to solve it i will need add-in. NDA is not a problem. If You need somebody who can Plus

22 $ USD en 1 jour
(14 Commentaires)
4.9
lalmansari

-> Excellent Programmer -> 4+ years of experience in VBA programming, PDF designing and Excel Macro Development -> Will provide high quality product. -> I have a Master degree in Computer Application and kind of a w Plus

30 $ USD en 1 jour
(6 Commentaires)
3.2
atifarzi

Yes this is very simple task. It will take max 2 hours of searching for the reasons behind the behavior and if lucky, can be done within 2-3 hours itself.

20 $ USD en 1 jour
(4 Commentaires)
2.8
remisanonymous

Hi, I think I know where problem is. I don't have Mac to test, but if it will not work, you can not pay me. Best regards, Remis

10 $ USD en 1 jour
(5 Commentaires)
2.6
bossumd

Hi! Try to change your script: Public Function SetLookupTable() As Workbook ' return the lookup table as an object. On Error Resume Next '***add this instruction to your code *** Set SetLookupTable = Application. Plus

20 $ USD en 3 jours
(4 Commentaires)
1.7
ashish98420

I have done visual basic code and i think that I can solve it but if I couldnot solve it I would ask for my teacher to solve it . But I don't understand what do you mean.

35 $ USD en 1 jour
(0 Commentaires)
0.0
mparker88

I have a lot of experience in Microsoft Excel VBA macros. I've had a look at your attached pdf code snippet and I have a few suspicions on what might be happening. What I think is the most likely explanation is tha Plus

30 $ USD en 1 jour
(0 Commentaires)
0.0
stanleyw12

Hi Sir Have u tried removing "ThisWorkbook" from ThisWorkbook.SetLookupTable() line? See if that works out for you? Regards,

25 $ USD en 1 jour
(0 Commentaires)
0.0
princtonb

A proposal has not yet been provided

25 $ USD en 2 jours
(0 Commentaires)
0.0
ameelbeesony

I have already modified your code to fix this error. If you assign the project to me: 1. I will deliver the fix immediately. 2. I will explain to you why your code caused an error.

20 $ USD en 1 jour
(0 Commentaires)
0.0
snapzcollections

A proposal has not yet been provided

23 $ USD en 1 jour
(0 Commentaires)
0.0
parama4u

Already Fixed this issue before long time. :) Ping me and get the work done in hours. Is that possible to access your computer through teamviewer or something? Just to test it on Mac, as my current system is in windows Plus

15 $ USD en 0 jours
(0 Commentaires)
0.0