I'm unsure if this should be in Office Automation or here, but I opted for here because I'm creating a VB.Net program to handle all of the office automation and my questions are a combination of the VB.net portion and some of the VBA formatting. At a high level I receive a file in email, put the attachment in a monitored folder, import the text file to excel, format the excel, and then email the excel file to a list of recipients. [code]Obviously the items above that are not complete are the bulk of the work, but I wanted to get some advice on what some of you think would be the best way to approach something like this. The import and formatting of the file are causing me some problems because I just can't decide what would be the most efficient way to do this. Having a template excel that contains all of the formatting already done for me and attempting to transition the data to this document (no clue if/how I can do this). Is it even feasible? Have the template already created and then import the text file to a new excel file, then transition that data to the excel template?
Something I thought about, in terms of formatting the document, was to record a macro of me doing all of the formatting that I'm going to need and then attempt to convert that macro into my vb.net code, but I'm not sure if that will work. I will need to verify that the text file comes in the EXACT format every time correct?
Imports System.ServiceProcess Imports System.IO Public Class fswService
[Code].....
2 problems: first, intellisense error saying: 'fswService' is a type and cannot be used as an expression. second, I can not figure out a way to pass on to the service the path of the folder to watch (which is stored at My.Settings.userPath).
give me a function or class which have properties ?For example:I shared a folder (C:shared)
Dim clsObj as new clsSharedMonitor("C:shared") 'so that I can get its properties like: clsObj.FullPath() 'Full Path of folder that client are accessing clsObj.ClientIP() 'IP of computer which access to server
I am working on a project where I want to convert all the mdb files in a folder to xls files in C# or VB. Here user will select folder and then all the mdb files in that folder should get converted to excel files having same name. Also mdb file can contain many no. of tables and and I want each table in mdb file must be converted to different sheet having same name as that of table.
Having difficulty with the module below failing on line 21. It is telling me: The system cannot find the file specified. (Exception from HRESULT: 0x80070002) Basically what it is designed to do is look for a directory, if that exists then look for a file in that directory. If both = True then it should open the folder to browse the files. I believe the issue is with the "Program Files" being 2 words since the script runs using a root path, but I'm not sure how to format the path correctly to make it work?
I created a vb.net 2008 application to windows 7 with some functions that monitor a folder within "Programs". Folder you created during installation of this application. But every time you launch the software (the exe, after installing the client package) I get UAC and I ask for confirmation. I tried to edit the manifest (with admin user) but it always comes out. I would like to depart immediately launch the EXE application, without uac.
I want to be able to monitor a folder, and anytime a file is placed in it (in this case, a .jdf file) I want to edit a string within the file (it's just a text file), then save the file onto a network path and remove it from the hotfolder into a "done" folder.
I am trying to use the filesystem watcher to monitor a folder on a ftp site for files added. Does anyone know how to do this? I have even read that the filesystem watcher was not meant for ftp's but rather local monitoring, which doesn't make sense to me.
I'm trying to write a program where people can click a browse button, click a file to copy, and then click a second browse button and click a destination folder. I've tried
and get the error "Could not complete operation since a directory already exists in this path 'C:UsersSamDesktop'."
FileCopy TextBox1.Text, TextBox2.Text gives me "The target file "C:UsersSamDesktop" is a directory, not a file."
Both methods work if I put C:UsersSamDesktop'filename'.'extension' in the destination. But I want the user to be able to select the destination without having to type a new file name.
This seems almost to easy to ask, but I must be missing something simple.I've added a folder in the project explorer, by right clicking>add>new folderBut when I run under debug, I am unable to save to that folder as it's not in the debug folder, I get:"A Generic error occurred in GDI+"In this code, the first line saves the bitmap fine (in the debug folder), the second line fails with the above alarm..
"vb" If Not value Is Nothing Then value.Save(Application.StartupPath & "Image.bmp") If Not value Is Nothing Then value.Save(Application.StartupPath & "ImageImage.bmp")
Im trying to make a game launcher, and I want to have it first see if there are updates. I know this is a really simple problem, but I can't figure it out. This is the code. I want it to read the link.txt and version.txt in the same folder instead of C:/ Oh and make it so it unzips the update into the same folder, and replaces the old files for the new ones.
I have a program that reads the version of a program off of a txt file in the program folder and off a txt file hosted off a site and compares them. If it's different it downloads the update, if not then you can use it. My problem is when I update it. It doesn't replace the version in the file. How would I update the version on the txt file in the program folder when it gets updated.
I want to make a process monitor tool with WMI that monitor the processes created or deleted, but the code will not work. Note to reference System.Management,
Can I monitor the registry for changes similar to how sysinternals process monitor does it in VB? I have checked many different articles and C# samples but not come any closer to getting an answer, I would like to know if there an easier way (a VB sample perhaps)that you folks can share. Ultimately I'd like to be able monitor other things too like file system, processes etc but wonder most about how the registry can be done in VB...Would using system.management be a start? Or WMI? if so is there a nice VB sample..
I have a vb.net project that has 2 exe's that get built as well as the installer. The two exe's share a bunch of common files. I do not want to have two copies of the common files or mess around with having build events that copy things around (if possible).
My method was to create two projects in the same folder and have them point to the files they needed. This appeared to work until I tried to compile both apps at which point I get an error in a file called Application. Designer.vb. It seems that project files create this file in their folder and when I have two solutions in the same folder they conflict. So my next effort was to create the second project in it's own folder and just add the items as needed. The problem here is that VS2010 doesn't hold a link to a file in a different folder it copies the file to the new project folder. What is the vs2010 way to get this done?
I have used the following code too save a notepad file; [Code] The code saves files but only in the 'Application.StartupPath' folder, the save dialogue starts in the correct place a quizzes folder inside the debug folder but files can't be saved here or in folders inside it, even though you can browse them in the dialogue. I want it saving where navigated to in the dialogue.
i'm still needing help to my "Download file names into Combobox1 from webserver's folder".I have folder at my webserver http://127.0.0.1/FolderName/ and inside my folder is alot of .txt files and here is few of them: A,B,C and D.txt file.
So when form loads i want my application download file names what are in my webserver folder TO Combobox1 then Combobox1 may look like this.
I have developed a small utility that can change the PC's brightness through the use fo a slider. I have achieved this with the SetDeviceGammaRamp API and the RAMP structure.As it is, it works. I am attaching the code here as well, so that you can see it works.Now, the problem is : At Form Load I am getting the current brightness settings for the monitor :
Private Sub SetBrightness_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load GetDeviceGammaRamp(Me.Handle, Ramp1(0, 0))
I want to make a Small Traffic Monitoring Program for our house. Since in South Africa Internet is One of the many things that are way overpriced I want to monitor each computers traffic with a small Program since even when we are not at home for a day we might easily use 2 gigs of data. Somewhere a computer is downloading like mad?For a 4 mib(you only get 3.5 at most) line here Will cost you around R413(36 GBP/ 58 Usd) per month and One gig of data around R19(1.68 GBP/ 2.70 Usd) - R112(9.9 GBP - 15 USD).Ok enough Complaining. Each Computer in our house Connects to the internet either with lan or Wlan So is their a way to get how much traffic passes through one of those OR is there a way to monitor the total internet traffic regardless of how it connects to the internet ?
Visual Basic 2008/2010 - Save Page As, create a Folder, upload the folder to a specific ftp site I am working on this vb app that will goto a specific site, click on a button(i am still working on the button process) do a save page as, create a folder, save those files to a folder and then upload that folder to a ftp site.