troubleshooting Question

Run Excel Macro daily on new file

Avatar of jae1
jae1 asked on
VBAMicrosoft ExcelMicrosoft Office
8 Comments1 Solution15 ViewsLast Modified:
I am trying to find a solution for this scenario.  We have a batch process from a vendor that delivers a new file in csv format every night.  Column E in this file contains numeric values with a minus sign included for negative values, and this minus sign must be removed before we can pass the file to another process.  I need to automate and schedule the process.

I can automate changing the file from csv to xlsx, and the following macro works for removing the minus sign as intended, but I am struggling with how to run the macro on a new file each night and save the results.    Thanks  

Sub ChgSign()
Columns(5).Select
For Each Cell In Selection
    If Cell.Value < 0 Then
        Cell.Value = -Cell.Value
    End If
Next Cell
End Sub
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros