• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

open pdf files in folder based hyperlinks in excel rage and save to a folder

D

dvsdasari

New Member
Hi,


I have 750 pdf documents of my company's barnches. I need to seperate all those pdf documents branch wise.


For that we need to open those pdf files through excel hyperlinks and save in folder (opened files).


Please help me out on this.


Thanks-Sekhar
 
Hi Sekhar,

Why not just copy the files to appropriate folders? And why do you need to involve hyperlinks?

Asa
 
Hi Asa,


Thanks for reply.


The problem here is, there is no way to find out the file of a particular vendor.


The file names are saved with a unique ID of Vendor.


For example, I have a vendor called ABC Company.


If we want to save the above vendor file into a seperate folder, we need to open all files, check the names and save in a other folder.


As we have 1000 files in a folder, how much time it takes to find out a vendor file.


Here, my idea to create hyperlinks to the all files in that particluar folder and segregate based on the ID and save into the folders.


Please let me know if you need any other information.


Thanks and Regards,

Sekhar Dasari
 
Hi,


I can give you the file names as ...........


AAACB2894G_FORM16A_2012-13_Q1

AAACC4175D_FORM16A_2012-13_Q1

AAACD2145G_FORM16A_2012-13_Q1


and so on......


Thanks-Sekhar
 
Hi Sekhar ,


From what I understand , each vendor is identified by their unique ID , so if AAACB2894G is the ID for ABC Company , then all files which begin with this ID will "belong" to ABC Company.


Is this so ?


Narayan
 
Hi Narayan,


You are right, each and every file has started with the unique ID of the vendor ( as mentioned in the previous post).


Thanks-Sekhar
 
Hi Sekhar,

Happy holidays and new year!


What I was getting at, is that you could use a macro to copy the files based on their filename. As you've indicated, the files are all coded according to their vendor unique ID, so the macro could copy the files into folders according to vendor ID.


Unfortunately, I have no time to help further right now, but hopefully others can get you going with that solution or another.

Asa
 
dvsdasari.

you have to do a few tasks before a solution can be made for you.

1 - you need a list of all the unique vendor IDs and the Company names. This is necessary what ever method you do so you might as well go and start colecting that information.

2 - you need to notify us of the path where the files are stored and an example of where you want them stored ( it is possible to write the script so that you can specify it, but it would be better to check these first.)

3 - you need to decide how you want to change the file names. I suggest that you store them with the same name, and you just name the folder. e.g with the vendor id and name like "ABC123 - Company ABC"


here is a link to some code that might help with collecting the names

http://www.ozgrid.com/forum/showthread.php?t=65530
 
You must log in or register to reply here.
Back
Top