How can I pass few variable in same path?

Help StudioX
,
1

image
image703×346 10.7 KB

Here is what i use for the command. I put two variable together but unfortunely it doesnt detect the files inside the folder that I want.

image
image1116×391 19 KB

Here is the result.

But if i click the exact excel files, then it should works.

2

hi @Muhamad_Izwan_Bin_Hamran ,
You assign file name as a string?
pls check file path in string?
regards,
LNV

3

Folder Name below is the string:
Path.Combine(“R:\CHARTERERS REPORTS\KCSM,KSL,KCSSG - Aging Report”,DateSerial(now.Year,now.Month,0).ToString(“MMMM yyyy”))

File Name below is the string:
“ZA01 “+Now.AddMonths(-2).ToString(“MM.yyyy”)+” - Draft”

4

Hi @Muhamad_Izwan_Bin_Hamran
I think miss extend of file,
in this is “.xlsx”
ex: “.xlsx” '.pdf", “jpg”,…
regards,
LNV

5

Path.Combine(“R:\CHARTERERS REPORTS\KCSM,KSL,KCSSG - Aging Report”,DateSerial(now.Year,now.Month,0).ToString(“MMMM yyyy”))+“ZA01 “+Now.AddMonths(-2).ToString(“MM.yyyy”)+” - Draft.xlsx”

Is this correct ?

6

I think
file name:
“ZA01 “+Now.AddMonths(-2).ToString(“MM.yyyy”)+” - Draft.xlsx”

folder name not have extend

you can test

regards,
LNV

7

image
image1046×202 12.3 KB

still doesnt works. Any other way ?

8

You can paste string at file path to check correct or not

image
image743×109 4.06 KB

this error is in string is not correct–> not found
found this file in your folder, I will fix string for you

9

Path.Combine(“R:\CHARTERERS REPORTS\KCSM,KSL,KCSSG - Aging Report”,DateSerial(now.Year,now.Month,0).ToString(“MMMM yyyy”))+“ZA01 “+Now.AddMonths(-1).ToString(“MM.yyyy”)+” - Draft.xlsx”

If i paste this, it doesnt go to the folder and specific files that i wanted to you. Need help to fix my string.

Below is the actual folder
R:\CHARTERERS REPORTS\KCSM,KSL,KCSSG - Aging Report

10

Your folder path
Path.Combine(“R:\CHARTERERS REPORTS\KCSM,KSL,KCSSG - Aging Report”,DateSerial(now.Year,now.Month,0).ToString(“MMMM yyyy”))

Did you check this folder correctly?

11

Im using below to go to folder:
R:\CHARTERERS REPORTS\KCSM,KSL,KCSSG - Aging Report

I didnt put path. combine at the search bar

12

you can use

path.combine(“R:\CHARTERERS REPORTS\KCSM,KSL,KCSSG - Aging Report”, VVV)

considered you have your file name in VVV Variable.

13

sample:

path.Combine(“R:\CHARTERERS REPORTS\KCSM,KSL,KCSSG - Aging Report”, DateSerial(now.Year,now.Month,0).ToString(“MMMM yyyy”),
“ZA01”+Now.AddMonths(-1).ToString(“MM.yyyy”)+“-Daft”+“.xlsx”)

14

i need to paste this in search bar ?

15

you can test with your code

16

it doest work. Any other alternative way

17

can you tell me the specific folder path
and file path you want to get?

18

@Muhamad_Izwan_Bin_Hamran

  1. Check the folder path properly if ot is printing correct
  2. Better to remove dots from the filename ao that it not confused

Cheers