Карта сайта ExcelVBA.ru

Примеры программ для Excel

Категория: Простые макросы

Категория: Программы средней сложности

Функции VBA Excel

Категория: Работа с диапазонами ячеек и листами

  1. NamesList
  2. JoinedArray
  3. TranslitAddin
  4. FindAndInsert
  5. ExportHTML
  6. EmailList
  7. NewWorksheet
  8. ParseFormula
  9. HiddenNames
  10. Convert_HTML_Range_To_Text
  11. SpecialCells
  12. SearchCells
  13. ExportPictures
  14. UniqueValues
  15. ShapesCoordinates
  16. KeyboardLayout
  17. HighlightText
  18. GoogleSearch
  19. PasteOLEobject
  20. FilenamesList
  21. FindAll
  22. CreateTextFiles2
  23. FileQueryRange
  24. AutoFitMergedCells
  25. CSV2Excel
  26. Array2worksheet
  27. RepeatRange
  28. DoubleSum
  29. CombineFiles
  30. WebQueryRange
  31. checkboxes
  32. FillBlankCellsWithRandomNumbers
  33. FormulaHyperlinks
  34. ColumnWidth
  35. Bitmap2Sheet
  36. GetCell
  37. Range2TXT
  38. SaveActiveSheet
  39. FormatHeader
  40. UnlockSheetProtection
  41. PasteSpecial
  42. ConditionalRowsDeleting
  43. GetValue
  44. LoadArrayFromWorkbook
  45. ShapesInRange
  46. Range2CSV
  47. DropDownList
  48. TwipsAndPixels
  49. RedNumbers
  50. CreateWordDocuments
  51. GetVisibleRowsArray
  52. CreateTextFiles_UTF8
  53. PastePictures

Категория: Текстовые строки

  1. LikeAnItemOfArray
  2. DativeCase
  3. ArrayOfValues
  4. JustUnique
  5. ParseColumnsStringEx
  6. ShowText
  7. Range2CSV
  8. CreateTextFiles_UTF8
  9. CharCodes
  10. Range2TXT
  11. SearchArray
  12. CropFIO
  13. ExportHTML
  14. SplitLanguages
  15. Text2Array
  16. EmailList
  17. GoogleTranslate
  18. HighlightText
  19. Encode
  20. FirstProperCaseWord
  21. OCR
  22. SplitTextFile
  23. GenitiveCase
  24. CheckEmail

Категория: Обработка файлов

  1. txt
  2. SaveAddin
  3. CreateWordDocuments
  4. SubFoldersCollection
  5. FileQueryRange
  6. FilenamesList
  7. MCI
  8. FilenamesCollection
  9. OCR
  10. FilesCount
  11. PasteOLEobject
  12. GetFolder
  13. GetValue
  14. CreateBackup
  15. GetAnotherWorkbook
  16. UNZIP
  17. LoadArrayFromWorkbook
  18. SortedFileList
  19. CombineFiles
  20. TextFile2Array
  21. LastFile
  22. GetFileOrFolderPath
  23. ChangeWorkbookFormat
  24. INI
  25. MkDir
  26. Password
  27. CSV2Excel
  28. SplitTextFile
  29. DATfolder2Array
  30. FileToVBAFunction
  31. SaveActiveSheet
  32. Replace_symbols

Категория: Работа со звуком и изображениями

  1. InsertImage
  2. Bitmap2Sheet
  3. PictureInCellComment
  4. beeps
  5. ResizePicture
  6. ShapesInRange
  7. PastePictures
  8. DownloadPictures2
  9. ResizeImages
  10. DownloadPictures
  11. ShapesCoordinates
  12. ZoomImages
  13. MCI
  14. ExportPictures

Категория: Обработка массивов

  1. SaveArray
  2. SortedFileList
  3. CSV2Excel
  4. ArrayOfValues
  5. Array2worksheet
  6. LoadArrayFromWorkbook
  7. GreatestCommonDivisor
  8. ArrAutofilter
  9. Transpose
  10. RandomRowsFromArray
  11. DATfolder2Array
  12. CombineArrays
  13. UniqueValuesFromArray
  14. DeleteBlankRows
  15. ExtendArray
  16. GetVisibleRowsArray
  17. Text2Array
  18. SearchArray
  19. LikeAnItemOfArray
  20. JoinedArray
  21. Array2XML
  22. SplitArray
  23. ArraySwapColumns
  24. TextFile2Array
  25. Range2CSV
  26. SortArray

Категория: Разное

  1. EmailSettings
  2. ProgressIndicator
  3. UsefulCode
  4. JSON_decode
  5. CloseAllWorkbooks
  6. ReplaceUnicode
  7. ConnectToServer
  8. URLEncode
  9. Transparency
  10. References
  11. TheBAT
  12. frmAbout
  13. MobilePhonesInfo
  14. SortSheets
  15. .Net
  16. Buttons
  17. FileToVBAFunction
  18. CropFIO
  19. PhoneCall
  20. HideCommandBarsAndRibbon
  21. Authentication
  22. atsenergo_login
  23. ClassModulesForUserform
  24. PickNewColor
  25. UNC
  26. replace_hyperlinks
  27. YoutubeVideo
  28. CommandBar
  29. FoldersList
  30. FaceID
  31. html
  32. VBE
  33. GetRealTime
  34. PopupMenu
  35. HexEdit
  36. BuiltinDocumentProperties
  37. Security
  38. SubFoldersCollection
  39. UserFullName
  40. CDO
  41. timer
  42. translit
  43. EnteringNumericValueIntoTextbox
  44. CreateWordDocuments
  45. Attachments
  46. DatePicker
  47. FTP
  48. CurrencyRate
  49. RestoreHyperlinksStyle
  50. LOG_class
  51. URL_SetParameter
  52. CheckEmail
  53. ColumnWidth
  54. KeyboardLayout
  55. Sippoint
  56. clipboard
  57. LicenceKeys
  58. IPaddresses
  59. YandexMarketAuthentication
  60. CustomDocumentProperties
  61. environ
  62. HiddenNames
  63. GreatestCommonDivisor
  64. AutoRun
  65. CommandBars
  66. UniqueValues
  67. RoundArray
  68. ShowAddinsList
  69. OutlookSendMail
  70. HTMLSelectElement
  71. GetURLstatus
  72. TwipsAndPixels
  73. registry
  74. KeyPressed
  75. punycode
  76. print_all_code_of_VBA_project
  77. md5
  78. GetYandexRegionCode
  79. CreateBackup