الخميس، 30 يوليو، 2015

How to Extract URL from Hyperlink in Excel

Microsoft Excel has a built in function called HYPERLINK() which allows you to convert a link location (URL) and friendly name (anchor text) into a hyperlinked cell that you can click on to open the link in a web browser window. However, Excel does not have a default function that allows you to do the reverse of that—to extract the URL from a hyperlinked cell. In order to do this, we need to get our hands dirty with some VBA (Visual Basic for Applications) code. Don’t worry, it isn’t too complicated.
  1. Hold down Alt + F11 Key to Open the Microsoft Visual Basic for Applications window
  2. Go to Insert -> Module
  3. Paste the following into the Module Window:
    Function GetURL(pWorkRng As Range) As String
    GetURL = pWorkRng.Hyperlinks(1).Address
    End Function
  4. Now use the function GetURL(A1) to extract the URL from the hyperlinked cell.

Good Luck ;)

 

الثلاثاء، 28 يوليو، 2015

الاثنين، 27 يوليو، 2015

الدرس (3) - دورة بناء الانظمة البرمجية وتطبيقات قواعد البيانات باستخدام Visual Studio

بسم الله الرحمن الرحيم


دورة بناء الانظمة البرمجية وتطبيقات قواعد البيانات باستخدام

2012 Visual Studio


رابط الدرس:

الجزء الاول:


الجزء الثاني:


Syllabus:

Introduction to Programming
Visual Studio 2012 Intro. To programming
Four Stages in a program
Read Input
Validate Input
Process Input
Output Result
When Developing a program in the real world, there are 6 steps
1) Analyze the problem
2) Plan a solution
3) Design an interface
4) Write the code
5) Test and debug
6) Document the program
Developing a User-Interface 
Developing a Visual Basic & C# Program
Programming Layer Model
New Project
Parts of the IDE:
Menu Bar – Has menus such as:  File, Edit, View, Window, Project, Data, and Debug.
Toolbar – Holds buttons that perform common controls.
Document Window – Currently holding the Form Window.
Form Window – What your VB program will look like when you open it.
Properties Window – Used to change how objects look and react.
Solution Explorer – Shows files associated with the program.
Toolbox – Contains controls to put on your form.
The Windows Form

الدرس (2) - دورة بناء الانظمة البرمجية وتطبيقات قواعد البيانات باستخدام Visual Studio

بسم الله الرحمن الرحيم


دورة بناء الانظمة البرمجية وتطبيقات قواعد البيانات باستخدام

2012 Visual Studio


رابط الدرس:



Syllabus:

Introduction to .NET Framework
What Is .NET
Framework, Languages, And Tools
ASP.NET
Web Forms
Web Services
Common Language Runtime
Languages provided by MS
VB, C++, C#, J#, JScript
Third-parties are building
APL, COBOL, Pascal, Eiffel, Haskell, ML, Oberon, Perl, Python, Scheme, Smalltalk…
ASP.NET Web Forms
ASP.NET Web Services
Visual Studio.NET