Extract Links From Dlc Files

When you load a DLC links list, JDownloader will check if the files are online. With any packet sniffer you can list those links. A more detailed short video tutorial was posted on sala source.

How To Get Dlc Files

How to extract hyperlinks from multiple images in Excel?

Let’s say, you have a list of images in a worksheet, and each image contains a hyperlink, now, you would like to extract the real hyperlink addresses from these pictures to their next cells as following screenshot shown. Of course, you can copy the hyperlink address from the Edit Hyperlink box one by one, but, this will be time-consuming if there are multiple hyperlinks needed to be extracted. In this article, I will introduce some methods to solve this task quickly and easily in Excel.

Extract real addresses from hyperlinks:

With Kutools for Excel’s Convert Hyperlinks, you can quickly extract real URL addresses from hyperlinked cells at once.

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...

Extract Links From Dlc Files Download

Kutools for Excel - The Best Office Productivity Tool Will Solve Most of Your Excel Problems
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words...
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum...
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns...
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Create Mailing List and Send Emails by Cell's Value...
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in company; Full features 60-day free trial.

Extract hyperlinks from multiple images with VBA code

Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!

The following VBA code can help you to extract the real addresses from the multiple hyperlinked images at once, please do step by step:

1. Hold down the ALT + F11 keys in Excel to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: Extract real addresses from multiple hyperlinked images

3. Then press F5 key to run this code, and all hyperlink addresses have been extracted into corresponding cells beside the pictures, see screenshot:

Note: This code will extracted real addresses from all images in the current worksheet.

Online

Kutools for Excel - The Best Office Productivity Tool Increase Your Productivity by80%

How To Extract Links From Web Page

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Works with Office 2007-2019 and 365. Supports all languages. Easy deploying in company. Full features 60-day free trial.

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • Worked like a charm once I figured out how to.
Posted by4 years ago
Archived

Took me an hour or 2 of hunting and experimenting to find this procedure, thought i might save you all the time.

note: all extracted sounds will have meaningless numeric filenames

You will need:

[bnk extractor] (https://github.com/eXpl0it3r/bnkextr/releases/download/1.1/bnkextr.exe)

[ww2ogg] (http://www.hcs64.com/files/ww2ogg022.zip)

[revorb] (http://yirkha.fud.cz/progs/foobar2000/revorb.exe)

Place the full contents of these all in one folder together. This includes extracting the ww2ogg zip.

Locate the sound files or archives you wish to extract. They look to be located in SteamSteamAppscommonkillingfloor2KFGameBrewedPCWwiseAudioWindows

This directory contains a combination of .wem files with meaningless numeric names and .bnk files with meaningful names. The .wem file type is already audio, so you can skip the bnkextr step with those files. The .wem files here look to be the game's full music soundtrack. This is nice since the special edition soundtrack only included the with-vocals music, the files here look to include the no vocals versions. Sadly you will have to determine their track titles manually.

The .bnk files are a Wwise archive format and contain many sound files. For example, the reverend Alberts voice .bnk contained over 700 sounds. These you need to run through bnkextr.

Extracting:

Step 1 (.bnk files only)

Copy the .bnk file you wish to extract into your folder, then drag that .bnk file onto bnkextr.exe. The folder you are in will suddenly be filled with .wem sound files that bnkextr extracted from the .bnk. You will not be able to play these.

Step 2

We need to convert these .wem files into something you can play. This is what ww2ogg does for us. However, the files it gives you play oddly and have skips and stutters ('tracking issues' said my research). The revorb tool fixes these.

Create a new text file of any name you want, but change its extension to .bat. In that text file put this script:

Save this .bat file and then run it via double click. This may take some time. Note the console window this opens will ask you to press any key to continue twice. You can stop this by removing the 'pause' lines if you want.

After that is done running you will now have .ogg files in addition to the .wem's. The .ogg's should be playable. If you want a format other than .ogg, you will have to convert the files on your own from there.

The .wem files are no longer needed for anything, so you can mass remove them by making and running another .bat file containing the following if you like:

I tried following my own instructions and they successfully got me all of Mr. Foster's voice lines, so this should work for you all too hopefully ^_^

(No, i do not know how to reverse this procedure so as to change in game sounds)

6 comments