How can I disable Save As button, I can open Ms Excel through vb net but the thing is I also want to disable the 'save as' as the Ms Excel Open.But not in Macro.. Here's my code:
Imports Excel = Microsoft.Office.Interop.Excel
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
[code].....
RichTextBox recording a name, surname, telephone number and address in the Excel spreadsheet, where the name is repeated every 5-th line in the RichTextBox, the same name each of the 5-line phone every 5-th line, address each of the 5-line.
View 7 Repliesim currently doing my special project in software development
[Code]...
I'm trying to export a datagridview to Excel and open the Excel spreadsheet (not SAVE the worksheet).
Public Sub ExcelRpt(ByVal DgvName As GridView, ByVal url As String)
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet
[code]....
when i choose this option (dont save any changes)in VB 2008 a msg error appear when press run or F5 and the msg is : Form1.vb cannt be modified at this time ?
View 3 RepliesI decided to to convert my excel macro in a exe file using visual studio 2010. In excel macro method find is present like this:
[Code]...
i'm trying to save an excel file after I open my excel application. This is what I have so far:
'Opens the report
xlPeakDemand.Visible = True
xlPeakDemandWorkbook.SaveAs("C:Documents and
[Code].....
When saving as an xls it works fine but when saving as a htm its a disaster Just a bunch or symbols and stuff. BUT if I go into my xls document and Save As webpage from there, it works fine!
I has some vb.net code to export some data into Excel format. I had set one of the column to date format. But I want to avoid user from changing the format because they can easily right click the Excel cells, and choose Format Cells. How can I disable this option in Excel via vb.net code so that user will always follow my format?
worksheet.Cells(intCnt, 19).NumberFormat = "dd/MM/yyyy;@"
worksheet.Cells(intCnt, 19).Style.Locked = True
I use the above code to locked it but seems to be not working.
This is my code to disable excel maximize button:
Option Explicit
Declare Function GetSystemMenu Lib "user32" (ByVal hWnd As Long, ByVal bRevert As Long) As Long
[code].....
I have an application that browses through Excel-files, changes color in some cells if they are in a wrong format etc.When my application is saving the changed file I get this alert about compatibility issues that can occur, and this alertbox has to be agreed or cancelled to move on to the next file.
How can I disable this compatibility check programmatically? Or is there any way to ensure there are only Excel 2003 compatible colors in the document before saving?
On my form i use binding source bound to fields.. if a user starts to change something then hits cancel (i set all the fields to "" to clear them) and then if they choose that record again it shows nothing in the bound fields..
is there a way to reset/cancel from editing without loosing original values?
How can I disable the Excel export option when I generate a report, via the ReportViewer, in my winforms application? In particular, I want to hide the toolbar button that refers to Excel output/export task, and not .the one that handles to the pdf export option.
View 3 RepliesI have an application that browses through Excel-files, changes color in some cells if they are in a wrong format etc.When my application is saving the changed file I get this alert about compatibility issues that can occur, and this alertbox has to be agreed or cancelled to move on to the next file. How can I disable this compatibility check programmatically? Or is there any way to ensure there are only Excel 2003 compatible colors in the document before saving?
View 13 RepliesI am using the Microsoft.Office.Interop.Excel library in VB.Net on an excel sheet that is protected. All of the protected settings are working fine except that I cannot set Select Locked Cells which shows when you are using the Excel protect sheet interface but I cannot see how to set this to false using the library. I have tried all of the different values in the protect method but none of them toggle the value.Excel protected sheet menu Below is the code snippet I am using to get my workSheet, populate some values, and then protect the sheet. GetWorkSheet is an internal method which will return a WorkSheet object, and invoiceData is a datatable which has the data which is being added to the spreadsheet.
Dim newSheet As Worksheet = getWorkSheet(newSheetName)
' Make the current Work Sheet active so that it will be accepting the data.
newSheet.Activate()
newSheet.Unprotect(sheetPassword)
[code]...
I can do this using VBA, but I want to be able to create the code using a compiled VB programme, which can then be opened in Excel.
View 1 RepliesI'm creating a program and i want it to secretly save when the user clicks on save.
In other words, i have made it so that it saves twice. Once for the user to read (like a fancy copy) and another that the program uses to open up the form.
Currently when pushed, 2 save dialog boxes come up after each other. I don't want this to happen. I want 1 to come up (the user friendly, fancy version) which is the easy part, but i also want the other 1 to save automatically and secretly without asking the user to set the destination.
How to save image from webbrowser loaded page to hdd (after loading save to hdd)?
View 2 RepliesI am confused what will happen, when I disable a timer. Will it finish the process and then disable or will it immediately disable without completing process? for example
[Code]....
I want to run getMessage from somewhere else, so I need to disable timer during that time to be asured not to override anything and also before timer disable it should complete that function code.
I am trying to use a spreadsheet with VBA macros that I wrote in Excel 2007 in Excel 2010.When the macros run in 2010, I get the error message "Can't find project or library" on functions like UCase and Date.I've set the macro settings to "Enable all macros" and selected "Trust access to the VBA project object model."What do I need to do to get these macros to run in 2010?
View 2 RepliesI am using a datagrid in my where i am having four columns. In first column the parameter values are entered and in the second column measured value is entered and in third column the nominal value is entered.Inthe fourth column the result is displayed by subtracting the measured value and nominal values. I am doing this calculation in Datagrid cell validated event. What i want is,there will be many rows in the grid,when typing the value in the third column the corresponding result will be displayedin the rowof theresult column,save button will be displayed while the form loads,when the calculate part is completed that is there should not any cell of the resut column empty then i should enable the save butto.
View 2 Repliesadd save and save as dialogue box options in vb 2010. I've already managed to do loading but i can't figure out how to save.
View 4 RepliesIs there a way to disable visual basic 10 language features in VS 2010.our Dev team has moved to Visual studio 2010, but we still have to keep backwards compatibility with Visual Studio 2008. is there a way to disable the new language features to avoid any issues.
View 1 RepliesI am making a fake virus program as a joke and would like to know how to disable all of the keys except for the shift and enter keys.(these will exit the program)
View 1 RepliesI would like to disable a button. Eg. I will press a button and after 3 times the button is disable. Now for that I used this
[Code]...
Now, when I closed the program and re-opened it, the button was enabled again. How could I make that button, to be disabled forever after 3 presses.
i press windows key sometimes when i writing somethng on my laptop.question : i want to disable windows logo key (windows key) and other key combos like Ctrl + Esc. i dont need disable all time(regedit method : HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesExplorerNoWinKeys ) just a little time when i writing..
View 2 RepliesI Just finished a very nice Excel database front end, using mostly code snippets and tutorials learned from this site, I am new to .net and OOP having only ever trained in VB6, many many years ago and working only with VBA since then, and now I'd like to add a little extra polish to my humble app, so I need some expert help.
The problem really lies with one user in particular, who insists on typing with the capslock on when using my application, filling the database with odd records of only uppercase, when challenged she protests she isn't computer savvy and finds capitals quicker and easier.
I am aware of the string conversion tricks (ToUpper/ToLower/ToProper) available, however, due to the nature of the information being entered, it needs to be true mixed case, certain information might contain for example brand names, which often have uppercase/lowercase letters which vb or Excel for that matter simply cannot pragmatically account for (McDonalds is a good example, neither upper, lower or 'proper' as defined by the rules)
And so to my cunning plan, it is my desire to disable the capslock key! I am already setting a set of rules for each user based on Environment.UserName and so I am hoping just for this one user I can switch off the ability to use caps, as everyone else behaves themselves. I have tried to code me own way down this path but as yet have failed on all accounts.
I am using the Microsoft.Office.Interop.Excel library in an ASP.NET application, and I have populated a Worksheet in a Workbook. I want the user to be prompted to Save the document to their machine, but I cannot find a way to do it (myWorkbook.SaveAs(...) doesn't work).
[Code]...
The Current Setup:So, I can use the following code to save a file as an XLS:
_myWorkbook.SaveAs("FileName.xls", Excel.XlFileFormat.xlWorkbookNormal)
I can also use the following code to save a file as an XLSX (Since I use Office 2010):
_myWorkbook.SaveAs("FileName.xlsx", Excel.XlFileFormat.xlWorkbookDefault)
I have tried (unsuccessfully) to save the file as an XLSX using the following code:
_myWorkbook.SaveAs("FileName.xlsx", Excel.XlFileFormat.xlExcel12)Why does this not work? Last I checked, Excel 12 was Excel 2007 (a version that supports XLSX). Am I missing something?
I get a This extension can not be used with the selected file type error)
I am trying to open an excel CSV file and overwrite some data, close then use that file in my program. Everything go is fine except when I read the data from the file, the file seems to be corrupted! [code]...
View 1 RepliesI have a program where I put data into a list view in VB.net. I then use the code below in a button click to export the content into a excel file where I can then save it. however I plan to add alot more data to the list view ad would like to auto save the data in the list view to an excel file (where it saves it to disk not an open excel window) and then clears the list view then will repopulate the list view and repet the loop of saving the data to a new excel file on disk.[code]...
View 2 Replies