Member Avatar for bytigma

Hi guys,

Hope you will be able to help me with this problem. The problem that I have is that I have two .xsl files that are uploaded to the same specified folder at 4pm everyday. The file names are the same apart from the end digits specifying the date they were uploaded.

I want to create a macro that when pressed makes a copy of the two recently uploaded .xsl files in the folder and paste them in the same folder, with the same names but instead of .xls I need it to be transformed to a .csv file.

I beleive this will be fairly simple but unfortunately I do not have much experience with working with marcros.

Please can someone help me with this problem by giving me sample code to solve it.

Many thanks for your help

  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by vbCNEW
Member Avatar for vbCNEW

dont use macro use vb or batch file. your problem is not that clear .. i want to help but explain and give sample pls...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.