Hi,
I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?
For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.
However I am trying to automate the manual process. Any suggestions or direction?
Thanks,
DR
8  14086 
Hi,
I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?
For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.
However I am trying to automate the manual process. Any suggestions or direction?
Thanks,
DR
hI
Can you please send me that pl/sql procedure that extracts data into an excel worksheet.
As i am working on a similar case
Email id: [ Removed ]
Thanks alot
Nitin Singh
Hi,
I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?
For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.
However I am trying to automate the manual process. Any suggestions or direction?
Thanks,
DR
Setting a macro would not be possible from PLSQL.
Could you please tell what is that macro going to do?
One suggestion would be to connect to oracle database from Excel using macro and fetch the data in to excel sheet.
You can't set macros form PL / SQL.
Hi, I have the same request. I am collecting data via PL/SQL procedure and downloading them in excel. I have a macro that runs a chart. I am trying to make the whole report automated. Any other workaround for the macro to run?
Thanks.
Hi, I have the same request. I am collecting data via PL/SQL procedure and downloading them in excel. I have a macro that runs a chart. I am trying to make the whole report automated. Any other workaround for the macro to run?
Thanks.
I hope you would have got the answer from the above posts that setting a macro using PLSQL is not possible.
You can rather connect to oracle DB from excel using macro and fetch the data and store them in the oracle work book.
hi...
i would like to know about the procedure that u used to extract data into excel.
Hi,
I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?
For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.
However I am trying to automate the manual process. Any suggestions or direction?
Thanks,
DR
Can some please put up the Stored proc to load data from a table into excel file?
you can "run" a macro using client-side client_ole2 code , use:
args:=client_ol e2.CREATE_ARGLI ST;
client_ole2.ADD _ARG( args, V_MACRO_NAME );
client_ole2.INV OKE( Application, 'RUN' ,ARGS );
client_ole2.des troy_arglist(ar gs);
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: chris |
last post by:
I'm creating an excel document dynamically from scratch using Python
and the win32com module. All is well, but now I need to add a macro to
the spreadsheet and run it (to enable some sorting features in the
spreadsheet). I think I know how to run a macro once it's installed
(using the Run method of the excel application object...I think), but I
can't figure out how to "install" the VBA macro code into the
spreadsheet to begin with from...
|
by: MS |
last post by:
We have to provide a facility on the client machines to download the data
visible on a ASP page into an excel sheet. We are using WIN2k clients
connected to WIN2k server with IE6.0 installed.
The way we plan to implement it is that :
a) provide a right click and download to excel button from the ASP page
|
by: OhMyGaw |
last post by:
Hello Excel/automation Gurus,
I am working on an application where I have to keep a centralized
database of all macros distributed to user and save the changes back on
a nightly basis back to one central Excel macro repository.
What would you guys suggest me do?
Should I keep all macros in a centralized unique text file of some sort
or is it best to do with SQL server?
|
by: Brian Hanson |
last post by:
Hi,
I have an unusual problem that just showed its ugly head at a pretty
bad time. I have an asp.net (VB) app that takes data from an Excel
sheet and puts it into SQL Server. I get the data out of Excel using
OleDB, and suddenly, some of the data was not being extracted from
Excel.
I use OleDb for the extract into a DataTable and from there an
SqlClient.SqlCommand to put it into SQL Server.
|
by: Mark Ritchey |
last post by:
I don't know if I am sending this to the right place, but
I have looked everywhere and have not found anything. My
question is this.
I am trying to Open a Excel Spreadsheet that contains
macros and when I open the document with VBScript it halts
because of the Prompt asking me if I want to enable
Macros. So, I was wanting to know if there is a way that
on the objExcel.Workbooks.Open Path what other arguments I
can add and the syntax...
| | |
by: Sreedhar Vankayala |
last post by:
Hi,
I joined a project where we need to import data from a excel file into
sql server via the asp.net.
After doing a long research found that
#1. Upload Excel file to the server
#2. Load or keep the Excel file into the memory
#3. Query the excel file and convert into insert queries and execute
them via sql server
|
by: chris.bunch |
last post by:
I have written code to open an excel workbook and edit 2 worksheets.
The code works great opening and editing a general workbook, but,
though it opens it fine, it will not edit the worsheets in the specific
workbook I need to edit. Though it has this problem it never throws
any kind of exception, just completes like it worked fine.
The only difference with the workbook I need to edit is that it
contains macros. When I open the file, I...
|
by: LacrosseB0ss |
last post by:
Quick question: is there a way to programmatically turn off the warning message for macros in Excel? (Macros can be harmful ... enable/disable)
The reason for the question is on our intranet page we have a link to an HR document a lot of people use. However, this document runs macros. We would like to, if possible, have the message NOT be displayed. It has been confusing some users as they don't know it's an Excel doc. Nor do they really know...
|
by: Raghavender143 |
last post by:
Hello everyone
How can i extract all the data from a report to excel worksheet using a macro in access.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
