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 data is not retrived while it paste in column B. Can Any one...
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 data is not retrived while it paste in column B. Can Any one...
5 pts.
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 color for...
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 color for...
jim development funds management
i would like someone to tell me how to develop an application in visual basic 6 that can be used to ; maitain a list of - development areas, details of proposals , awarded projects and maintain funds recieved, given; jim is an organisation that receives funds for development from...
i would like someone to tell me how to develop an application in visual basic 6 that can be used to ; maitain a list of - development areas, details of proposals , awarded projects and maintain funds recieved, given; jim is an organisation that receives funds for development from...
Separation of data
I want to copy a part of a table from Adobe to Excel, but all the data are getting copied to one cell. How can I use VBA to separate this set of data each one into different cell? Thank you beforehand.
I want to copy a part of a table from Adobe to Excel, but all the data are getting copied to one cell. How can I use VBA to separate this set of data each one into different cell? Thank you beforehand.
Overwrite previous record with VBA code
I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code
I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code
Open Import window via code in MS Access
Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.
Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.
Save Access 2007 format as 2000 format with VBA
how can i save the curent database as a 2000 format with vba
how can i save the curent database as a 2000 format with vba
How Can i restrict the user to insert next record
Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should...
Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should...
Saving form calculations to tables
I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table
I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table
How to save a document as current date ?
I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please
I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please
Combo box and VBA
The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use...
The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use...
easy way to automate uploading data from a word document to a spreadsheet?
I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of a data file I create...
I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of a data file I create...
While Loop in Excel VBA
I have the basic loop and can not figure out what to write in the middle. I need to have row 9 column D populate a value from another sheet depending on the value in cell A9. Here is what I have so far: Private Sub Loop1() Dim myLoopCtr As Integer myLoopCtr = 0 While myLoopCtr <= 15 ...
I have the basic loop and can not figure out what to write in the middle. I need to have row 9 column D populate a value from another sheet depending on the value in cell A9. Here is what I have so far: Private Sub Loop1() Dim myLoopCtr As Integer myLoopCtr = 0 While myLoopCtr <= 15 ...
How to create dsktp shortcut to VB userform created in Word
I created a userform through VB in Word. I need this form to be accessed via a desktop shortcut icon where only the form is visible when the shortcut is initialized. I created this form in Word. Please help. TY
I created a userform through VB in Word. I need this form to be accessed via a desktop shortcut icon where only the form is visible when the shortcut is initialized. I created this form in Word. Please help. TY
