Write some Software

$30-250 USD

Abgeschlossen

Veröffentlicht

vor mehr als 7 Jahren

$30-250 USD

Bezahlt bei Lieferung

Hi, I've been using the code in the attached Excel workbook in many stock analysis workbooks and generally, it works just fine. If I fat finger a wrong ticker and the sub doesn't run, I just click on "End" and go back and retype the ticker. I do the same when I lose my internet connection and get an error. It would be nice though if these errors could be trapped with a "Ticker not found" message and a "No data connection" for the second. The job would be to trap these errors gracefully and offer a simple option to return to the worksheet. This is probably simple, but I need help with this code. Thanks, Art

Excel

Projekt-ID: 12857643

Über das Projekt

8 Vorschläge

Remote Projekt

Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@KavTan

I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.

$100 USD in 3 Tagen

4,8

(24 Bewertungen)

4,2

8 Freelancer bieten im Durchschnitt $71 USD für diesen Auftrag

@jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Automated Web Scrapping using Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample file before you consider awarding me the project. Thanks, Jay

$150 USD in 2 Tagen

5,0

(387 Bewertungen)

7,7

@TonmoyRoy111

A proposal has not yet been provided

$50 USD in 1 Tag

4,9

(131 Bewertungen)

5,7

@yh2013

I have the required expertise for developing your project. Check my developed projects and reviews of my portfolio.

$35 USD in 5 Tagen

4,8

(7 Bewertungen)

3,5

@ben899

HI, I've had the same issue with my Macro code once and could fix it in a nice way. I definitely can do the same here:)

$45 USD in 3 Tagen

0,0

(0 Bewertungen)

0,0

@profesitor

Hello there, I took a look at the code in the sample that you placed. It looks like a couple of the subs don't have any error handlers, which is why you are getting the behavior that you are describing. I could easily add in some error handlers for you so that the spreadsheet behaves the way that you would like. Other than that, the code looks pretty simple and straightforward, so it doesn't appear that there needs to be much in the way of debugging. At bit about me, I've been creating VBA scripts for a couple of years now in my day jobs. I've created many spreadsheets to help me automate my work and clean up data when needed. I've also created spreadsheets that were customer facing, so they had to be water tight and have proper error handling so that the customer experience was a positive one. Please let me know if you have any questions. Thank you and have a great day.

$60 USD in 3 Tagen