Deleting all formulas in a worksheet when unprotected in VBA code
I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have protected using the [...]
Answer Question
| September 26, 2008 9:52 AM
Excel 2003, Excel formulas, Microsoft Excel, VBA, Visual Basic for Applications
I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have protected using the [...]
Answer Question
| September 26, 2008 9:52 AM
Excel 2003, Excel formulas, Microsoft Excel, VBA, Visual Basic for Applications
email query recordset
“I have a query (emailnotifytest) based on 2 tables . One table (shipmentdata) filters on new records. the other table (contact) filters which contains the email address filters whether the address is not null. The tables are joined by the companyname. the code below works as far as sending the recordset to each different email [...]
Answer Question
| September 25, 2008 4:34 PM
Microsoft Access, VBA
“I have a query (emailnotifytest) based on 2 tables . One table (shipmentdata) filters on new records. the other table (contact) filters which contains the email address filters whether the address is not null. The tables are joined by the companyname. the code below works as far as sending the recordset to each different email [...]
Answer Question
| September 25, 2008 4:34 PM
Microsoft Access, VBA
VBA question for a beginner
I am very new to VBA and my boss is having work on a spreadsheet that dynamically updates the comment box with a value from a designated cell. Here is what I am using for the first target address of C39 to be displayed in a text box in C5. Problem is I have to [...]
Answer Question
| September 30, 2008 9:43 PM
Dymnamic comment boxs in excel, VBA
I am very new to VBA and my boss is having work on a spreadsheet that dynamically updates the comment box with a value from a designated cell. Here is what I am using for the first target address of C39 to be displayed in a text box in C5. Problem is I have to [...]
Answer Question
| September 30, 2008 9:43 PM
Dymnamic comment boxs in excel, VBA
How can i connect DB and input values in stored procedures using VBA
hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me….
Answer Question
| September 23, 2008 6:41 AM
DB2, Stored Procedures, VBA
hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me….
Answer Question
| September 23, 2008 6:41 AM
DB2, Stored Procedures, VBA
How can we insert space between text and a table in MSword using macros
My task is like this. SampleText Table1 with some columns and rows. I need to insert text between “SampleText” and “Table1″. When I am inserting text it is inserted into the first cell of “Table1″,however I have to insert it in between “SampleText” and “Table1″ by inserting line break/space between them.
Answer Question
| September 10, 2008 7:21 AM
Microsoft Word, VBA, Visual Basic for Applications
My task is like this. SampleText Table1 with some columns and rows. I need to insert text between “SampleText” and “Table1″. When I am inserting text it is inserted into the first cell of “Table1″,however I have to insert it in between “SampleText” and “Table1″ by inserting line break/space between them.
Answer Question
| September 10, 2008 7:21 AM
Microsoft Word, VBA, Visual Basic for Applications
Excel Form Macro
Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux’ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work [...]
Answer Question
| August 30, 2008 11:27 PM
Excel formulas, Excel functions, Excel macros, Microsoft Excel, SpinButton, VBA, Visual Basic for Applications
Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux’ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work [...]
Answer Question
| August 30, 2008 11:27 PM
Excel formulas, Excel functions, Excel macros, Microsoft Excel, SpinButton, VBA, Visual Basic for Applications
Excel 2003.novice user wants to set up database for research
Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don’t know what it’s called. can I do something like this to then use it to make queries for certain data?
Answer Question
| August 14, 2008 10:23 AM
Database programming, Microsoft Excel, VBA, Visual Basic for Applications
Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don’t know what it’s called. can I do something like this to then use it to make queries for certain data?
Answer Question
| August 14, 2008 10:23 AM
Database programming, Microsoft Excel, VBA, Visual Basic for Applications
VBA-question
How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.
Answer Question
| August 1, 2008 3:11 PM
Database programming, Microsoft Access, VBA, Visual Basic for Applications
How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.
Answer Question
| August 1, 2008 3:11 PM
Database programming, Microsoft Access, VBA, Visual Basic for Applications
Copy and paste in Excel using Visual Basic scripting?
First of all – Thank you…. I receive info in Excel worksheet “A” with columns of variable length which I want to cut and paste into Excel worksheet “B”. Worksheet “A” info starts at B:13 and can range in length from 1 to 200 rows or more. I would like to copy this variable length [...]
Answer Question
| August 30, 2008 11:46 PM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
First of all – Thank you…. I receive info in Excel worksheet “A” with columns of variable length which I want to cut and paste into Excel worksheet “B”. Worksheet “A” info starts at B:13 and can range in length from 1 to 200 rows or more. I would like to copy this variable length [...]
Answer Question
| August 30, 2008 11:46 PM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Error 2501
While navigating my database I have a button that will take you to a different form using parameters. It works when you either simply click ok or type in a parameter, but when you click cancel it returns an error 2501. What code should i put in to VBA to make it simply close the [...]
Answer Question
| July 30, 2008 1:38 PM
Access errors, Error 2501, Microsoft Access, VBA
While navigating my database I have a button that will take you to a different form using parameters. It works when you either simply click ok or type in a parameter, but when you click cancel it returns an error 2501. What code should i put in to VBA to make it simply close the [...]
Answer Question
| July 30, 2008 1:38 PM
Access errors, Error 2501, Microsoft Access, VBA
Can you help with the following DAO code explaining a step-by-step process?
I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to figure out how [...]
Answer Question
| August 30, 2008 4:44 PM
Access 2007, DAO, Microsoft Access, VBA, Visual Basic
I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to figure out how [...]
Answer Question
| August 30, 2008 4:44 PM
Access 2007, DAO, Microsoft Access, VBA, Visual Basic
EXCEL find-copy-paste
Hello! Using VBA for first time, so everything is toughed for me.. The problem is: we need to find on the first sheet named SD in second column all cells contianing word ‘drilling’, then for each cell copy row which contains that cell and paste it in other sheet or book (doesn’t matter). Please help [...]
Answer Question
| August 30, 2008 6:50 AM
Microsoft Excel, VBA
Hello! Using VBA for first time, so everything is toughed for me.. The problem is: we need to find on the first sheet named SD in second column all cells contianing word ‘drilling’, then for each cell copy row which contains that cell and paste it in other sheet or book (doesn’t matter). Please help [...]
Answer Question
| August 30, 2008 6:50 AM
Microsoft Excel, VBA
Change Font Style of Menu Item Through VB6
My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to “Gopika.ttf”. So, during the execution of my program I want to show menus also in Gujarati. Normally, we change this from desktop –> properties –> appearnce –> advance. Now, my question is how this [...]
Answer Question
| July 10, 2008 8:17 AM
Localization, VB, VBA, VBScript, Visual Basic, Visual Basic 6, Visual Basic developers, Visual Basic for Applications, Windows, Windows XP
My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to “Gopika.ttf”. So, during the execution of my program I want to show menus also in Gujarati. Normally, we change this from desktop –> properties –> appearnce –> advance. Now, my question is how this [...]
Answer Question
| July 10, 2008 8:17 AM
Localization, VB, VBA, VBScript, Visual Basic, Visual Basic 6, Visual Basic developers, Visual Basic for Applications, Windows, Windows XP
programming
Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want ‘X’ and in Place of alphabet i want ‘N’, do you know how can you we do that in Excel? i wana to change numeric values in ‘X’ and alphabet in ‘N’ form, and my friend [...]
Answer Question
| July 15, 2008 6:48 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want ‘X’ and in Place of alphabet i want ‘N’, do you know how can you we do that in Excel? i wana to change numeric values in ‘X’ and alphabet in ‘N’ form, and my friend [...]
Answer Question
| July 15, 2008 6:48 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Add module to remote access database
I have 100+ access 2000 .mdb’s that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend [...]
Answer Question
| August 30, 2008 5:53 PM
Access, Access 2000, MDB, VBA
I have 100+ access 2000 .mdb’s that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend [...]
Answer Question
| August 30, 2008 5:53 PM
Access, Access 2000, MDB, VBA
Copy past in excel using VB
i want to cut data in a colunm H and copy it in column B. i tried to record macro and run it. but i am not getting the values in column B. i am using excel macro and vb code to do this. i understand that the data in colum is cut and the [...]
Answer Question
| July 2, 2008 10:26 AM
Excel macros, Microsoft Excel, VB, VBA, Visual Basic for Applications
i want to cut data in a colunm H and copy it in column B. i tried to record macro and run it. but i am not getting the values in column B. i am using excel macro and vb code to do this. i understand that the data in colum is cut and the [...]
Answer Question
| July 2, 2008 10:26 AM
Excel macros, Microsoft Excel, VB, VBA, Visual Basic for Applications
Changing Color in a Cell
I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading [...]
Answer Question
| June 19, 2008 12:06 PM
Conditional formatting, Excel 2003, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading [...]
Answer Question
| June 19, 2008 12:06 PM
Conditional formatting, Excel 2003, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
How do I get a macro to move between workbooks?
I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5…). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks [...]
Answer Question
| June 20, 2008 1:19 AM
Macros, Microsoft Excel, Variables, VBA, Workbooks
I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5…). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks [...]
Answer Question
| June 20, 2008 1:19 AM
Macros, Microsoft Excel, Variables, VBA, Workbooks
Executing a Stored procedure using Excel Macro
I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?
Answer Question
| June 13, 2008 6:36 PM
Excel macros, SQL, Stored Procedures, VBA
I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?
Answer Question
| June 13, 2008 6:36 PM
Excel macros, SQL, Stored Procedures, VBA
use vba to draw graphics in ms word
can vba create drawing “free hand” or by joining forms and circles together (putting one near another is good enough)
Answer Question
| June 6, 2008 4:04 PM
Microsoft Word, objects, VBA, VBA editor
can vba create drawing “free hand” or by joining forms and circles together (putting one near another is good enough)
Answer Question
| June 6, 2008 4:04 PM
Microsoft Word, objects, VBA, VBA editor
