Profile

Cover photo
Edoardo Aroni
4 followers|92,859 views
AboutPosts

Stream

Edoardo Aroni

Shared publicly  - 
 
Sub CopyWorksheetToAnotherWorkbook()          Dim srcBook As Workbook Dim FileName as String Set FileName = "C:\Test.xlsx"                 Set srcBook = Application.Workbooks.Open(FileName, _                 UpdateLinks:=Fals...
1

Edoardo Aroni

Shared publicly  - 
 
The XLStart folder is a special folder created when you install Excel. That's where Excel stores the workbook template, Book.xltx. In addition, if you store a workbook in this folder, Excel will open it automatically every ti...
1

Edoardo Aroni

Shared publicly  - 
 
Step by step guide This guide shows how to  enable the directory browsing feature in IIS Express 1. Open cmd 2. Go the IIS Express folder. Type: cd C:\Program Files\IIS Express 3. Type the following command:   ...
1

Edoardo Aroni

Shared publicly  - 
 
Very instructive slides from Visualization Course of Cecilia Aragon @ University of Washington
1

Edoardo Aroni

Shared publicly  - 
 
Right click the Dateset/Tablix and select 'Dataset/Tablix Properties'. Select the Filters tab and click Add Click 'fx' (expession button) and enter the below (example with filter with three options) =IIF(Parameters!filterb...
1

Edoardo Aroni

Shared publicly  - 
 
T-SQL -How implement optional parameters in stored procedure
Add = null to the parameter declaration          @myParameter = null Add IS NULL to the WHERE clause in the stored procedure          WHERE Test = @myParameter         change to           WHERE (Test = @myParameter OR @myParameter IS NULL)
Add = null to the parameter declaration          @myParameter = null Add IS NULL to the WHERE clause in the stored procedure          WHERE Test = @myParameter         change to          WHERE (Test = @myParameter ...
1

Communities

Edoardo Aroni

Shared publicly  - 
 
Option Explicit Dim SelectFile As String ' module level variable Dim FileName As String Private Sub PickFile() '********************************************************************************* '   Prompt the user to select t...
1

Edoardo Aroni

Shared publicly  - 
 
“Getting B.S. in CS” without Getting B.S. in CS = Getting a Computer Science Degree without going to the University.
Maybe not but Today there are pretty good standard courses online for free. Check it out :-)
PROG 001C, ↘︎, Harvard CS50(x), Intensive Introduction to Computer Science, ↘︎, http://www.extension.harvard.edu/open-learning-initiative/intensive-introduction-computer-science https://www.edx.org/course/introduction-computer-science-harvardx-cs50x#.VST3yxPF_7c ...
1

Edoardo Aroni

Shared publicly  - 
 
https://play.spotify.com/artist/1ecFXl47gHlnxGXjTKfGwP

Lory De Palma
Awesome voice! I love it
Music for every moment. Spotify is a digital music service that gives you access to millions of songs.
1

Edoardo Aroni

Shared publicly  - 
 
Let's say that you have a table called BRANCHES.STATES that holds all States where your companies has branches and you need a parameter to select  groups of  those states according the their geographical area @branchArea.  ...
1

Edoardo Aroni

Shared publicly  - 
 
T-SQL - How implement LIKE operator on stored procedure parameter
You can concatenate the wildcards onto your string and then use the string: There are two alternative solutions: add another varchar variable and concatenate the wildcards on that varchar variable and then use that variable as parameter. @ myString = '%' + ...
You can concatenate the wildcards onto your string and then use the string: There are two alternative solutions: add another varchar variable and concatenate the wildcards on that varchar variable and then use that variab...
1
Communities
Basic Information
Gender
Male
Collections Edoardo is following
Links