I'm working with 2010 now, but I have an old project that was created in 2003. I started that project with a 2003 vb.net template. I would like to use that template again, but I want to develope a current 2010 application. Does that make any sense? How do I get the vb 2010 express to recognize my old 2003 vb express template?
View 2 Replies
how do I open a document from template in VBA?
View 3 RepliesI want to open a excel template with a browse button, the file needs to open and must be directly saved by the user. after the file is saved the file location needs to be displayed in a textbox.With this i can open excel itself, but i don't know how to open the template and save the document
Dim Xl As Excel.Application
Dim Filepath As String
Dim Workbook As Excel.Workbook
[code]....
The file opens and i get a save as dialog, but when i want to save the document it doesn;t save at all, However it won't give me a error.
I get the following error message when I try the following:[code]"Excel cannot open the file 'ContactReports.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."What I would like to do is Open a excel file that is the XLTemplatePath and the either rename or save the file at the XLSaveReportPath and then use that renamed/saved file to fill the report out.I am using Visual Studio 2008 in VB.NET
View 2 RepliesI'm trying to open a word 2003 document, but I get an error that says 'Application' is not a member of 'WindowsApplicaion1.Form1'. Below is the code that I'm trying to use.
View 2 RepliesI have both 2003 and 2007 installed on my machine. I want to create a VB Script to open a few files in 2003 and in 2007 versions. How can i do that?
View 2 RepliesIn VB.NET,I want to create template at runtime and save it the template with name. for ex : Administrator design a page with 5 fields like using firstname, lastname, dob,nationality and job. He want to assign this page to the user with some restriction like user1 need to enter the all the fields and save it the forms as user1profile, but user2 need to enter only firstname and lastname and save it as user2profile.(in features, he can remove the fields from the form).
View 1 RepliesI am trying to transfer data from a VB form to an existing Excel 2003 file. This is the code I am using, but it is throwing up the following error:I have coded in VBA but am new to VB.NET and am struggling with setting up the objects
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
[code].....
Im having a problem with my program which was coded in VB.net 2005. My pc is windows XP with MS Office 2003. My program works fine for users with 2003 Office but has errors on users with 2000 Office. I was able to downgrade my pc to Office 2000 so my program would reference to MS office 9.0 (2000). This proved to be successful since both 2000 and 2003 users can now print properly. The problem now is my development pc cant create any word.application ...
on this part...
Friend mWordObject As Word.Application
Dim oWord As New Word.Document
mWordObject = CreateObject("Word.Application") '- where error
[Code]....
I'm working on my first T4 code generation tool to add some Stored Procedure helper code to my project. I've created custom types (e.g. StoredProcedure and StoredProcedureParameter to help with my code generation and have included the assembly and namespace references in my code:
<#@ template debug="false" hostspecific="false" language="VB" #>
<#@ output extension=".generated.vb" #>
<#@ assembly name="$(TargetPath)" #>
<#@ import namespace="StoredProcCodeGenerator" #>
This allows me to use my custom types in my T4 template code. However, because my custom types exist in the same project as the T4 template code, I can't recompile my project once I run the template code without restarting Visual Studio. This isn't very much fun.
I read a great article that addresses this exact issue by using the T4 Toolbox, but it's not working. Either I'm implementing the VolatileAssembly directive wrong or the T4 toolbox simply didn't get installed. I'm not sure that the toolbox got installed correctly (I'm using VS 2010 on Win XP).
I have a program written in VB.net 2003 that are folks run under alternate credentials. Inside the app there is an option to open a UNC path to a network share. We were running Windows XP SP3 and IE6. The code is simple just a call to the explorer.exe with /root,\UNCPath. After installing IE 8 onto the machine this no longer works. Best I can tell the code is still working but now being executed in non interactive mode so nothing opens up. You can however see a new spawned explorer.exe running under the system account for each attempt at opening a UNC Path. Any ideas what IE8 could have done to cause this behavior?
View 4 RepliesWhen I use Export Template in VB2010 Express, it exports to different place every time even I set up the User project templates location and User item templates location in Tool -> Options -> Projects and Solutions.It seems it exports to a path the same as used in the last Add Resource path.How can I export to where I want?
View 10 RepliesHow do I create a Windows form template? want to avoid adding all graphics setting up all other objects each time I create a new form. I am sure there must be an easy way of doing this but I just cant see how.
View 7 RepliesI can't get this to work. My program fills all the values into an Excel spreadsheet- no problems there. What I'd like to do is a print preview/print function. I can't seem to get my code right, all I get are blank pages in the print preview box.
Dim oExcel As Object = CreateObject("Excel.Application")
oExcel.Workbooks.Open("C:DailyLogsDailyLog.xlsx")
PrintPreviewDialog1.Document = PrintDocument1
PrintPreviewDialog1.ShowDialog()
oExcel.Sheet1.PrintPreview()
So as I see it, this should open excel, then navigate to the actual excel file. The print preview dialog should come up, which it does, and the excel sheet1 should be previewing, but it's not? I don't have any errors, just a blank print preview. At least thats how I see it, but obviously I'm wrong because it won't work.
I have a project that will need several forms with a similar structure - a Data Grid View control, a few buttons and some textboxes. They are not similar enough to use just one form and change things programatically so I would like to create a "template" and add several copies of it into my project. My first attempts have failed miserably, ending up with lots of "conflicts" and "duplicate items".
So, how should I save a form from my existing project in such a way that I can then load in multiple copies (giving them suitably different names) without having name conflicts?
In the Designing Class section of Sam's 'learning 2010 in 24 Hours', it prompts you to type the following two statements:
Private m_intHeight As Integer
Public Property Height() As Integer
After you press Enter, VB is supposed to fill in the rest of the property procedure template but when I try it, this doesn't happen.I looked for a setting in the options dialog that might need to be set but didn't find one, if it exists.
I need to open an excel file from vb.net and then search it for specific data. I then need to take those data and insert them into text boxes on a form that i have created. This is all controlled by a button click. I already have some code that will open a file dialog box and let me navigate to the correct file, but I am having trouble with the search portion. I have tried the Find function but I am not sure of the proper syntax. I am using Visual Studio 2008 and Excel 2003.
[Code]...
I created a VB.NET winforms project using Visual Studio 2003, including reports done with CRystal Reports. I need to upgrade the system to the latest VB.NET using Visual Studio 2010. What kind of problems can I expect? How difficult will it be to convert the reports to Business Objects (which I believe is now th default in V Studio).
It's not a huge system about 6-8 screens and a similar number of reports using an Access 2000 Database. Most of the screens were coded directly in VB and not done with the automated processes at the time.
I have a weird problem with compatibility I guess. The code works on Excel 2010 but doesn't on 2003. Here is the [code].....
I have no idea why but it gives an error on Excel 2003 saying he cannot access the file to Save as (even though by calling SaveAs I am creating it)
Private Sub LinkClicked(ByVal sender As Object, ByVal e As EventArgs)
Dim link As HtmlElement = WebBrowser1.Document.ActiveElement
Dim url As String = link.GetAttribute("href")
[code]...
Okay so here's the question how do I get the links that open in a new window to open in my main webbrowser control. The above code does some, but it's not fool proof.
I would like to know if it is possible to have dynamic data in word (2003) documents. Let me explain, I will start with what we do now and how I would like to fix or change it.We have approx 35 , we will call them divisions for the time being, and each division has a folder on the shared drive. We have approx 700 ,lets call them customers for the time, and each customer has a folder located in the associated division folder on the shared Drive. (\DriveDivision#1Customer#1...\DriveDivision#32Customer#348 etc etc etc .)There is a MSword2003 document that exists in every Customer Folder that contains data about that customer (including but not limited too.Contacts, Notes, Customer #s etc) We will call this the DeCust.doc file for the time. A lot of the information in these DeCust.doc files can exist in another customers DeCust.doc files such as a contact name and address. One of the problems we run into is that a contact (lets say Smiths Plumbing Service) may send an email to notify of an address change and the person receiving the email will change the contacts address in the DeCust.doc files of the customers that that employee (employee #1) works with but, there are other DeCust.doc files in other customer folders that the address never gets changed in. When a different employee (employee #2) opens a deCust.doc file of a different customer that he/she works with the contact (Smiths Plumbing Service) the address of this deCust.doc: file is wrong (not updated).
I would like to solve this problem. I have already developed a Demo VB/Database application to be used in lieu of the DeCust.doc files but, I have met Way too much resistance in getting people to switch from using individual docs in each customer folder to using a database program. With that being said, I started wondering if there was a way to Link/populate/fill the contact information in these DeCust.Doc files to a central Database or such that when someone changes an address for a contact it is simultaneously changed in all the other DeCust.doc files.
I'm am trying to determine the total number of fields under a particular heading given that the other Heading's total number of fields are > or < than the heading in question. The query, shown first in the attached code, works well if there is one column in one database table, however it does not work well when there are a number of columns with a different number of fields respectively. The CategoriesID encompasses the entire tables contents.I devised a function to determine the total number of fields within a particular column and then attempted to incorporate this, without success, into the second query, shown in the code.
Private Sub GetRandomHeadingFields()
Dim varNumberHigh As Integer
varNumberHigh = TotalNumberofHeadingFields()
[code]....
Is it possible to import a query from Access 2003 into Visual studio 2010 (language used vb.net).
I created the queries originally for a project, then when I imported the database to visual studio I can only use the tables that i created. I have started looking at the coding to re-do these, but if I can import them would it be quicker?
We were using Ofiice 2003 since long but now we are migrating to Office 2010.The problem that we facing now is that in our Workbook based on Excel 2003 we had a few ranges with names like BCD1, DOT1 but now in Excel 2010 BCD1 and DOT1 are cell names. The new version changes the BCD1 to _BCD1 automatically but we have to manually change the Macro code for the same which is a cumbersome problem.
PS: Some code that would automatically change the required in Macro Code.
Why is it that when I'm trying to run my program i always see this error>>>> syntax error in insert into statement.....i declared everythingin this function has an error:
if inc <>-1 then dim cb as new oledb.oledbcommandbuilder(da) dim dsnewrow as datarow dsnewrow=ds.tables("ryan").newrow() dsnewrow.item("ID")=textbox1.text dsnewrow.item("Password")=textbox2.text ds.tables("ryan").rows.add(dsnewrow) msgbox("data added!")
I have some code that retrieves some data from multiple tables.This works fine.Now I want the data I retrieved to ADD to an excisting table in an Access 2003 DB.
How can I achieve this.I searched this forum and google...without succes :-(
The code I use to retrieve the data from sql server 2005: Dim connection As New SqlConnection(strConnectionStringSQL)
[Code]...
I'm running into a bit of a roadblock here. I have tried to search the web/forums for answer for last several hours to no avail and I'm not the expert VB Programmer.However, I was able to write an app to do the following:
1) read Outlook emails for particular emails containing xml link in which I was able to download the file and save to my hard drive.
2) opened the Excel spreadsheet to run the macro which import those XMLs into existing XLS spreadsheets to refresh the data.
3) Those XLS spreadsheets are linked in my MS Access in which I join all four XLS sheets to create one report via Query which I have created in the past prior to this app development.
I have manually done a File Export of this query via ALT+F then E and what I'd like to do is to either take control of menu commands OR alternate method of performing a File Export to a new Excel spreadsheet (version 2003).I've seen two different methods, one via DoCmd OutputtoFile and another is TransferSpreadsheet.Here's my Access coding I have in my VB 2010:
Imports Microsoft.Office.Interop
Public Class OutlookOfflineEmailExtractor
Dim wsAccessApp As Access.Application
[code]....
I have created an excel 2003 file using visual basic 2010 express edition with access as backend. The excel is created using a select into query. I would need help to protect this excel file once it generated using visual basic 2010 so that the users cannot edit the same.
View 1 RepliesIf I create a windows app which I link to an MS Access databse file that already exists..will I need to have MS Office installed on every computer at which I want to use the app? If not then how do I go about making a standalone windows app that will store information in a database of some form or another ?
View 1 Repliesi just want to know how to get a template and store it in a data base without using data set
View 1 Replies
