Protect file name

[Tempy]

Good day all, i need to send a file retrieved from SAP and send it to a
supplier with the following format: 720_1234567_091005_I.xls

720 = the buyer number (Variable)
1234567 = Vendor number (Variable)
091005 = Date (Variable)
I = Input (Static)

The numbers and date are variable per download from SAP.

I need to keep the file name exactly as it is, could somebody please
help in advising if it is possible to do with code and how to do it.


thanks in advance.

regards,

Tempy

 

[Guest]

looks like you just need to construct a string, then save as (unless teh data
and input are real time adjustments?

dim myName as string
myname = ""
myname = Cstr(buyernumber) & "_" & Cstr(Vendornumber) & "_" &
cstr(date) & "_" & cstr(input) &".xls"

' add path info as needed
'myname = "PAthinformation" & myname

myfile.saveas Filename:=myname

 

[Tempy]

Thanks Vacation's Over, sorry for the time delay....due to different
time zones


Tempy