{"id":3089,"date":"2013-05-15T11:41:23","date_gmt":"2013-05-15T11:41:23","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=3089"},"modified":"2025-07-18T08:45:18","modified_gmt":"2025-07-18T08:45:18","slug":"run-vba-macro-without-logging-to-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/","title":{"rendered":"Run VBA Macro without Logging to Sage 300 ERP"},"content":{"rendered":"

In our previous blog, we discussed \u201cVBA Macro Errors related to EXD File<\/a>\u201d. Now let\u2019s see how to run VBA macro file without logging to Sage 300 ERP (formerly Sage Accpac ERP) or directly from scheduler in unattended mode.
\nSay, the user wants to schedule a macro in unattended mode from windows scheduler, without continuously keeping Sage 300 session logged in, as it is essential for a macro to execute.<\/span>
\nUsers would be able to achieve it by using the below code snippet. Wherein, we have automated the process to create a Sage 300 session and provided it to the macro to execute successfully. \u00a0<\/span>
\nFollow below-mentioned steps to execute;<\/span><\/p>\n

1.<\/strong> Copy below code and paste in Notepad[++].
\n2.<\/strong> Change macro file name, user, password, and company in VBS file before running.
\n3.<\/strong> Then save the file as RunMacro.VBS.
\n4.<\/strong> Execute VBS script or schedule the\u00a0.VBS file in windows scheduler.<\/p>\n

Note: <\/strong>If there are multiple Sage 300 session open on the same machine, then the macro will pop-up Sage 300 login screen.
\nAlso Read:<\/strong><\/span>\u00a0\u201cHTTP Error 500.0 Internal Server Error\u201d while Configuring IIS for Sage 300 Portal<\/a><\/em>
\n<Code Snip><\/strong>
\nDim Signon<\/em><\/span>
\nDim SignonID<\/em><\/span>
\nDim strCommand<\/em><\/span>
\nDim AllProcess <\/em><\/span>
\nDim Process <\/em><\/span>
\nDim strFoundProcess<\/em><\/span>
\nstrFoundProcess = False <\/em><\/span>
\nSet AllProcess = getobject(“winmgmts:”) ‘create object <\/em><\/span>
\nFor Each Process In AllProcess.InstancesOf(“Win32_process”) ‘Get all the processes running ‘in your PC <\/em><\/span>
\n If (Instr (Ucase(Process.Name),”ACCPAC.EXE”) = 1) Then ‘Made all uppercase to ‘remove ambiguity. Replace TASKMGR.EXE with your application name in CAPS. <\/em><\/span>
\n ‘msgbox “Application is already running!” ‘You can replace this with ‘Reporter.ReportEvent <\/em><\/span>
\n ‘Change the macro name and path<\/em><\/span>
\n strCommand = “A4WVBA.EXE -r -f “”E:\\Program Files\\Sage\\Sage Accpac\\OE60A\\XXX.avb”””<\/em><\/span>
\nSet wshShell = WScript.CreateObject (“WSCript.shell”)<\/em><\/span>
\n wshshell.run strCommand, 6, True<\/em><\/span>
\n set wshshell = nothing<\/em><\/span>
\n‘Signon.SignoffSession SignonID<\/em><\/span>
\n‘Set Signon = Nothing<\/em><\/span>
\n strFoundProcess = True <\/em><\/span>
\n Exit for <\/em><\/span>
\n End If <\/em><\/span>
\nNext <\/em><\/span>
\nIf strFoundProcess = False Then <\/em><\/span>
\n ‘msgbox “Go ahead!Application is not running” ‘You can replace this with ‘Reporter.ReportEvent <\/em><\/span>
\n Set Signon = CreateObject(“A4wSignonMgr.AccpacSignonMgr”)<\/em><\/span>
\n ‘Change the Signon paramters to match the company login<\/em><\/span>
\n ‘SignonID = Signon.RegisterSignon(“USERID”, “PASSWORD”, “COMPANYID”, “Company Name”, Date)<\/em><\/span>
\n ‘USERID = Accpac user in upper case<\/em><\/span>
\n ‘PASSWORD = Accpac user password in upper case<\/em><\/span>
\n ‘COMPANYID = Accpac company ID in upper case<\/em><\/span>
\n SignonID = Signon.RegisterSignon(“ADMIN”, “ADMIN”, “SAMINC”, “Sample Company”, Date)<\/em><\/span>
\n‘Change the macro name and path<\/em><\/span>
\n strCommand = “A4WVBA.EXE -r -f “”E:\\Program Files\\Sage\\Sage Accpac\\OE60A\\XXX.avb”””<\/em><\/span>
\nSet wshShell = WScript.CreateObject (“WSCript.shell”)<\/em><\/span>
\n wshshell.run strCommand, 6, True<\/em><\/span>
\n set wshshell = nothing<\/em><\/span>
\nSignon.SignoffSession SignonID<\/em><\/span>
\nSet Signon = Nothing<\/em><\/span>
\nEnd If<\/em><\/span>
\nSet AllProcess = nothing<\/em><\/span>
\n<\/Code Snip><\/strong>
\nUser just needs to add RunMacro.VBS file in scheduler in order to run macro without logging to Sage 300 ERP.
\nAbout Us<\/strong>
\nGreytrix is a one-stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
\nGreytrix<\/a>\u00a0has some unique solutions of\u00a0Sage 300 integration with Sage CRM,<\/a>\u00a0Salesforce.com\u00a0<\/a>and\u00a0Magento eCommerce<\/a> along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 300 customization and development services<\/a>\u00a0to Sage business partners, end users, and Sage PSG worldwide.
\nFor more details on Sage 300 Services, please contact us at\u00a0accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous blog, we discussed \u201cVBA Macro Errors related to EXD File\u201d. Now let\u2019s see how to run VBA macro file without logging to Sage 300 ERP (formerly Sage Accpac ERP) or directly from scheduler in unattended mode. Say, the user wants to schedule a macro in unattended mode from windows scheduler, without continuously\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":[87,1510,2302,2303,2357,2451,2490,2591,2652,2979],"class_list":["post-3089","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac-macro","tag-macro","tag-run-macro","tag-run-macro-in-unattended-mode","tag-sage-300-erp","tag-sage-accpac-erp","tag-sage-erp-macro","tag-schedule-macro","tag-session-manager","tag-vba-macro"],"yoast_head":"\nRun VBA Macro without Logging to Sage 300 ERP<\/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\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Run VBA Macro without Logging to Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"In our previous blog, we discussed \u201cVBA Macro Errors related to EXD File\u201d. Now let\u2019s see how to run VBA macro file without logging to Sage 300 ERP (formerly Sage Accpac ERP) or directly from scheduler in unattended mode. Say, the user wants to schedule a macro in unattended mode from windows scheduler, without continuously\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-05-15T11:41:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-18T08:45:18+00:00\" \/>\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=\"3 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\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/\",\"name\":\"Run VBA Macro without Logging to Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"datePublished\":\"2013-05-15T11:41:23+00:00\",\"dateModified\":\"2025-07-18T08:45:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Run VBA Macro without Logging to Sage 300 ERP\"}]},{\"@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":"Run VBA Macro without Logging to Sage 300 ERP","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\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Run VBA Macro without Logging to Sage 300 ERP","og_description":"In our previous blog, we discussed \u201cVBA Macro Errors related to EXD File\u201d. Now let\u2019s see how to run VBA macro file without logging to Sage 300 ERP (formerly Sage Accpac ERP) or directly from scheduler in unattended mode. Say, the user wants to schedule a macro in unattended mode from windows scheduler, without continuously\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-05-15T11:41:23+00:00","article_modified_time":"2025-07-18T08:45:18+00:00","author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/","name":"Run VBA Macro without Logging to Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"datePublished":"2013-05-15T11:41:23+00:00","dateModified":"2025-07-18T08:45:18+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/15\/run-vba-macro-without-logging-to-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Run VBA Macro without Logging to Sage 300 ERP"}]},{"@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\/3089","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=3089"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3089\/revisions"}],"predecessor-version":[{"id":35489,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3089\/revisions\/35489"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=3089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=3089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=3089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}