So I am attempting to do the following: Use VB to select multiple Files(Excel, Word, RTF, PDFs) and create one PDF from all these files. I need to perform this for approximately 2000 files with a different number of files going into each PDF. I have Acrobat 8 and Visual Studio 2008.
View 2 Repliesi want to create an atomated excel files actually this software exceLINX ( my research software) build in excel files.then this exceLINX software is the main software to trigger my data acquisition equipment. thus
i need a coding in VB/macro to trigger the excel in the exceLINX software to start my measurement for the experiment.
How to create automate (or) schedule backup files in vb.net application using window services
View 5 RepliesI'm trying to pull the creation date of all the files (1000+) in a folder on a local server to list in an excel file. I've been trying to use FileSystemInfo for this, but it doesn't seem to work to get the creation date of MULTIPLE files because it doesn't allow me to use wildcard characters to read all (not even sure if that's what I'll need to do).
View 1 RepliesI'm new here at Dream.In.Code, and this is my first question! To begin I would like to say I am new to Java but not new to coding, I am using Eclipse IDE 3.7 for Java and only have a basic knowledge of Java. I understand how it works; I don't know very much code... On to my question! I am wishing to create a simple JAR file for my own education/demonstration. Yet despite my searching and reading through my book I cannot find any relevant information about how JAR files are constructed. So, what defines a JAR file? How does one compile/make one?
P.S. I wish to work with JAR files because of their seeming simplistic nature and cross-compatibility. This is true, yes?My dearest apologies, I realise I posted this in the wrong forum. May a moderator move it for me?
I've written a loading program that writes text files to our database. The text files are dumped by another system every 2 hours onto on a shared network drive at my work. Here's the problem though - the files don't have a date/time stamp within them. I've been getting the date for each file from the creation date. That works okay, but when I've written loading programs in the past, I like to move the loaded files into a folder called "Loaded Files". That way, I can quickly see visually how many files I've loaded vs how many have not be loaded.
The problem this time, is that if I were to move the file into another folder, the creation date changes...a lesson I learned when I copied all of the files into a directory on my C: for testing. They all had the same date/time stamp!My question is, what's the best way to handle this? I don't want to move the files after loading them if it alters their creation date. I mean, what if I have to go back and load one for some reason, the date will be lost forever. I also don't want to write something into the software that has to check a file each time before loading it to the database.
I'm trying to monitor the creation of files from macros I have launched from VB.Net. The code below works and the event fires but nay code I insert in the OnChanged events gets this error:Error 7 Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class.
The error message makes no sense to me. I just want to call a SUB() on the same form or make a call to me WP class as shown. How do I do that?
Imports System.IO ' WP
Imports System.Diagnostics ' WP
' WP Monitoring
[code]....
I would like to fine-tune their work tool.The basic idea is to load different libraries etc CppThere in my working environment, such as files - *. dsm.Read the information from them is no mean feat.
View 2 Replieshow to create automated bookmark url using vb.net?
View 3 RepliesI'm new to VB and i'm using VS 2008, i just wanted to know if there's a set of instructions you can provide me that can enable me to auto login when you telnet on a node. That is when you telnet an ip address of that particular node it will automatically log on the system with your username and password already inserted in the instruction. So it wont have to prompt a screen saying insert username or password
View 1 RepliesI used to do all the database logic with SqlCommand and the Methodes ExecuteReader and ExecuteNonReader and never used something like DataSet or Datatable.
Dim dbcon As Data.Common.DbConnection
Dim cmdselect = dbcon.CreateCommand()
cmdselect.CommandText = "SELECT * FROM users WHERE id = 1"[code]...
This is sometimes hard to administrate. So I would like to use a more efficent way. May thought was to Query a DataTable, make changes to it and then call .AcceptChanges and all changes where wrote back to the Database. But this seems not to be the way it works?The method .Update requires that i bring with my own update command, if i have to do that myself, why using the datatable, dataset... anyway?How do you write your DB Backend?
With SQLCommands arrays and variables?
With DataSet, DataTable?
With a VisualStudio genereated template?
With Linq?
I have created a small game where you need to add value to be able to play. This all works fine and after every game a certain value is deducted.This all works fine but the extra credit is only added after you play again.Is there a command so I can execute a calculation (of the remaining value + the game winnings) ?
View 4 RepliesI'm trying to automate writing some data to an Excel spreadsheet (Office 2010, VS 2010), save the spreadsheet, and then open the spreadsheet for the user to view and edit. When I save the spreadsheet, an instance Excel is left running in the Task manager. No matter how many spreadsheets I create, there is always instance in Task Manager left.[code]...
View 5 RepliesI�m using Outlook to automatically send an email to my mobile phone. To bypass the stupid "security" bug in outlook I use redemption.safemailitem.Now, this has worked for years, but for some reason I can�t change the adress to which outlook sends the mail. Instead of sending to the adress in the code, it sends to an old adress that�s not anywhere in the code (but it was, ages ago)
View 6 RepliesI made a little VB app to shutdown a laptop after it has been powered on for 2 1/2 hours, and giving the user a little over 8min warning that it is about to be shutdown. However I have nothing in place to stop the user from restarting the device once it is shutdown. What I would like to integrate in this, is a sort of memory where if the user doesn't wait at least 30 minutes, the shutdwon will re-iniate immediatly.
I included the code I did so far.
Public Class Form1
Private Declare Sub Sleep Lib "kernel32" (ByVal dwmilliseconds As Long)
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code].....
how to automate generated send email using vb.net, example what time do you want to send the message. and set time before you leave and after that the system will automatic to generate.
View 3 RepliesI am trying for the first time to automate Excel 2007 using VB.Net. I have VS 2008 Pro running on a machine with Windows XP 64-bit. All updates have been applied.
Like other posters, my problem started out with Excel.exe hanging up in the task manager, even after calling the Quit method. I have tried to recreate the suggestions of using the Garbage Collector and Marshal.FinalReleaseCOMObject methods. The problem that I get now is that after about 20 seconds during which I can still see EXCEL.EXE in the task manager, I always get the Microsoft message box stating: "Microsoft Office Excel has encountered a problem and needs to close." asking me if I want to send or not send a report.[code]...
I receive info requests through email, generated from a web form, which I cant touch, I would, but I can't cos it's an external service. These emails have assigned differents template replies, which I, manually, use to answer them. For this company, this is obvious. For me is a machine work, it¡s totally automatic. So, why don't I set up a rule in Outlook? Because the reply-to address doesn't match with the real one. As it comes from our own server, the reply-to address is our own address.
i just have to answer with different specific templates I already have depending on different fields in the message and send this to an address that is also in one of these message fields. For more data, here is one of the messages I could receive:
[Code]....
Firstly please see this thread.>>[URL]..In the code in that thread the code calls on MS Word to check its dictionary and then report back TRUE / FALSE if the word is found or not.
Rewriting the code slightly for a Windows Form application with one Button on the Form I now have.>>
Option Strict On
Option Explicit On
Option Infer Off
[Code]..
I'm working on a automated content updating script. When a new update is entered I insert into a database table, and cache, the time of the update.
Dim setT As DateTime = DateTime.Now
modCommand2.Parameters.Add("?brmt", setT)
modCommand2.Parameters.Add("?lup", setT)
'databse code here
Dim myData As String = CType(Cache("ltu"), String)
' if it's not there, add it
If myData Is Nothing Then
Cache("ltu") = setT
Else
Cache.Remove("ltu")
Cache("ltu") = setT
End If
How to know if a mouse click is simulated or not? When mouse click send by a program or real mouse device
View 10 RepliesI have a problem where i need to write a class that will open a browser and automated the controls on it. I am struggling getting started with this.
View 2 RepliesI wrote this little function to allow me to pass an ArrayList of Strings and then based on the table passed to pre-build a SQLCommand like so
INSERT INTO table` (`column`,`column`) VALUES (`value1`,`value2`);
The function for this is here:
Public Function _SQLInsertBuilder(ByVal values As ArrayList, ByVal Table As String) As String
Dim commandString As String
Dim columns As ArrayList = GetTables(Table)
commandString = "INSERT INTO `" & Table & "` ("
For Each column As String In columns
[Code] .....
Now I know that much like mysql_real_escape_string() VB.NET has a Parameter ability to make querys safer. How could I parameterize the values during the build of the string.
I'm trying to make a program that will allow people to queue certain tasks at certain intervals. (i.e. the task is done every 15 minutes, etc.) They can make as many tasks as they want, at whatever intervals they want. How can I possibly make a task queue? Like, how can I queue up code that I already have made to be run every so and so often, according to what the user inputs? And, if 2 tasks are started at the same time, they will both still be done, it's just that one will be done as soon as the first one is complete.
View 4 RepliesI am trying to create an application that will make calls to an API. I want this process to be fully automated to run a few times a day. What kind of application in vb.net can be automated? I've created windows applications in the past, but never automated anything.
View 8 RepliesI am looking to make an application which records a database which tracks loans people have withdrawn and automatically emails/texts that person if there late on returning items. Is it even possible to do something like this solely in VB? And how would I go about setting it up.
View 3 RepliesI am trying to creating a windows application that can automatically sign into a website and download a file. I have managed to get it to sign in and reach the file, however a windows pop up box appears asking if you want to open or save the file and then specify a location. How can I automate this part?
Basically I want to schedule this to run each morning and download the file without any manual intervention.
Imports System
Imports System.Windows.Forms
Imports System.Security.Permissions
Imports System.Net
[Code]....
I am doing automation testing of a web application using selenium. While running automation testing of web application you encounter application errors. Is there any way to detect those exceptions. Specially exceptions that are on the page which causes the page to hang up as it is not finding the element it is looking for or page stays on the same page and waitforpage() function keeps running.
View 1 RepliesI have both Excel 2003 and Excel 2007 installed on my system. When I call oExcel = CreateObject("Excel.Application"), Excel 2003 is used in the context in my .NET code instead of Excel 2007 (which I need to be used). I have referenced the "Microsoft Excel 12.0 Object Library" but when the code runs, the 11.0 version is used.
Is it because I am using Visual Studio .Net 2003 that Excel 2007 cannot be correctly referenced or do I need to change a reference or setting?
I am having a problem setting up automated email signatures for a company through VBScript. Everything works fine apart from the rich text file creation. In this section for some reason a double underscore (__) always appears at the end of the e-mail signature when a user has their outlook set up for rich text. As you can see the script creates the signature in all the file formats needed.
On Error Resume Next
Dim qQuery, objSysInfo, objuserDim FullName, EMail, Title, PhoneNumber, MobileNumber, FaxNumber, OfficeLocation, DepartmentDim web_address, FolderLocation, HTMFileString, StreetAddress, Town, State, CompanyDim ZipCode, PostOfficeBox, UserDataPath, Maillink
Set objSysInfo = CreateObject("ADSystemInfo")objSysInfo.RefreshSchemaCacheqQuery = "LDAP://" & objSysInfo.UsernameSet objuser = GetObject(qQuery)
[code]....