<?xml version="1.0" encoding="windows-1250" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>CAD F&#243;rum : Oprava VBA kódu</title>
  <link>https://www.cadforum.cz/forum/</link>
  <description><![CDATA[Toto je XML obsahový kanál serveru; CAD F&#243;rum : Non-CAD software, IT : Oprava VBA kódu]]></description>
  <pubDate>Wed, 13 May 2026 13:04:30 +0000</pubDate>
  <lastBuildDate>Fri, 03 Sep 2010 22:58:55 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.04</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://www.cadforum.cz/forum/RSS_post_feed.asp?TID=11449</WebWizForums:feedURL>
  <image>
   <title><![CDATA[CAD F&#243;rum]]></title>
   <url>https://www.cadforum.cz/forum/forum_images/web_wiz_forums.png</url>
   <link>https://www.cadforum.cz/forum/</link>
  </image>
  <item>
   <title><![CDATA[Oprava VBA kódu : Dobr&#253; den,   pot&#345;eboval bych...]]></title>
   <link>https://www.cadforum.cz/forum/forum_posts.asp?TID=11449&amp;PID=55674&amp;title=oprava-vba-kodu#55674</link>
   <description>
    <![CDATA[<strong>Autor:</strong> <a href="https://www.cadforum.cz/forum/member_profile.asp?PF=270">PepaR</a><br /><strong>Předmět:</strong> 11449<br /><strong>Zasláno:</strong> 03.zář.2010 v 22:58<br /><br />Dobrý den, <DIV></DIV><DIV></DIV>potřeboval bych pomoci s opravou VBA kódu na 64bitové systémy. Nepomohl by prosím někdo? Jde konkrétně o tučné řádky. <DIV>&nbsp;</DIV><DIV><table width="99%"><tr><td class="BBquote"><img src="forum_images/quote_box.png" title="Původně odeslal(a) VBA kód" alt="Původně odeslal(a) VBA kód" style="vertical-align: text-bottom;" /> <strong>VBA kód napsal(a):</strong><br /><br /></DIV><DIV>Public PoleSouboru()<BR>Public Slozka As String<BR>Public ObrMeritko<BR>Public Type BROWSEINFO<BR>&nbsp;&nbsp;&nbsp; hOwner As Long<BR>&nbsp;&nbsp;&nbsp; pidlRoot As Long<BR>&nbsp;&nbsp;&nbsp; pszDisplayName As String<BR>&nbsp;&nbsp;&nbsp; lpszTitle As String<BR>&nbsp;&nbsp;&nbsp; ulFlags As Long<BR>&nbsp;&nbsp;&nbsp; lpfn As Long<BR>&nbsp;&nbsp;&nbsp; lParam As Long<BR>&nbsp;&nbsp;&nbsp; iImage As Long<BR>End Type<BR><strong>Private Declare Function SHGetPathFromIDList Lib "shell32.dll" Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As Long<BR>Private Declare Function SHBrowseForFolder Lib "shell32.dll" Alias "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) As Long<BR>Dim subFolder As Object, fl As Object</strong></DIV><DIV>&nbsp;</DIV><DIV>Private Function GetDirectory(Optional Msg) As String<BR>&nbsp;&nbsp;&nbsp; Dim bInfo As BROWSEINFO<BR>&nbsp;&nbsp;&nbsp; Dim path As String<BR>&nbsp;&nbsp;&nbsp; Dim R As Long, x As Long, pos As Integer<BR>&nbsp;&nbsp;&nbsp; bInfo.pidlRoot = 0&amp;<BR>&nbsp;&nbsp;&nbsp; If IsMissing(Msg) Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bInfo.lpszTitle = "Označte složku, jejíž obsah si přejete zobrazit:"<BR>&nbsp;&nbsp;&nbsp; Else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bInfo.lpszTitle = Msg<BR>&nbsp;&nbsp;&nbsp; End If<BR>&nbsp;&nbsp;&nbsp; bInfo.ulFlags = &amp;H1<BR>&nbsp;&nbsp;&nbsp; x = SHBrowseForFolder(bInfo)<BR>&nbsp;&nbsp;&nbsp; path = Space$(512)<BR>&nbsp;&nbsp;&nbsp; R = SHGetPathFromIDList(ByVal x, ByVal path)<BR>&nbsp;&nbsp;&nbsp; If R Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pos = InStr(path, Chr$(0))<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GetDirectory = Left(path, pos - 1)<BR>&nbsp;&nbsp;&nbsp; Else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GetDirectory = ""<BR>&nbsp;&nbsp;&nbsp; End If<BR>End Function</DIV><DIV>&nbsp;</DIV><DIV>Sub VypisSlozky(Optional Adresar As String)<BR>&nbsp;&nbsp;&nbsp; Dim fso As Object, fl As Object<BR>&nbsp;&nbsp;&nbsp; Application.ScreenUpdating = False<BR>&nbsp;&nbsp;&nbsp; Application.DisplayAlerts = False<BR>&nbsp;&nbsp;&nbsp; Set fso = CreateObject("Scripting.FileSystemObject")<BR>&nbsp;&nbsp;&nbsp; If Adresar = vbNullString Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Slozka = GetDirectory()<BR>&nbsp;&nbsp;&nbsp; End If<BR>&nbsp;&nbsp;&nbsp; If Slozka = "" Then Exit Sub<BR>&nbsp;&nbsp;&nbsp; If Right(Slozka, 1) &lt;&gt; "\" Then Slozka = Slozka &amp; "\"<BR>&nbsp;&nbsp;&nbsp; Set fl = fso.GetFolder(Slozka)<BR>&nbsp;&nbsp;&nbsp; On Error Resume Next<BR>&nbsp;&nbsp;&nbsp; With CommandBars("Officír").Controls(2)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Do<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .RemoveItem (.ListIndex)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Loop While .ListCount &gt; 0<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; For Each f In fl.Files<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NazevSouboru = Right(f.path, Len(f.path) - Len(Slozka))</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Koncovka = Right(NazevSouboru, 4)</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Select Case LCase(Koncovka)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case ".gif", ".bmp", ".png", ".wmf", ".emf", ".tif", ".tiff", ".jpg", ".jpeg", ".jpe", ".eps"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; R = R + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ReDim Preserve PoleSouboru(1 To R)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PoleSouboru(R) = NazevSouboru<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Select<BR>&nbsp;&nbsp;&nbsp; Next f<BR>&nbsp;&nbsp;&nbsp; QuickSort PoleSouboru, LBound(PoleSouboru), UBound(PoleSouboru)</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; For i = 1 To R<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CommandBars("Officír").Controls(2).AddItem PoleSouboru(i)<BR>&nbsp;&nbsp;&nbsp; Next i<BR>&nbsp;&nbsp;&nbsp; CommandBars("Officír").Controls(2).ListIndex = 1<BR>&nbsp;&nbsp;&nbsp; Titulek<BR>&nbsp;&nbsp;&nbsp; Application.DisplayAlerts = True<BR>&nbsp;&nbsp;&nbsp; Application.ScreenUpdating = True<BR>End Sub</DIV><DIV>&nbsp;</DIV><DIV>Sub VytvorPanelOfficir()<BR>&nbsp;&nbsp;&nbsp; Dim MujPanel As CommandBar<BR>&nbsp;&nbsp;&nbsp; Application.ScreenUpdating = False<BR>&nbsp;&nbsp;&nbsp; OdstranPanelOfficir<BR>&nbsp;&nbsp;&nbsp; Set MujPanel = CommandBars.Add<BR>&nbsp;&nbsp;&nbsp; With MujPanel<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Name = "Officír"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Visible = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Position = msoBarBottom<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Protection = msoBarNoCustomize<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Set Nova = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 23<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Vybrat složku s obrázky"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "VypisSlozky"<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; Set Nova0 = CommandBars("Officír").Controls.Add(Type:=msoControlDropdown)<BR>&nbsp;&nbsp;&nbsp; With Nova0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Caption = "Seznam obrázků"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Seznam obrázků ve složce " &amp; Slozka<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "VlozZeSeznamuObr"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Width = 150<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; Set Nova0 = CommandBars("Officír").Controls.Add(Type:=msoControlDropdown)<BR>&nbsp;&nbsp;&nbsp; With Nova0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Caption = "Měřítko obrázků"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Velikost vkládaných obrázků <img src="https://www.cadforum.cz/forum/smileys/smiley33.gif" border="0" align="middle" />"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "MeritkoObrazky"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Width = 50<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; For i = 5 To 100 Step 5<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .AddItem i &amp; "%"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Next i<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .ListIndex = 20<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MeritkoObrazky<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; With CommandBars("Picture")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(12).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(14).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(2).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(4).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(5).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(6).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(8).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(11).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; With CommandBars("Draw")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(5).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(1).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Controls(2).Copy Bar:=CommandBars("Officír")<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; Set Nova1 = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 664<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Objekt do levého horního rohu odstavce"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "ObjektDolevaNahoru"<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Set Nova2 = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova2<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 668<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Objekt na střed"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "ObjektNaStred"<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Set Nova3 = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova3<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 665<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Objekt do pravého horního rohu odstavce"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "ObjektDopravaNahoru"<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Set Nova4 = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova4<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 41<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Objekt doleva"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "ObjektDoleva"<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Set Nova5 = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova5<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 39<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Objekt doprava"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "ObjektDoprava"<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Set Nova7 = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova7<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 223<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Otitulkovat obrázek"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "OtitulkovatObrazek"<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Set Nova6 = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova6<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 37<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TooltipText = "Aktualizace panelu"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "AktualizacePanelOfficir"<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Set Nova = CommandBars("Officír").Controls.Add(Type:=msoControlButton)<BR>&nbsp;&nbsp;&nbsp; With Nova<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .FaceId = 358<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Caption = "Odstranit panel"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Style = msoButtonIcon<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Enabled = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .OnAction = "OdstranPanelOfficir"<BR>&nbsp;&nbsp;&nbsp; End With</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;&nbsp;&nbsp; Application.ScreenUpdating = True<BR>End Sub</DIV><DIV>&nbsp;</DIV><DIV>Sub OdstranPanelOfficir()<BR>&nbsp;&nbsp;&nbsp; On Error Resume Next<BR>&nbsp;&nbsp;&nbsp; CommandBars("Officír").Delete<BR>End Sub</DIV><DIV>&nbsp;</DIV><DIV>Sub AktualizacePanelOfficir()<BR>&nbsp;&nbsp;&nbsp; Application.ScreenUpdating = False<BR>&nbsp;&nbsp;&nbsp; If IsEmpty(Slozka) Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VypisSlozky<BR>&nbsp;&nbsp;&nbsp; Else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VypisSlozky (Slozka)<BR>&nbsp;&nbsp;&nbsp; End If<BR>&nbsp;&nbsp;&nbsp; Titulek<BR>&nbsp;&nbsp;&nbsp; Application.ScreenUpdating = True<BR>End Sub</DIV><DIV>&nbsp;</DIV><DIV>Sub SeskupitObjekty()<BR>&nbsp;&nbsp;&nbsp; On Error Resume Next<BR>&nbsp;&nbsp;&nbsp; Selection.ShapeRange.Group<BR>End Sub</DIV><DIV>&nbsp;</DIV><DIV>Sub RozdelitObjekty()<BR>&nbsp;&nbsp;&nbsp; On Error Resume Next<BR>&nbsp;&nbsp;&nbsp; Selection.ShapeRange.Ungroup<BR>End Sub</DIV><DIV>&nbsp;</DIV><DIV>Sub Titulek()<BR>&nbsp;&nbsp;&nbsp; CommandBars("Officír").Controls(2).TooltipText = "Seznam obrázků ve složce " &amp; Slozka<BR>End Sub<BR>Sub MeritkoObrazky()<BR>&nbsp;&nbsp;&nbsp; Procenta = CommandBars("Officír").Controls(3).List(CommandBars("Officír").Controls(3).ListIndex)<BR>&nbsp;&nbsp;&nbsp; ObrMeritko = Left(Procenta, Len(Procenta) - 1) / 100<BR>&nbsp;&nbsp;&nbsp; On Error Resume Next<BR>&nbsp;&nbsp;&nbsp; If Selection.Type = wdSelectionShape Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selection.ShapeRange.ScaleHeight ObrMeritko, True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selection.ShapeRange.ScaleWidth ObrMeritko, True<BR>&nbsp;&nbsp;&nbsp; End If<BR>End Sub</DIV><DIV>&nbsp;</DIV><DIV>Sub VlozZeSeznamuObr()<BR>&nbsp;&nbsp;&nbsp; Dim NovyObrazek As Shape<BR>&nbsp;&nbsp;&nbsp; Dim NovyTextBox As Shape<BR>&nbsp;&nbsp;&nbsp; Set NovyObrazek = ActiveDocument.Shapes.AddPicture(Slozka &amp; CommandBars("Officír").Controls(2).List(CommandBars("Officír").Controls(2).ListIndex), True, False, , , , , Selection.Range)<BR>&nbsp;&nbsp;&nbsp; With NovyObrazek<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .RelativeHorizontalPosition = wdRelativeHorizontalPositionPage<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .RelativeVerticalPosition = wdRelativeVerticalPositionPage<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .ScaleHeight ObrMeritko, True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .ScaleWidth ObrMeritko, True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .LockAnchor = False<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .AlternativeText = Slozka &amp; CommandBars("Officír").Controls(2).List(CommandBars("Officír").Controls(2).ListIndex)<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; Set NovyTextBox = ActiveDocument.Shapes.AddTextbox _<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Orientation:=msoTextOrientationHorizontal, _<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Left:=NovyObrazek.Left, Top:=NovyObrazek.Top + NovyObrazek.Height, Width:=NovyObrazek.Width, Height:=10)<BR>&nbsp;&nbsp;&nbsp; With NovyTextBox<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .ZOrder msoSendToBack<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .Line.Visible = msoFalse<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TextFrame.MarginTop = 6<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TextFrame.MarginBottom = 3<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TextFrame.MarginLeft = 0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TextFrame.MarginRight = 0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TextFrame.AutoSize = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TextFrame.WordWrap = True<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .TextFrame.TextRange.Text = "Obr."<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .LockAnchor = False<BR>&nbsp;&nbsp;&nbsp; End With<BR>&nbsp;&nbsp;&nbsp; ActiveDocument.Shapes.Range(Array(NovyObrazek.Name, NovyTextBox.Name)).Select<BR>End Sub<BR>Private Function QuickSort(vArray As Variant, inLow As Long, inHi As Long)<BR>&nbsp;&nbsp;&nbsp; Dim pivot As Variant<BR>&nbsp;&nbsp;&nbsp; Dim tmpSwap As Variant<BR>&nbsp;&nbsp;&nbsp; Dim tmpLow As Long<BR>&nbsp;&nbsp;&nbsp; Dim tmpHi As Long<BR>&nbsp;&nbsp;&nbsp; tmpLow = inLow<BR>&nbsp;&nbsp;&nbsp; tmpHi = inHi<BR>&nbsp;&nbsp;&nbsp; pivot = vArray((inLow + inHi) \ 2)<BR>&nbsp;&nbsp;&nbsp; While (tmpLow &lt;= tmpHi)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; While (vArray(tmpLow) &lt; pivot And tmpLow &lt; inHi)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tmpLow = tmpLow + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wend<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; While (pivot &lt; vArray(tmpHi) And tmpHi &gt; inLow)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tmpHi = tmpHi - 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wend<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If (tmpLow &lt;= tmpHi) Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tmpSwap = vArray(tmpLow)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vArray(tmpLow) = vArray(tmpHi)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vArray(tmpHi) = tmpSwap<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tmpLow = tmpLow + 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tmpHi = tmpHi - 1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If<BR>&nbsp;&nbsp;&nbsp; Wend<BR>&nbsp;&nbsp;&nbsp; If (inLow &lt; tmpHi) Then QuickSort vArray, inLow, tmpHi<BR>&nbsp;&nbsp;&nbsp; If (tmpLow &lt; inHi) Then QuickSort vArray, tmpLow, inHi<BR>End Function</DIV><DIV></td></tr></table></DIV><DIV>&nbsp;</DIV><DIV>Předem děkuju za případnou pomoc<BR>&nbsp;</DIV><span style="font-size:10px"><br /><br />Upravil PepaR - 05.zář.2010 v 07:56</span>]]>
   </description>
   <pubDate>Fri, 03 Sep 2010 22:58:55 +0000</pubDate>
   <guid isPermaLink="true">https://www.cadforum.cz/forum/forum_posts.asp?TID=11449&amp;PID=55674&amp;title=oprava-vba-kodu#55674</guid>
  </item> 
 </channel>
</rss>