Completed

Modificar Macros

Published on the December 02, 2016 in IT & Programming

About this project

Open

Tengo un Macro en Excel que me exporta un libro del archivo en PDF utilizando el comando:

Function CrearCarpeta(Ruta As String, Carpeta As String) As String
    Dim FSO As Object, Fold As Object, SubFold As Object
   
    Set FSO = CreateObject("Scripting.FileSystemObject")
    On Error Resume Next
    Set Fold = FSO.GetFolder(Ruta)
    Set SubFold = Fold.SUBFOLDERS
    SubFold.Add Carpeta
    Set Fold = Nothing
    Set SubFold = Nothing
    Set FSO = Nothing
    CrearCarpeta = Ruta & "\" & Carpeta & "\"
End Function

Function ExportToPDF(Rango As String)
    Dim RutaBase As String
    Dim Ruta As String
    Dim Celda As Range
    Dim Celdas As Integer
    Dim Contador As Integer
    Dim Porcentaje As Single
   


La idea es modificar el macro para que me lo exporte en una hoja de Excel y solo los valores (sin que se vean las formulas).

Category IT & Programming
Project size Small
Is this a project or a position? Project
I currently have I have an idea
Required availability As needed
Experience in this type of projects Yes (I have managed this kind of project before)

Delivery term: Not specified

Skills needed

Microsoft Excel Visual Basic VBA

Want to start working on this project?

Log into your Workana account or Register today. Boost your freelance work!

Other projects posted by D. E.