Automating Process Of Opening MPP File And Saving It As CSV?
Mar 12, 2012
I need to find a way to automate the process when a user uploads a microsoft project file to a web application I already have created. The process will need to basically use the save as from project to save into a .csv file so I can use this to import the data to an SQL database (this is needed for custom reporting we already have set up using SQL). I need to automate this process because I will be receiving tons of project files, and if the process is automated the users will then be able to instantly see results.
Basically, is there any way to create or run an automated process that will save these project files as .csv files? Even if the csv files are not formatted correctly, I can find a way around that, just need to first get them into .csv files. The only way I could think of this is to follow the instructions listed below, but I would then need to automate a process to open the file and hit save so this works... [URL]
View 1 Replies
ADVERTISEMENT
Jul 30, 2010
I am automating a javascript web form submission process using webbrowser. I would like to use something without a UI but don't think httpresponse etc would do all that is needed. My code works but I think is not designed correctly. I think I should be breaking each step into its own sub or function. In its current state I think every time a page is refreshed/redrawn all the code is running which makes causes endless looping of clicking a link which is on its own destination page. What that means is click the link and the page refreshes with new information but does not navigate to a new page. So the code looks for the link and selects it over and over and over .... This I think needs to be subbed or done as a function instead.
Here's the code.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Part 1: Load elogging login page in Form_Load event
WebBrowser1.Navigate("[URL]")
[Code] .....
View 4 Replies
Aug 11, 2009
i would like to do FILE I/O without a dialogue. the file always be the same and the location will always be the same, therefore i dont need a dialogue. i would like to know how can i do this? what is the code to open, write, and save to a file without the dialogue.
View 2 Replies
Jun 10, 2011
i'm having trouble opening a text file to process and order the data in it. When i try to read the first line of characters an error message occurs saying: 'Variable words1 is used before it has been assigned a value.' I dont understand what i am doing wrong when opening the file. Also, I am sorry if this is a rather basic question.
[Code]...
View 2 Replies
Oct 25, 2009
I have an Excel file with utilizes macros to allow a user to enter names of people and then double click on cells to enter ratings via radio buttons. When I open a blank file and enable the macros, I can add users, rate their skills using the radio buttons, etc. with no issue. I then SaveAs the file and continue working on it. once I Save and CLOSE the file, then go to re-open it, the trouble begins. Keep in mind, there is no alteration to the macros directly. Just entering data and using the form as intended. Here's what happens.
I reopen the file.I enter in the name of a person on one line. I go to the first box - double click on it.It is supposed to pop up a dialog box which allows me to choose a rating via radio button (as I had been doing before I closed the file). Instead, in that first column of ratings, it instead gives me the following error:
Runtime error '1004'Unable to set the LineStyle property of the Border class
When I hit "debug" this is the code it points to:
If ActiveCell.Column = leftb Then Range(Cells(ActiveCell.Row, leftb), Cells(ActiveCell.Row, rightb + 1)).Borders(xlEdgeTop).LineStyle = xlContinuous I have no idea why this would not work when I re-open the file!
note that when I go to click on the subsequent cells (there are 8 cells in which you provide ratings, moving across the columns with each cell) - the 2nd through 8th cells function fine. The dialog box pops up, the rating can be selected. it's just the FIRST cell that gives the issue What would possibly be the cause of this? We need users of this form to be able to save, close, and re-open it if needed.
View 1 Replies
Jun 22, 2010
I need to logging the process list and saving it as a text file. I need it so that it will log any new program that opens up. Basically monitoring the process list.
View 2 Replies
May 28, 2010
ANyone knows the code for it. I have encountered many options but each one lacks something it seems to make them all work together.
View 10 Replies
Mar 7, 2010
I have a program, and writes data to a text file... with a template inside...
All works fine, and saves fine...
I'm wondering, how could I automate the filename it saves?
Currently it saves the text file as NewOrder.txt
I would like it to now realise that there is a NewOrder.txt already there, and save as NewOrder1.txt
Then when the program is closed, and I go to do a new one, it will say ok NewOrder2.txt
Hoping this is possible, I've been reading up on my.settings but I can't really find what I'm looking for...
View 5 Replies
Sep 1, 2010
First time user on here, basically have been teaching myself VB and I enjoy it quite a bit! Basically I have a program now that has the File Drop-Down Menu with Open and Save options. I want to open and save in a .txt format. The open command will need to place the text in TextBox1 ; and the Save command will need to take the text from TextBox2 and save it as a .txt. I have gotten to the point where it will save it to a specified .txt file, but I would like the user to be able to "browse" the computer for where to open from and save files to.
View 4 Replies
Dec 30, 2008
I have developed a tool(vb.net), it provides you to save the process, the next time when the user click on the saved process(ie the saved icon thing), it should open the appropriate process, now it just opens with tht exe,, how it can be done i am not aware of the tech terms of the these process type.. I hope i conveyed wht is my requirement,, Take for eg, When we save a word doc, it saves as .doc Next time when we click on the .doc the document opens. Like that process has to take place..
View 1 Replies
Jun 14, 2009
within my project i need to open and save some files. i wont go into detail as theres no need. what i need to do is open the files from the install directory, which could be where ever the user puts it! i also need to be able to open them whilst im building too. if i hard code the directory in then it will fail..obviously
View 3 Replies
Jun 11, 2011
I am opening a word document and saving it as html with the following code. If i set the objWord.Visible = False , i get an error: Exception from HRESULT: 0x800A1098 , which i believe indicates there is nothing to open.
Protected Sub btnUpload_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim objWord As Microsoft.Office.Interop.Word.ApplicationClass = New ApplicationClass()
If Not (fUpload.HasFile) Then
[code].....
View 2 Replies
Jun 11, 2009
A query concerning opening and saving a file.i have two commands, one the opens and another that saves [the same file].i'm using the StreamReader and StreamWriter methods.issue is this:if i comment out the open code, the save works fine.if i comment out the save code, the open works fine.if i let both run together, i get an error, usually with the save saying that the file could not be accessed. note, before anyone asks, i do close the file after saving or opening what could be the problem? open works fine, because it usually happens prior to the save, and then save process cannot access the file..?
View 3 Replies
Dec 17, 2010
I have Hotspot Shield and I want it to open the process, then back to focus to my application, and wait about 15 seconds and then kill the process. How do I do that
View 1 Replies
Aug 12, 2010
Is this even possible? tried several ways and i have no idea how to continue. Using vb.net in vs 2008 and itextsharp This is my code for creating the pdf.. also have alot of code to fill it
Dim doc As New Document(iTextSharp.text.PageSize.LETTER, 90, 80, 80, 90) Try
PdfWriter.GetInstance(doc, New FileStream(Server.MapPath("PDF.pdf"),FileMode.Create))
But this saves the pdf.. can i do it any other way?
View 1 Replies
Jun 3, 2011
I need to open a .xlt for editing, like so:
System.Diagnostics.Process.Start("Template.xlt", "Editable=True")
But I don't know the correct switch in Excel. This is the same as right-clicking on an .xlt and choosing "Open", whereas the default action is "New".
View 1 Replies
Mar 28, 2012
I have an windows application (created using visual studio 2005) and it also is using an autocad .api. The user runs Autocad and the user enters various commands that will open forms. One of these forms, contains Windows.Forms.LinkLabels with paths to the autocad drawing files they've attatched (.dwg). When they click on the link, I need the file to open in the existing Autocad they already have open; however, the problem is that it's opening a new instance of Autocad and placing the file into it. How can I make it so it opens in the existing Autocad program already open? [Code]
View 4 Replies
May 1, 2011
I have an application that takes quite long to save the data as it has to write over intranet.I want to run an animation showing that saving is in progress. How to do it?
View 1 Replies
Sep 21, 2007
When I load my solution and compile it after first starting the IDE, everything works as expected. After changing source and recompiling, I get the following compile error:
Error 11 Unable to copy file "objDebugCAMDRS.Library.dll" to "binCAMDRS.Library.dll". The process cannot access the file 'binCAMDRS.Library.dll' because it is being used by another process. CAMDRS.Library.
After closing Visual Studio 2005 and reopening the solution I can compile again successfully. This is an old solution that has been fine for a long time. I just recently changed computers and reinstalled everything.I am running win XP Pro sp2, Visual Studio 2005 sp1.
View 22 Replies
Feb 12, 2012
Currently I am saving data from my applications by saving a text file via a stream reader as a string. I have come to a problem. In my current application, I have an array of the following structure:
[Code]...
View 7 Replies
Feb 1, 2012
My program writes to a .txt file (and this is the ONLY program that writes to it) in a thread (with lowest priority), but every now and then it gets an error "The process cannot access the file because another process has locked a portion of the file" when it executes this code: swLog.WriteLine(sPacket).Other program reads from the file, not write to it, why do I get this error, and how can I get around it, or what shall I do when I get this error since I can't write to the file ?
Class
clsFile
Private swLogOrig As StreamWriter
[code].....
View 5 Replies
Sep 1, 2009
I am getting an error with this code.
The process cannot access the file 'C:UsersdavidDesktopTest Folderdavid 2.xml' because it is being used by another process.
how do i end the prosess after I create the file? Or am I creating it in the wrong manner.The underlined line is where the error ocures.
Public Sub AddDTData(ByVal value1 As String, ByVal value2 As String, ByVal filename As String)
dtUser.Rows.Add(value1, value2, Now.Date)
If My.Computer.FileSystem.FileExists(filename) Then
[code]....
View 4 Replies
Sep 13, 2011
I try to open a text file and write in some text, when i run the program it says the following error:The process cannot access the file 'D:VB projectsCategory_Characteristics.txt' because it is being used by another process.
THe code is as follows and the error hits in line :
Dim objWriter As New System.IO.StreamWriter(FILE_NAME)
-----------------------------------------
Dim FILE_NAME As String = "D:VB projectsCategory_Characteristics.txt"
[code]....
View 5 Replies
Aug 31, 2009
How can i access a file through FileStream which is being used by a window service. Actually i am trying to access a file which is also being used by our window service. I need to read data from this file. I am using below code but also getting following error:
Code:
Dim fs1 As IO.FileStream = New IO.FileStream(psPath, IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.Read)
Dim sr As IO.StreamReader = New IO.StreamReader(fs1)
sData = sr.ReadToEnd
Error: The process cannot access the file 'FILENAME' because it is being used by another process.
I tried changing FileShare.Read parameter to FileShare.None but it didn't work out. I also read below post which says that it is not possible but i think there is a way to read it like if you open a file through Firefox but still window service is accessing it.
View 2 Replies
Oct 27, 2011
I am working with saving and deleting images. What i really want to do is check and see if an image exists in the destination folder and if it does automatically overwrite it. i couldnt figure that out so i figured i would look to see if the file was there if it is Delete it then write the new file..The issue is i keep getting this error.The process cannot access the file "FileName" because it is being used by another process. [code]
View 5 Replies
Dec 4, 2011
The process cannot access the file 'C:UsersJoshuaDocumentsTest1.txt' because it is being used by another process.Now the Problem. When i step through my code, it will do as intended, e.g. clear all contents of test1.txt. when i run it at run time it throws this error. The reason for it throwing an error is the text file is reading string, int, string, and the txt file has a string including in the int part, so i'm making it so you can empty a corrupt file.
vb
Imports System.IO
Public Class Form1
Private norepeat As Boolean
[code]....
View 3 Replies
Jan 12, 2010
this process problem only happen when i add the line below (red colored (line 12 and 19))the error pointed at the colored (blue (line 32)) at saving the image to the database
here's the code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
OpenFileDialog1.Title = "Set Image File"
OpenFileDialog1.Filter = "JPEG Files|*.jpg"
OpenFileDialog1.DefaultExt = "bmp"
[code]....
View 1 Replies
May 14, 2012
when i'm running the update it shows the error The process cannot access the file 'C:Documents and SettingsMackyMy DocumentsVisual Studio 2008ProjectsMarcelo 2.2.3MarceloinDebugStudentsMIC953867.jpg' because it is being used by another process.
[Code]...
I can save new student information with picture.. but when it comes in updating the picture these codes didn't work......
View 2 Replies
Sep 16, 2010
After I managed to add a picture in a database, I wanted to add two but it doesn't work.Here is my code:[code...]
View 3 Replies
Mar 11, 2010
Imports HR.EZTwainLibrary
Imports System.Runtime.InteropServices
Public Class frmNewScan
[Code].....
this problem occurs when i scan an images for the second time. i think the error is my filename(C:MyImage.jpeg). how can i have a different filename thru coding or how to delete the tempory filename of an image to make scan again.
View 5 Replies
