Excel Macro to extract substrings from a comma-separated string.
How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.
Answer Question
| April 13, 2009 6:17 AM
Microsoft Excel, Microsoft Excel formulas, Microsoft Excel macros, String manipulation
How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.
Answer Question
| April 13, 2009 6:17 AM
Microsoft Excel, Microsoft Excel formulas, Microsoft Excel macros, String manipulation
vba recorder issue
When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can’t figure out why [...]
Answer Question
| April 13, 2009 11:28 PM
Excel 2007, Excel macros, Excel VBA, Microsoft Excel, VBA
When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can’t figure out why [...]
Answer Question
| April 13, 2009 11:28 PM
Excel 2007, Excel macros, Excel VBA, Microsoft Excel, VBA
Horizontal to vertical
how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco
Answer Question
| April 13, 2009 8:09 PM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel
how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco
Answer Question
| April 13, 2009 8:09 PM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel
EXCEL 2003 – CONDITIONAL FORMATTING
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column L = Start Date [...]
Answer Question
| March 1, 2010 2:40 PM
Excel 2003, Microsoft Excel
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column L = Start Date [...]
Answer Question
| March 1, 2010 2:40 PM
Excel 2003, Microsoft Excel
Print one row on all pages in Excel
Hi, Does anyone know of a way to print one row on all pages in Excel, kind of like a header? Thanks, Dustin
Answer Question
| April 9, 2009 1:43 PM
Excel 2003, Microsoft Excel
Hi, Does anyone know of a way to print one row on all pages in Excel, kind of like a header? Thanks, Dustin
Answer Question
| April 9, 2009 1:43 PM
Excel 2003, Microsoft Excel
What is the Excel VBScript for the following…
Avatar I put a value in cell B1 and a value in cell C1. Then, when I put a value in A1, I need both B1 and C1 to over-write themselves and become the product of A1*B1 and A1*C1. The same for A2,B2,C2 and A3,B3,C3, etc
Answer Question
| April 13, 2009 4:05 PM
Excel macros, Microsoft Excel, VBScript
Avatar I put a value in cell B1 and a value in cell C1. Then, when I put a value in A1, I need both B1 and C1 to over-write themselves and become the product of A1*B1 and A1*C1. The same for A2,B2,C2 and A3,B3,C3, etc
Answer Question
| April 13, 2009 4:05 PM
Excel macros, Microsoft Excel, VBScript
Linking Information in two seperate Workbooks
I need to create a Workbook that has certain cells accessible for people to enter in thier information and then have the ability to pick from a drop down list that will autopopulate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens [...]
Answer Question
| April 9, 2009 2:22 PM
Excel VLOOKUP function, Microsoft Excel, VLOOKUP
I need to create a Workbook that has certain cells accessible for people to enter in thier information and then have the ability to pick from a drop down list that will autopopulate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens [...]
Answer Question
| April 9, 2009 2:22 PM
Excel VLOOKUP function, Microsoft Excel, VLOOKUP
Microsoft Excel subtraction using VBA
I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in sheet1.By [...]
Answer Question
| April 13, 2009 11:26 AM
Microsoft Excel, Microsoft Excel formulas, VBA, Visual Basic for Applications
I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in sheet1.By [...]
Answer Question
| April 13, 2009 11:26 AM
Microsoft Excel, Microsoft Excel formulas, VBA, Visual Basic for Applications
How to Create “Are you sure you want to ….” MsgBox
I am creating a userform at the bottom of which there are various commands including “Save”. When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an “Are you sure you want to save” box with [...]
Answer Question
| April 16, 2009 7:10 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
I am creating a userform at the bottom of which there are various commands including “Save”. When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an “Are you sure you want to save” box with [...]
Answer Question
| April 16, 2009 7:10 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
Excel custom format, weekday & date line break query….
I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is [...]
Answer Question
| April 16, 2009 4:34 PM
Excel 2003, Excel formulas, Excel functions, Microsoft Excel
I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is [...]
Answer Question
| April 16, 2009 4:34 PM
Excel 2003, Excel formulas, Excel functions, Microsoft Excel
Export or Import data Excle to Excel (VBA coding)
Hi Experts Pls How to possible Export or Import data Excle to Excel (VBA coding) Ananda Debnath
Answer Question
| March 31, 2010 12:15 PM
Excel import/export, Microsoft Excel, VBA
Hi Experts Pls How to possible Export or Import data Excle to Excel (VBA coding) Ananda Debnath
Answer Question
| March 31, 2010 12:15 PM
Excel import/export, Microsoft Excel, VBA
Excel file problem in Lotus Notes
When the user is trying to open an attachment ms excel 2003 file, the user is not able to open it, but the user is able to open the file after it is saved to the computer/ The user is having problem only witht he excel files.Can anyone please help me with this?
Answer Question
| April 9, 2009 7:59 AM
Excel 2003, Lotus Notes, Lotus Notes email, Lotus Notes email attachments, Microsoft Excel, Microsoft Excel 2003
When the user is trying to open an attachment ms excel 2003 file, the user is not able to open it, but the user is able to open the file after it is saved to the computer/ The user is having problem only witht he excel files.Can anyone please help me with this?
Answer Question
| April 9, 2009 7:59 AM
Excel 2003, Lotus Notes, Lotus Notes email, Lotus Notes email attachments, Microsoft Excel, Microsoft Excel 2003
Cell Formatting Protection
How do I protect a cell (or series of cells) from being re-formatted, and yet allow the user to Sort and Copy the Data within the spreadsheet? When I LOCK the cell(s), then protect the Worksheet and contents of locked cell, I allow them to Select Locked Cells, Select Unlocked Cells, Delete Rows, Insert Rows, [...]
Answer Question
| April 3, 2009 2:43 PM
Excel Cell Formatting, Excel workbooks, Microsoft Excel
How do I protect a cell (or series of cells) from being re-formatted, and yet allow the user to Sort and Copy the Data within the spreadsheet? When I LOCK the cell(s), then protect the Worksheet and contents of locked cell, I allow them to Select Locked Cells, Select Unlocked Cells, Delete Rows, Insert Rows, [...]
Answer Question
| April 3, 2009 2:43 PM
Excel Cell Formatting, Excel workbooks, Microsoft Excel
How to assign a numerical value to a word in Excel
I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I [...]
Answer Question
| May 9, 2013 10:57 AM
Excel 2003, Excel macros, Microsoft Excel
I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I [...]
Answer Question
| May 9, 2013 10:57 AM
Excel 2003, Excel macros, Microsoft Excel
Excel 2003 toolbar functions greyed out, but not Excel 2007
I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). [...]
Answer Question
| April 2, 2009 6:26 PM
Excel 2003, Excel 2007, Excel Toolbars, Microsoft Excel
I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). [...]
Answer Question
| April 2, 2009 6:26 PM
Excel 2003, Excel 2007, Excel Toolbars, Microsoft Excel
PDF save as TXT file (VBA)
HI EXPERTS PLEASE SOLVE IT I WANT TO SAVE AS TXT FILE FROM PDF FILE THROUGH VBA (XLS) CODING; I WANT TO GET THE DATAs AS TEXT MODE FROM A SPECIFIC PDF FILE IN EXCEL SHEET PLEASE ANSWER IT ANANDA DEBNATH DELHI, INDIA
Answer Question
| September 26, 2011 4:01 AM
Microsoft Excel, PDF, VBA, Visual Basic for Applications
HI EXPERTS PLEASE SOLVE IT I WANT TO SAVE AS TXT FILE FROM PDF FILE THROUGH VBA (XLS) CODING; I WANT TO GET THE DATAs AS TEXT MODE FROM A SPECIFIC PDF FILE IN EXCEL SHEET PLEASE ANSWER IT ANANDA DEBNATH DELHI, INDIA
Answer Question
| September 26, 2011 4:01 AM
Microsoft Excel, PDF, VBA, Visual Basic for Applications
VB Active Cell problem
I am a vb problem. On an excel sheet, I am trying to have a macro run when the user selects a changing column’s active cell. For columns F to I on Sheet!Data, if you choose any cell in range (F9:I65000), then take the value of Column B in the selected row and make as [...]
Answer Question
| February 22, 2010 3:34 PM
Excel macros, Microsoft Excel, VB, Visual Basic
I am a vb problem. On an excel sheet, I am trying to have a macro run when the user selects a changing column’s active cell. For columns F to I on Sheet!Data, if you choose any cell in range (F9:I65000), then take the value of Column B in the selected row and make as [...]
Answer Question
| February 22, 2010 3:34 PM
Excel macros, Microsoft Excel, VB, Visual Basic
Loading image into MySQL database from Excel file
I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?
Answer Question
| December 19, 2011 11:57 AM
Database programming, Microsoft Excel, MySQL
I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?
Answer Question
| December 19, 2011 11:57 AM
Database programming, Microsoft Excel, MySQL
Data transfer from EXCEL using AS400 add-in to AS400 physical file
If EXCEL is the starting point, how can I make the user specify the file name to transfer the EXCEL info to. Or how can I lock a predetermined file until after the transfer is complete? Thanks in advance
Answer Question
| April 9, 2009 7:47 PM
AS/400, Data transfer, Exporting AS/400 to Excel, Microsoft Excel
If EXCEL is the starting point, how can I make the user specify the file name to transfer the EXCEL info to. Or how can I lock a predetermined file until after the transfer is complete? Thanks in advance
Answer Question
| April 9, 2009 7:47 PM
AS/400, Data transfer, Exporting AS/400 to Excel, Microsoft Excel
UNC alternative
I have many excel worksheets that link to other worksheets. Some link by drive letter mappings and others have a UNC name. Is there a way to link without using the UNC name? Concern is what to do if the linked server is changed. Do we have to go through each spreadsheet and change the [...]
Answer Question
| March 26, 2009 2:51 PM
Excel macros, Excel worksheets, Microsoft Excel, UNC, UNC path
I have many excel worksheets that link to other worksheets. Some link by drive letter mappings and others have a UNC name. Is there a way to link without using the UNC name? Concern is what to do if the linked server is changed. Do we have to go through each spreadsheet and change the [...]
Answer Question
| March 26, 2009 2:51 PM
Excel macros, Excel worksheets, Microsoft Excel, UNC, UNC path
