Autor: Valy Greavu

PhD, MCP, MOS https://mvp.support.microsoft.com/profile/Valy.Greavu

Excel: How to add a formula to a comment

Nu de multe ori avem nevoie de a folosi formule in comentariile Excel.

Dar, daca avem cu adevarat nevoie de a afisa un comentariu bazandu-ne pe o formula, atunci singura metoda este sa utilizam un macro.

Exemplu de problema:

Add formula and pictures to comments

Avem o listă de echipamente și o dată de achiziție. Dorim ca în celula cu data să ni se afișeze mesaj cu numărul de zile trecut de la achiziție.

Pentru acest lucru trebuie să stabilim întâi un comentariu vid pentru E3 și E4 apoi creăm următorul macro:

Sub DateCmnt()
'
' DateCmnt Macro
' Show a comment to a cell using a calculated value.
'
' Keyboard Shortcut: Ctrl+q
'
    Dim Res1 As Double
    Res1 = (Range("A7").Value - Range("E3").Value)
    Range("E3").Comment.Text Text:="Au trecut: " & Res1 & " zile de la achizitie"
    
    Res1 = (Range("A7").Value - Range("E4").Value)
    Range("E4").Comment.Text Text:="Au trecut: " & Res1 & " zile de la achizitie"

Range("E4").Comment.Shape.Fill.UserPicture ("P:\Avatar2.jpg")
    Range("E3").Select
  
End Sub

Res1 este variabila în care se stochează diferența de zile dintre data achizției și data curentă stocată în A7.

În momentul apăsării combinației de comenzi Ctrl+q se actualizează comentariul cu valoarea formulei.

Dacă doriți să adăugați o imagine pe un comentariu… sau un grafic, sau un shape acest lucru se poate realiza cu instrucțiunea din VBA:

 Range("E4").Comment.Shape.Fill.UserPicture ("P:\Avatar2.jpg")

Sper să vă fie util.

 

Acest articol este republicat și adaptat pe un exemplu economic.

Installing SharePoint Fundation 2010 on a Domain Controller

First at all, you must know that this is a hazardous method. It is stronglly recomended to do not install SharePoint into a Domain Controller because of performance, security and others.

If you really want to do that, you can use this method but, only on a test environment and for your own risk.

Please read these posts before installing:

My deployment:

First step is to install SPF 2010 using a config file. You cannot install standalone version of SPF 2010 but you can install Farm version.

Download SPF 2010 and extract instalation kit into a distinct folder.

D:\SharePointFiles\SharePoint.exe /extract:D:\SPF2010

Identify and edit config.xml file, using notepad or other XML Editor. You can find the file in %extractedpath%\Files\SetupFarmSilent\

(Run CMD in Admin Mode)

After that run setup.exe using /config parameter and full path to config.xml file as paramater.

D:\SPF2010\setup.exe /config D:\SPF2010\Files\SetupFarmSilent\config.xml

image

Second step:

After install, DO NOT RUN configuration Wizard. It is better to create first the database using psconfig tool.

Navigate to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN

psconfig -cmd configdb -create -server srv-01\SharePoint -database SPF_Config_DB -user SharePoint\Admin.sql -password Abc*123 -passphrase C0mpl3x-P@ss0rd  -admincontentdatabase SPF_Admin_Content_Db

After that, run SharePoint 2010 Products Configuration Wizard.

I was trying to install SPF2010 integrated with Active Directory, by using –addomain  and –adorgunit parameters but I wasn’t able to create a new content for a SharePoint site.

Run Central Admin, but DO NOT USE Configuration Wizards because it is possible to alter Default site from IIS.

Remember: Use this methond only for test servers.

Internship Microsoft Danemarca

DoYouSpeakCode

Microsoft Development Center Copenhagen (MDCC) is Microsoft’s biggest development center in Europe and is located just north of Copenhagen in Denmark. Around 650 employees are working at MDCC, including a significant number of highly specialized software developers recruited from all over the world. In 2008 and 1009, MDCC was rated the "Best Place to Work in Europe” by the Great Place to Work Institute (more info). The staff counts more than 40 different nationalities making MDCC one of the most international companies in Denmark.
What we offer
We offer internships at Microsoft in Copenhagen of 9 to 12 months. At the end, you might get the opportunity of a full-time job with us, or you might choose to get back to school (if you interrupted your studies), or continue your career as you like. In any case, Microsoft on your CV can be a good advantage.
Requirements
Software development expertise, particularly within C#, C++ or similar object oriented programming languages, Strong technical and analytical skills, Excellent problem solving and design skills. Ability to work independently – and in teams. An excellent command of written and spoken English.
We are looking for engineers with a strong background in object oriented development. Experience business applications or ERP solutions is a plus. Working toward an academic degree within computer science, engineering, mathematics, physics. 
Good academic results are a plus (make sure to mention them in your CV), but they are not mandatory.
Responsibilities
Write and review technical requirements and design documents. Plan, design, and write code for automated tests of features within the Core ERP, presentation tier or Dynamics platform. Create and use test tools and processes to both increase effectiveness in the daily work and assure quality of the product.
Collaborate with other engineers to ensure all feature areas achieve the desired high level of innovation and quality our customers demand.
Working Conditions
You will gain valuable experience working on a world-class product development team and learn what it’s like to work at Microsoft. Each trainee will work on real projects that contribute to the success of Dynamics Products which is used by over 1 million customers. You will work on the Microsoft Development Center Copenhagen (MDCC) campus. The work environment is truly international with over 40 different nationalities working under the same roof. Each trainee will be provided desk and PC and a mentor to help guide them through their work experience. The campus is situated on a wooded, park-like site, complete with sports fields and walking trails just north of Copenhagen and easily accessible by train or bus. Free beverages and fruits are available for you the whole day. Breakfast, warm lunch, are part of the package offered to all employees. You will have access to the latest technologies and the best hardware equipment. Sports events and other entertainment is regularly organized at discounted prices.
How to apply
If you are a student in the last 2 years, a fresh graduate or a master’s at AC, send your CV to bogdana.botez@microsoft.com. The sooner you apply the more chances you get to be processed in time to get an interview invitation. We will travel to Bucharest on 23rd and 24th of April. If you are selected, you will have the chance to meet us at a "per invitation" interview in Bucharest, with the travel expenses covered by Microsoft.

For more information on Microsoft Development Center Copenhagen, you are welcome to check our website, http://www.mdcc.dk.

Blog la WordPress.com.

SUS ↑