{"id":6121,"date":"2014-01-27T08:29:02","date_gmt":"2014-01-27T08:29:02","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=6121"},"modified":"2014-01-27T08:29:02","modified_gmt":"2014-01-27T08:29:02","slug":"vba-forms-macro-in-windows-taskbar","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/","title":{"rendered":"VBA Forms Macro in Windows Taskbar"},"content":{"rendered":"

In our previous blogs on Accpac Macro, we discussed about features like\u00a0providing icons to macro<\/a>, Minimize\/Maximize buttons<\/a>, executing macro without logging in sage 300<\/a>.<\/p>\n

In this article, we will discuss about how we can enable macro to be displayed in the taskbar.<\/p>\n

The New Stuff :<\/span><\/strong><\/em> Default settings for Receipts in Account Receivable in Sage 300 ERP<\/a><\/p>\n

When we run macro from Sage300 desktop, it does not have a handle in windows task bar as other applications appear, due to this; often the user launches the same macro many times.<\/p>\n

\"Fig1\"<\/a><\/p>\n

By adding the below code snippet, you can show the macro in windows taskbar.<\/p>\n

Step 1:<\/strong> Variable declaration in the main module file.<\/p>\n

<SNIP>
\nPublic Declare Function FindWindow Lib “user32” Alias “FindWindowA” _
\n(ByVal lpClassname As String, ByVal lpWindowName As String) As Long
\nPublic Declare Function GetWindowLong Lib “user32” _
\nAlias “GetWindowLongA” _
\n(ByVal hwnd As Long, _
\nByVal nIndex As Long) As Long
\nPublic Declare Function SetWindowPos Lib “user32” _
\n(ByVal hwnd As Long, _
\nByVal hWndInsertAfter As Long, _
\nByVal x As Long, _
\nByVal y As Long, _
\nByVal cx As Long, _
\nByVal cy As Long, _
\nByVal wFlags As Long) As Long
\nPublic Declare Function SetWindowLong Lib “user32” _
\nAlias “SetWindowLongA” _
\n(ByVal hwnd As Long, _
\nByVal nIndex As Long, _
\nByVal dwNewLong As Long) As Long
\nPublic Const SWP_NOMOVE = &H2
\nPublic Const SWP_NOSIZE = &H1
\nPublic Const GWL_EXSTYLE = (-20)
\nPublic Const SWP_NOACTIVATE = &H10
\nPublic Const SWP_HIDEWINDOW = &H80
\nPublic Const SWP_SHOWWINDOW = &H40
\nPublic Const WS_EX_APPWINDOW = &H40000
\nPublic Const HWND_TOP = 0
\n<\/SNIP><\/span><\/span>
\nStep 2:<\/strong> Define method \u201cAppTasklist\u201d in the user form.
\n<SNIP>
\nPrivate Sub AppTasklist(myForm)
\n‘Add this userform into the Task bar
\nDim WStyle As Long
\nDim Result As Long
\nDim hwnd As Long
\nhwnd = FindWindow(vbNullString, myForm.Caption)
\nWStyle = GetWindowLong(hwnd, GWL_EXSTYLE)
\nWStyle = WStyle Or WS_EX_APPWINDOW
\nResult = SetWindowPos(hwnd, HWND_TOP, 0, 0, 0, 0, _
\nSWP_NOMOVE Or _
\nSWP_NOSIZE Or _
\nSWP_NOACTIVATE Or _
\nSWP_HIDEWINDOW)
\nResult = SetWindowLong(hwnd, GWL_EXSTYLE, WStyle)
\nResult = SetWindowPos(hwnd, HWND_TOP, 0, 0, 0, 0, _
\nSWP_NOMOVE Or _
\nSWP_NOSIZE Or _
\nSWP_NOACTIVATE Or _
\nSWP_SHOWWINDOW)
\nEnd Sub
\n<\/SNIP><\/span><\/span>
\nStep 3:<\/strong> On form activation; call the method to add the macro to task bar:
\n<SNIP>
\nPrivate Sub UserForm_Activate()
\nAppTasklist Me
\nEnd Sub
\n<\/SNIP>
\nAfter execution you can notice the macro has been added to the taskbar.<\/p>\n

\"Fig2<\/a><\/p>\n

Using above instructions VBA forms (macro) can be added at task bar.<\/p>\n

Also Read :<\/strong>
\n1. VBA Macro Errors related to EXD Files<\/a>
\n2. Macros in Sage 300 ERP<\/a>
\n3. How To Add A Macro To Accpac Desktop of Sage 300 ERP<\/a>
\n4. Run VBA Macro without Logging to Sage 300 ERP<\/a>
\n5. Define Budget Using Macro<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous blogs on Accpac Macro, we discussed about features like\u00a0providing icons to macro, Minimize\/Maximize buttons, executing macro without logging in sage 300. In this article, we will discuss about how we can enable macro to be displayed in the taskbar. The New Stuff : Default settings for Receipts in Account Receivable in Sage\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[79,110,1510,2311,2324,2801,2979],"class_list":["post-6121","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac","tag-adding-macro-on-windows-taskbar","tag-macro","tag-sage","tag-sage-300","tag-taskbar","tag-vba-macro"],"yoast_head":"\nVBA Forms Macro in Windows Taskbar - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA Forms Macro in Windows Taskbar - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our previous blogs on Accpac Macro, we discussed about features like\u00a0providing icons to macro, Minimize\/Maximize buttons, executing macro without logging in sage 300. In this article, we will discuss about how we can enable macro to be displayed in the taskbar. The New Stuff : Default settings for Receipts in Account Receivable in Sage\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-27T08:29:02+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/01\/Fig1.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/\",\"name\":\"VBA Forms Macro in Windows Taskbar - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/01\/Fig1.jpg\",\"datePublished\":\"2014-01-27T08:29:02+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/01\/Fig1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/01\/Fig1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA Forms Macro in Windows Taskbar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA Forms Macro in Windows Taskbar - Sage 300 ERP \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/","og_locale":"en_US","og_type":"article","og_title":"VBA Forms Macro in Windows Taskbar - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In our previous blogs on Accpac Macro, we discussed about features like\u00a0providing icons to macro, Minimize\/Maximize buttons, executing macro without logging in sage 300. In this article, we will discuss about how we can enable macro to be displayed in the taskbar. The New Stuff : Default settings for Receipts in Account Receivable in Sage\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-01-27T08:29:02+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/01\/Fig1.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/","name":"VBA Forms Macro in Windows Taskbar - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/01\/Fig1.jpg","datePublished":"2014-01-27T08:29:02+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/01\/Fig1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/01\/Fig1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/01\/27\/vba-forms-macro-in-windows-taskbar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"VBA Forms Macro in Windows Taskbar"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/6121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=6121"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/6121\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=6121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=6121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=6121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}