TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
suchi rana
NA
18
30.9k
How to call Access Macros with parameters from vb.net
Jul 17 2013 5:11 AM
HI All,
I have created macro in Access DB. Now i want to run that macro from Windows Vb.net.
Here is my code....
Dim oAccess As Object
oAccess = CreateObject("Access.Application")
oAccess.Visible = True
oAccess.OpenCurrentDatabase("\\Asihydfp01n1\it\Soft\IT-US\CSSD\ITS-US-LA\Sucharitha\TestCase\TestC.mdb")
oAccess.DoCmd.RunMAcro("macro1", lbluid)
oAccess.CloseCurrentDatabase()
'oAccess.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(oAccess)
oAccess = Nothing
************
But it won't affect in DB.
after this i am not able to open the Access DB.
Please any suggestions
Thanks in Advnace
Sucharitha
Reply
Answers (
0
)
Calling R.exe from command prompt using C# not working
Help for Developing Multi Location Software in c# (winform)