Computer Support Forum

Macro to email an excel spreadsheet

Question: Macro to email an excel spreadsheet

I have a user who wants to create a macro which will automatically send an excel spreadsheet into outlook and email it.
Any suggestions welcome. Thanks.

More replies
Relevance 100%
Preferred Solution: Macro to email an excel spreadsheet

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 82%

Hi,

Im trying to create a Excel macro which scans the worksheet and if it finds a:

( ) in there then to colour it.

Between the brackets will be a number.

Any Ideas?

Cheers,

Jon
 

Answer:Macro for Excel Spreadsheet

"if it finds a: '( )' in there then to colour it."

So ... the cells in question are formatted as text?

"Between the brackets will be a number."

OK. But when you say "colour it", what is "it"? The number between the brackets? The number and the brackets? The entire cell? Might the cell content be more, such as:

Here's the news at ten (10)

?

Anyways, why a macro? Why not just a CF formula, such as:

=SEARCH("(*)",A1)>0

?

(sorry for all the questions )
 

2 more replies
Relevance 81.18%

This is my first time using an Excel macro, so I'm a total novice. I created the macro below. It seems to work just fine, but just as it's done I get a Microsoft Visual Basic error that says:

"Run-time error '1004':
Application-defined or object-defined error"

My choices in error-window at that point are "End", "Debug" or "Help".

I need help to get the macro working without the error.

The spreadsheet contains a product number in column 1 followed by an unlimited number of colors in column 2. Each 2-character color is separated by a comma. The purpose of the macro is to copy the row as many times as needed (1 for each color) and append each color code from col 2 to the product number in col 1.

The macro follows:

Sub FixModel()

x = ActiveCell.Row
y = x + 1
cursorpos = 3
addrow = 0

Do While Cells(x, 1).Value <> " "

Do While Mid(Cells(x, 2).Value, cursorpos, 1) = ","
Rows.Insert
Rows(x).Copy Rows
Cells(y, 1).Value = Cells(y, 1).Value + Mid(Cells(y, 2).Value, cursorpos + 1, 2)
y = y + 1
cursorpos = cursorpos + 3
addrow = addrow + 1
Loop

Cells(x, 1).Value = Cells(x, 1).Value + Left(Cells(x, 2).Value, 2)

x = x + addrow + 1
y = x + 1
cursorpos = 3
addrow = 0

Loop

End Sub

Thank you for any help anyone can provide!
 

Answer:Excel Macro to Copy a Row in a Spreadsheet

9 more replies
Relevance 81.18%

I have not coded vba macros fo many years. I am trying to create a macro that opens a second spreadsheet from the first. Copies a predefined range of cells from the second spreadsheet into the active cell of the first spreadsheet. The copy range in the second spreasheethas previously been highlighted. Here is the code:

Sub OpenSpreadsheet()
'
' OpenSpreadsheet Macro
'
' Keyboard Shortcut: Ctrl+m
'
' Dim mybook As Workbook.Name

Rows("14:14").Select
mybook = ActiveWorkbook.Name
Workbooks.Open Filename:="C:\Users\Peter\Desktop\Hiatt slide repair 2~ACTUAL.xls"
Selection.Copy
ActiveWorkbook.Close (False)
Windows(mybook).Activate
Selection.Paste

End Sub

I get an error message "obiect desn't support this property or method" for Selection.Paste. If I remove that line of code, I can then do a ctrl V after running the macro, and it will paste the data properly, so the problem is with the VBA paste statement. Please help.
 

Answer:Excel macro to copy from 1 spreadsheet into another

Probably you should use Selection.PasteSpecial instead
and I think there is something wrong with the order of things in your macro but that's becasue I don't see what your trying to do

Rows("14:14").Select
mybook = ActiveWorkbook.Name
Workbooks.Open Filename:="C:\Users\Peter\Desktop\Hiatt slide repair 2~ACTUAL.xls"

< here you are in the opened sheet but what selection????? >

Selection.Copy
ActiveWorkbook.Close (False)
Windows(mybook).Activate
Selection.Paste or Selction.PasteSpecial

But the problem lies in the red part
 

3 more replies
Relevance 80.36%

Have a procedure that is being used where large amounts of data are copied from Excel template to individual templates for users.

Wrote a macro to perform this task, worked perfectly for a few minutes, and then the formatting was off for the individual spreadsheet; the individual performing is again copying and pasting.

Other than picking up empty spaces in the macro, what else could be wrong?

Here is the macro:

'This macro copies all visible data from the source file to the create file, removes any excess rows/columns/formatting,
' deletes any sheets from the create file if no data is present, and renames the create file to the manager's name
' so that it's ready to be mailed to them
'Ranges need to be modified for each new set of data. They have been included in the comments for convenince for using
' find and replace throughout this page. A2 should always been the starting point for manager data. If
' multiple headers exist within a single sheet, delete all but 1 row for this macro to function properly.
' Only the end range should need to be changed. This should indicate the last row containing data for each sheet.
' Ranges in this function need to be updated to match the ranges called in each sub
'Vista Range("A2:A18210")
'EAS Range("A2:A34785")
'EFC Range("A2:A8265")
'INAS Range("A2:A1886")
'Vertex Range("A2:A109")
'Oracle Range("A2:... Read more

Answer:Excel Template, macro to create new spreadsheet

Hi, welcome to the forum
Nice code etc etc etc, but I don't think you realized that nobody is going to copy this and then try and figure out all the sheet names and so to test and troubleshoot.
If I read it correctly and seing that the excel file has the xlsx extension I assume at least Excel 2007.

I suggest you upload a copy of the file with dummy data or at least non-sensitive private dat in it so that we can try to figure out what the problem is.

A pice of advice when writing macro code: never hardcode filepaths into your code, everytime the location changes you have to go back to the drawing board.
 

1 more replies
Relevance 79.54%

Hello all,

I don't know if I'm posting in the right forum. This is an Excel problem I'm having at work.

I'm not overly Excel savvy, but I know enough to get by at work, and fix most problems myself.

I may just have some post maternity baby brain, but I can't fix this problem.

My manager has a spreadsheet with about 5 tables in, each with monthly totals for different areas, and each cell pulls data from half a dozen different spreadsheets and work books. Pulling cell refs from so many things makes it slow on opening, and management asked me to find a way to have individual months formulas calculate on the click of a button, rather than on opening the spreadsheet.

I did a little test sheet which worked fine, but when I did the same on managements spreadsheet it went a bit pete tong. I recorded a macro to input the formula, which when I recorded it, is fine - all totals are correct, but when I run the macro only half the formula appears.

I even tried a different method; taking out =sum, so the formula doesnt work on opening and having a macro that simply pops that bit back in, but half the formula disappears when I run it, even though the macro doesn't touch the rest of the formula.

Any clue as to why this happens, or am I just being a ditz and over complicating things?

Sorry if this is a bit confusing - I'm not great with excel, and I'm now at home without the spreadsheet so can't go into much detail.

Ta muchly.
 

Answer:Solved: Excel Spreadsheet macro/formula query

6 more replies
Relevance 79.54%

How will I write a macro in excel that will enable me to save a current workbook in a specified directory and use the wording in a cell on the spreadsheet as the file name.

I have tried copying a macro and have got as far as the new directory, but do not know how to name the file after wording in a cell in a spreadsheet.
 

Answer:Macro to save excel workbook as name in cell on spreadsheet

Just one simple line. Just change the portions in red to reflect your true save path and cell to use. You may need to also change the xls file extension if you are using Office 2007 or newer.
Code:
ActiveWorkbook.SaveAs Filename:="[COLOR="Red"]C:\TEST\[/COLOR]" & Range("[COLOR="Red"]A1[/COLOR]").Text & ".xls", FileFormat:=xlNormal

 

1 more replies
Relevance 79.54%

Hi
I have set up the following macro to enable users of the spreadsheet to insert a row and copy the formating and formula's. For some reason, when I go to insert a new row again, it inserts the row in a completely random place and not in the exact same place. People may want to add 20 rows one after the other to populate and I am trying to enable them to do this without having to worry about the formulas in there (I want to protect the formula's to ensure they don't overwrite them). Can anyone help? This is my code from Excel 2007 (I recorded a macro, I am not competent and writing them from scratch):

Sub InsertRowStock()
'
' InsertRowStock Macro
' Insert a row into the stock sheet and copies all formats and formulas
'
' Keyboard Shortcut: Ctrl+i
'
ActiveCell.Offset(27, 0).Rows("1:1").EntireRow.Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
ActiveCell.Offset(-1, 0).Rows("1:1").EntireRow.Select
Selection.Copy
ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
 

Answer:Macro to insert rows into Excel 2011 spreadsheet

Just one other thing, I think the rows it is inserting are every 27 rows down but I want a row always to be inserted in the one specific place on the worksheet.
 

1 more replies
Relevance 79.13%

I have searched the net but cannot find anything specifically what I'm trying to accomplish.

I have a timesheet, of sorts, that I added buttons to move around and I would like to add a button for the user to click and it will send the Excel spreadsheet to me when they're done entering their data. I can get the email to open a new email message with the file attached but I'm stuck on getting my name in the To field, as well as a subject and body. Then I would like for it to send and display a message that the email was sent.

I am using Office 2003

Any help would be appreciated.
 

Answer:Solved: Macro to Send Email with Spreadsheet as attachment

7 more replies
Relevance 77.9%

I need to write a macro that will copy data from one spreadsheet into a separate spreadsheet (not in the same file). Here is the scenario...

On the first spreadsheet I have a customer's name in one column and a customer's address in another column. On a separate spreadsheet a have those same customer's names without the addresses. On the second spreadsheet the customer's name may be listed more than once. What I need to do is add the corresponding address to the second spreadsheet beside the name of the customer (identical data from both spreadsheets). The reason copy and paste won't work is because the customer may appear numerous times on the second spreadsheet and their are approximately 50,000 rows of data.

The macro needs to basically say IF Spreadsheet 1, Column A (customer) equals Spreadsheet 2, Column G (customer) then ADD/REPLACE info from Spreadsheet 1, Column B (address) to Spreadsheet 2, Column H (currently blank). I just can't figure out how to make it do that. ANY HELP ANYONE CAN GIVE IS APPRECIATED!
 

Answer:Solved: Need Help Writing a Macro for Excel to Move Data From One Spreadsheet to Anot

7 more replies
Relevance 77.9%

I am currently trying to create appointments in a calender i have created in outlook using information from an excel spreadsheet. I have copied several codes from other forums to help with this Macro but have only been able to add the appointments to my calender.

The code i am currently using is:

Sub ExportAppointmentsToOutlook()
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "E").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0
'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = Location
For i = LBound(arrAppt) To UBound(arrAppt)
Set olApt = olApp.CreateItem(olAppointmentItem)
With olApt
.Start = arrAppt(i, 1) + arrAppt(i, 2)
.End = arrAppt(i, 1) + arrAppt(i, 3)
.Subject = arrAppt(i, 4)
.Location = arrAppt(i, 5)
.Body = "Created by excel tool"
.BusyStatus = olBusy
.ReminderMinutesBeforeStart = 5
.ReminderSet = True
.Save
End With
Next i

Set olApt = Nothing
Set olApp = Nothing
End Sub
I also have the calender location but have no idea where it would need to fit into... Read more

Answer:Macro/VBE to create appointments in Outlook from an Excel Spreadsheet (Office 2003)

16 more replies
Relevance 77.08%

Hi,

I have several completed templates that I need to summarize into a spreadsheet.

Is there a way for me to list down the files and the location of the excel spreadsheets and run a macro for copying the data I need from the files listed and pasting them into a spreadsheet format?

Here's what I am doing now, manually.

1. Open file1
2. Copy B2
3. Paste to SummaryFile on B1
4. Copy C2
5. Paste to SummaryFile on B2
6. Copy D2
7. Paste to SummaryFile on B3
8. Close file1

9. Open file2
10. Copy B2
11. Paste to SummaryFile on C1
12. Copy C2
13. Paste to SummaryFile on C2
14. Copy D2
15. Paste to SummaryFile on C3
16. Close file 2

I hope somebody can help.

Thanks,
Monica
 

Answer:Solved: Excel Macro needed for creating a spreadsheet from data on several but similar files.

7 more replies
Relevance 72.57%

How to Extract Email Addresses From Excel Spreadsheet. How to extract emails from different cells into a new sheet.

Answer:How to Extract Email Addresses From Excel Spreadsheet

Without knowing the layout of your spreadsheet, it is impossible for us to answer your question. You need to supply some more details.If you are going to post any example data to show us how your spreadsheet is set up, please click on the following line and read the instructions found via that link.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 72.57%

I have saved my contacts to an excel spreadsheet. I opened my windows live mail and clicked on import, and followed the directions. out of the 5,000 email addresses, only 233 imported into my contacts. why is this? is there a limit on how many email addresses you can import at a time or is there a limit to how many contacts you can actually have in windows live email?
 

More replies
Relevance 72.57%

Hi,
I am a summer student for a concrete company and I am responsible for keeping all of our MSDS up to date. I have a spreadsheet set up to summarize it and that includes expiration dates. Currently the dates change color when it is within 30 days of expiration and to red when it has passed the expiration date. My problem is I have other jobs to do at the same time and don't check the sheet daily. Is there a way I can have Excel email my outlook account when the msds hits 30 days before the expiry?

P.S. I'm running excel 2010
 

More replies
Relevance 72.57%

Hi,

My company uses an excel spreadsheet to record when we are providing information to clients. Mmy colleagues enter this into the spreadsheet and should tell me when we have finished providing the information - which means that I then raise an invoice to the client for the number of days' work we have done. Unfortunately, they can forget - so I then have to go through the spreadsheet daily to double check that my invoices are right. I'm sure there must be a way of inserting some sort of code into the spreadsheet so that I get an email automatically when I should raise an invoice. I know very little about excel though and don't have a clue how to understand or manipulate any of the codes posted for similar sorts of queries! My initial thoughts were:

1. Put a column in the spreadsheet whereby the colleagues enter the value "0" if providing info that day or "1" if the info supply has stopped.

2. I could put in a conditional format so that the client's name cell becomes red as a visual clue - but there is still a risk that I miss it, as the column would gradually become more and more red (or I enter value "2" once I have raised the invoice which then turns it blue).

However, what I would really like is that Excel spots that the value has been changed from 0 to 1 and then emails me to say that it is time to invoice the client (and which client it is that needs to be invoiced).

Could someone please provide clear, step by step... Read more

Answer:Email me when colleague changes value of excel spreadsheet cell

Hi, and welcome to TSG forums

I had several thoughts upon reading your post. Preparing an email message with Excel is an easy task. Preparing and sending it is a bit more difficult, but no problem either. However, choosing the event that triggers email sending requires a thorough planning.
I'm not sure I understood completely the situation, but it seems that either way, the notification will depend on other users (i.e. your colleagues), who either call you by phone, or send you an email, or change a cell's value from 0 to 1 (which latter would then trigger a mail sending), etc.. And there comes my problem. If you colleagues can forget to call you, even though it is a strict part of their workflow, how can you be sure they won't forget to put 1 into that cell? Or, even if they do put 1 into that cell, will they do it when they will have already filled the other cells? Or maybe someone will think: 'I'm gonna deal with these clients today, and I'm surely gonna close their cases, so let's put 1 into those cells right now, before I forget to do it.' And her computer sends you a bunch of emails, signaling that you can raise the invoices, even though she hardly even started to fill the spreadsheet.
Maybe I'm getting it wrong but the bottom line is that when you depend on others, who are also typically non-expert Excel users, there's always a chance that they will fail you.

So maybe it would be a better approach to create a code th... Read more

3 more replies
Relevance 71.75%

I am having a problem figuring out how to email an Excel 2007 spreadsheet in the body of an email. I cannot do it as an attachment as the owner of the company is just not that computer literate. I recently got a new computer at work and they installed Office 2007. I am getting use to it but I cannot find the way to do this simple thing. Copy paste does not work and the only command I have found so far is "Send Email" in the file menu when you click on the Office Icon but this opens an email with the spreadsheet as an attachment. Can someone help?
 

Answer:Emailing an Excel 2007 spreadsheet in the body of an email

Don't have Office 2007 and can not test this, but ...

First, are you sure you are composing the new e-mail as HTML formatted when you tried the copy and paste?

Does Excel give you the option to save the worksheet as an HTML file? If so, try opening the saved HTML file in Internet Explorer and then copying and pasting from IE into your HTML formatted e-mail message.
 

2 more replies
Relevance 70.93%

Hey everyone,

I'm trying to stretch my resources and minimize some data entry, using the tools at hand. However, I've hit a bit of a wall on inspiration - looking for some ideas.

I have an Excel Spreadsheet (about 8 worksheets) that I use to log some daily activities - however, because I have a lousy memory, I like to email myself from the road with the notes for my Log. Then, when I return to the office, I either re-type (or copy/paste) my email notes into the appropriate sections of my log file.

What I'd LIKE to do is create a form and rule in Outlook that would auto-fill my Excel worksheets based on the text of my email. I'm not worried about Triggers (the rules setup on that end is simple enough for me), I'm more looking for the best way to have Outlook interact with Excel in this way.

I send emails from the road on my Android phone.

Any ideas? Thanks!
 

Answer:Solved: Outlook Email to Auto-Fill Excel spreadsheet

8 more replies
Relevance 69.7%

Hi,

Im quite new to this excel programming thing and could really do with some help.

I need to send an automated email to 3 recipients (always the same 3 email addresses) when a number (formatted from a countdown of days to go) is 10 or less. Also i need a different automated email to be sent when a date is manually entered into a different cell.

I have managed to get the current date and time on my spreadsheet and used the format to work out the days to go to the deadline.

I have looked over all different types of forums but unfortunately because i'm still very green when it comes to excel i get lost and confused when trying to do this.

Is there anyone out there who can treat me as an alien and help me through this step by step.???
 

Answer:Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

10 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi

I am trying to write a macro in Excel 2003 to automatically send an email using Outlook to a list of individuals asking them to confirm their personal details using the attached template. Could someone show me where I am going wrong with the script please?

Many thanks
 

Answer:Excel Email Macro

16 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi All,

I have a spreadsheet and i am needing to create a macro that will opena new message in Outlook and populate the 'To' Field with one cell and then the 'CC' field with 2 email addresses, one from one field and the other from a different field. then the subject from another field and then the body from another. it then leaves the message window open so i can check it right and hit send.

I found the script the other day but can not find it anywhere including this site.

Any help on this will be great.

JPL

Any
 

Answer:Excel Email Macro

Hi JPL,

You could use this function, just pass the values to it
Code:

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)

With Itm
.Subject = mSubject
.to = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Function

It's from one of the posts, I do not remember which one
 

1 more replies
Relevance 68.88%

Any way of controlling the time a email is sent via a excel spread sheet using vba?
 

Answer:Excel - macro email-

6 more replies
Relevance 68.88%

I have an Excel model (office 2000) which has a range of cells that contain if/then statements. I'm trying to get Excel to automatically send an email if any of the cells within that specified range were to provide a value that was false. Is this possible? Thanks for any insight.
 

Answer:Email Macro in Excel??

16 more replies
Relevance 68.06%

My sense is this is a pretty simple request, but I'm completely illiterate when it comes to VB.

I have an excel spreadsheet with a number of data points. I'm looking to export the entire sheet to a CSV file and send it via Outlook. Any suggestions?
 

More replies
Relevance 68.06%

Hello all;

I am new to this forum and also to Excel macros. I have a large Excel file detailing financial accounts with my small business.
Anyway, I would like to email any customer who has an overdue balance as per column V in my attached sample file (any customer with a greater than zero value in V). I would like to send an email; something like this:

Joe Wilson;
As of 2/28/11 (latest date in the row that is on/after the current date), your account is currently overdue and you owe $1500.00 (G3).
Thank you.
Treasurer
I found several other threads explaining how to send an automatic email from Excel, but I haven't found one for sending an individualized email to a list of recipients. If this question has been answered, please feel free to redirect me. Otherwise, I'd appreciate any suggestions. Please let me know if I can detail my needs any better.
Thanks!
 

Answer:Excel Macro: Auto Email

welcome to the board.

I put some code in the sheet

The macro name is CheckAndMail

Let me know if this is what you need

PS: I just corrected something I came accross and have re attached the corrected sample
 

2 more replies
Relevance 68.06%

Windows 7 --------------------------------------------------------------------------------First thing...I know nothing about macros!! I do know a very little about formulasI have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"sendworks great but, I have to go thru 86 rows in column "E" and hit "Send Due" numorous times,then hit send again on all the emails, can we automate this some how, like a macro that engadges when I open my outlook every morning?Thank u

Answer:Need Macro to automate email from excel

I have written code in Outlook, which is essentially a template, you fill in the details, all sorts of stuff happens accordingly to what you have selected, and you press send and it will send the emails to whoever it is you want. Iv done this in Outlook, so my question is, why do you need this to be done in Excel? is Outlook acceptable?

3 more replies
Relevance 67.24%

I would like to ask for an Excel macro which can send an automate email on a certain date every Month.

The dates would be as follows:

1st Monday: Email should be sent to [email protected] automatically
2nd Wednesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

"Dear All,
This is to remind you that we are expecting the data transfer to be posted in Novartis system today . This is just an advanced intimation.

Kindly let us know if you foresee a delay in the data transfer.

Kind regards,
Rohit"
Many thanks in advance for your help guys. This means a lot.
 

More replies
Relevance 67.24%

Hi - I have a list of names for a particular company where I have the first name and last name of the customer plus the email naming convention their company uses. For example the company's email naming convention is: [email protected] Is there a way I can create an Excel Macro that will automatically create the email from the available information? For example if I create three columns where one has the first name, last name and the @companyurl.com?I hope someone can help with this as it will save a lot of time!!Thank You!

Answer:Need Excel macro to creat email address out of just a name

This can be done fairly easily, but I'm not going to offer any suggestions.Since it appears that you do not work for this company, I can only assume that this will be for some sort of mass, unsolicited mailing. If your project was sponsored by the company in question, they would supply you with a distribution list and you wouldn't have to build your own.For all I know, I'm on that list of names that you have and I don't need any more unsolicited email.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 67.24%

Hi there,

I have a workbook which i would ideally like to send an automated mail when the date is within 30 days of "Todays date" .
I have found something similaar on past posts whichprints certain cells to an email but is triggered by a button press not date, but wondered if anyone could adjust it for me as my excel knowledge is very limited.
I really am struggling.

The password for the spreadsheet is Kalibratedbyme (capital K)

Best regards and many thanks!
 

Answer:macro to allow a date to send an email in excel

The content is different but why are you duplicating a post?
 

3 more replies
Relevance 67.24%

Hello

I need to come up with a simple outlook macro (or script?) that fires off whenever a new email meeting certain criteria is received.

1. new email is received with "please refresh quotes" in the subject
2. outlook runs a macro that causes another macro to run (the second macro is located in a excel workbook which is already running in my office pc)
3. the excel (attached) is simply refreshing market prices and emails whenever the macro is triggered. because the quotes are obtained via a DLL feed I can only get it at work.

the purpose is simply to get live market quotes on my personal email from my work email whenever i need.
thanks in advance for your help.
 

Answer:Solved: Run excel macro when new email is received

9 more replies
Relevance 66.42%

Hello,

My first post, sorry to be a leech right off!

I'm trying to automate some of my day to day emails. I'd like to get a macro set up that will send an email from Excel and paste the range I select in to the body of the email. Would be great if it would send to a list of addresses listed on the page as well.

Using the attached example, I'd like the macro to take whatever range I highlight on the table, copy it to the body of an email and send it to the group of emails listed on the right side.

I'm learning excel, this would help me a lot! I'll be editing this to fit a variety of other tasks. I hope it can be flexible. Thanks in advance.

Chris
 

Answer:Macro: Email Range/Selection to group from Excel

http://www.rondebruin.nl/mail/folder3/mail4.htm

I have done the looping attached.
 

2 more replies
Relevance 66.42%

Hi
I need help writing a macro that takes an Excel file to email.

The Excel file is a data base, I wanted the Macro to take the email from a column of the Excel file, and send out the email to all the emails in the database, if possible also adding a column of the Excel file to address the specific person.

thank you.
 

Answer:need help writing a macro that takes Excel file to email

Can you post a sample file? Please remove any sensitive data.

Rollin
 

2 more replies
Relevance 66.42%

Hy guys

2nd time i am posting stuff for help, and as i was helped before i will again look forward the response.

I have a file of excel, in which i am sending emails to different candidates of admission, with scan letter placed in the same folder by name.

I want to edit this code, which could select attachment based on Column A list adjacent to the email address

I am attaching the file also pasting the code

Sub Test1()
'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
'Working in Office 2000-2013
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim SigString As String
Dim Signature As String
Dim cell As Range

Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")

On Error GoTo cleanup
For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "?*@?*.?*" And _
LCase(Cells(cell.Row, "C").Value) = "yes" Then

Set OutMail = OutApp.CreateItem(0)

strbody = "We at Graduate School of Engineering Sciences and Information Technology are extremely pleased to know that you have selected Hamdard University as preferred choice for your graduate/post-graduate Studies. " & vbNewLine & vbNewLine & _
"Hamdard University is a pioneer Higher Education Institute (HEI) of Karachi producing Masters and PhDs in the fields of Engineering, Computer Sciences, Information Technology, Energy and Environment since 19... Read more

Answer:Attachment based on cell value in a excel email macro

anybody ???
 

2 more replies
Relevance 66.42%

Hi:
I am very new to Excel 2007 and macros. I have a spreadsheet that I am trying to get to send an email reminder to the point of contact [ col b ] 5 days prior to the closure document due NLT date [ col m ]. I am looking for assistance in writing a macro which will accomplish this if it is possible. I have attached the spreadsheet that I referenced.
Your assistance would be greatly appreciated.
Thanks in advance.

desantisj
 

Answer:Excel 2007 Macro to Send Reminder Email

desantisj, welcome to the Forum.
There are already 3 or 4 posts on this forum that have the VBA code (Macro) that you can modify for your Workbook if you can read the code. Zack has written the code so it is a bit complicated, but it should be a case of substituting your Cell references that hold the data for the ones that others have used.
Otherwise it is a case of waiting for an Excel guru to come along and help. If none of them come along I can probably help you, but I normally work with Access.
 

2 more replies
Relevance 66.42%

I found this code in this forum.
i want to add recipient as CC or BCC. What is the correct code for that?
Thanks in advance!

Code:
Public Sub email()

Dim SubJ, Recip As String

SubJ = "Enter your suject"
Recip = "[email protected]"


ThisWorkbook.SendMail Recip, SubJ

msgbox "Email Sent"

End Sub

 

Answer:Send excel sheet ( email) through macro with recipient and cc

6 more replies
Relevance 66.42%

Hi there - Using MS Access 2007.
I have a FORM with a macro that runs a query to generate ONE excel file and attaches to email using MS Out look to send out. - That Works great.

Problem: Multiple users to send email & attachment.
I would like for the macro to generate excel file (S) - based by the UID.

Can someone suggest a better way of handling this that is not time consuming?

Thanks In advance!
 

Answer:MS Access 2007 - Macro > Excel > Auto Email

Access can open Outlook and send an attachment to mutiple recipients either as a list or as individual emails.
So are the attachments all the same for the recipients?
 

1 more replies
Relevance 66.01%

Hello,

I have a list of email addresses that have either:
[email protected]
[email protected]
[email protected]
or no corelation to [email protected]

I'm looking for a macro that will take the emails with dots in them and put the first and last names into cells next to the email. The others I can do by hand. PLEASE HELP!
 

Answer:Solved: Excel Macro to convert email addresses to names

16 more replies
Relevance 66.01%

I found how to send an email from an Excel Macro (http://forums.techguy.org/business-applications/1056070-solved-excel-email-outlook-code.html)

Here is the code I'm using:
Code:

Sub Email_Test()
'
' Macro11 Macro
' Keyboard Shortcut: Ctrl+r
Dim eSubject As String
Dim Sendto As String
Dim CCto As String
Dim Body As String
Dim app As Object
Dim Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)
'Populate variables

mSubject = "Excel EMail Test"
Sendto = "[EMAIL="[email protected]"][email protected][/EMAIL]"
CCto = ""
mMessage = "You have received Knowledge Document Feedback for your domain."

With Itm
.Subject = mSubject
.To = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Sub
Is there a way to format the message section with bullets? How about paragraph breaks?

Name: John Doe

Date: 6/15/2012
Doc #: KM123456
Etc:
Etc:
Comments:
I'm perfictly willing to look at how-to documentation if someone can point me in the right direction.

Thanks
firstshot
 

Answer:Solved: Formatting Excel Macro Email Message Section

Hi, I haven't really looked myself but instead of bullets I generally use a dash and a tab
Paragraph as such are not possible but you have the linefeed and carriage return

example to add to your macro code before calling the mail proc
Code:

Dim mytext as string
mytext = vbnullstring
mytext = "Dear Jon Doe" & vbclrf & vbcrlf
mytext=mytext & "-" & chr(9) & "Date :" & the date variable & vbcrlf
mytext=mytext & "-" & chr(9) & "Doc #:" & the dos variable & vbcrlf
mytext = mytext & "-" & chr(9) & "Etc :" "etcetera"
mytext = mytext & vbcrlf & vbcrlf
mytext = mytext & "Sincerely yours," & vbcrlf & vbcrlf
mytext = mytext & "Jane Doe" & vbcrlf

vbcrlf can also be replaced wij Chr(10) or Chr(13)

See it this helps.

Maybe html formattingis possible but this works just as fine.
 

3 more replies
Relevance 65.19%

Hi all,

I need to know if is it possible that a macro in Excel sends an email containing the visible cells using Microsoft Outlook.
btw, I saw some code on the internet, that saves the visible cells in a new excel file and attach it in a new email using Microsoft Outlook, but I don't want to have attachments in the email.

thanks for any possible help.
 

More replies
Relevance 65.19%

Hi all

Looking for some help! Working on an excel document which contains a button I need to send to multiple people, that's fine what I need is for the subject field of the email to take the contents of a particular cell in the workbook and display that. My current code is;
Code:
Sub SendThis_ActiveWorkbook()

Dim Recip()
With ActiveWorkbook

ReDim Preserve Recip(0)
Recip(0) = "[EMAIL="[email protected]"][email protected][/EMAIL]"
ReDim Preserve Recip(1)
Recip(1) = "[EMAIL="[email protected]"]example[/EMAIL][EMAIL="[email protected]"][email protected][/EMAIL]"
.SendMail Recipients:=Recip, _
Subject:="Vacancy Authorisation " & Format(Date, "dd/mmm/yy")
End With

End Sub
Basically I want the subject to be "Vacancy Authorisation [cell contents] 01/01/2000" so I want the contents of a cell to appear in between the date and the "vacancy authorisation" part of the subject line. Assistance appreciated!
 

Answer:Solved: Excel email macro auto-populate subject line

Subject:="Vacancy Authorization " & Range("A1").Value & " " & Format(Date, "dd/mmm/yy")

Regards,
Rollin
 

2 more replies
Relevance 65.19%

Although decently experience with excel, I am quite new with VBA and I cannot "record" this macro, so any help writing this in VBA is much appreciated.

1) I need to create a macro that will take a number that is entered into a cell, and upon hitting a button in the excel sheet create an email where the subject line is the number that was in that original cell.

1b)I would like to do this without changing the name of the excel file though, or at least have another macro that resets the file to its original name.

2) Also, if possible, the same macro/vba as above, only with two cells, a number in one and a name in the other, which then shows up as "Number-Name" as the subject line in the email.

Thanks to anyone that can help - Mike
 

Answer:Excel Macro -> email created with field data as subject line

8 more replies
Relevance 62.32%
Question: Spreadsheet/macro?

Good evening everyone,

I hope you can help me, I have a spreadsheet set out as follows, I need to collate this data (received on a daily basis) and supply info weekly :-

Container No. GLCX 315321321
Booking Ref: 12345 Bay k2
G12334 13 1 18.7 J12
G12335 48 0 17.5 J13
G12336 555 0 17.5 J14
Container No. MCPU 64654987
Booking Ref: 12346777 Bay k6
G5557 13 1 18.7 J15
G3332 48 0 17.5 J16
G388 555 0 17.5 J17
G3333 33 1 1.25 J18
G332884 255 0 45.48 J19
G3111 21 2 20.5 J20

How can I make it look like the following (a normal spreadsheet that I can sort etc. etc.) , bearing in mind that each group has a different number of lines each time and there could be 50 groups to a spreadsheet :-

Container No. Booking Ref. Bay No. Col 1 Col 2 Col 3 Col 4 Col 5
GLCX 315321321 12345 k2 G12334 13 1 18.7 J12
GLCX 315321321 12345 k2 G12335 48 0 17.5 J13
GLCX 315321321 12345 k2 G12336 555 0 17.5 J14
MCPU 64654987 12346777 k6 G5557 13 1 18.7 J15
MCPU 64654987 12346777 k6 G3332 48 0 17.5 J16
MCPU 64654987 12346777 k6 G388 555 0 17.5 J17
MCPU 64654987 12346777 k6 G3333 33 1 1.25 J18
MCPU 64654987 12346777 k6 G332884 255 0 45.48 J19
MCPU 64654987 12346777 k6 G3111 21 2 20.5 J20

I get so far using a macro.....then lose the plot... can anyone help please?

Is this enough info?

Thanks,

Moll
 

Answer:Spreadsheet/macro?

8 more replies
Relevance 61.5%

I was creating an Excel file (2003, yes still using it). I had the spreadsheet almost complete, but a formula wouldn't work the way I needed it to. I tried writing macros, but realized there was a simpler solution. Convert it to LibreOffice and the formula works the simple way. But because I'd used macros before, it's giving me a security warning, even though I am not using macros. How do I remove all the macros in the file, and also tell the program I'm not using them. That way the warning will go away. I'm not sure I want to disable the warning globally or not, but if there was a way to do it for just this spreadsheet, that would certainly work too. I'll attatch the spreadsheet here.
 

More replies
Relevance 61.5%

I'm working with a very situation and need some input. I have a spreadsheet that if there if a value greater than 10 in the field, I need a row inserted below the current row.Is there a macro someone can help me with to do this?For example.. if G2>10, insert row beneath 2. All help is appreciated!!

Answer:How to write Macro to add row to spreadsheet

There are many different spreadsheet programs out there, and writing macros for them is not always done in the same way or with the same syntax. Letting us know what program you are using would make it easier to help.Meanwhile lets hope one of the moderators can move this thread to the Office Software forum, where is belongs, and will attract attention from those best suited to help.NigelWind slow

5 more replies
Relevance 61.5%

Need help fast!!!! Macro to e-mail spreadsheet with specific info

I need to change the macro I currently use to email an excel spreadsheet so that it emails to a specific email address and enters data (from 2 cells in the spreadsheet) into the subject line. I am not real good with these things so if anyone can help - I would greatly appreciate it! Here is the macro I currently use:

ActiveWorkbook.UNPROTECT
Sheets("ACKNOWLEDGMENT").Select
ActiveSheet.UNPROTECT
Sheets("ACKNOWLEDGMENT").Select
Sheets("ACKNOWLEDGMENT").COPY
Sheets("ACKNOWLEDGMENT").Select
Sheets("ACKNOWLEDGMENT").Name = "COMPLETED ACKNOLEDGEMENT"
Range("G4:H4").Select
Application.Dialogs(xlDialogSendMail).Show
Windows("USTruckbuilder10.15.2009(version1)-1.xls").Activate
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Order Form").Select
ActiveWorkbook.Protect Structure:=True, Windows:=False
End Sub



Thanks!
Bublin
 

More replies
Relevance 60.68%

Hello,
I was just wondering if there is a way to Delete a Spreadsheet, using a macro? Thanks
 

Answer:Solved: Delete Spreadsheet via Macro

Code:
Sub DelSht()

'This is so you don't get the confirmation

Application.DisplayAlerts = False

sheets("YourSheetName").delete

Application.DisplayAlerts = True

End Sub
 

2 more replies
Relevance 60.68%

I have a spreadsheet that I need to automatically password protect via a macro. I have gotten it to protect, but not with a password. Need to make sure that when sent to a customer they cannot UNPROTECT it. Can anyone help me with the script? I am using Excel 2003.
 

Answer:Password protect a spreadsheet via macro

Hi there, and welcome to the board!

Depending on where you are running the code from (assuming the workbook in question) you can use...
Code:
ThisWorkbook.Sheets("Sheet Name Here").Protect password:="password here"
Just know that Excel is NOT SECURE and these passwords are very easily hacked. Of course most people do not know that, but to somebody with determination and/or know-how, it is very simple. A couple minutes, tops.

HTH
 

1 more replies
Relevance 59.45%

Hi Folks,
I have a valued Excel 2003 spreadsheet that, I can currently only open in Excel 2007. However, an error message has been displayed that Excel was unable to read some of the document and it did a recovery. The file has now lost a few key sections. I have attached the error log below.

Any suggestions please?

Thanks,
Dave

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error033640_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\User\Documents\tool sourcing.xls'</summary>
-<additionalInfo>

<info>Excel recovered your formulas and cell values, but some data may have been lost.</info>

</additionalInfo>

</recoveryLog>
 

More replies
Relevance 59.45%

I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?

Leanne
 

Answer:Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Welcome to TSG.
Can this file be opened fine in Excel 97? Any chance that it is corrupted?
What are some of the error messages you are getting?

 

3 more replies
Relevance 59.04%

I am using the MSN Stock Quote addin with MS Excel 2003. Prior knowledge of this should not be necessary, but I just thought I'd provide full context to my issue. I wrote a macro that essentially records daily stock prices. Because I don't want to store old quotes into perpetuity, i need to ensure that the update quotes button has been hit. I use sendkey() to accomplish this, and then the macro copies the quotes and pastes them elsewhere. My main goal is to have the task scheduler open this file daily so i dont ever have to think about this again, and i'm so close. Essentially my problem is that it takes a few seconds after the update button is hit for the add-in to fetch the new prices from the internet, and this process appears to be delayed until the macro is finished. This is a problem because the macro ends up recording un-updated quotes. I have tried the Application.Wait procedure, and I've tried time consuming loops, do while loops, etc. All of these approaches result in the same thing: Can someone please help me with this? I'm too lazy to hand update this spreadsheet every trading day for the rest of my life (or until i quit). Thank you in advance!
 

Answer:Excel Macro - Allow cells to update query before macro completes

Can't you just put the update macro code in a module of it's own and call it from the main macro?

Regards,
Rollin
 

1 more replies
Relevance 58.63%

I'm trying to Merge an Excel spreadsheet to Outlook and provide alerts for critical dates in said spreadsheet in the Outlook calender !
 

Answer:Excel - Merge Excel spreadsheet to Outlook with Alerts

Welcome to TSG faithtronic.

I've never done it but your thread has been setting here a while. A method to do this here http://www.ehow.com/how_5685419_create-calendar-excel-data.html

I would start with a couple of dates so not to screw up the whole calender! There are some sharper excel folk on this site that might provide a better answer. But this is a starting point?
 

1 more replies
Relevance 58.63%

Hi
I am trying to export data from word or excel form into a spreadsheet. I have tried the macro at http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html and it worked for all text fields but not the drop down list options that I have in my form. Can anyone please help/

I have never done this before, hence the struggle. Any help would be much appreciated.

I attach the word form and the excel form which also includes the excel spreadsheet that will collate the data for analysis.

I would prefer the form in word and have it set up as that indicated in the forum thread above but picking up the data from the drop down lists as well.

Thanks
LAD786
 

Answer:Export data from word or excel into Excel spreadsheet

Hi there, welcome to the forum.
It seems this post you added on August 12th hasn't given you much answers.
You mention the two files, OK, But what I don't understand
I am trying to export data from word or excel form into a spreadsheet. ...
Click to expand...

You probably forgot to attach the macro's with it, that is if you did anything with the link you mentioned.
If you could attach the files with the macros, I could take a look and see what I can do for you.

Another thinng From Word or Excel.

Which one is it going to be?
 

1 more replies
Relevance 57.81%

I have some VBA code that copies all the filenames in a Windows folder and pastes them into an Excel spreadsheet. Here it is: Dim myRow As Integer Dim myFile As String Dim mySheet As Worksheet For Each mySheet In Worksheets mySheet.Select mySheet.Unprotect Next mySheet Sheets("Files").Select Range("a1").Select myRow = 1 myFile = dir("*.xls")Do Until myFile = "" Cells(myRow, 1) = myFile myRow = myRow + 1 myFile = dirLoopThis works really well except I have to open the file that runs the code from within Excel, otherwise I get the file names from the default file location. I'd like to open the file from a desktop shortcut and have the code go to the directory of my choice. I've tried ChDir and opening a dummy file at the beginning of the macro, but neither of these works.Hope you can help. Thanks, MaryPS The above code might be useful to Onizuka

Answer:Excel VBA copy filenames into Excel Spreadsheet

ChDir should work. You need to specify the full path to the folder in " quotes.

8 more replies
Relevance 55.76%

Hi,

After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not changed. Is there a safe free program that can uncorrupt a file? I have tried Open and repair, changing the format, and using open office. Also tried using recova but the file was not lost.
 

Answer:Solved: Excel 2007 spreadsheet gets error "Excel cannot open the file .xlsx.." How ca

https://support.microsoft.com/en-us/kb/820741

and 5 ways are shown here http://www.wikihow.com/Recover-a-Corrupt-Excel-File
 

2 more replies
Relevance 55.35%

Hi, I'm new to this forum (actually forums in general) I was wondering if anyone could help me with a macro code. I work with 4 Excel sheets for my shippments, 2 sets for one plant and 2 for the other but all within the same file.

What I am trying to do is set up a macro that will automatically search for changes within sheet 1 (also for sheet 3, the other plant) When I change the rows color from blank to green/red, I need the macro to automatically cut that whole row and paste it into sheet 2 on the next blank row.

This doesn't seem like it would be that hard to do, but I know know the whole macro language.

If you can answer this please send me an email to soulblazor(@)hotmail.com

Thank you for your help.

More replies
Relevance 54.94%

Hi,

I was wondering if anyone could help me. I need to extract data from multiple excel files into a new excel file and sum the values. The data comes from excel files that are made from a template so the data is always in the same place or same cells. For example, i have data saved daily in excel files with the following naming convention 080204, 080304, 080404,..... and so on. What i would like to do is have a macro that will create a week ending sheet by importing and summing the data from that week.

Thanks for reading!
 

Answer:excel macro for copying and pasting data from multiple excel files

thanks for all those who read!!!! let me know if anyone needs the code!
 

1 more replies
Relevance 54.94%

I am trying to create a code that will autofilter data on an Excel worksheet. The code works fine to filter the data, but it does not hide the AutoFilter Arrows.

Below is the code I am using. What (if anything) is wrong with the code below?
Code:

ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>", Visibledropdown:=False
 

Answer:Solved: Excel 2007 Macro -> Hide Excel AutoFilter Arrows

I noticed that the code above (in Post #1) that the AutoFilter Arrows were beinf truned off on Field 2, but none of the others.

I have played around, and done some research to come up with the code below:
Code:

Dim c As Range

For Each c In ActiveSheet.Range("A1:D1")
ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>"
c.AutoFilter Field:=c.Column, Visibledropdown:=False
Next

Does anyone have a better solution?
 

1 more replies
Relevance 54.94%

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10
etc

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you
____________________________
 

Answer:Solved: Excel macro to extract Word form data into Excel

7 more replies
Relevance 54.94%

Iím using Windows 7 and I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:

"Run-time error '445':
Object doesn't support this action.

The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.

When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearch

Can you help me with this? I've searched for a solution for a long time but could not find anything which worked.

The following is the start of the macro code:

Sub UpdateTable()
Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As Variant
Dim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As Range
Dim ServRange As Range, SrcOpen As Boolean, SourceName As String
Dim FilSrch As Object, MyFilArray() As String

'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"
'Exit Sub
'Sheets("LookUp").[a12] = Now
With Application
.ScreenUpdating = False
.StatusBar = "Counting source files ..."
End With
Set FilSrch = Application.FileSearch
With FilSrch
.NewSearch
.LookIn = ActiveWorkbook.Path
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
ReDim MyFilArray(.FoundFiles.Count)
For I = 1 ... Read more

Answer:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

7 more replies
Relevance 54.94%

Hello,

I need help to create an Excel macro that would

1. ask users to select x number of rows to be copied from one worksheet of one Excel file
2. once users have selected the rows to be copied, then the rows are copied from the one original Excel file into X number of target Excel files

Notes:
the target Excel files are all based on the same template
there is one worksheet in each of the target Excel files

in the target files, the rows should be copied from the first available empty row, going down

Looking forward to your help!

Thanks a lot.
Mzz
 

Answer:Macro needed to copy x number of rows from one Excel file into a batch of Excel files

Hi, welcome to the board.
Not much info there to get the correct picture.
Sample? Of source and template please
And not to forget, what version of Excel are you and the users using?
 

1 more replies
Relevance 54.94%

I have accidentally forget my password to open a protected xls. Anyone got any idea?
 

Answer:MS Excel spreadsheet

Sorry to say but you won't receive any assistance with password cracking in this forum. There is no way to verify that you are the true owner of the workbook and/or that you have the right to view to protected material. For all we know, you may be trying to open a workbook that belongs to someone else which may contain sensitive private information about others.

Regards,
Rollin
 

1 more replies
Relevance 54.94%
Question: Excel Spreadsheet

I started logging my miles for work and stuff. I want to make it count two different sets of miles. The first bot I have is total miles, which is expressed as =SUM(I6:I35) I want a second one, I just don't know how to make it work.
 

Answer:Excel Spreadsheet

9 more replies
Relevance 54.94%
Question: Excel Spreadsheet

I am setting up a spreadsheet for my classes, and I am wanting to see if there is a way to sort a column by male, female pattern. (I was hoping to be able to sort the list that way in order to prepare a seating chart....boy, girl, boy, girl etc...)

...I know that it will sort it by lumping the males together and then the females or vice versa... But I am hoping there is a way to be able to alternate the boys and girls.

But before giving up I thought I would ask you all here, since you have been a big help in the past.

Thanks in advance!!!

=O)
KimlaiKy
 

Answer:Excel Spreadsheet

You could have another Column where you have numbers pairing them.
ie. Sort them Male/Female and then for the Males enter 1 for the first and 2 for the second and then drag that sequence down to the last male. The repeat that for the Females.
Now sort by value first and then m/f and you should have boy, girl.
I think.
Actually you get Girl, Boy etc
Make it G & B instead of F & M to get it as Boy Girl.

The column with the values can of course be hidden.
 

1 more replies
Relevance 54.94%
Question: Excel Spreadsheet

Hi,
I have to import values into a website. This information is for electrical transmission flow. Based on the number of paths I have and the duration I select. I would like the spread sheet to create the lines for me and have them populate the correct field. I am attaching an example. The Por and Pod are the To and From. Currently in my spreadsheet I have 7 paths setup. If that changes though I would like it to automatically add the additional path in the correct place. I also show 3 hours for the duration, but this could be days or months and it might be broken up in hours days months. Example for Months it would be 7/18/2009 0:00 to 8/18/2009 0:00. I generally post 1 year of monthly values so on the Input page I was thinking about asking the user for the duration (Start to Stop times), Increment (hours, days, Months), and path names (To and From) and have excel create the attached worksheet with those colums filled in. I am not sure I have explaned the situation very clearly so if you have any questions please ask.
Thanks,
Joe
 

More replies
Relevance 54.94%

Hi, I have a column of about 2000 numbers, I want to put four spaces at the fron of the numbers. Is there an easy way to do this on a Excel spreadsheet?Thanks

Answer:Excel Spreadsheet Help Please

That's a bit unclear to me. Do you mean that you want to:a) pad them with four spaces in front? They won't be treated as numbers anymore if you do that.b) make them *appear* to have 4 spaces in front but still be treated as numbers.c) be padded with leading zeroes.A few examples would help.

5 more replies
Relevance 54.94%

Every month for several years I have accessed my own spreadsheet offline from desktop icon.
To utter consternation and increasing frustration, today OPEN brought up the file BUT can do nothing with it.
Same results with backups on different drives.

Consequently told browse to find program from which can OPEN. Obvious choice MSN Excel. Result: "Cannot find any version ...to open file for edit".

Further on I installed msn xlviewer. In Open process came box, "Office Source Engine (Process ID: 2120) running. Need to Close". How/where to do so no idea. I am on Vista Ultimate with !E7; note not included in list for this item.

FYI, I only have Office 2002 (with Excel 2002), but cannot even remember last time I used it for anything. Also note many MSN references to Office 2003, but hardly ever 2002.
Point is, HOW CAN I GET BACK WHERE I WAS & NOT BE REFERRED TO NEED FOR A PROGRAM (EXCEL)?
Only secondarily (and reluctantly) interested in making Excel function to restore ability to use my spreadsheet.

I will be most grateful for help in this unexpected problem.
 

Answer:Spreadsheet with/without MSN EXCEL

Well, I can give you advice on installing an alternative (freeware) program that you can work with your spreadsheet with.

Check out http://www.openoffice.org . It's an open source alternative to MS Office, and can open MS Office documents, spreadsheets, etc.
 

11 more replies
Relevance 54.94%

I have a very large Excel table that I need to convert into an XML document to display on the web in various ways. I found a macro online that creates a very nice and clean XML document -- www.meadinkent.co.uk/myxml/XL_to_XML.txt
However the table has lots of external links and none of the link attributes come through to the XML.
Likely there are a variety of ways I could do this but my experience with Excel is very limited, so any advice would be greatly appreciated!

Thanks in advance!
 

Answer:Excel Spreadsheet to XML

16 more replies
Relevance 54.94%
Question: Excel Spreadsheet

Can somebody help please. Have a spreadsheet something like this

DATE DATE DATE
CM789 Y L Y
CF897 Y Y Y
CM856 L L Y
CM742 Y Y Y
CF7854 L Y L

TOTAL 3 3 4

What I am trying to achieve is to get a total by either CM or CF for each date
ie

CM 2 1 3
CF 1 2 2

Can somebody help please
 

Answer:Excel Spreadsheet

7 more replies
Relevance 54.94%

Hey,

I have a weekly Poker group and I made a spreadsheet for it to keep track of all the satistics. Iv managed to make a worksheet for each season and then I thought wouldnt it be cool to have an 'overall' worksheet to show the overall standings - sorta like a league table ladder.

Here are the things I want:

1# In each of the seasons, in the ranking ladder, I need a tiebreaker like rebuys to break ties. Because when there is a tie, it glitches and it shows my name twice.

2#In each players profile in each season, under the average placing column, in the average, I need a formula that doesnt count the 0s, because if someone doesnt show up, there will be a zero, and the current formula counts that 0 as a placing. It saves me manually having to exclude the 0s from everyone's average at the end of each season.

3#If you open the overall tab, you will see the overall standings ladder. That is the beast I am hoping to get up and running with your help. I want it cover all the stats across every season automatically. So when a new seasonis made, it will track it auto, when a new player is added, it will track it auto. The primary column will be score obviously, then for tie breakers use re-buys again. In this table Score refers to Profit in the player profiles,1st, 2nd 3rd refers to how many time each player has finished 1st 2nd or 3rd all together, Average placing refers to the average placing column in the players profile, Prize Money refers to the gross column in the ... Read more

Answer:Excel Spreadsheet Help

I also tried to attach the spreadsheet but it doesnt seem to work...

Cheers,
Joronamo.

1 more replies
Relevance 54.94%

I am sure this is obvious to folks out there!
I have a short list on numbers in a list of cells (e.g. - c3: c14) and I want the spreadsheet to select the lowest value entry and display it in another cell.
Do I use an 'IF' formula? How

More replies
Relevance 54.94%

Looking for some help?. I am using the following macro to insert a blank row (to separate varying Group rows) and then, Subtotal Column B per each Group:
Sub GroupInsertRowAndTotal()
Dim lngRow As Long, lngStart As Long
lngStart = 2: lngRow = lngStart
Do: lngRow = lngRow + 1
If Range("A" & lngRow) <> Range("A" & lngRow - 1) Then
Rows(lngRow).Insert
Range("B" & lngRow) = "=SUM(B" & lngStart & ":B" & lngRow - 1 & ")"
'Remark the below line if you want to convert the formulas to actual values.
'Range("B" & lngRow).Value = Range("B" & lngRow)
lngRow = lngRow + 1: lngStart = lngRow
End If
Loop Until Range("B" & lngRow) = ""
End Sub

If possible and practical, I would like to edit the above with additional VBA code using the respective ?Subtotal? generated above to populate Column M (starting in row 2) with the following formula:

=(1-(b2/$b$13))/(b2/$b$13); =(1-(b3/$b$13))/(b3/$b$13); =(1-(b4/$b$13))/(b4/$b$13); (etc.)

[Note 1: Same formula calculation for cells (b2:b12) and for illustration purposes only, $b$13 = the cell location of the first Subtotal?. Then, repeat based on cell location of next Subtotal?. RE: All columns are ?blank? in each Subtotal row except for Column B]

I am trying to automate current daily spreadsheet that usually has in excess of 1000 rows which doing manually, is obviously ver... Read more

Answer:Need VBA help for Excel Spreadsheet

Your text says the groups vary. What distinguishes a group?

Stoneboy
 

3 more replies
Relevance 54.94%

Attached is a spreadsheet I have 2 questions on. I have read many posts out here but I haven't gotten any to work.

1. How do I remove the page # that appears on each page?
2. Is it possible to sort the contents of a single cell? I want to sort the following data that is in a single cell: Magellan, PrimeSource-GSH, UBH, Quest, Value Options, Intergroup, Cigna, CBHNP, CCBHO, Gateway Assured, Aetna, Highmark, Premier Blue, Freedom Blue, Unison, MH Net, LifeSynch, LifeSynch MC, Medicare

Any help would be much appreciated.
 

Answer:Need help with Excel spreadsheet

8 more replies
Relevance 54.94%
Question: excel spreadsheet

Excel spreadsheet not auto updating. What can I do other than hitting f9?
 

Answer:excel spreadsheet

try open excel,click on the tools menu,click on the calculations tab and set the radio button to automatic
 

2 more replies
Relevance 54.94%
Question: Excel spreadsheet

I am trying to figure out if you can merge information into Excel but have it show up as a cell comment?

I have a large amount of information that needs to fit onto one page, and have cells that have enough text to wrap around. So, instead I was going to have it be a cell comment, but wondered if this would work with the information being merged into Excel?

We currently merge information for this particular document from Act2000 into Excel. Please let me know if this is possible, and if not, if I have any other options?

Thanks in advance!
 

Answer:Excel spreadsheet

Hi.

I've left this sit without responding long enough.

Either I don't understand what you're trying to do (though I think I do), or you are asking for the (next to) impossible.

Why are you not using Word to do this? Comments are rather cumbersome in Excel, as well as a lot of text.
 

1 more replies
Relevance 54.94%

Hi,
I have a question about excel 97
I'm setting up an excel spreadsheet for a Reading Teacher.
She needs 4-columns called Names,Hearing/Sounds, Stanine, and
Writing/Vocabulary.
The question I have is the columns called (Writing/Vocabulary) and
(Hearing/ Sounds)will have scores and the teacher would like to click on Desceding or Acsending and sort the scores to see which student needs more help by checking lower scores.
How do I do that so that the scores will move with the names when she sorts them?
Any help would be greatly needed.
thanks walk12
 

Answer:Excel Spreadsheet help

Hi walk12,

If the data is selected from those specific columns, you can go to Data -> Sort, you should be promted to Expand the selection (I believe this is in 97). If not, select all 4 columns, Data -> Sort, Sort by Hearing/Sounds (or whatever). This should do it for you. There are also formula solutions to do this instead of sorting. Just depends on how much you want to manipulate your data. HTH
 

3 more replies
Relevance 54.94%
Question: EXCEL spreadsheet

Attached is a file where I need to allocate the dollar amount. I need to allocate the dollar amount, proportionately, from cells C84 & D84 (Management Volume Challenge) across the values in each of the columns C3, D3 through C72, D72(SINGLES and KIND SIZE). Cell F84 is the area where the dollar value for a reduction or increase. The row items in BOLD are summary lines and do not require an allocation of dollars.

Thanks for your cooperation in advance.
 

Answer:EXCEL spreadsheet

Nothing is bold. It's a TXT file.
Try uploading the file again.
This time, do not SAVE it as a text file.
Instead, copy your file, change the file extension from xls to txt using Windows Explorer and not Excel.
Then load it.
 

1 more replies
Relevance 54.94%

Hi there,

I am going to try to word this as simple as possible, but i am having trouble coming up with a formula to work between TWO worksheets, and i am not even sure it is possible.

Basically these two worksheets contain similar data, however, only one of them is updated, and i would like the other worksheet to populate itself based on what is entered on the first worksheet.

I have figured out how to do this using IF statements, however, as new data is entered into the first sheet, i would have to continuously build IF statement formulas.

My question is, is there a way to make a formula based on the following that would work absolutely (When you drag it down changing per row it would display the data i need):

WHEN data in column one, matches data in column one on sheet 2
AND
Data in column three match data in column 3 on sheet 2
THEN
display data in specific cell on sheet 1 to specific cell on sheet 2

I know that it seems simple to build an IF formula, and nest it. But is there a way to build a formula that would search the entire sheet matching the data and displaying without having to build a specific fomula for each row?
 

Answer:HELP! with an Excel Spreadsheet

Hi Jake

Are you ever a candidate for Visual Basic for Applications (VBA), which comes for free with Excel. You can buy a book on it -- I got good value from the Weekend Crash Course book on the subject. However, you can also get started easily by recording macros and then editing them. There are tons of resources on the internet (google for VBA and Excel and whatever term you want help on) and the Help in VBA is also very helpful. One of my favorite websites on Excel is mrexcel.com. Bill Jelen (aka Mr. Excel) has written tons of articles and books on Excel and is one of Microsoft's preferred gurus, although he doesn't work for Microsoft.

To start VBA from within Excel without recording a macro, just hit Alt-F11 and start using it.

Have fun!

Jeremy
 

3 more replies
Relevance 54.94%

I was sent an Excel spreadsheet attached to an email. I need to get it filled out, and sent back. I'm able to view the spreadsheet, but when I click on a cell, I'm not able to type anything in the space.
I've never used Excel before, and am clueless, as you can surely tell.
So, can someone fill me in on how to fill this in?

Thanks!!
 

Answer:How to use Excel Spreadsheet

Hi there,

It sounds like your worksheet may be protected. With this sheet activated click on Tools | Protection; What does it say, Protect Worksheet or Unprotect Worksheet?

Also, if possible, how about zipping and attaching an example workbook?
 

3 more replies
Relevance 54.94%

Sheet 1 is an order form, sheet 2 is product #s and descriptions, I want to choose a product on sheet 2 and have it populate the first blank row on sheet 1

Answer:I have an Excel spreadsheet,

Well, now we know what you want.If you need any help with that, feel free to ask.

2 more replies
Relevance 54.94%

I have a pricelist i need to make changes to. It has about 300 prices on. I dont want to do it manualy. How do i add 7% to all my prices?

Answer:190.23 plus 7% on excel spreadsheet

Try this:
A B
1) Old Price New Price
2) $10.00 $10.70
3) $200.00 $214.00
4) $3,000.00 $3,210.00

In cell B2 enter the formula: =(A2*0.07)+A2Drag down as many cells as needed.Now select your New Price cells and do a Copy Now select your Old Price cells and do a Paste / Special / ValuesDelete column B and your done.MIKEhttp://www.skeptic.com/

4 more replies
Relevance 54.94%
Question: Excel Spreadsheet

I have a spreadsheet of students names, their subject results (F,P,C,D) for each stage for example STAGE 1 STAGE 2 STAGE 3
JOHN BLOGGS P D C C P C P P P P P P C P P C D
Each stage has a set number of subjects be it 5 or 6. What I would like to be able to do is
automate the spreadsheet so that as each stage is completed a master list is update with the stage the pupil is now enrolled and the pupil automatically transferred to the next stage.

Can anyone help me please.

Many thanks
NiftyK
 

Answer:Excel Spreadsheet

12 more replies
Relevance 54.53%

Hi,
I want to merge two excel files into a 3rd one.

The data are in the files Book1, Book2 and the result in Book3.

I know that i can use VLookup to do the above. But what i have pasted is just an example. The real excel files contains about 9 columns with at many repeating row!!!

Any help will be much appreciated.
Thx
 

Answer:Excel - macro to merge 2 excel files using a common column

Hi welcome to the board. How are you going to treat the duble items, If you want to merge 2 files adn duplication occurs here must be one cell whihc is common to let's say Book1 and Book2.

Do you have a common value? Index? Whatever you call it?
 

3 more replies
Relevance 54.53%

I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none.
The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following:
1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project"
2) Find all the .mdb databases in this folder
3) Find "HistoricalMaterialItemsAll" table in EACH of those databases in step 2, and import the data from the columns listed below into PGE BOM.xls's columns C through G:
DrawingNumber
ItemNumber
Quantity
PgeCode
Description
The following is a VBA code that my friend had written in Excel 2007. Unfortunately I have an older version (2000) and the code does not seem to be compatible with Excel 2000.
Sub ImportAccessData()
Stop
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
sRow = 2
bFile = False
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath)
strFlNm = Dir
If strFlNm = "" Then bFile = False
Loop
End Sub
Sub GetData(fl)
Stop
strSQL = "Select HistoricalMaterialItemsAll.* From HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, xlCmdTable
Set WB = Application.ActiveWorkbook
Set WS = Applicatio... Read more

Answer:Excel Macro - VBA code to import access data to excel

Hello, and welcome to the board!

When posting code, please use CODE tags, which extremely helps with readability.

Perhaps you could try using the code constant???...
Code:

Option Explicit

Sub ImportAccessData()
Dim dPath As String, sFile As String, strSrch As String
Dim TargetWB As Workbook, TargetWS As Worksheet
Dim sRow As Long, bFile As Boolean, strFlNm As String, strPath As String
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
sRow = 2
bFile = False
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath, TargetWB, TargetWS)
strFlNm = Dir()
If strFlNm = "" Then bFile = False
Loop
End Sub

Sub GetData(fl As String, WB As Workbook, ws As Worksheet)
Dim strSQL As String, iRow As Long, sRow As Long
strSQL = "SELECT HistoricalMaterialItemsAll.* FROM HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, 3 'xlCmdTable
iRow = 2
Do Until ws.Cells(iRow, 1) = ""
ws.Cells(sRow, 7) = ws.Cells(iRow, 5) 'Get the Description
iRow = iRow + 1
sRow = sRow + 1
Loop
Application.DisplayAlerts = False
WB.... Read more

1 more replies
Relevance 54.12%

I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:"Run-time error '445':Object doesn't support this action.The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearchCan you help me with this? I've searched for a solution for a long time but could not find anything which worked.The following is the start of the macro code:Sub UpdateTable()Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As VariantDim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As RangeDim ServRange As Range, SrcOpen As Boolean, SourceName As StringDim FilSrch As Object, MyFilArray() As String'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"'Exit Sub'Sheets("LookUp").[a12] = NowWith Application .ScreenUpdating = False .StatusBar = "Counting source files ..."End WithSet FilSrch = Application.FileSearchWith FilSrch .NewSearch .LookIn = ActiveWorkbook.Path .FileType = msoFileTypeExcelWorkbooks If .Execute > 0 Then ReDim MyFilArray(.FoundFiles.Count) For I = 1 To .FoundFiles.Count If .FoundFiles(I) <> ActiveWorkbook.Path & "\" & ActiveWorkbook.Name Then ... Read more

Answer:Excel 2003 Macro doesn't run under Excel 2007

As far as I know, Application.FileSearch is not available in 2007. Searching for filesearch replacement turns up lots of hits with various workarounds, such as this:http://groups.google.com/group/micr...Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 54.12%

Hi guys,

I have been on the lookout for a macro that will compare 2 worksheets within MS Excel and output the differences on a third sheet.

I am being directed to the URL below but cannot for the life of me work out how to implement this:

http://exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html

There are two snippets of code which I will include here for convenience but not sure whether these should be pasted into Workbook Code (i.e. right-clicking Excel icon left of "File" - top-left), Worksheet Code (i.e. right-clicking worksheet tab) or inserting a new Module - or some other method. Is there anyone here that could guide me to how to implement this code?

Quote from webpage - "With the macro below it is possible to compare the content of two worksheets.
The result is displayed in a new workbook listing all cell differences. "

Code:
Sub CompareWorksheets(ws1 As Worksheet, ws2 As Worksheet)
Dim r As Long, c As Integer
Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer
Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String
Dim rptWB As Workbook, DiffCount As Long
Application.ScreenUpdating = False
Application.StatusBar = "Creating the report..."
Set rptWB = Workbooks.Add
Application.DisplayAlerts = False
While Worksheets.Count > 1
Worksheets(2).Delete
Wend
Application.DisplayAlerts = True
With ws1.UsedRange
lr1 = .Rows.Count
lc1 = .Column... Read more

Answer:Solved: How to use this Macro in MS Excel (compare excel worksheets)

Apologies... I have sorted this... For those that might be looking at this for help here's what I missed:

These are both Sub's that should be created as a Module - both in the same module. I am just comparing worksheets within the Active Worksheet so just removed:

' compare two different worksheets in two different workbooks
CompareWorksheets ActiveWorkbook.Worksheets("Sheet1"), _
Workbooks("WorkBookName.xls").Worksheets("Sheet2")
Click to expand...

I was then able to run this from Macro's. All sorted.

Apologies again
 

1 more replies
Relevance 54.12%

I run a weekly excel 2007 macro that converts a spreadsheet to a Word document, but it stops after row 29 of data. Any spreadsheet with 29 rows or less works fine. If I have 34 rows of data, the macro hangs. See below for script. Any help would be appreciated.

Public Sub AddControls(WrdApp As Word.Application, CurRow As Integer)
Dim OptChecked As Boolean
Dim GrpName As String
GrpName = "Grp" & CurRow
'Calculate the colors based on the cell information.
CurRange = "F" & CurRow & ".." & "F" & CurRow
Range(CurRange).Select

If InStr(1, UCase(ActiveCell.Text), "X SRM") > 0 Then 'SRM
OptChecked = True
Else
OptChecked = False
End If

SetCellBG WrdApp, True
WrdApp.Selection.TypeText Text:="Governance:" & vbCrLf

Set RadioObj = WrdApp.Selection.InlineShapes.AddOLEControl("Forms.OptionButton.1")
With RadioObj.OLEFormat.Object
.GroupName = GrpName
.Caption = "SRM"
.Font.Name = "Arial"
.Font.Size = 8
.Value = OptChecked
End With

If InStr(1, UCase(ActiveCell.Text), "X PPO") > 0 Then ' PPO
OptChecked = True
Else
OptChecked = False
End If

WrdApp.Selection.Collapse Direction:=wdCollapseEnd
WrdApp.Selection.TypeParagraph

Set RadioObj = WrdApp.Selection.InlineShapes.AddOLEControl("Forms.OptionButton.1")
With RadioObj.OLEFormat.Object
.GroupName = GrpName
.Caption = "PPO"
.Font.Name = "Arial"
.Font.Size = 8
.Value = O... Read more

Answer:Excel Macro - converting excel to word doc - stops after row 29

13 more replies
Relevance 54.12%

Does anyone know how to run Excel 2003 print macro on Excel 2007 or higher? When I tried running my 2003 macro, the VBA editor pops up w dialogue box, " Run-time error '1004': Method 'ActivePrinter' of object'_Application' failed ".

This is my code: Application.ActivePrinter = "Epson LQ-300 ESC/P 2 on USB003"

Can anyone help?

Thanks!
 

Answer:How to run Excel 2003 print macro on Excel 2007?

Welcome to TSG hope we can help you and you can help others.

I'm not an Excel macro guy but you code looks reasonable. What happens if you run this. I suspect printer name is a little off.

MsgBox "The name of the active printer is " & Application.ActivePrinter
 

1 more replies
Relevance 54.12%

With due respect and credit to DerbyDad03 whose earlier post gave me the code below; is there any way to have the new worksheets created from a variable length field e.g. a persons name in a list or a field of fixed length other than a date as the script below uses?Sub CreateMonthlySheets()Dim lastRow, mMonth, tstDate1, tstDate2, shtName, nxtRowOn Error Resume Next'Turn off ScreenUpdatingApplication.ScreenUpdating = False'Make a copy of the data sheet and sort by date Sheets("Sheet1").Copy After:=Sheets(1) Sheets(2).Name = "SortTemp" With Sheets("SortTemp") lastRow = .Cells(Rows.Count, 1).End(xlUp).Row Rows("2:" & lastRow).Sort Key1:=Range("A2"), Order1:=xlAscending 'Using SortTemp Sheet, create monthly sheets by'testing Month and Year values in Column A'Loop through dates For Each mMonth In .Range("A2:A" & lastRow) tstDate1 = Month(mMonth) & Year(mMonth) tstDate2 = Month(mMonth.Offset(-1, 0)) & Year(mMonth.Offset(-1, 0)) 'If Month and Year are different than cell above, create new sheet If tstDate1 <> tstDate2 Then ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count) 'Name the sheet based on the Month and Year ActiveSheet.Name = MonthName(Month(mMonth)) & " " & Year(mMonth)'Copy Column Widths and Header Row .Rows(1).Copy ActiveSheet.Rows(1).PasteSpecial Paste:=8 'ColumnWidth ActiveSheet.Rows(1).PasteSpecial 'Data... Read more

Answer:Excel Macro to create new worksheet in Excel 2010

I created a quick macro to help you out. This macro creates a new sheet and names it using the contents of cell "A1".Sub CreateNewSheet()
Dim NewSheet
Dim SheetName As String

SheetName = Worksheets("Sheet1").Cells(1, "A").Value
Set NewSheet = Sheets.Add(After:=Sheets(Worksheets.Count), Count:=1, Type:=xlWorksheet)
NewSheet.Name = SheetName

End Sub
Law if Logical Argument: Anything is possible if you don't know what you're talking about.

4 more replies
Relevance 54.12%

Hi, I have created an excel macro that runs sensitivities in my model. The excel button runs 5 different cases.

The macro runs fine and does as I want it to.

Once the macro has run, and I go to edit a cell and hit "F2" excel crashes. This only seems to happen in certain cells and not all of the time.

Does anyone have experience with similar questions?

Thanks
 

Answer:Excel Macro runs fine..then excel crashes

11 more replies
Relevance 54.12%

I have produced an EXCEL spreadsheet for examining what is happening in the material development of our civilization and so expected future trends. I have done examinations for the global, US, Chinese and Australian economies. Based on my experience, I believe it will be a powerful, transparent tool to aid sound decision making.I want to make the G&SC spreadsheet available globally so a range of experts can contribute to estimating the values in appropriate cells while using the associated charts as feedback. These estimates need to be backed by explanatory comments and appropriate references. This wide-ranging input will help to improve its credibility as well as providing better understanding of the complex issues.I know that I can forward the spreadsheet using the Routing procedure. However, there may be means that I am unaware of that will be a more efficient way of having a central version of the spreadsheet which is being continually refined while participants can also have their versions so the can carry out trials.

Answer:EXCEL G&SC spreadsheet development

I'm wondering what G&SC means.  QuoteI know that I can forward the spreadsheet using the Routing procedure.What is "the Routing procedure"?Some options you might consider:http://mashable.com/2008/02/06/forget-excel-14-online-spreadsheet-applications/http://www.expressocorp.com/And, a lot more stuff to peruse here:http://www.google.com/search?aq=1&oq=online+excel&sourceid=chrome&ie=UTF-8&q=online+excel+spreadsheet

3 more replies
Relevance 54.12%

I am choosing Cells from the Tools menu in order to change the color of the borders. I make the color change, but it doesn't take. It is a new document, and no protection option has been put in place.
 

Answer:Microsoft Excel Spreadsheet

Is this a shared file? Or is this a file that is not shared?
 

3 more replies