Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filecopy in vba macro
It's not case sensitive for me. (win98 now, and I've never worried about case
sensitivity in winNT, either.) Any chance that your datafile.dat is hidden? If you go to windows explorer and go to that folder and rightclick on the file, select properties, do you see a check mark in the Hidden property? Jodie wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filecopy in vba macro | Excel Programming | |||
Filecopy in vba macro | Excel Programming | |||
FileCopy | Excel Programming | |||
FileCopy | Excel Programming | |||
FileCopy error | Excel Programming |