![]() |
Filecopy in vba macro
Hi,
I am trying to write vba macro using Filecopy but I always get an error (file not found) while reading the file in the folder. Is FILECOPY are Upper or Lower case sensitive? If yes, What is the command that uses or interprete wether it is a lower or upper case? here's my code: Dim a as string Dim b as string atemp = "c:\temp\myfile\" btemp = "d:\temp\yourfile\" ctemp = "Datafile.dat" FILECOPY atemp & ctemp, btemp & ctemp Appreciate your help. Thanks in advance. Jodie |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com