Flux rss
They need your help
Search : in
By : Relevance Date Username
Statut : Not resolved

Execute Macro in Access

anilchand6, on Tuesday 15 April 2008 à 15:34:51
Hello,


I am currently executing a macro by opening Access aand running it from there. Is there another way to execute the macro without opening Access? Something like a script, or anything else. Any suggestions are greatly apperciated!


Thanks!
Configuration: Windows XP
Internet Explorer 6.0
Reply to anilchand6  Report this message to moderators Go to last message

1


  • 1    This message seems useful, vote!
  • Ce message ne vous semble pas utile, votez !
  • Report this message to moderators
 Sandira, on Tuesday 15 April 2008 à 16:50:47
Hello

I don't know too much about Access (i.e. nothing <g>) but I have an Excel macro that runs "almost invisibly" when I double click the icon for an specific Excel file. Snippets of the code are shown below.

A Workbook_Open macro, when placed in the ThisWorkbook module of an Excel file, will run as soon the workbook is open.

The application appears briefly, then becomes "invisible" as per the code, then the rest of the code runs and finally the application quits.

So, while I don't know of a way to run a macro without actually opening the app, I can at least run it without having to deal with the application directly. Perhaps Access has the same "on open" capability.

The Excel file uses the following code:

Private Sub Workbook_Open()
'Dim statements snipped
Application.Visible = False
'Code snipped
Application.Quit
End Sub
   
Reply to Sandira
Ask your question Reply

Résultats pour Execute Macro in Access

Excel Macro Help Please (Solved) Hello Everyone, I am sking for some help with an Excel macro please. I have a 1,900 hundred static HTML pages that I have converted to text for the purpose of importing to a DB via an Excel CSV file. I have everything sitting in an excel file now with... en.kioskea.net/forum/affich-11146-excel-macro-help-please
Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3
Processes - cdantsrv - cdantsrv.exe The process cdantsrv.exe is part of the C-Dilla License Management Software Macrovision suite, used for digital rights management (DRM), i.e. managing access rights for copyright-protected content. The file that corresponds to this process is... en.kioskea.net/processus/cdantsrv-exe.php3

Résultats pour Execute Macro in Access

Access the hidden Administrator Account in Windows VistaAccess the hidden Administrator Account in Windows Vista Why has the Administrator account been disabled in Vista? How to activate the Administrator Account Solution 1: Through User Account Control Solution 2: With Command Prompt Solution... en.kioskea.net/faq/sujet-300-access-the-hidden-administrator-account-in-windows-vista
How to access your BIOS set upHow to access your BIOS set up Depending on your computer model, the way you will access your BIOS set up menu will differ. Here is a list of the most common models used and the access key used for this process. ACER You can make use... en.kioskea.net/faq/sujet-283-how-to-access-your-bios-set-up
Accessing Safe Mode without key F8Accessing Safe Mode without key F8 Introduction Explanation Introduction Safe mode is the windows maintenance mode of a computer operating system. You can access your computer to diagnose problems on your computer. Below is a tips of how... en.kioskea.net/faq/sujet-628-accessing-safe-mode-without-key-f8
1 2 3 Next

Résultats pour Execute Macro in Access

Need help in Excel Macro (Solved)Hello Ivan, Ive' been reading a lot of your answers and i'm quite facinated of your skill. I need to create a macro for one of my project and it involves tranferring data (row) to specific range in another work sheet. I tried to produce a... en.kioskea.net/forum/affich-17266-need-help-in-excel-macro
Excel active cell macroHello, I'm trying to write a macro in excel which would copy and paste a range from WITHIN THE SAME ROW in the same sheet as the active cell is selected. For example let's say i select a cell within range A6:P36 then i would like the macro... en.kioskea.net/forum/affich-25813-excel-active-cell-macro
Pretty Basic Excel Macro HelpHello, I am writing a macro (which will be used to create a VB6 program) in Excel 2003. The spreadsheet Update_Log is a database with 9 user input columns and 7 columns which are calculated by formulas based on user input. I need to create a macro... en.kioskea.net/forum/affich-15106-pretty-basic-excel-macro-help
1 2 3 Next

Résultats pour Execute Macro in Access

Download Java ToolsPopular dance Tools is very light IDE for creation, compilation, execution and debugging of applications Popular dance and applets. The tool including of points and clicks of access to orders Popular dance, to documents, to directory and to files.It... en.kioskea.net/telecharger/telecharger-561-java-tools
1 2 3 Next

Résultats pour Execute Macro in Access

YouTube access blocked in China after Tibet clips appearThis file photo dated shows a web page from www.youtube.com displayed on a computer screen in Hong Kong. Access to YouTube in China was denied on Sunday after footage of recent deadly protests in Tibet appeared on the video posting site. Access to... en.kioskea.net/actualites/youtube-access-blocked-in-china-after-tibet-clips-appear-10211-actualite.php3
1 2 3 Next

Résultats pour Execute Macro in Access

Computer - Random access memory There are generally two broad categories of random access memory: DRAM memories (Dynamic Random Access Module), which are inexpensive. They are used essentially for the computer's main memory SRAM memories (Static Random Access Module), which are... en.kioskea.net/pc/ram.php3
WiMAX - 802.16 - Worldwide Interoperability for Microwave Access WiMAX is short for Worldwide Interoperability for Microwave Access. It is a metropolitan wireless standard created by the companies Intel and Alvarion in 2002 and ratified by the IEEE (Institute of Electrical and Electronics Engineers) under the name... en.kioskea.net/wimax/wimax-intro.php3
WPA - WiFi Protected Access WPA (WiFi protected Access) WiFi network security solution offered by the WiFi Alliance, in order to fill gaps in WEP. WPA is a "light" version of the 802.11i protocol, which relies on authentication protocols and a strong encryption algorithm:... en.kioskea.net/wifi/wifi-wpa.php3
1 2 3 Next