calling all excell guru ... realy need help on this tricky problem

Paras Bhoot

New member
Joined
Mar 17, 2013
Messages
1
Reaction score
0
Points
0
Location
A, A
hello,

i am using excel 2007, and i have invoice format in sheet 1 as shown below.
..INVOICE.jpg

now i need the code for save button for following problem:

Problems:

the first problem is when i press the save button it should generate the pdf file of sheet 1, and have a link to open this newly generated file in sheet 2
and it should ask me for the file name at the time of saving it,

now the second problem is it should save the link in next row each time
for example :
first it save link in sheet 2 a1
than next time it should save link in sheet 2 a2
than next time it should save link in sheet 2 a3
and again and again...

pls help..
 
Top