Jump to content

Search the Community

Showing results for tags 'save excel formula as value'.

  • Search By Tags

    Type tags separated by commas.

  • Search By Author

Content Type


Forums

  • General
    • Announcements and Site News
    • Administration
  • AutoIt v3
    • AutoIt Help and Support
    • AutoIt Technical Discussion
    • AutoIt Example Scripts
  • Scripting and Development
    • Developer General Discussion
    • Language Specific Discussion
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Categories

  • AutoIt Team
    • Beta
    • MVP
  • AutoIt
    • Automation
    • Databases and web connections
    • Data compression
    • Encryption and hash
    • Games
    • GUI Additions
    • Hardware
    • Information gathering
    • Internet protocol suite
    • Maths
    • Media
    • PDF
    • Security
    • Social Media and other Website API
    • Windows
  • Scripting and Development
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Find results in...

Find results that contain...


Date Created

  • Start

    End

Last Updated

  • Start

    End

Filter by number of...

Joined

  • Start

    End

Group

Member Title

Location

WWW

Interests

Found 1 result

  1. RickB75
    Just a quick question guys. How can I save a formula as a value in excel? I'm using autoit to write an excel sheet for me, writes a formula (VLookup) that looks in different workbooks for values. Well, I would like to email this report but I need the values rendered and not the formula. I found an answer on Microsoft's website here, but they want you to copy and paste the values. There's gotta be an easier way... I would think it would be something like this I found on this site but I don't know how to write it into my script. Range("A1:A10").formula="=20*10" Range("A1:A10").value=range("A1:A10").value
×
×
  • Create New...