Has anyone ever tried to run a stored procedure through a macro before?? And If so do you get a message that says that the stored procedure exectuted successfully but a macro Halt macro message that says "Action Failed"?? Now the stored procedure executes just fine its just that the macro itself is having some trouble. Can anyone help me?? please
View 8 RepliesOur IT department says to me all a stored procedure is, is a Macro. This is what Our network tech says to me. There are days I just want slap these people. This is the same one that made the Flat File comment, I think databases are very important and can be very complex I get annoyed when they IT people make them seems as if they are of no importance at all.
Venting again sorry
hi,
I have already set up a DTS package to convert my data to an excel file and I would like to alter the format of my data through my DTS without having to write a macro.
Do you know how to do this?
Hi,
I have Marco Dreamweaver 8 and SQL. I don't know how to tied them up. Anyone who can help me?
Thanks
Having trouble with this assignment. My teachers say it should work but itjust doesn't. This part of a macro is designed to take payment from the costand show the balance owing. What am I doing wrong. The sql is shown below.No error message is showing but the process still dosen't work.UPDATE [wedding] INNER JOIN deal ON wedding.deal = deal.deal SETwedding.balance = (deal!cost - [wedding]!paid)
View 1 Replies View RelatedHi all,
I am trying to run a Excel macro from a DTS package.I've created the macro and Batch file to run a macro, and i am executing a batch file from DTS package.I am able to run a macro when i am executing a DTS package manually.but its not working when i schedule the process. any solutions?
its not the security problem also.I've checked it.
Does anyone know how to do this?
View 1 Replies View Related
Hi,
Is it possible to embed excel macros in an rdl report and run those macros while exporting the rdl report to excel.
Thanks,
Priya
Can you call run an excel macro as part dts step. I would imagine it would be some active script, but am not sure.
Any Ideas ?.
I am running SQL 7.0 sp2, excel 97.
Hi,
can I run a macro Access from a trigger ?
Hi All
I just have a excel macro code, It is working in excel itself.
But I want to execute within SSIL package.
When I am trying through Active X, It is returning error.
Can any one help me please....
MichaelRaj Arokiyasamy
Here's the scenario. Using a campaigning applicaion for aneNewsletter. It writes to an Access table. I have an ASP web page thatwrites to another table. I chained 3 Access queries together into aMacro to copy that data to the campaigning table, give a numericidentifier to that record, and then delete all records with thatidentifier (in the 2nd table). This will keep the ASP > Access tableclean.The campaigning software allows for a pre-processing SQL command tobe run. I would like to automate the updating of the table byinitiating this Access Macro from the SQL command. Anyone have anyideas on the command/syntax?Thanks in advanceJasonJoin Bytes!
View 1 Replies View RelatedI know this might be the wrong forums, but I thought that some SQL Server users might know the answer and have accomplished this before. Does anyone know how to run a SQL Server job through an Excel macro? I have the macro where it's entering the data into my database, but now I need to use the data by running the job. Thanks!
View 3 Replies View RelatedHi all
I am running a excel macro from SSIS package, after executing macro I just want to remove the module(Macro code) from Excel file.
can you please tell me how it?
MichaelRaj Arokiyasamy
Greetings!I am now doing one type of analysis every month, and wanted to creattable names in a more efficient way.Here is what happens now, everytime I do the analysis, I will create atable called something like customer_20050930, and then update thetable by using several update steps. Then next month I will create atable called customer_20051031. Does anyone know if there is a betterway to do it? like using a macro variable for the month-end date? Noweverytime I have to change the table name in every single update step,which would cause errors if I forget to change one of them. By using amacro, I would only need to change it once.Thanks!
View 8 Replies View RelatedHow do I query an SQL Express database from within an Excel 2002 VBA macro?
For example, how could I accomplish this in an Excel macro.
SELECT myID FROM MyTable WHERE Compound = string in cell A1
And then put the resulting ID number in cell A2. The relationship between Compound and myID is always one to one.
Thanks to all.
Dan
Hi Guys
I create some reports by connecting the SQL database using Business Intelligence.
I do these reports each fortnight so I want to automate these tasks using a macro.
How do I create or record a macro in BI??
I will need to have input parameters in it as well
When I click 'Tools' menu, I cant see any 'macro' submenu in it.
Please help guys
I am using SQL Server 2005
Thanks
I found this and have done everything it says to do, but I can't get the script to compile. Any ideas on how to run a access macro in SSIS??
Baiscally to execute an Access Macros in SSIS package we need to Download
Microsoft.Office.Interop.Access DLL from Office XP PIAs.
Download site
http://www.microsoft.com/downloads/details.aspx?FamilyId=C41BD61E-3060-4F71-A6B4-01FEBA508E52&displaylang=en
1) Extract the Microsoft.Office.Interop.Access DLL from Oxppia.exe
2) Drag and Drop Microsoft.Office.Interop.Access DLL to Global Assembley Directory(GAC) ie: C:WINNTassembly for Windows 2000 -- C:WINDOWSassembly for ( Win Xp and Win 2003)
3) Copy paste Microsoft.Office.Interop.Access to C:WINNTMicrosoft.NETFrameworkv2.0.50727 for Windows 2000 -- C:WINDOWSMicrosoft.NETFrameworkv2.0.50727 ( Win Xp and Win 2003)
4) Add DLL reference in the Script Task
5) Add the below Code
1) Create a New Project in SSIS
2) Drag and Drop Script Task
3) Copy Paste the code in script task editor
Imports Microsoft.Office.Interop.Access
Try
Dim objAccess As New Access.Application
objAccess.OpenCurrentDatabase("D:TestMacro.mdb", False) ' Add the Access File Path
objAccess.DoCmd.RunMacro("Macro1") ' Replace Macro1 with the name of your macro
objAccess.CloseCurrentDatabase()
objAccess.Quit(Access.AcQuitOption.acQuitSaveNone)
objAccess = Nothing
Catch ex As Exception
System.Windows.Forms.MessageBox.Show(ex.ToString())
End Try
Dts.TaskResult = Dts.Results.Success
I have the following code below where I need to have all of the query results output into a .csv file to use in a VBA macro. The issue I am running into is that the data is not deliminating correctly and my rows are being shifted incorrectly. Any better way of out putting the results into a .csv file with a common delimiter.
-- Declare the variables
DECLARE @CMD VARCHAR(4000),
@DelCMD VARCHAR(4000),
@HEADERCMD VARCHAR(4000),
@Combine VARCHAR(4000),
@Path VARCHAR(4000),
@COLUMNS VARCHAR(4000)
[Code] ...
Output from query (please post in a text editor. The line starting with (only ) should be on line 1 after 20 pks and is shifted to a new line.):
557898^1^9885E25^80082^9.0 CM GLASS FIBER PADS 20PKS
(only 12 pks in stock that will ship today)
^12.00000000^.00000000^18.32000000^219.84000000000^28.30000000
^339.60000000000^9.98000000^35.2650176678445^DR9146322^0^
[Code] ....
To overcome the inability to manage the sheet tab names when exporting from Reporting Services to Excel, is there anyway to include a short macro with the exported Excel workbook to Auto_Run macro when the Excel file is opened to rename the tabs?
View 1 Replies View RelatedWhen we deploy any PowerPivot Data Model to SharePoint 2013, we get the following options-
1. Create New PowerPivot Report
2. Create New PowerView Report
3. Schedule Data Refresh
These options work fine as long as we deploy a normal Excel Data Model file like .xlsx . However, When I deploy Data Model with some VBA code (Macros, VB functions) contained within it i.e. Macro Enabled file - .xlsm,the above options didn't work. I got following error while creating a New PowerView report as It says that your Excel has unsupported features like Macro function.Can't we create a new PowerPivot/PowerView report with Macro Enabled Data Model? Is this not supported in SharePoint 2013?