How to capture the height,width of the latest picture inserted in word using macros,VBA?
Hi, My task involves capturing the height , width of the latest picture inserted in word using macros,VBA.
Hi, My task involves capturing the height , width of the latest picture inserted in word using macros,VBA.
20 pts.
Conditional formatting
How do I get conditional formatting in a form to continue to work as a sub form
How do I get conditional formatting in a form to continue to work as a sub form
Not allowed to edit Microsoft Access forms
A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...
A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...
How to use Access object library in my Windows application
dear friends , how to use docmd.opencurrentdatabse command to open an access application database please advise
dear friends , how to use docmd.opencurrentdatabse command to open an access application database please advise
Trying to copy a value created within a subroutine to another cell in the same worksheet
I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not working for the last step - Sub Count()...
I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not working for the last step - Sub Count()...
Switching Excel Custom Views Based on Selection
I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very...
I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very...
Comparing 2 Large Excel Files
I have 2 large Excel files, one containing yesterday's data, and another containing yesterday's data + today's updates/changes. For registration purposes, I need to find all the differences (ie new rows/entries, a value changed within the row in the new file vs the old file, etc). These excel files...
I have 2 large Excel files, one containing yesterday's data, and another containing yesterday's data + today's updates/changes. For registration purposes, I need to find all the differences (ie new rows/entries, a value changed within the row in the new file vs the old file, etc). These excel files...
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...
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...
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...
"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...
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 do it for 140 cells. I don’t...
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 do it for 140 cells. I don’t...
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....
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....
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...
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...
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...
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...
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?
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?
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.
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.
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...
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...
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 parameter box and...
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 parameter box and...
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...
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...
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...
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...
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 -->...
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 -->...
