MEIR
05-20-2015, 06:03 AM
Hello,
i have excel with links to pdf,jpeg,doc...
i need vba code to get files to specific folder
example:
this my data:
columb A columb B
links
new name
C:\Users\Desktop\44.pdf
A1
C:\Users\Desktop\13.pdf
B3
C:\Users\Desktop\10.pdf
D1
C:\Users\Desktop\44.jpeg
D2
C:\Users\Desktop\20.jpeg
D3
C:\Users\Desktop\123.doc
D4
C:\Users\Desktop\123.xls
D5
i need button when i press all files ( pdf,doc,jpeg) copied to folder C:\Users\Desktop\new data.
copy files no links.
thanks
i have excel with links to pdf,jpeg,doc...
i need vba code to get files to specific folder
example:
this my data:
columb A columb B
links
new name
C:\Users\Desktop\44.pdf
A1
C:\Users\Desktop\13.pdf
B3
C:\Users\Desktop\10.pdf
D1
C:\Users\Desktop\44.jpeg
D2
C:\Users\Desktop\20.jpeg
D3
C:\Users\Desktop\123.doc
D4
C:\Users\Desktop\123.xls
D5
i need button when i press all files ( pdf,doc,jpeg) copied to folder C:\Users\Desktop\new data.
copy files no links.
thanks