Do want to use a function call in the VBA programming hyperlinks in the original Excel spreadsheet what to get?

Say specific point is:

1. VBA statement - this I use Case Is

2. If it is the first selected have hyperlinks cell

3. Read the selected Cell?

4. Reference hyperlink and finding the link file

5. The original file is copied then according to the number of pages one page a page and paste into one of the Excel sheet

Is this four 2, 3, 4, 5 do? Or everybody has similar to guide the trouble, please give a sample of the procedures section is ok thank you very much

CodePudding user response:

Start recording macros in Excel 2003, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

CodePudding user response:

To make more convenient use hyperlinks collection:

 Option Explicit 
Sub test () 
Dim Lnk As the Hyperlink 
For Each Lnk In Sheet1. Hyperlinks 
"' 
Next 
End Sub 

.

CodePudding user response:

reference 1st floor zhao4zhong1 response:

start recording macros in Excel 2003, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,

I want to do this is to judge how can also use the process of the macro?
Me put it this way VBA into calls to read and then deal with hyperlinks and it is pointing to the file

CodePudding user response:

refer to the second floor Topc008 response:

to make more convenient use hyperlinks collection:

 Option Explicit 
Sub test () 
Dim Lnk As the Hyperlink 
For Each Lnk In Sheet1. Hyperlinks 
"' 
Next 
End Sub 

.

Oh oh thank you so suppose I have two columns in the first column is the second column is the filename hyperlink (should be three columns of the third column is the address)
First of all, I want according to the file name to do a judgment compound required in the reading corresponding to the first column of the hyperlink
You see is that ok?

CodePudding user response:

Don't know what is your links, you see the properties of the Hyperlink, range, address, etc., in which the range corresponds to the address, where the cell can be used to offset to locate near to its cell...

CodePudding user response:

Press Alt + F11 key, press the F1 key again,...