Share via

VBA code issue for transfer of multiple types of files

Tamal Khan 1 Reputation point
2021-06-30T09:12:57.557+00:00

Hi,

Can someone help me in the below codes.

Details:

  1. I have File names stored in Col B from Row 16 to 132
  2. The reports are saved in input location path
  3. Each report have 3 formats(CSV, XLS, PDF).
  4. I want to move the mentioned files into the destination path mentioned in Col D (beside each file name)
  5. the Code in the name will play a factor to decide destination folder like 2000 in master, 3000 in LP etc.
    Please refer to Image 2 for the above details.
    Please also refer Image 1 (getting error in code running)

110613-image.png

110574-image.png

Developer technologies | Visual Basic for Applications
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Larson (Access MVP 2008, 2009, 2011) 251 Reputation points
    2021-07-06T01:10:43.59+00:00

    Well, first off, your variable path does not refer to a correct computer path. So that would be why you are getting an error.

  2. Tamal Khan 1 Reputation point
    2021-07-06T05:41:41.697+00:00

    The issue is resolved now. Thanks guys for the comments.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.