Determine Other User Of Excel File?
May 27, 2010
I am currently using the FileOpen method wrapped in a try/catch block to determine if a particular Excel file is currently in use or not.
When my app tries to access the file, I would like to be able to notify the user who it is that already has the file open. If I try to open the file in excel while it is in use, the message that Excel provides includes the network login of the user that has the file open. Is it possible to get this information via code so that I can tell the user of my app the login of whomever already has the file open?
View 1 Replies
ADVERTISEMENT
Jun 14, 2009
I want catch excel file close event
Like this :
if Xapp.exit = true then...
View 5 Replies
Jan 10, 2009
how i can able to determine if the user intended to delete a file. What im going to do is this application will be placed in a certain folder together with some files. And this program will determine if the user inteded to delete a file within the folder.
View 2 Replies
Apr 26, 2012
My program opens 4 excel spreadsheets updating info. I update one at a time and then close it before opening the next one.I want to add code to my program to test if the file is already open, before trying to open it. Occasionally someone will have one of the files opened and it causes a crash. If I test to ensure it is not open, then I can avoid this.
View 7 Replies
Mar 31, 2010
I have a excel file place on server. I am using a application which written by VB.NET to open file in read only mode. User 1 open file in read only mode. How can user 2 detect that file is open or not status?
View 2 Replies
May 26, 2009
How do I specify a path for current user to export excel file? My goal is to set a path as "MyDocument" of current user to export excel file when "SaveFileDialog" is opened.
Below is my code.
With UC_PAY_STATUS_U
.SaveFileDialog1.Filter = "Microsoft Excel|*.xls"
.SaveFileDialog1.Title = "Save as Excel"
.SaveFileDialog1.FileName = "Payroll" & Microsoft.VisualBasic.Strings.Replace(Now.ToShortDateString, "/", "")
.SaveFileDialog1.ShowDialog()
[Code] .....
View 2 Replies
Apr 10, 2012
This is a simple fragment of my code:
[Code]...
The last line throws an exception "Cannot open file" with certain end-user profiles. It works perfectly fine when executing from an Admin account. I just cannot figure out what user privileges and access settings may cause the error. Note that it also works with some end-user accounts (not admins). What missing user rights can cause this?
View 6 Replies
Mar 5, 2009
I'm currently generating some excel files using vb.net (2008). I want to protect the workbook or sheet inside, so that the user cannot edit anything within the file.I tried some options from MSDN but no luck and some other forums but no luck.The following is my last few lines of code in the program.
Code:
ExcelReport = New Excel.ApplicationClass
ExcelReport.Workbooks(1).SaveAs(ExcelFileName)
I basically don't want the user to edit anything inside the file. Perhaps a printout is allowed.
View 1 Replies
Feb 10, 2009
I'm trying to save an excel file:
vb.net
xlWBook.SaveAs("J:DOWNLOADS.xls")
xlWBook.Close()
xlApp.Quit()
If the file already exists excel will open an message box and ask if you want to overwrite. If I click yes, it works. If I click no or cancel, I get an error:
Exception from HRESULT: 0x800A03EC
How can I tell what button the user clicked?
View 3 Replies
Dec 20, 2011
I'm in the process of adapting a current program that I've created to automate it. **Current State***User selects an excel file and the contents are loaded into a DataGrid User can select which environment to run their query against (stage/prod) Program completes processing and updates datagrid with new values User can export datagrid to excel What I'd like to do is centralize the program on one computer and have it monitor a network folder for creation of a specific file type (*.xls or *.xlsx). If one of these is created in that folder then I want to add that file to a queue for processing. Once done processing I want to send the results as an attachment to an email to the user that created the file. After a file is processed I would like to remove it from that folder as well (into a diff folder of completed items).
[Code]...
View 8 Replies
Sep 8, 2009
I have an application that automatically updates addins for excel from the server to all the computers on our network. right now all i get is an error if excel is open, but what I want to be able to do is check if excel is open on each computer first and give the user a chance to save their current work then close excel. otherwise i cannot update their addins if excel is open.
View 3 Replies
Dec 2, 2009
I have Visual Studio 2008/VB application that opens Excel workbooks, reads all the sheets, and writes some data to a SQL database. I need an easy way to determine if a sheet has any data on it. By default most books has three sheets (Sheet1, Sheet2, Sheet3) and usually, but not always, my books have data only on sheet1. But i need to look at alal sheets to check for the existence of data. I know I can do a nested for loop from 1 to columns.count and rows.count, but that would take a good bit of time since those numbers usually are something like 256 and 65K.
Is ther some easy way to determine if there is any data on the sheet? If there is, is there an easy way to find the "first" cell with data in it?
View 8 Replies
Jun 26, 2009
is there a way to determine what theme that the end user is using.for example im making a program where the glass is extended so if the end user uses the program on a computer that is not using the vista aero theme then the program will look different then it would if they were using the aero theme.how would i check to see if they have the aero theme and could i set the theme to aero from my program?
View 2 Replies
Mar 27, 2012
I need to be able to validate the windows password of the account that is currently logged in. I've managed to do this when the unit has a password. But if it does not have a password, passing an empty string does not work. It fails each time.I've been looking around, but haven't been able to find much on this. Does anyone know how to determine if the user password is empty?[code]
View 9 Replies
Jan 30, 2012
Possible Duplicate: How can I programmatically determine if my workstation is locked? Checking for workstation lock/unlock change with c#
I would like to determine when a Windows (XP, or 7) machine is locked, and unlocked.I would like to create a timesheet activity logging app, and pre-filling times in, with lunch, breaks taken, etc, would be very useful.Is it possible to pick up an event that fires when the Windows Operating System is locked and unlocked ?
View 3 Replies
Sep 25, 2008
Is there a 'simple' way to determine the current user's email address ? I want to automatically send an email when an application detects an unhandled exception, but would like it to come from the current user.I found this on the net and haven't yet worked out what its doing (although it seems to work). Unfortunately, as I'm not sure how it works, I also don't know what drawbacks there are to this technique.[code]...
View 5 Replies
Jan 25, 2012
I'm writing a control that needs to check a property of the form it's placed in.Is there a way to do that?
View 1 Replies
Mar 2, 2010
In reading various answers regarding "masked TextBox Control, am I to assume that the masked textBox control uses a mask to determine what characters the user can enter into the control?
View 1 Replies
Nov 12, 2010
I'm trying to get an application to determine which operating system the user is currently running and use that to decide what to do. For example, a user uses the program and they're using Windows 7. I want it to know that and use predetermined variables throughout the program for Windows 7. Likewise if they're using Vista or XP/Macintosh.
View 4 Replies
Dec 8, 2011
I'm working on a problem where i have to allow a user to input a word or phrase and then determine if it is a palindrome (a words that reads the same forwards and backwards) . It also says that the program should use a Boolean-valued function procedure named IsPalindrome that returns the value True when the word or phrase is a palindrome and the value False otherwise.
View 3 Replies
Nov 28, 2011
I've found various C# examples here, but I can't seem to get a VB version working.I want to be able to pass a simple variable into a User Control to determine whether it shows a certain section of data.It's basically a Customer Data form, and in some circumstances I need to show a line with the customers account number and sort code, and in some I don't, so my user control:
<controls:customerForm ID='customerForm' showBankDetails="no" runat='server' />
But I can't work out what to do with the showBankDetails variable in Code Behind to stop it from rendering that section, or simply hide it with a CSS snippet.How do I access that variable in the code behind using VB.NET?
View 1 Replies
Mar 8, 2009
I am creating a project with VB2008 Express Edition. The end result will be a CD containing tech manuals in pdf format which will be accessed via various buttons on a form. I am going to include Acrobat Reader Redisributable on the CD which the user can install by pressing a button on the form if required. What I want to do is this:- When the user inserts the CD into the PC, the form will load.When the form loads, I want to search the users PC to determine if Acrobat Reader is installed.If the Acrobat Reader program is not found on the system, then display a MessageBox to inform the user to install the reader from the CD.Would this involve searching the users registry? I would need to insert in my Form1_Load sectionTarget systems would be Windows XP/ Vista with programs on the C: drive as default.
View 4 Replies
Mar 15, 2010
I have numberic updown control in my app. There may be times when I want to programatically change the vlaue (in which case I don't want to ValueChanged event handler code to run). There will certainly be times when the user makes a change (in which case, I would want the event handler code to run).
[Code]...
View 5 Replies
Aug 22, 2010
I am modifying some code I found here to test to see if a user has scrolled to the end of the control. In this case the control is a Crystal Viewer but I posted here because I think the issue is based on the vertical scrollbar not the Crystal Viewer itself.
The code flags an error at
Me.CRViewer.Controls.OfType
Indicating 'OfType' is not a member of 'System.Windows.Forms.Control.ControlCollection'.
I understand the concept that I can't reference something that it is not but I don't know how to fix it. The original code was for a DataGridView.
The ultimate goal (not finished) is to find out when the user has used the mouse or possibly the scroll bar itself and if it hits the bottom of the page of the viewer, then trigger a new page so it looks like they can just keep using the mouse to scroll.
Public Sub New()
Me.InitializeComponent()
Dim vscroll As VScrollBar = Me.CRViewer.Controls.OfType(Of VScrollBar)
[Code]...
View 9 Replies
Nov 22, 2011
I have been doing a lot of reading on this topic and most folks seem to agree that having Excel is required to use the COM Interop libraries. However they are never specific as to where that should be installed. Does it need to be installed on the machine I am developing on or does it need to be on every machine that I deploy to?
Edit: I should mention that this is desktop development/deployment targeted for all Windows machines.
View 3 Replies
Apr 5, 2011
With vb.net I would like to select 4 cells in Excel and then pass those cell values along with 1 button tag to a formula in Excel.I press a button with a month, say "May" as text. I want to grab a cell in Excel labeled "May1t" the value of which is the number of hours until may. This is the code I'm using.
xlsWB.Worksheets(2).Range(Month1 & "1t").Value I am able to set a variable with this as the value but,
I want to pass this cell (which will be updating as the time counts down) and 3 other similarly specified cells along with the button tag to an Excel formula.I have something like this:
Private Sub F_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles F.Click
xlsWB.Worksheets(4).Range("B2").Formula = "=MyFunction()"
xlsWB.Worksheets(1).Range(Month1 & "1t").Select()
End Sub
The formula takes the parameters in the order: MyFunction(Cell,Tag,Cell,Cell,Cell).
View 1 Replies
Mar 13, 2010
I have created an application which asks the user to enter password to login.Now how can i inform the user(if his caps button is on) that his caps button is on while he is entering his password?
View 3 Replies
Feb 24, 2010
I am using asp.net oledb to export information to excel file. I encounter problems when the information to export becomes too big, in this case the code I have given below, the excel file generated becomes an empty spreadsheet.If I changed the loop to 1123 for insertion of the rows. The generated excel file is fine, 1125 rows, and 4 columns shown.A test program in windows form is also working fine regardless of how many rows.[code]I couldn't find a solution to my problem as well. What I did eventually was to run the process using another separate windows service. The code works perfectly fine running from a windows form or service program, but not asp.net, not sure why.
View 1 Replies
May 8, 2012
I have this issue that occurs with me and driving me crazy i have a report that contains thousands of records and i need to export it to excel , but the excel normal extension .xls
is showing missing records at the end of the file , so i save my file as an .xlsx extension it saves correctly but when i open the file it generates an error
"Excel cannot open the file '<var>filename</var>.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."but when i test the file i drag it and open it in an empty notepad all the records shows up correctly
View 2 Replies
Nov 28, 2011
Can I safely move ReferencePath information from a .vbproj.user (or .csproj.user) file into the corresponding project file? Note: All developers will be using developing from the same location on their machines.We'd like to allow users to maintain their own settings for other things, but have this basic info be setup once and checked into source control to be shared to all.
View 1 Replies
