03-23-2016, 04:56 PM
Hi Guys,
I need a macro to do the follow steps.
1. Open the file C:\BASE\sales.xlsx (if not open)
2. Copy the range Sheet1!A1
21
3. Save this range as a CSV File (C:\BASE\data.csv)
I will run this macro every 30 seconds, so it's important to have an error handler to repeat the step until it gets sucessfull.
Thanks a lot for helping!!!!
I need a macro to do the follow steps.
1. Open the file C:\BASE\sales.xlsx (if not open)
2. Copy the range Sheet1!A1
213. Save this range as a CSV File (C:\BASE\data.csv)
I will run this macro every 30 seconds, so it's important to have an error handler to repeat the step until it gets sucessfull.
Thanks a lot for helping!!!!