« Translinguisme/Programmation » : différence entre les versions

Object, String, Enum, Date, File, Class, Method, ...

|-

|-

| '''Python''' || basestring, bool, complex, dict, exception, file, float, fonction, frozenset, int, list, long, module, none, NotImplementedType, object, set, slice, str unicode, tuple, type, xrange<ref>{{WV|Python/Les types de base|Python/Les types de base}}</ref>

| [[Visual Basic]] || <font color=red>''rien''</font> || if ... then<br/>...<br/>elseif ... then<br/>...<br/>end if || <!--switch--> || while ... wend<br/>do while ... loop<br/>for ... next || call || <!--module_unite--> || <!--main--> || <tt>on error resume next<br/>...<br/>on error goto 0</tt>

|-

|}

 

| [[Visual Basic]] || ', rem || <font color=red>''rien''</font> || " || MsgBox || InputBox || ''variable :'' dim <br>''fonction :'' sub || =, ''fichier :'' .CopyFile<br/> ''fichier, feuille :'' .new || = || <> || and || or

|-

|}

 

| [[Visual Basic]] || _ || & || * || || len() || UCase() || LCase() || instr()<br/>''inverse :'' instrrev() || replace() || left(), mid(), right()

|-

|}

 

| [[Visual Basic]] || IsNumeric() || .save, .saveas || Erase<br/>''fichier :'' .DeleteFile || Sleep<ref>Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)</ref> || dir() || ''fonction : ''Exit, End<br/>''fichier :'' .close<br/> goto || now()

|-

|}

 

| [[Visual Basic]]<ref>{{WV|Visual Basic/Lecture-écriture_des_fichiers|Fichiers en VB}}</ref><ref>http://cisternino.free.fr/informatique/excel/vba/cours_vba_excel_fiche_07.pdf</ref> || .Workbooks.Open(ActiveWorkbook.Path & "\" & "NomDuFichier") || .Close || .Save || Sheets(1).Cells(x,y).Value = "Contenu"<br/>''ou'' Sheets("feuille 1").Range(x & y).Value = "Contenu" || Range(x & y).Font.Size = 10<br/>Range(x & y).HorizontalAlignment = xlCenter<br/>Range(x & y).Font.Color = vbBlack <br/>''ou'' Range(x & y).Font.Colorindex = 2 <br/>Range(x & y).Interior.ColorIndex = 4

|-

|}