condorelli
New Member
- Joined
- Jul 27, 2017
- Messages
- 12
Hi all!
I need help about vba code.
This is the scenario...
Many pdf have hyperlinks towards one excel file. In this file I have:
"Excel.Application.Workbooks.Open("\\aaa\aaa\Prova.xlsx").Sheets(bbb).Range("ccc").Activate"
This file opens another excel file (Prova.xlsx) in a named cell "ccc".
The question is...
Is there a way to read the name of the pdf and put it in "bbb" without ".pdf" extension?
I need help about vba code.
This is the scenario...
Many pdf have hyperlinks towards one excel file. In this file I have:
"Excel.Application.Workbooks.Open("\\aaa\aaa\Prova.xlsx").Sheets(bbb).Range("ccc").Activate"
This file opens another excel file (Prova.xlsx) in a named cell "ccc".
The question is...
Is there a way to read the name of the pdf and put it in "bbb" without ".pdf" extension?