How to Insert the current Excel file name, path, or worksheet in a cell !?

How to Insert the current Excel file name, path, or worksheet in a cell !?

1--Puna putanja / path:

=CELL("filename", A1) 

vraća punu putanju, naziv datoteke i naziv trenutnog lista u Excelu, uz uvjet da je radna knjiga spremljena.

2--Samo naziv datoteke:
=MID(CELL("filename", A1), SEARCH("[", CELL("filename", A1)) + 1, SEARCH("]", CELL("filename", A1)) - SEARCH("[", CELL("filename", A1)) - 1)

3--Samo naziv datoteke i naziv lista:
=RIGHT(CELL("filename", A1), LEN(CELL("filename", A1)) - FIND("]", CELL("filename", A1)))

🔊 WARNING !!!   NAPOMENA !!! 🔊
WPS Office (and Excel configured with European regional settings) uses a semicolon (;) instead of a comma (,) to separate function arguments.

Ova gore NAPOMENA znači da je potrebno sve zareze (,) zamijeniti sa točka zarez (;) u slučaju kada je vaš EXCEL postavljen sa "European regional settings".  

Npr. tada formula br.2 glasi:

=MID(CELL("filename";A1);SEARCH("[";CELL("filename";A1))+1;SEARCH("]";CELL("filename";A1))-SEARCH("[";CELL("filename";A1))-1)

https://professor-excel.com/file-name-sheet-name-path-insert-file-information-excel-cell/

UWT - partner for measuring solutions for all types of industries

 UWT - partner for measuring solutions for all types of industries 

https://www.uwtgroup.com/en/

Easy Rivet Nut Installation - How to mount a Rivet Nut Without a gun

Easy Rivet nut Installation - How to mount a Rivet Nut Without a gun

https://www.youtube.com/watch?v=JkxXlzv1h88

https://www.youtube.com/watch?v=R5mXTGUO82g

Google Chrome - Creating a Desktop Shortcut for a YouTube Video

Google Chrome  -  Creating a Desktop Shortcut for a YouTube Video

You can create a direct desktop shortcut to a specific YouTube video in Chrome by clicking the three-dot menu, selecting Save and share, and choosing Create shortcut.

1. Open the specific YouTube video you want to save in Google Chrome.
2. Click the three vertical dots in the top-right corner of the browser window.
3. Go to Save and share, then click Create shortcut...

Google Chrome - Full-page screenshot in Google Chrome Without an Extension

Google Chrome  -  Full-page screenshot in Google Chrome Without an Extension

Chrome has a hidden built-in feature that requires no downloads: [1]

1. Open the webpage you want to capture.
2. Press Ctrl + Shift + I (Windows) or Cmd + Option + I (Mac) to open Developer Tools.
3. Press Ctrl + Shift + P (Windows) or Cmd + Shift + P (Mac) to open the command menu.
4. Type screenshot into the search bar.
5. Select Capture full size screenshot, and Chrome will save the file to your downloads

KARL GEORG Crane wheels - Crane wheel accessories - Wheel axle with lubrication bore

KARL GEORG Crane wheels - Crane wheel accessories - Wheel axle with lubrication bore 

https://www.karl-georg.de/en


1 - - Crane wheel accessories
https://www.karl-georg.de/en/products-solutions/crane-wheels/crane-wheel-accessories

Wearing washers - KG 010.3Wheel axle without lubrication bore - KG 010.4
Axle bracket - DIN 15058
Pinion - KG 010.5
Wheel axle without lubrication bore - KG 010.6
Wheel axle - KG 020.1
Flangable gear ring - DIN 15082 - 1
Press-fit gear rings - DIN 15082 - 2
Wheel tyres - DIN 15083
Sealing Cap - DIN 15084
Internal bush B 500 - DIN 15086
Spacer ring S 630 - DIN 15086
Connection flange for cardan shaft - DIN 15452
Inner bushes - KG 030

2 - - Crane wheels - Wheel axle with lubrication bore 
https://www.karl-georg.de/en/products-solutions/crane-wheels/karl-georg/kg-factory-standard-accessories/wheel-axle-without-lubrication-bore-kg-0104#downloads

https://www.karl-georg.de/fileadmin/Pdf/Catalogs/crane_wheels/_extract/KG-catalogue-crane-wheels-en-web__11-11.pdf

3 - - Karl Georg crane wheel product catalogue

https://www.karl-georg.de/fileadmin/Pdf/Catalogs/crane_wheels/KG-catalogue-crane-wheels-en-web.pdf

KARL GEORG The world of crane components

KARL GEORG The world of crane components

https://www.karl-georg.de/en

https://www.karl-georg.de/en/downloads

Crane wheels
Crane wheels according to DIN, factory standard or customer drawing (O 100-1250 mm, from batch size 1). Forged steel, cast steel, spheroidal graphite cast iron, customised, with/without flanges, roller/sliding bearings, with/without gear rim. Heat treatment and special colouring possible. Accessories such as: Pinions, axles, thrust discs, crane components, crane accessories are also available.

Wheel blocks
The ATLAS wheel block system for the low-maintenance direct drive and for shaft-mounted gearboxes from various manufacturers in sizes 160, 200, 250, 250-V, 315, 400 and 500 perform a wide range of transport tasks in handling systems and in the entire field of mechanical engineering as a ready-to-install travelling unit.

Wheel sets
KARL GEORG supplies wheel sets for low-maintenance direct drive and suitable for shaft-mounted gearboxes from various manufacturers. Wheel sets are manufactured according to DIN standard, KARL GEORG factory standard KG 125 and KG 130 or according to customer requirements in various wheel materials.

Buffers
Maximum safety and performance with hydraulic buffers from leading manufacturer Karl Georg. Customised damping characteristics and durable, corrosion-resistant design for cranes and a wide range of other applications.

Rope sheaves
Our high-quality rope pulleys are manufactured from cast steel or forged steel in various material qualities. Welded rope pulleys are not part of our delivery programme. Slip-free hardening of the rope groove is also possible at the customer's request. Sheaves can be supplied either without internal parts or complete with plain or roller bearings.

Maintenance Repair and Overhaul
KARL GEORG also offers professional maintenance and repair of worn or damaged crane wheels, wheel sets, and wheel blocks, performed directly at our plant and, upon request, including pickup and delivery service.