utorak, 6. listopada 2026.

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)

srijeda, 2. rujna 2026.

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

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...

srijeda, 26. kolovoza 2026.

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