I'm not getting make VB run a macro of a program that I use in the job(WinFIOL) that is a non-Microsoft program.I created the macro in the WinFIOL, and put the Hot Key Ctrl+F2 to run it; I make a program with VB, that calls the WinFIOL (the program that contains the macro), but I don't know how to make VB runs the WinFIOL macro.
View 5 RepliesI already know how to check what buttons/mouse event have been issued by the user. What I need to know is how to reissue those commands at the same intervals. Reissuing the commands is easy to do, but issuing them at the same intervals as I have done? Not so easy for me.
So let's just say I press LMB one minute after I press a button that starts recording what I've done, then RMB 15 seconds later, if I wanted to click Playback and it would do these actions at the same time that I did them after pressing Record, how would I make the program issue the commands at those specific times?
I can't belive I can't figure this out but Im trying to make a macro type program. I just need to computer to press a key. Here is my outline:
Step 1: Open Crafting Menu
Key: T
Step 2: Select Farming
Position:
Step 3: Select Crop Field
Position: User Defined
Step 4: Use Optional Yes or No
If Yes Position:
Step 5: Make Number
Position:
[code]....
I am trying the whole day to make an excel-macro run through VB2008. The macro in excel calls another file and extracts two values in order to draw a graph. The VB code should run the excel macro everytime and import the graph. However, I have a problem with this line : oExcel.Run("Macro1")
[Code]....
I need to open an excel file and run its macro from VB.
View 1 RepliesI'm have a program (GUI) that interfaces with excel to execute macros. We're using Microsoft.Office.Interop.Excel to call/run the macros and this works great.What I can't figure out is a good way to cancel the macros from the GUI.One idea we had was to use the excel.application variable that runs the macros to write a "stop" value to a specific cell in the workbook, and in the macros (they are all mostly loops), check for the "stop" value in that cell. This crashes my GUI with this The program '[2188] BVLReports.vshost.exe: Managed' has exited with code -336589910 (0xebf00baa).And excel gets tied up, and won't respond. I know how to Exit Sub from within the macro if the "stop" value exists, so I don't need answers on how to check/cancel from inside the macro. Any ideas on a better way to write this "stop" value or a better way to cancel the macros externally?
View 2 RepliesMy Project is : Calculate Lowest price of Nutrient I Need to use Excel with VB.NET not VBA.[code]...
View 2 RepliesAs you read this, though I have pretty good experience in C++ and Java, eep in mind that I am a complete beginner when it comes to VB. :)Here is one idea of what I want to do:
Option Strict Off
Option Explicit Off
Imports System
[code]......
I cannot find a way to make a program that I write make a shortcut in the start menu for all users.My final goal is to make an MSI and deploy it in group policy to all users on a computers OU. Is this possible?
View 5 RepliesHow do i make my button open a program and make it windows size?
View 6 RepliesIf e.CommandLine.Count > 0 Then
Dim IncomingCommand As String = e.CommandLine.Item(0).ToString
If IncomingCommand.Substring(0, 2) = "-1" Then
form1.close()
End If
End If
I am trying to make the program close if the -1 string is sent with the program. See my installer allows for me to run certain programs before it actually installs, but it doesn't shut down copies of the program itself. So I have a next startup instance set to shut the program down if the -1 is received. But if the program is not running it starts up instead. This is not desired. form1.close doesn't work. e.cancel = true doesn't work, etc etc. What can I do to make the program not start during this instance.
I made vb.net program for 1440x900 resolution, if i run my program on 800x600 or 1024x768, my program's resolution is bigger then windows, so i have problem with resolution. Now i want to change my program's size and i am interested in, wich resolution is correct to make program, 800x600 such as minimum?
View 9 RepliesHow do I make a program that opens a file in the folder the program is stored?
View 6 RepliesI want to make a program that searches for a RGB color and clicks on it, WITHIN the program.
View 2 Replieswhat im trying to do= make a program that will make multiple accounts
[code]...
ok what i type in textbox(es) "1" i want it typed on a "3"{a website=www.justin.tv/signup} when i hit the "2"[button1]i really dont have any idea what im doing i know ill need to have a webrowser to load the justin.tv/signup but i have no clue what the name of the boxes are called on the webpage
Me and a friend are making an app which we need to play a sound when Form1 is started. How do we do this? I don't mind code.
View 2 RepliesHow to make a computerized examination program using vb.net...
View 1 RepliesI am new the Visual Basic and just downloaded 2008, and I am wanting to make a program with a button that will run a .exe that is in the same location as the program/
View 2 RepliesIm having kind of trouble looking for this info, but i created a POS program that when i install it, it install under Local SettingsApps2.0labla
So what i want to know if how can i make my system install like any other program, "Under Program Files/POSystem/" like so
I am making trial version of my vb .net project but it is not counting the days , date and time . Can u plz give me any suggestions to make it correct. [code]...
View 1 RepliesI made a simple vb program with vb 2011 express. I want with a simple button click to open a prototype Powerpoint presentation and running in background a batch file.So far,so good... I want to do a third step. Into the "test.ppt" i have already made a macro with vba and i want to execute the macro.
[Code]...
Ok, so I'm trying to make a program in VB that will bring up another program (Like MSN Messenger, etc) and press a certain button on that interface (i.e. an "OK" button, or File on the menu at top). How would I be able to do this?
View 1 RepliesIs it possible to only make a program open when another program opens it? so when someone tries to open it themselfs by clicking on it, it pops up a error message?if so then how would someone go about doing this in VB 2008?
View 9 RepliesI am trying to get a macro convert from VBA over to vb.net and I am getting a type mismatched error and can't figure it out.
This is the code.
Sub SortRawData()
Dim oSheet As Excel.Worksheet
Dim oRange As Excel.Range
[code]....
I wrote a UDF to enable users to run Macro`s in excel here is the function below
Private Sub RunExcelMacros(ByVal Path As String, ByVal MacroName As String)
Dim oExcel As Excel.Application
Dim oBook As Excel.Workbook
Dim oBooks As Excel.Workbooks
[code].....
And to use it just call the udf with the 2 parameters like below
RunExcelMacros("c:MyExcelBook.xls", "TheNetMacro")
just remember that you have to have an excel sheet with a macro named TheNetMacro or any other name you want to give it.
I want create macro for replacing. But my problem is how to use regular expression in Visual Basic's macro for Visual Studio?
document.Selection.ReplacePattern("test{[^']+}test", "testAAAAtest")
Doesn't work.
Using word 2003, merging to a new document. I want the macros in the template to be in the new document. I'm using the macros to control printer desitination, each template can go to a different printer.
View 1 RepliesI need to make a difficult makro.When the makro has been activated (will happen via a button), it has to add a header and a footer to the document.Also page1/frontpage needs a different header and footer than all the other potential pages.So far, I have accomplished making page1/frontpage to work - somewhat.I did this by recording a makro, where I'd enable headers and footers, write the needed data and then stop recording.Afterwards I edited the coding so it would fit a little better. Mostly it was junk-code cleanup.
[Code]...
I have an excel document that has a button that i need to activate through vb.net.
View 5 RepliesI call an Access macro from vb.net like so: Acc.DoCmd.RunMacro("Macro1")
The Macro in Access has many OpenQuerys and Msgbox with a message saying "data done" at the end.
When I execute the macro from vb.net, it shows the data done message and then done. However, when I analyse the table's to see if data has been appended, it hasen't.When I run the same macro from within Access, it works fine. It does show many messages like "You are about to run an append query that will modify data in your query" and I hit yes and does take slightly longer, but it does do it. In VB.NET, the only message I get is the final messagebox.
[Code]...