I am getting “compiler error in hidden module” error in Excel 2003 while running Macro
I am getting :”compiler error in hidden module ” error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !
Answer Question
| December 4, 2008 7:24 AM
Compile error in hidden module, Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel error messages
I am getting :”compiler error in hidden module ” error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !
Answer Question
| December 4, 2008 7:24 AM
Compile error in hidden module, Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel error messages
Search Excel Macro Help!
I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.
Answer Question
| March 17, 2009 3:24 PM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.
Answer Question
| March 17, 2009 3:24 PM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Deleting Excel Worksheets with macro
I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the [...]
Answer Question
| December 31, 2008 12:38 AM
Excel 2000, Excel 2000 macros, Excel macros, Excel workbooks, Excel worksheets, Microsoft Excel, Microsoft Excel 2000, Microsoft Excel 2000 macros
I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the [...]
Answer Question
| December 31, 2008 12:38 AM
Excel 2000, Excel 2000 macros, Excel macros, Excel workbooks, Excel worksheets, Microsoft Excel, Microsoft Excel 2000, Microsoft Excel 2000 macros
How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA
I’ve been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual existing graph and [...]
Answer Question
| November 19, 2008 4:53 PM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
I’ve been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual existing graph and [...]
Answer Question
| November 19, 2008 4:53 PM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
Excel 2007 – formula or macro to show value from one cell next to a given reference
Hope someone can help I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG – Sheet 1 has a cell with £500 in cell [...]
Answer Question
| November 18, 2008 3:26 PM
Excel 2007, Excel macros, Microsoft Excel
Hope someone can help I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG – Sheet 1 has a cell with £500 in cell [...]
Answer Question
| November 18, 2008 3:26 PM
Excel 2007, Excel macros, Microsoft Excel
How to paste data directly from Excel to PowerPoint graphic as data
I’ve been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste [...]
Answer Question
| November 16, 2008 5:05 PM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
I’ve been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste [...]
Answer Question
| November 16, 2008 5:05 PM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
new to macros – extracting data
Hello, I’m just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course code, course [...]
Answer Question
| November 25, 2008 5:52 PM
Excel macros, Macros, Microsoft Excel, VBA
Hello, I’m just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course code, course [...]
Answer Question
| November 25, 2008 5:52 PM
Excel macros, Macros, Microsoft Excel, VBA
How to send mail to multipie recipients from lotus using excel macro
Hi , I am using following code right now for sending mail from lotus using excel macro for single client its working fine Sub SendLotusNotesMail() Dim UserName As String Dim MailDbName As String Dim Maildb As Object Dim MailDoc As Object Dim AttachME As Object Dim Session1 As Object Dim EmbedObj1 As Object Dim recep [...]
Answer Question
| November 21, 2008 3:22 PM
Excel macros, Lotus Notes, Microsoft Excel
Hi , I am using following code right now for sending mail from lotus using excel macro for single client its working fine Sub SendLotusNotesMail() Dim UserName As String Dim MailDbName As String Dim Maildb As Object Dim MailDoc As Object Dim AttachME As Object Dim Session1 As Object Dim EmbedObj1 As Object Dim recep [...]
Answer Question
| November 21, 2008 3:22 PM
Excel macros, Lotus Notes, Microsoft Excel
Combining data from two Excel sheets into a new sheet
Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new [...]
Answer Question
| November 14, 2008 5:26 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new [...]
Answer Question
| November 14, 2008 5:26 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
How do I macro 20,000+ series of data?
The full s/s stretches to nearly 350,000 rows and consists of over 20,000 series of data, between 6 and 30 rows deep, in columns A:J. In column I of each series, on rows 3, 4 and 5 there are three numbers. The second number is to be subtracted from the first with the answer being [...]
Answer Question
| June 25, 2009 9:57 PM
Excel macros, Microsoft Excel
The full s/s stretches to nearly 350,000 rows and consists of over 20,000 series of data, between 6 and 30 rows deep, in columns A:J. In column I of each series, on rows 3, 4 and 5 there are three numbers. The second number is to be subtracted from the first with the answer being [...]
Answer Question
| June 25, 2009 9:57 PM
Excel macros, Microsoft Excel
Import text from another excel workbook
I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to [...]
Answer Question
| November 13, 2008 1:54 PM
Excel 2003, Excel functions, Excel macros, Excel workbooks, Macros
I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to [...]
Answer Question
| November 13, 2008 1:54 PM
Excel 2003, Excel functions, Excel macros, Excel workbooks, Macros
Microsoft Excel 2003 Macros
I am wondering if there is an easy way to remove macros from an Excel 2003 workbook. Several of our users have had emails with Excel attachments rejected due to the macros they contain.
Answer Question
| November 16, 2008 3:18 AM
Email attachments, Excel 2003, Excel 2003 macros, Excel macros
I am wondering if there is an easy way to remove macros from an Excel 2003 workbook. Several of our users have had emails with Excel attachments rejected due to the macros they contain.
Answer Question
| November 16, 2008 3:18 AM
Email attachments, Excel 2003, Excel 2003 macros, Excel macros
find which excel spreadsheets contain macros
in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?
Answer Question
| November 17, 2008 5:21 PM
Excel macros, Macros, Microsoft Excel, VBScript
in a folder or drive how can I find which excel spreadsheets contain macros without opening every one individually?
Answer Question
| November 17, 2008 5:21 PM
Excel macros, Macros, Microsoft Excel, VBScript
How to paste data directly from Excel to PowerPoint graphic as data
I’ve been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste [...]
Answer Question
| November 18, 2008 11:46 AM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
I’ve been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste [...]
Answer Question
| November 18, 2008 11:46 AM
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
New to macros
Hi, I’m just learning how to use macros and the first thing I’m trying to do is create a macro that will pull a character from a cell and place it in a new cell- for example “right(c10,1)”. My problem is I have a large list that I want to do this with but everytime [...]
Answer Question
| October 31, 2008 2:48 PM
Excel macros, Macros, Microsoft Excel
Hi, I’m just learning how to use macros and the first thing I’m trying to do is create a macro that will pull a character from a cell and place it in a new cell- for example “right(c10,1)”. My problem is I have a large list that I want to do this with but everytime [...]
Answer Question
| October 31, 2008 2:48 PM
Excel macros, Macros, Microsoft Excel
Import lotus notes view data from Excel
I need to import frequently data from some Lotus notes views into my Excel Sheets, I want to know if they are a macro or a vb script which could do that.
Answer Question
| November 6, 2008 3:18 PM
Excel macros, Lotus Notes, Microsoft Excel
I need to import frequently data from some Lotus notes views into my Excel Sheets, I want to know if they are a macro or a vb script which could do that.
Answer Question
| November 6, 2008 3:18 PM
Excel macros, Lotus Notes, Microsoft Excel
How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?
i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute [...]
Answer Question
| October 29, 2008 10:11 PM
Excel functions, Excel macros, Excel statistical functions, Microsoft Excel, Spreadsheets
i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute [...]
Answer Question
| October 29, 2008 10:11 PM
Excel functions, Excel macros, Excel statistical functions, Microsoft Excel, Spreadsheets
Excel macro between worksheets
I have an Excel Workbook with a “Paid” sheet and an “Outstanding” sheet, both sheets have a File Number column. I would like to create a macro that looks through the “Outstanding” sheet and if the File Number from the “Outstanding” sheet is also in the “Paid” sheet can the entire row be deleted from [...]
Answer Question
| November 26, 2008 4:59 AM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel
I have an Excel Workbook with a “Paid” sheet and an “Outstanding” sheet, both sheets have a File Number column. I would like to create a macro that looks through the “Outstanding” sheet and if the File Number from the “Outstanding” sheet is also in the “Paid” sheet can the entire row be deleted from [...]
Answer Question
| November 26, 2008 4:59 AM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel
Is there a macro to transfer a row of data from top to bottom row of range ??
I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3, [...]
Answer Question
| October 23, 2008 4:19 PM
Excel 2007, Excel 2007 macros, Excel macros, Microsoft Excel
I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3, [...]
Answer Question
| October 23, 2008 4:19 PM
Excel 2007, Excel 2007 macros, Excel macros, Microsoft Excel
Disable saving in Excel 2007
Hi, I need to get rid of the save option. I only want the sheet able save when the document is closed and it askes if you want to save. I do not want the document to be saved any other time. Here is my document (Office 2007 Only). http://www.savefile.com/files/1848919 It has been made to [...]
Answer Question
| October 21, 2008 9:18 AM
Excel 2007, Excel macros, Microsoft Excel, Office 2007
Hi, I need to get rid of the save option. I only want the sheet able save when the document is closed and it askes if you want to save. I do not want the document to be saved any other time. Here is my document (Office 2007 Only). http://www.savefile.com/files/1848919 It has been made to [...]
Answer Question
| October 21, 2008 9:18 AM
Excel 2007, Excel macros, Microsoft Excel, Office 2007
