I created a vb.net RTD server as explained in the link below in vb 2008 express. [URL]. But this link gives no indication of how to register the dll on another machine. I tried to register the dll using regasm, but it still doesn't work. (I keep getting #N/A s).
View 1 RepliesDoes anyone have an example of how to register an automation server in the ROT (Runtime Object Table) using IRunningObjectTable.Register and how to revoke it using IRunningObjectTable.Revoke?
View 1 RepliesI am creating an Excel Add-In using Visual Studio 2010. My intention was to add a context menu to a cell and perform some action on the selected cell or cells. Here is the code I have got as of now
[Code]...
I am trying to use a COM dll referenced from a vb.net project. Everything works fine when I reference the interop inside the IDE but when I publish the file in bin folder on my server I get:
Retrieving the COM class factory for component with CLSID {A440BD76-CFE1-4D46-AB1F-15F238437A3D} failed due to the following error: 80040154.
I can't register the original dll with regsvr as the server is with a hosting provider and I thought the point of interops was to be able to use old COM dlls without having to register them
I have an old Visual Basic 6.0 application. The program was compiled and ran as a schedule task. It creates the pdf files. When I look at the event viewer. It gives me this error message. The server {85DE1C45-2C66-101B-B02E-04021C009402} did not register with DCOM within the required timeout. The application id refers to adobe file. The schedule task never runs. This above error message showed up on the event viewer.
If I run the application by itself, it creates the pdf files with no problem. Any idea with this issue. I did a look up on this error. There is no solution for this issue that I came across on the web.
I downloaded visual studio and the 30 day period to register expired and i cant start it to register.i uninstalled it and reinstalled it and it still wont let me start it up to register it. what can i do to get the key?
View 3 RepliesI can do this using VBA, but I want to be able to create the code using a compiled VB programme, which can then be opened in Excel.
View 1 RepliesI have read some of the other posts on this and seem to be a little different than my situation. Trying to print out some reports into an excel document on the clients machine - of course it works fine on my local (heard that before right). I went in and set my references Ms.Office.Core and Ms.Office.Interop.Excel to 'Copy Local' = True so the .dll are in the servers bin folder.
[Code]...
I create some files in VB.net from a master file but when I try to open the newly created file, Excel starts and nothing is displayed, you can see the outline of Excel and it's menus and nothing else. You can't do anything with excel except close the entire application. [Code] It is upon trying to re-open where it fails, outside of the VBE. I have not had a problem like this using VB6 before, so I am assuming I am doing or not doing something.
View 3 RepliesI am trying to retrieve an excel chart (created out of .net), which i have earlier copied to the clipboard.As long as I work with type bitmap I can copy/retrieve it as follows:
Code:' copy to clipboard (in .net)charts.CopyPicture(Office.XlPictureAppearance.xlScreen, Office.XlCopyPictureFormat.xlBitmap)
' retrieve it againimgImage=Clipboard.GetDataObject.GetData(DataFormats.Bitmap)
Unfortunately, the quality of the bitmap is rather bad, thus I would like to copy it as a Metafile. The copying works, but the retrieving will only return Nothing.
Code:' copy to clipboard (in .net)charts.CopyPicture(Office.XlPictureAppearance.xlScreen, Office.XlCopyPictureFormat.xlPicture)
' retrieve it againimgImage=Clipboard.GetDataObject.GetData(DataFormats.MetaFilePict) ' returns Nothing!
I have checked if the object is available in the clipboard using GetDataPresent and it shows that there is a metafile available. Still, it returns nothing.On a side note: Is there a way to avoid using the clipboard? After all I am creating the charts in .NET and I need them there as well. Could I access the image of the chartobject directly?
We have a VB 2005 program that reads data from a database and builds an Excel output file to be emailed. This works fine from my computer but when we put it on the server it fails on the Excel functionality.
The error is: Unhandled Exception: System.Runtim.InteropServices.COMException
Although Excel is not installed on the server we did also build a Setup program to install our program. It copies the Microsoft.Office.Interop.Excell.dll to the server folder with the exe.I thought the setup program should register the Excel DLL and the program should work even if the server does not have Office or Excel installed.
I want to use icon files that reside outside of Excel on my Excel toolbars for macro buttons I have created (I don't want to use the customizing function within Excel, but rather, icons that have already been created). In some prior life, I have done this and have some neat-looking icons on the Excel that resides on my desktop. I don't know how I did it, but I know it's doable!
Alternatively, if someone could tell me how to copy over the customized Excel setup, that would work too. I tried copying over my "Book 1" file, but got a message about macro security and digital certificates.
I created some database already in my SQL server 2008. And im planning to show all this data via graph using VB.net..Is there anyone here can give me LINK, thread or the best is tutorial so that I can begin doing it.Usually my data is based on date only. So once the date inputted then it will SQL and get the exaxt data in Graph format.
View 3 RepliesI currently have a JSTree all set up to do the creation and renaming of a new node:[code]The problem is that my success doesn't seem to get hit when I return an integer ID on the create node, thus I can't set it to a global variable. What exactly do I need to return in the function to get back the ID from the server? I'm simply returning a new integer right now.
View 1 RepliesI have 2 blocks of code, if someone could help me put them together I would get the functionality I am looking for. The first block of code downloads a gridview to excel using the download dialog I am looking for:
Public Overloads Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)
' Verifies that the control is rendered
End Sub
Private Sub ExportToExcel(ByVal filename As String, ByVal gv As GridView, ByVal numOfCol As Integer)
Response.Clear()
[Code]...
I have code for a user created button that gets placed on a custom ribbon control, within a custom drop-down menu.[code]...
View 2 Replieshow can i link form created using vb.net to sql server database.I created a database with sql server 2000 now i want to connect form created in vb.net to sql server database
View 1 RepliesI am using SQL server express 2005 as an backend. I created a backup file programmatically. If I use same server , then it restore the data successfully. however if we try to restore on different server, then it fails. and throw following message:
"The Backup set Holds a backup of a database other than the existing 'DatabaseName' database. RESTORE DATABASE is terminating abnormally."
On both server, Sql server instance name and database name is same. How can I resolve this error?
I have a windows app created in 2005 with sql server backend. There's also a web service that is located on a web server at a hosting facility. In my app, when ever it needs to interact with the data, it calls the web service.Ive been having this issue with several screens that Ive developed in .Net. The user enters a date, and saves to the database. When the datagridview is refreshed, the date that they entered always displays one day earlier. Eg. If they entered 4/18/2012, it displays as: 4/17/2012.
The date is correct in the database. I verified that the problem resides on the web server. The default timezone set on the server is GMT -06.00 Central Time(US and Canada) and it cannot be changed on the shared server. The time zone where I'm at is Pacific Standard time. I'm not sure the best way to deal with this issue. Here's one way I was thinking: Retrieve today's date from the server (don't know how to do this), and compare it to the date on my machine so I know the difference. Then, when I'm looping through the datatable, add this same number to the dates to display correctly. Maybe it's better to retreive it from the database via the sql?
here is a copy of my current code. Am trying to open an existing Excel spreadsheet then retrieve the old balance data refigure the new balance and store new data into the spreadsheet. Am I on the right tracK, or way out in left field?
Private
oWB.SaveAs(
"Checkbook.xlsx") Nothing
oWB.Close()
[Code].....
[Code]...
overcome the ActiveX error Do I need to add a referrence? If not "Registered" how to do it?
I have a program that creates excel and word documents from another main Excel workbook. Essentially it opens excel checks data, posts data to appropriate forms. It then saves them as (number from main excel) & date/time stamp and corresponding extension. I want to be able to list the created documents according to the number from the main excel workbook.
[Code]...
i created some buttons to start a remote connection with some server.Private Sub Button15_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button15.Click Dim RetVal
RetVal = Shell("mstsc.exe /v 10.100.6.11")End Sub But now the remote connection starts minimized, how can i fix this so it starts maximized,i dont want to use /span because some people use 2 monitors and don't want it "widescreen"
I have a table that I'm creating in code behind with the final column containing a HTML checkbox with runat="server".
The code I'm using to do this is:
Do While reader.HasRows
Do While reader.Read
[code].....
In the following code I open several Excel workbooks from within the VS 2010 .IDE. I want to Try the open workbook code, then Catch exceptions using a dialogbox as a form created programmatically at run-time. The exception handler works, but the dialog box does not display in front of the workbook. So, the user can't respond to the modal form. If at that point the Excel workbook is shrunk manually to expose the dialogBox which is then dismissed, Excel pops up a "Save Changes?" alert and the VB code does not resume the Sub at the Me.Focus() line
When the workbook Is open Excel is the active application. I think this is why the dialog box is not in front, and I don't know how to solve the problem programmatically.[code]...
I am creating an Excel Add-In using Visual Studio 2010. I would like to run some code when users clicks a combination of keys.Here is the code I have got
Public Class CC
Private Sub ThisAddIn_Startup() Handles Me.Startup
EnableShortCut()
End Sub
Sub A1()
[Code]...
The Add-In when installed shows an error on clicking the short cuts. It says the specific macro cannot be found.The code under the Sub EnableShortCut() works well when it is in an excel vba module. The same won't work when it is added to an Excel Add-In created with Visual Studio.
How can I get the output data of sql procedure from SQL Server to my asp.net[vb.net] page dropdown list?<asp:DropDownList ID="DdLocation"></asp:DropDownList>
View 1 RepliesThe above is more or less the complete question. I have created a table in the VB 2010 Database Explorer but I cannot for the life of me work out how I can get this copied or created into the underlying server. It is not appearing in the underyling serverand when I run the code of course I ge "invalid object <tablename>" I have data as well in the table that appears in Database Explorer. I think I have missed something fundamental in my overall conception of using VB 2010 Express with SQL Server Express in that I don't know if I have a local copy (that isn't then mirrored on the server), or what (the ____ have I got)? An article that explains the overall relation of Database Explorer to the underyling Server would be great as well
View 8 Repliesam trying to store and retrieve data from a closed excel worksheet while in a form created in vba studio express 2008?
View 3 RepliesI am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?