Quantcast








     

Excel / protecting worksheet with macro

excelforum.com - 2013-03-17 17:38:31 - Similar - Report/Block

Worksheet can be protected with macro but once the macro is run and reprotect the worksheet it can be simply open by simple click of unprotect menu , is there any other way that we could protect the worksheet...with macro it's like the worksheet is unprotected .

Excel VBA Code to Lock Data Cells after running the macro result

excelforum.com - 2012-09-07 14:17:15 - Similar - Report/Block

I have got an worksheet where I process some data to get results in the sheet thru Excel VBA Macro (Button click()). After the Results are shown in the same worksheet, I wish the data should not get modified and protected till "Reset" the results as 0. I need the VBA code for locking the Data cells from d4:d8 (Data Cells). I am...

Excel 2003 macro won't work in Excel 2010

excelforum.com - 2012-08-07 20:10:31 - Similar - Report/Block

I have an Excel 2003 macro that will not run in Excel 2010. The macro allows me to extract data from our accounting business system into Excel. However, since we have upgraded to Excel 2010 and Windows 7, the macro will not work. I'm told it is because 2010 is 64bit and runs a newer VBA7. I know almost nothing about VBA programing. Is th...

Change row color if C1 < D1 using Macro.

excelforum.com - 2012-11-05 15:05:26 - Similar - Report/Block

Hello Excel Forum, I have been living on this site for the last two days as I compile code and learn a little more about VB. I am trying to make a simple inventory database using macro's in Excel. I have buttons assigned to macro's that do some simple processing and sorting. The last bit is where I am having difficulty. I need a Macro tha...

Excel 2010 Tutorial 12 Case Problem 4 The Brass Broker Part 5

excelforum.com - 2013-04-21 09:53:53 - Similar - Report/Block

I need help with Excel 2010 Tutorial 12 Case Problem 4 The Brass Broker part 5. I need to write a macro named insert_Trans to copy the data from the Transaction worksheet and insert it at the top of the list of transactions in the Auctions Account worksheet. The macro should include the following: An if statement that verifies that there...

Excel 2010 Macro to load all text files to one worksheet?

stackoverflow.com - 2012-04-09 17:53:17 - Similar - Report/Block

HI I am looking for help to write an Excel 2010 macro to load all text files data from a folder to One Worksheet each sheet should have data of one text file each sheet is a Pipe delimited with header on first Row. here is the macro that i started with Sub LoadFiles() ' LoadFiles Macro ' Keyboard Shortcut: Ctrl+Shift+L With ActiveSheet.Q...

how to run VBA macro from perl code

stackoverflow.com - 2012-02-29 11:57:53 - Similar - Report/Block

I am new to perl & i am trying to write a module which would run a excel macro on a already open excel sheet. there is a code sniplet that describes how to run a macro from another excel sheet but i want the macro code as a subroutine in the same file. How to implement that? Can any one help? use strict; use warnings; use Win32::OLE;...

Need help setting Excel to display as I would like

sevenforums.com - 2013-05-08 17:45:13 - Similar - Report/Block

A problem I have had for a few years now and have not been able to figure it out so I put up with it. When I use Excel 2010 and open more than one worksheet I have troubles finding each worksheet, is there a way to have Excel display a tab for each worksheet so I can switch back and forth easier. Thanks...

excel VBA run macro automatically whenever a cell is changed

stackoverflow.com - 2013-03-11 11:05:50 - Similar - Report/Block

Is there a simple way to get excel to automatically execute a simple macro whenever a cell is changed? The cell in question would be in Worksheet("BigBoard").Range("D2") I am only asking because what i thought would be a simple google inquiry is providing to be more complicated - every sample i can find involved intersects (whatever those...

excel macro: permission denied (error 70). Strange behaviour

excelforum.com - 2013-03-07 11:02:27 - Similar - Report/Block

Hi, I have a problem with Excel macros. I have several files containing macro (saved as macro-enabled files), they run correctly on some windows vista pcs and windows seven pcs. Recently I formatted two pcs with Windows 7 Pro, installed Office 2007 and performed updates. When I run macro on these pcs, i get "permission denied, runtime err...

Need Macro Button, getting "too complex" error

excelforum.com - 2013-04-23 18:45:28 - Similar - Report/Block

I am trying to assign a macro I recorded to a button and I am getting the "Formula is too complex to be assigned to object" error. Here is what I am working with: I have a pivot table set up to take data from the "Data" worksheet, and rank it, format it properly etc., I then recorded a macro to copy the results from the pivot table in to...

C# Excel Cell Style Alignment on a range

stackoverflow.com - 2012-07-17 21:52:01 - Similar - Report/Block

So I'm having a problem fromatting cells in an excel sheet. For some reason my code seems to be changing the style of all cells when I just want to change the style of a few specified, or a specified range. Here's some of the code that I am using: app = new Microsoft.Office.Interop.Excel.Applicati on(); workbook = app.Workbooks.Add(1); wor...

evolveStar Join

Macro to create email with refrence taken from excel sheet

excelforum.com - 2013-03-06 13:46:11 - Similar - Report/Block

Hi Guys, I want to creat a macro which take the input from an excel file and create and email in my outlook excel file will contain email...body Email send to and CC could you please help me in this i have attched a sample file. and macro shold run thorugh a shortcut key like pressing CTRL+U... Appericiate your quik response. Thanks Sam A...

"Do until" loop exits the macro before the "for each" loop ends

stackoverflow.com - 2013-03-20 04:33:35 - Similar - Report/Block

For each row of my worksheet, I'm trying to browse cells. I'll stop when I encounter an empty cell. Then I want to go to the following row. In order to do this I'm using a "Do until" loop with a "IsEmpty" condition. This "Do until" loop is inside a "For each" loop. The "For each" loop is used to go from one range to another in the first c...

Consolidar varias planilhas do Excel

babooforum.com.br - 2013-05-28 03:11:07 - Similar - Report/Block

Boa Noite senhores. Eu tenho um diretório que tem várias planilhas do excel como os mesmos campos e mesmo formato, eu preciso que estas planilhas sejam consolidadas em uma única planilha. Esta macro abaixo e praticamente o que preciso para resolver o meu problema, a única coisa e que a macro abre em sequência as planilhas no diretório, e...

C# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed

stackoverflow.com - 2013-03-21 01:07:32 - Similar - Report/Block

I have a C# console program. When it runs, it instantiates some Excel objects such as: (openExcelO). When the program is done running, I have a method to close down Excel (closeExcel) and that is supposed to properly clean up the Excel process. In task manager I can see the remnants of Excel that remain. The shut down routines were cobble...

C# Open XML SDK 2.0 Excel spreadsheet - load range of cells from string array

stackoverflow.com - 2012-06-12 16:40:22 - Similar - Report/Block

In a .Net windows desktop application, I am able to import a string array of data into a range of cells located in Excel spreadsheet. The C# code is as follows: using Excel = Microsoft.Office.Interop.Excel; // Create Application, Workbook, and Worksheet xlApp = new Microsoft.Office.Interop.Excel.Applicati on(); xlWorkBook = xlApp.Workbooks...

conditional check, action, then continue

excelforum.com - 2013-06-12 01:08:52 - Similar - Report/Block

Hi there, My main goal here is to push a button, and based on the contents of a cell will either show or hide a worksheet. I have a macro that checks the contents of a variable on a worksheet for a #DIV/0! error, if there is one, performs an action, and if there isn't, performs an action. Code: Public Sub unrequiredtabs() If IsError(Shee...

Excel, VBA Editor - Autocomplete for the Worksheet object's properties doesn't work

stackoverflow.com - 2013-03-18 04:12:30 - Similar - Report/Block

I want the VBA Editor to use the Autocomplete feature to display the properties of the Worksheet object. Out of this question on SuperUser, I've learned that the Worksheets object Item() property returns the Variant type. That type is not strongly typed to the Worksheet object. But, even if I use the ActiveSheet object or the followi...

proper copying 1 macro to other similar excel file - so it'll work

excelforum.com - 2013-06-08 15:53:49 - Similar - Report/Block

Hello , I'm trying to use the macro in U1.xlsm in U2.xlsm but I'm a beginner , and can't figure out how to do it. what I'm trying to do is to copy the working macro from U1 to U2, ( without deleting sheets ) . I'm curious why I wasn't able to do it, will like to learn how to . thanks :) Attached Files U1.xlsm‎ (60.5 KB) U2.xlsm‎ (114.7 KB...

need a Macro to open chrome from excel when I click on Keyword

excelforum.com - 2013-05-15 10:05:33 - Similar - Report/Block

Hi All I have excel sheet with keywords in column A I need a Macro which should help in taking me to Google chrome images when I click on any keyword. kindly Advise Regards Kiran Kumar...

Create a connection to an informix DB using ODBC and parameters through Excel VBA

dbforums.com - 2013-06-05 12:01:45 - Similar - Report/Block

For reasons out of my control I cannot use Microsoft Query and parameters for this, as would be desirable, so I wish to go through this route, but I'm not sure how. Using VBA, I want to establish a connection using ODBC to a database, and execute a SQL query passing two parameters that will be entered into cells A1 and B1 in the Excel wor...

delete excel worksheets programatically

stackoverflow.com - 2013-05-02 01:21:33 - Similar - Report/Block

have an excel workbook with many, many sheets. I want to delete all the sheets except for three of them. specifically, i would like to know if there is a way to remove the sheets using sheet name instead of ordinals (sheet number). i am using excel interop and C# to work with Excel. any code / ideas would be helpful. Microsoft.Office.Int...

Macro Needed to Rollup Mulitple Excel Files

stackoverflow.com - 2013-04-11 21:18:14 - Similar - Report/Block

I have multiple excel files that are structured identically and are in a folder. Each excel files data starts at d4 (multiple rows of data but all rows start on the subsequent d) I need a macro to take the data from all the separate excel files in the folder and create a single new excel file of all the data from the separate excel files,...

Macro Vba para exportar em Pdf no Excel 2003

babooforum.com.br - 2013-04-23 23:44:11 - Similar - Report/Block

Boa noite pessoal. Alguém conhece uma macro que exporte a planilha para Pdf? No caso, eu precisaria de uma macro que já exportasse em uma pasta (C:/Pdf, por exemplo), sem ficar perguntando onde salvar. Grato!...

Create a macro to copy from a cell in excel to a text box in a browser, then click add

stackoverflow.com - 2012-03-09 11:09:51 - Similar - Report/Block

I have already created a Macro using a 3rd party application that does what i want 80% of the time. The problem is that i can't leave it running because it sometimes bugs out, or the browser takes a little longer to respond. I would like to know if i could create what i wanted in the macro manager that comes with excel (VB). I want to: co...

deleting rows from an excel file using c#

stackoverflow.com - 2012-03-31 00:32:10 - Similar - Report/Block

i am opening an excel file like this: Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; string str; int rCnt = 0; int cCnt = 0; xlApp = new Excel.ApplicationClass(); xlWorkBook = xlApp.Workbooks.Open("csharp.net-informa tions.xls", 0, true, 5, "", "", tru...

Creating Macro in Word to clear worksheet one Printed

techguy.org - 2013-05-21 20:29:59 - Similar - Report/Block

I have a generic worksheet created from a Word Template (Bill of Lading Template if that helps) and I want to have the user enter input such as address to, PO #, CO #, Quantity of Pieces/Lbs, i.e. only certain boxes of the table. Once the user prints this form, I would like for it to clear only these certain boxes. Is there a macro I coul...

Excel copy and paste macro

techguy.org - 2013-03-13 03:16:36 - Similar - Report/Block

Is it possible to make a macro that copy predefined cells in a selected row into new row/cell ? For example : I select row 4 push the 'macro button' and it copies A4, B4, C4, D4 and E5 to D21, D22, D23, D24 and D25. If this is possible , could someone please write me an example to this and if not write and example how this could be done ?...

Can you condition an excel macro based on cell content?

stackoverflow.com - 2013-06-04 15:34:51 - Similar - Report/Block

For work, I download a a series of spreadsheets that have quiz names in one of the cell columns. There are generally 5-10 attempts per quiz and about 10 quizzes that are reported in the spreadsheet. I have a macro that sorts the data by quiz name so the attempts are grouped together, but I want to add a space before and after each groupin...

Excel 2010 - Macro to count if cell is a certain color

techguy.org - 2013-04-22 02:29:40 - Similar - Report/Block

I'm trying to write a macro for Excel 2010 to count cells only if the background fill color is a certain color. I'm having trouble finding how to access the background color information in Excel 2010.

Recording a macro to link workbooks with conditional information

excelforum.com - 2013-06-12 01:24:13 - Similar - Report/Block

Hello. I am a new memeber with moderate excel experience. My problem is I am trying to create a macro to pull specific information if a condition is met. For example I would like to copy and paste A57:H57 from one work book to another, but only if K57 has a value. Or more specifically, I would like to seach a named cell range for values a...

Excel VBA Copy master sheet into a new workbook

excelforum.com - 2013-04-26 01:28:28 - Similar - Report/Block

Hi, Please help as I am stuck!! I have a macro which copies data from a master excel sheet into a new excel workbook without the formulaes but with the formatting. The below code works fine, but i have a data validation cell which i would like only the value to be copied but this code seems to copy all, also I have charts on the master sh...

Trying to program word to copy from an excel file

excelforum.com - 2013-04-11 18:26:39 - Similar - Report/Block

I am designing an excel/word complitation for my job. The spreadsheet and word doc are created already. The word doc is an inspection memorandum template and the spreadsheet is the inspection form with criteria. What I have accomplished: -In excel: -I have defined some drop down menus that autopopulate other cells based on selection of t...

Excel macro that creates pdf files in Dropbox folders works inconsistently in Windows 8

excelforum.com - 2013-03-23 05:03:31 - Similar - Report/Block

I have just moved from a laptop running XP/Excel 2007 to a laptop running Windows 8 64-bit/Excel 2013 (installed via Office 365). I have a .xlsm file that is stored in a Dropbox folder. It contains a macro which prints various sheets from the graph into 7 pdf files stored in other Dropbox folders. The part of code that creates (i.e. overw...

VBA code to Subtract values in Column F with Column E if found non-blank

excelforum.com - 2013-03-05 08:12:39 - Similar - Report/Block

Please can anyone give me a code that will subtract NOW() values in column F with the NOW() values in column E and populate the answer in column I of the worksheet. I'm doing this to determine the # of working hours of each staff. The reason I want a code and not regular formula from excel sheet is that the entries for this worksheet (Adm...

Не выполняется сохранение в Excel - C# .NET

cyberforum.ru - 2013-02-27 08:39:11 - Similar - Report/Block

Код: int year = DateTime.Now.Year; string god = year.ToString(); string x = ".xls"; string C = "C:\\Users\\Роман\\Desktop\\Проги\\Excel \\WindowsFormsApplication1\\"; string res = god + x; if (File.Exists(res)) else res = C + god + x; Excel.Application app = new Excel.Application(); app.Visible = true; app.SheetsInNewWorkbook =...

Работа с Excel - C# для начинающих

cyberforum.ru - 2012-08-01 13:00:58 - Similar - Report/Block

Здравствуйте! У меня проблема в том, что я делаю все так как там , но выдает ошибку в строчках на слова Excel, например: Код: Excel.Application xlApp; // здесь на Excel Error Namespace '<global namespace>' contains a definition conflicting with alias 'Excel' C:\Users\Администратор\Desktop\Excel\Exc el\Form1.cs 23 13 Excel Excel.Workb...

Как програмно сохранить Excel документ? - C# .NET

cyberforum.ru - 2013-02-26 12:32:03 - Similar - Report/Block

Я формирую отчёт в C# и вывожу его в Excel. Ну чтоб понятно было вот некоторые отрывки кода:Код C# Код: using Excel = Microsoft.Office.Interop.Excel; Excel.Application oXL; Excel.Workbook oWB; Excel.Worksheet oSheet; Excel.Range oRng; oXL = new Excel.Application(); oXL.Visible = true; ... Дальше идёт манипуляции с Excel-евскими таблиц...

WorkSheet.Index - C# .NET

cyberforum.ru - 2013-03-01 03:53:55 - Similar - Report/Block

Получения index у Excel файла страницы, использую так int = i; WorkSheet.Index[i] при этом WorkSheet создано мной, и он ругается говорит - невозможна применить индексирование через [] к выражению типа "int", почему он ругается?...




dialogShowMessage!

Fill out the form you see below. Registration is free, fast and simple.
If you are already registered, sign in page login.


Web Site :
Required Field
First Name :
Required Field
Last Name :
Required Field
Email :
Required Field
Sex :
Required Field

evolveStar.com is free for ever !


evolveStar.com provides a search engine that allows you to gather information to write their own blog.


evolveStar.com enhances the sources displaying the logo of the site.


If you want to remove your site or you believe a site listed infringes copyright, please report it to: info@evolvestar.com


Specifies the subject copyright violation and the url of the page


evolveStar.com respecting the law DMCA (Digital Millennium Copyright Act) will immediately remove whatever its merits.


Next will be effectual and relevant checks.







Who We Are Partner Advertising Contacts Privacy terms Help & FAQ

© Copyright 2010-2017 Fabrizio Fichera. All rights reserved.