Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 40 results for
vbproject
- Page 1
Add VBA code to Excel file
Programming
Software Development
9 Years Ago
by djjeavons
… and add a standard module component Dim
vbProject
As
VBProject
= excelWorkbook.
VBProject
Dim vbComponent As VBComponent =
vbProject
.VBComponents.Add(vbext_ComponentType.vbext_ct_StdModule) 'Your code Dim…
excel.exe still running in the background
Programming
Software Development
16 Years Ago
by pbosek
… xlapp.DisplayAlerts = False ActiveWorkbook.SaveAs FileName:=file_name Set xlmodule = xlBook.
VBProject
.VBComponents.Import(ExcelMacro) For i = 0 To List2.ListCount - 1…
Trust access to Visual Basic Project - Is Not Enough
Programming
Web Development
14 Years Ago
by Ptero
… files contain some VBA code that is added with oWB.
VBProject
.VBComponents.Item(i).CodeModule.AddFromString(s). The "Trust access…
Problems with dynamic Excel with Module
Programming
Web Development
14 Years Ago
by Jojo1974
… code Code: [code]Dim xlmodule As Object 'VBComponent xlmodule = xlbook.
VBProject
.VBComponents.Import(PathToImport & "Module1.bas")[/code]If…
creating excel macro in C#
Programming
Software Development
14 Years Ago
by carobee
….The code that i have used is [code] module = excelWorkbook.
VBProject
.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule); [/code] this part of the…
C# Excel Add Macro Using Late Binding
Programming
Software Development
13 Years Ago
by PhilHernandez
…) PIA: [CODE] //create a new VBA control module oModule = oWorkbook.
VBProject
.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule); //Add the VBA macro to…
array trouble
Programming
Software Development
13 Years Ago
by xorinzor
…]http://dl.dropbox.com/u/6072059/ArtificialLife.rar[/url] password:
vbproject
The problem occurs in the Maps.vb file on line…
Run Macro on toolbar button click
Programming
Software Development
10 Years Ago
by bullet_1
… a module Dim xlmodule As Object 'VBComponent Set xlmodule = xlbook.
VBProject
.VBComponents.Add(1) 'vbext_ct_StdModule ' Add a macro to the module…
how can i generate the id using date format
Programming
Software Development
10 Years Ago
by lrhimma
hi everyone im doing small
vbproject
that must auto generate id using the current date format …
Re: Database is not updating but no errors :(
Programming
Software Development
16 Years Ago
by VB_help
… not getting error .The path of my database was E:\
vbproject
\ dcSchool.mdb. But the database which was getting updated was… E:\
vbproject
\ dcSchool\ dcSchool\ dcSchool.mdb. (i.e. the copy of database…
Re: save `n` run
Programming
Software Development
16 Years Ago
by QVeen72
Hi, follow the above procedure. did u Check it and Clicked "OK"..? it will add in toolbox, but it will be in the end, if u have many controls on the toolbox, Increase the width of toolbox and check.. it is a small icon resembling
VBProject
icon.. Regards Veena
Re: How to stop and pause music files in runtime
Programming
Software Development
15 Years Ago
by selvaganapathy
To add Media Player Component > Start
VBProject
> Click [B]Project -> Components [/B]Menu (a dialog …
Re: Visual Basic 2008 Express Edition Login System
Programming
Software Development
13 Years Ago
by Luc001
…("Provider=Microsoft.jet.oledb.4.0;data source=E:\
VBproject
\myDB.mdb") Dim cmd As OleDbCommand = New OleDbCommand("…
Re: Debugger.
Programming
Software Development
13 Years Ago
by abelingaw
… an error. "Could not find file 'C:\Documents\Pic\
VbProject
\Images\Database.mdb" And if i open my DBase…
Re: Debugger.
Programming
Software Development
13 Years Ago
by AndreRet
[QUOTE]"Could not find file 'C:\Documents\Pic\
VbProject
\Images\Database.mdb" And if i open my DBase …
Re: Visual Basic 2008 Express Edition Login System
Programming
Software Development
13 Years Ago
by Luc001
Hi, As you can read in the code example I gave you find this: [CODE]Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=E:\
VBproject
\myDB.mdb") [/CODE] And that says I've used a Access database. ( [B]myDB.mdb[/B] )
Re: Excel code to add Button that writes a code to that button
Programming
Software Development
11 Years Ago
by davesexcel
… Me" .Name = "myMacro" End With With ThisWorkbook.
VBProject
.VBComponents(MySht.CodeName).CodeModule .InsertLines .CreateEventProc("Click", MyOle…
Re: excel.exe still running in the background
Programming
Software Development
16 Years Ago
by techniner
See you original post. I replied there. [code] Application.DisplayAlerts = False Application.Quit [/code]
Re: creating excel macro in C#
Programming
Software Development
14 Years Ago
by avirag
Go through this: [url]http://support.microsoft.com/kb/303872[/url]
Re: creating excel macro in C#
Programming
Software Development
14 Years Ago
by avirag
follow this link as well [url]http://www.eggheadcafe.com/articles/create_macro_at_runtime_in_dotnet.asp[/url]
Re: creating excel macro in C#
Programming
Software Development
14 Years Ago
by carobee
i have referred to both the links before posting the thread. If you look in you will see that they have used the same syntax.But my code won't compile
Re: creating excel macro in C#
Programming
Software Development
14 Years Ago
by carobee
any help???????
Re: creating excel macro in C#
Programming
Software Development
13 Years Ago
by comsdev
We talk about functions of Excel in our daily routine. One of the millions of functions of Excel is “Macros”. When you turns the Macros “on”, it starts recording whatever is being done in particular excel sheet. So you can get to know about the work done by your co workers on one Excel Sheet in your absence. Moreover, it can also be used for …
Re: C# Excel Add Macro Using Late Binding
Programming
Software Development
13 Years Ago
by ddanbe
Hi, PhilHernandez, welcome here! Is this meant to be a code snippet?
Re: C# Excel Add Macro Using Late Binding
Programming
Software Development
13 Years Ago
by PhilHernandez
Yes, this was just some of the code that I am using to get some of my Excel working. I just need to figure out how to add a macro to an Excel worksheet. Do I need to post more info?
Re: C# Excel Add Macro Using Late Binding
Programming
Software Development
13 Years Ago
by ddanbe
More info never hurts, but it is fine as it is. Thank you. Perhaps some moderator can change your contribution into a snippet...
Re: C# Excel Add Macro Using Late Binding
Programming
Software Development
13 Years Ago
by PhilHernandez
I'm obviously a noob here. I guess I don't understand what you mean by 'code snippet'. Should I have posted more code? Thanks for your response
Re: C# Excel Add Macro Using Late Binding
Programming
Software Development
13 Years Ago
by ddanbe
Well for your info, sometimes I still feel like I'm a noob :-O A "code snippet" means you can select how you post, you see it in the heading when you start a new thread. If you have some interesting code you like to share, post it as a snippet, else if you have a question, just post it as a normal thread.
Re: C# Excel Add Macro Using Late Binding
Programming
Software Development
13 Years Ago
by Sebastian_
try to use a real latebindingapi like these http://excel.codeplex.com example7 contains an example to add vba code to a worksheet. hope it helps
Re: array trouble
Programming
Software Development
13 Years Ago
by xorinzor
sorry I made a stupid mistake, I tried to put a string in a array defined as Double. This thread can be removed/closed/whatever :)
1
2
Next
Search
Search
Forum Categories
Hardware/Software
Programming
Digital Media
Community Center
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Meet People
Forums
Top Members
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC