Renaming files and cells

[koichirose]

Hi
I have to create a macro for an excel sheet

I have:
column A - a string (AA-001-06, for example)
column B - empty
column C - a link to a pdf file

I have to rename the file linked in column C with the name contained in
column A (it will be AA-001-06.pdf)

create a link to the new file in column B

suggestions?

if possible, i'd like to leave the old file as is, to have both
oldfile.pdf and AA-001-06.pdf, although it's the same pdf file.
Also, can it be done by selecting some cells to execute this macro on
instead of doing it for the whole sheet?

Thanks!

 

[Jim Cone]

Depending on your situation, the free Excel add-in "List Files" could help.
It can list all files in a specified folder(s) with a specified file extension.
It also creates hyperlinks to each file.
All nicely formatted (including some file properties) on a new worksheet.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


Hi
I have to create a macro for an excel sheet

I have:
column A - a string (AA-001-06, for example)
column B - empty
column C - a link to a pdf file

I have to rename the file linked in column C with the name contained in
column A (it will be AA-001-06.pdf)

create a link to the new file in column B

suggestions?

if possible, i'd like to leave the old file as is, to have both
oldfile.pdf and AA-001-06.pdf, although it's the same pdf file.
Also, can it be done by selecting some cells to execute this macro on
instead of doing it for the whole sheet?

Thanks!

 

[koichirose]

Jim Cone ha scritto:

Depending on your situation, the free Excel add-in "List Files" could help.
It can list all files in a specified folder(s) with a specified file extension.
It also creates hyperlinks to each file.

I don't think that's what I need: i need to rename the files before
listing them