Closed

Excel VBA Subroutine, Fix my Code: print screen clipboard paste to microsoft paint -- 2

This project received 20 bids from talented freelancers with an average bid price of $30 USD.

Get free quotes for a project like this
Employer working
Project Budget
$10 - $30 USD
Total Bids
20
Project Description

**I need someone to add onto my current code.

It should be able to:

1. Copy certain cells, (I already have done this part)

2. Open a microsoft paint file, (I already have done this part)

3. Paste image to microsoft paint,

4. Save file.

5. Close paint

Use VBA found in Excel

** Option Explicit

Sub Save_Picture()

'

'Windows("BEEMER COMPANIES [url removed, login to view]").Activate

Worksheets("EMPLOYEE DAILY SCHEDULE").Activate

Range("A1:J31").Select

[url removed, login to view] Appearance:=xlScreen, Format:=xlBitmap

'opens Paint

Call Shell("C:\WINDOWS\system32\[url removed, login to view] " & Chr(34) & "P:\Documents\Nate's Documents\Over 6 months old\Schedule\[url removed, login to view]" & Chr(34), vbNormalFocus)

End Sub

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online