My code is below - doesnt work
1. Currently I am in Query.xls.
Application.Workbooks.Open ("C:AdiData.xls") 'Opening a file to query from
Worksheets("Sheet1").Range("K2:K" & rowCount).Formula = "=VLOOKUP(RC[-5],'[D:AdiData.xls]Sheet1'!C3:C5,3,0)" 'Performing vlookup in data file
I am unable to do this.
I have written a program that will export data from access data to Excel by using XML programmatically, But I seem to be having problem when I tried to open in excel.
View 2 RepliesHow can I open a Visual Basic application that I created in 2002? I downloaded a current version of Visual Basic Express and was able to connect a new project to the .mdb files but I couldn't figure out how to open the other files which I need to actually use the application.
Ideally I'd like to run the .exe file, but it doesn't seem to be compatible with Windows 64-bit. Alternatively I'd be happy recreating it with the various components if I could figure out how to access them.
How to create a macro recorder that will save each and every keystroke, like the one in MS WORD, and save the saved keystroke in a database, and it will allow user to assign it a hotkey to paste the saved data anywhere in e.g. text editor, emails, etc!
View 5 RepliesI'm looking to call an excel macro (excel version 07) within a separate visual studio application (visual studio express 2010). Basically, a user clicks a browse dialog button to select a xls or xlsm file which is then added to a listbox. Next, I would like the macro to run when another button is clicked. The macro looks at the first column in excel and moves the listed .tif images from one folder to another. I referenced the excel libraries, but seem to be getting hung up on a few code statements (''''ERROR see code below). I would like to run the macro within visual studio for any selected excel file or add the macro somehow to the selected excel file and run it.
'Here is the button click procedure
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
filenames = lstFiles.SelectedItem
[Code].....
I would like to open the excel file after create the excel file. The creating file function is done, but the system unable to open the excel file. My coding as below:
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim misValue As Object = System.Reflection.Missing.Value
[code]....
I have Visual Studio 2008 Professional and I'm trying to make it so I can click a button to send the application to the System Tray and then click the icon in the System Tray to make the application come back.
Can anyone provide me a method or sample code to do this?
How would I open a program within Visual Basic 2010? (Like running "Application.txt" from "C:" within a Visual Basic project.
Public Class getfrom
Dim getfrom As String
Dim saveto As String
Dim download As Boolean
[code]....
i have create software using visual basic 2008 now i am stuck with several matter
i need a code that can open multiple URL in one time... when i click the button.. the URL also i can easily add or deleted it
How do I run files/application with standard editor/viewer?
View 1 RepliesI have a appliction developed on Visual studio 2003, .Net Frame work 1.1.After I migarted that application to Visual studio 2008, .Net Frame work 3.5, Visual Studio is crashed as opening some Visual basic designer files by Visual Basic Form Editor.The below is detail error message of Visual studio:
Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: devenv.exe[code]......
How do i open an VBS project in Visual Basic Express Edition?
View 1 RepliesI had a tree view in visual basic with many root and child.
I want to direct open file like xlsx, aspx even a folder each time i click at the selected node.
i'm creating a program in visual basic and i want to have a shortcut key that opens up another form even though my application is not the foreground window
View 1 RepliesI need to send a short string, (less than 30 bytes, but sent every second), from one VB application, to a Delphi application.. is this possible, using CopyDataStruct, WM_COPYDATA and SendMessage functions in Windows?
View 1 RepliesI'm using VB Express 2008 and I would like to open an excel file and save it with different name file. For example, I would like to open a file in
C: est.xls
And then I want to save them with different file name such as
C: ry.xls
I need to open an MS Word document and insert a picture to it using VisulaBasic 2008 by clicking on a button. I tried the automation code provided at this link [URL] but I can't find how to do what I want.
View 6 RepliesI have created a (kind of) 'Desktop' Form for the main basis of my program. Basically it is made up of 3 panel controls.
1. Holds all buttons which load the different forms (Like the windows start menu when expanded). name: StartMenuPanel
2. Holds Information on log in deatails. name: LogCheckPanel (very thin panel at top of screen)
3. Main panel which takes up the majority of the screen (where I want the forms to load). name: MainPanel
My aim is: When a button is clicked from the 'StartMenuPanel' the form will load with-in the 'MainPanel'.
I tried changing the start position to 'centre parent', but the panels are in the way so some of the childform is overlayed by the panels.
[Code]...
When I run this I get the following error: 'Top-level control cannot be added to a control'.
I hope I've explained this well enough.
We are testing the visual basic 2010 ee in one of the computing suites at a secondary high school. The installation was fine When we tried opening or saving a project it saves it into a default location i.e my documents. The problem withthis is pupils dont have access to c:. They their own drive on the network (h:) where they save their work. When i went and changed the settings in VB in tool > options.
View 3 RepliesI would like to display all open workbooks in a listbox.The problem being that there may be a number of Excel Processes running.[code]...
View 7 Repliesmy code is giving me a serious problems i thought my code has worked prefectly but theresulting valuesare not corresponding with the typed sentences in the text box .i thought when i had trimmed my sentences the code would work but thatis not the case now .i am requesting full assitance with my code is displayed here:
Dim txtInput
As
String =
[code].....
I'm a complete beginner to Visual Basic & am hoping to get a solution here.(VB version = Microsoft Visual Basic 2008 Express Edition)I'm trying to use VB to construct a GUI that runs an external application w/ arguments. The actual app is a DB builder that takes 3 arguments:
- a working directory ( flag = -d )
- an output directory ( flag = -o )
- an input text file
When I run the application from a DOS window it works fine as follows:
[Code]...
How to Exit Application in Visual Basic
View 2 RepliesI am looking for some tip on how to send keystroke of a mouse button click. Basically my requirement is when a list box is dropped it shows a datagrid, right now user has to click 2 times to get focus on datagrid, although i send a focus on datagrid when list is dropped from dropdown event still the focus stays on list box, i have to click 1 time to release focus from listbox then click on datagrid to set focus. I like to automate this 2 clicks with a keystroke. I dont see any mouse button click keystrokes.
View 4 RepliesHow do I go about enabling web features in my application? I'm wanting to put in a title in my application send it to imbd.com and scrape the site for the results to display in my application. Can anyone direct me to a tutorial or simply tell me how to go about implementing this type of feature?
View 2 RepliesWhat is the best way to zip a file with my visual basic application?
View 2 RepliesHow do I completely remove a visual basic application?
View 3 RepliesI was wondering if someone could tell me how to print text from a console application to the default printer.
View 1 RepliesWe are installing our application on windows 7. The application utlizes a Acces database. The application locates the database by looking in the registry under at HKEY_LOCAL_MACHINE / SOFTWARE / WOW6432NODE / COMPANY NAME / SOFTWARE NAME /STARTUP. When i install the application on windows 7 it places the a database where installshield directs it to and writes the path to the registry. However, somehow local copies of the database are showing up under the user profiles. (Example: c:/users/profilename/AppData/Local/VirtualStore/Program FIles (X86)/Company/SoftwareName/Data). We recently changed it to store the information in c:/ProgramData/Company/software however the same issue occurs and its creating local copies of the database and when the application runs it points to the local copy of the database. What we need is for all users to be pointed to and use the same database in ProgramData, is there something we are missing to accomplish this?
View 10 RepliesIt needs to be run standalone on NT How do you launch a VB app without VB being installed on the run-time computer? The VB executable will be on a CD. It can be standalone or as part of a bat file.
View 5 Replies