- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.
If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:
Folder name
Filename
Concatenated
LINK
../excel/
file1.pdf
../excel/file1.pdf
file1.pdf
../excel/
file2.pdf
../excel/file2.pdf
file2.pdf
../excel/
file3.pdf
../excel/file3.pdf
file3.pdf
Here are the formulas behind this:
A B C D
Folder name
Filename
Concatenated
LINK
../excel/
file1.pdf
=CONCATENATE(A2,B2)
=HYPERLINK((C2),B2)
../excel/
file2.pdf
=CONCATENATE(A3,B3)
=HYPERLINK((C3),B3)
../excel/
file3.pdf
=CONCATENATE(A4,B4)
=HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).
Many names for this part: TT support, turntable support, wheel support... This site is likely to have what you're looking for:http://www.repairclinic.com/
This is explained in the Excel help. - select the second data set (in the chart). - select the Format tab in the ribbon. - click the Format Selection option. - select Secondayr axis. - click Close.
Simple fix for forward-back movement axis inversion:
In "My Documents\My Games\Gears of *** for Windows\***Game\Config", edit the file "***Input.ini". At the very top, under the section "[Engine.PlayerInput]", change your MoveForwardSpeed to a negative number, like this:
MoveForwardSpeed=-1200
Note that I only play offline, and this setting in this file works great for me with Logitech Rumblepad 2 (although all of the other buttons are still a little off, but that I can live with). I tried every other reference to forward-backward movement and the left Y axis in this file, as well as "<installdir>\Engine\Config\BaseInput.ini" and "<installdir>\***Game\Config\DefaultInput.ini", so don't bother with those...
×