problem concatenating the filename to the code

[safisam]

Hi, can someone please advise me on how to fix this macro, (the area marked in red). I want the filename that resulted from Cells(a,11)

"Z:\Pumps_Division\CS&A Dept\Quotations Per Customer\" 'Cells(a, 11) & ".xls"

to be the filename in the hyperlink with added .xls extension.

Thanks
Sam

Please Login or Register  to view this content.

[DonkeyOte]

As mentioned on your original thread (now closed) at first glance you need to replace the ' with &

[safisam]

As mentioned on your original thread (now closed) at first glance you need to replace the ' with &

When I do this, I get z:/..../.xls without the file name, that's why it was commented it.

[DonkeyOte]

see that highlighted in red:

Please Login or Register  to view this content.

[safisam]

see that highlighted in red:

Please Login or Register  to view this content.

I did that, and that's what I got:

Please Login or Register  to view this content.

[DonkeyOte]

The implication then being that the cell being referenced for file name is blank.

[safisam]

The implication then being that the cell being referenced for file name is blank.

I don't understand, I'm creating a filename which Cell(a,11) then I want to use this name add to it .xls to come up with a file name. So it will be something like this:

R1-Ferz-00851-020909-AJ.xls

[safisam]

Guys, any help would be appreciated.

As I said, I have a macro that contatenate servral cells to make a serial number (Cell 1+2+3+4) = Serial number Then in another Excel session, I want to create a file and want to name this file as the same name as the Serial number so the file name would be cell 1+2+3+4.xls

I need help so when I create a hyperlink over the serial number is to open the serial number excel file. but I cannot seem to figure out how to put a function (cell 1+2+3+4) as a file name. See attached Example

Thanks