File Name question
I have a macro I use to pull data from 2 worksheets. the problem I have is that everytime I run this macro it is on 2 diff files and the file names are diff than when I originally created the macro & my macro keeps crapping out because it is looking for the original file name I used. is it possible...
I have a macro I use to pull data from 2 worksheets. the problem I have is that everytime I run this macro it is on 2 diff files and the file names are diff than when I originally created the macro & my macro keeps crapping out because it is looking for the original file name I used. is it possible...
5 pts.
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...
how to increase no of rows of validation list (drop down list)???
hello, thanks for viewing this thread. i have one excel sheet. i have entered following data in 30 rows in one column and created the validation list for that data 10:00 AM 10:01 AM 10:02 AM '' '' ' '' 5:00 PM i want to show drop down list box with my own no of rows to be displayed not current...
hello, thanks for viewing this thread. i have one excel sheet. i have entered following data in 30 rows in one column and created the validation list for that data 10:00 AM 10:01 AM 10:02 AM '' '' ' '' 5:00 PM i want to show drop down list box with my own no of rows to be displayed not current...
Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...
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 did already, through...
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 did already, through...
Forms in Excel 2003
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when a title is selected it...
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when a title is selected it...
Recording cell value changes to another cell in excel using a macro
Is it possible to use a macro that will record the value changes I make in one cell and make it appear in another cell on the same worksheet? Example: On a worksheet the cell value of A:1 will change every week. As the value is updated, the previous value is copied to another cell on the same...
Is it possible to use a macro that will record the value changes I make in one cell and make it appear in another cell on the same worksheet? Example: On a worksheet the cell value of A:1 will change every week. As the value is updated, the previous value is copied to another cell on the same...
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...
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...
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?
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?
Editing exhisting macro
I have an exhisting macro but now I want to delete column's E and H in one of the sheets and am unsure how to edit the macro to correspond to this change.
I have an exhisting macro but now I want to delete column's E and H in one of the sheets and am unsure how to edit the macro to correspond to this change.
Writing excel RTD to a file
I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new row so that all of the incoming...
I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new row so that all of the incoming...
Cell Colors in Excel
I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.
I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.
Excel 2007 Macros problem
AOA, I am using office 2007 the Macros are disabled when we open password Protected Workbook.
AOA, I am using office 2007 the Macros are disabled when we open password Protected Workbook.
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
Search for duplicates in a collumn and delete the row on which it occurs
Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather...
Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather...
Printing the contents property of an EXCEL file
I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access. I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?
I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access. I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?
Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)
I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the...
I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the...
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
Excel-Macro Help
I'm creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I've created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the...
I'm creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I've created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the...
