Over 1 million tech questions and answers.

Solved: convert excel 97 macros to excel 2003 macros

Q: Solved: convert excel 97 macros to excel 2003 macros

I have a report that contains macros to update all the information that is put in. It is in excel 97 and my business just recently updated to 2003 and now I get a compile error when I run the reports. How can I fix this error?

Preferred Solution: Solved: convert excel 97 macros to excel 2003 macros

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.)

A: Solved: convert excel 97 macros to excel 2003 macros

Read other 8 answers

I have just been upgraded to Excel 2007. I find that some of the macros that were recorded in Excel 2003 no longer work in Excel 2007. We use the Analysis Toolpak VBA add-in and I have added this in to 2007 ok, but when running a macro I get a run time 1004 error ATPVBAEN.XLA cannot be found. After some searching it would appear that some of these functions have been renamed in 2007 e.g. it is now a .XLAM file rather than .XLA which is why the macro code can't find it. I guess I could manually edit all the macros and change the fucntion names but there are other colleagues in my team that are still using 2003, so I don't want to break things for them. Is there any solution to this? Thanks

A:Solved: Problem with Excel 2003 macros in Excel 2007

Read other 8 answers

i am using macros to create charts on a 2nd sheet. i need to make 3 total and then move them to the right spot. the first two go without any issues however, the 3rd doesnt move or risize like it should. it seems like the problem is because i use the mouse to move the chart and the screen scrolls down. also, is there a way to assign the chart title with a block from the spreadsheet?


A:Solved: excel 2003 macros

Read other 16 answers

Hey all,

Does anyone know if it's possible to convert macros from Excel 97 (Excel Basic) to Excel XP/2002 (Visual Basic) ? Or do I have to do these manually?

Any help is appreciated


A:Help!! Convert Excel 97 Macros to Excel XP (2002) ???

Read other 9 answers

ok here goes nothing.... i'm a big noob at excel macros and i shurelly would need a little help.. i have a table (it has like 40-50 collmns amd 2000-3000 rows).... on D collumn i have a lot of names (like 20)...

i need a macro that splits my original excel table (or only that sheet) in 20 smaller tables (or sheets) and the criteria should be the names from that collumn

the names from that collumn are not in any order.... so bassiclly i could sort the table by name (starting with that collumn) and this can be done using a macro (i can record one while i push the button ) but how do i split my table in 20 different tables???

if anyone wold like to help me i'ld much apreciate it

thank you

A:Solved: macros in office excel 2003 sp3

Read other 16 answers

Hi can anybody tell me hoe to copy macros from excel 2003 to excel 2007?
The excel 2003 is running under windows xp and the 2007 under windows vista.
(The two versions of excel are installed at differnt computers)

A:Copy Macros From Excel 2003 To Excel 2007

I don't know Excel 2007 nor Vista.
But the usual way to copy macros brute force would be to open the VBA toolbar, get into the Modules, select each, and Export one by one. Then import into 2007 modules if Excel 2007 VBA permits that.
If export/import doesn't work, you can always copy out the entire text into Notepad text files, and copy/paste from the Notepad into your 2007 Excel.
If the VBA language or object model has changed between 2000 or 2003 and 2007, then some tweaking might be in order, but I suspect they left it alone, and the error messages, if any, might suggest what to fix.

Since these are different computers, either network them and share some common directory, or use USB flash drive for transfers of the, say, Notepad files.

Export is good, because it names the modules. They get saved someplace in your local settings. Notepad will not name, and doesn't matter really.

Read other 3 answers


i have a Lotus 1-2-3 spreed with macros which, i need to convert it to excel 2003/2007 is there a way this can be done easliy. Or is there any software that can do it.

i need to keep the marcos working.



Read other answers

Hi all

I can provide the code if necessary, but this issue is really confusing me, and seems to be more to do with the differences between how excel 2007 saves files.

I have written a dozen macros in VBA (Excel 2003) and recently upgraded to 2007. When in run the macros
in 2007, they run fine.

HOWEVER - when someone who is still on Excel 2003 uses the files after me, they get error messages, even though the code was written for 2003, and is completely unchanged.

Compile Error : Cant Find Project or Library

the Debugger then highlights the following line of code

Dim currentDate as Date
currentDate = Date (the Date section is where I am getting the error)

That line of code works in Excel 2003, if the file has not been saved by Excel 2007.

Anyone have any ideas?

At this I am considering downgrading my Excel back to 2003 version.

Any help would be appreciated
Thanks & Regards

A:Solved: Bizarre Issue // Excel 2003 & 2007 Macros

Read other 8 answers

I would like a macro that will compare Accounting system data and Bank statement data. I am comparing the date and amount for an exact match. If there isn't a match, I need the macro to list the exceptions. I am using Windows XP.

A:Using Macros in Excel 2003

Read other 10 answers

OK it's not my fault I am working on XP with Office 2003 (you never know work may catch up with the rest of the world one day!)

I am trying to pull a macro together for our sections watchlist so when someone enters "L" into a cell it will automatically shade it blue, "C" will shade it a different colour and so on and so forth. I have tried using conditional formatting but that only gives me the option of setting 3 conditions (4 if you count the default blank lol)

As it is I have 12 different options with 12 different colours to denote Leave, Courses, Duties, Sick etc, etc

Can anyone help. I have played about with the Macro recorder but it has confused me to the point of getting a headache and resorting to asking for help.

A:Excel 2003 Macros help needed!

does this help at all

Read other 3 answers

Can I ask for help in a similar vein to last post, I have another CSV file thatís down loaded
where text is in column D and I want to enter equivalent in column E as below which is used to build a pivot table on column E headings in correct order to match input journals, again varying number of rows each time file extracted.

Change formula to below for each type
Layaway Part Payme to 9Layaway Part Payme
Gift Voucher sale to 8Gift Voucher sale
Sales without VAT to zSales without VAT
Visa / Mastercard to 1Visa / Mastercard
Cash to 1xCash
Layaway Part Payment Clearing to 3Layaway Part Payment Clearing
Gift Voucher Redemption to 4Gift Voucher Redemption
Credit note redeemed to 5Credit note redeemed
Till Differences to 6Till Differences
Cash to 1Cash
POS Payment/Outpayment. to 8POS Payment/Outpayment.
prod Sales to Zprod Sales

A:loops in macros Excel 2003

Again my question: what do the numbers stand for under what I imagine should be E?

Read other 1 answers

Hi all,

I've got a series of Excel 2003 spreadsheets with macros. They run just fine on a Windows XP machine. However, we recently moved them to a Windows 7 Pro machine. We still run them in Excel 2003, only now on a Windows 7 system. Problem is, they don't run right. No errors, but the one that is giving me grief needs to read from a csv text file. I don't thinki it is opening and/or reading the input fule. I don't understand why.
Like I said, everything runs OK on WinXPSP3. I think I have all of the permissions set correctly. UAC is turned off and Elevated priveleges is turned off as well.

Anyone have any ideas?

Thanks in advance.

A:Excel 2003 Macros do not run correctly on a Windows 7 system.

Hi Honu425

According to Windows 7 Compatibility Centre, it is compatible with Excel 2003 with Service Pack 3. Do you have Office Excel SP3 installed?

http://www.microsoft.com/windows/compatibility/Windows-7/en-us/Details.aspx?type=Software&p=Microsoft%20Office%20Excel%202003%20Service%20Pack%203&v=Microsoft&uid= 11&l=en&pf=1π=6&s=office%20frontpage%202003&os=32-bit

Read other 1 answers

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?


A: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?


Read other 3 answers

Can somebody please let me know how to record a macro that is able to run in every workbook i open?


A:Solved: Excel Macros

Basically, on places their macros in a single worksheet that is saved in Personal.XLS, which starts every time you open Excel. For a more complete description, read here

Read other 3 answers


I desperately need some help with some excel macros, can anybody help please?

I need the VBA code so that an excel macros will run once automatically when, for example cell A4 = 1.

Using a great thread posted by Zack Barresse, I've managed to get this far with the VBA:

Sub copytohere()
If ThisWorkbook.Sheets("Sheet1").Range("A4").Value = "1" Then
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End If
End Sub

I dont think I've got it quite right though...
Can anyone help please?

This macros is basic - all it does is copy data from cell A1 to E1 and then deletes A1.
I was hoping the IF statement would make the macros run once automatically when cell A4 = 1 however when I enter 1 into cell A4 nothing happens.

What is interesting is that if i then go to run the macros manually, it will perform the macros correctly if cell A4 = 1 .If cell A4 doesn't equal 1 and I run the macros manually, nothing happens.

I need the VBA so that the macros will run once automatically when cell A4 equals 1.

Any help si much appreciated.

Thank you!

A:Solved: Run Excel Macros IF...

Hi there, welcome to the board!

If you want something to occur "automatically", you'll need to utilize an event. There are different events you can 'capture' or 'hook' in Excel, as it's commonly referred to. What it sounds like to me that you will need is either a change event or a calculate event.

The change event will fire every time a cell is changed. So if a user starts typing in a cell and hits the Esc key, a change event will not have occured, as opposed to them hitting Enter, then a change event has occured.

The calculate event will run every time the worksheet is calculated, regardless of a sheet change. This may be beneficial if A1 houses a formula which will update from other cells within the workbook.

I'm going to assume you want to utilize a calculate event, but you can use a change event if you want. I'll post both code snippets, so choose the one you want. Both of these are worksheet module code events. To put there, right click your worksheet tab, select View Code.
Private Sub Worksheet_Calculate()
If Me.Range("A4").Value = "1" Then
Application.EnableEvents = False
Me.Range("E1").Value = Me.Range("A1").Value
Application.EnableEvents = True
End If
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
If Me.Range("A4").Value = "1" Then
Application... Read more

Read other 3 answers

I created a macro but cant seem to figure out a few different things
First open the file named SPL1275-3A, next open the files called HLC M, then run the macro. as you can see the macro works fine for this file but when the file does not contain the same number of station the macro continues to loop because its looking for a station that is not used, for example try it on the file SPL1275-3B which is the same file exept it has 1 less station.

Can any body help!!!

A:Solved: Excel macros


Your macro script have loops for each and every block of data you want to process. That is you have created 10 loops for 10 blocks of data. The file "SPL1275-3A" runs OK because it has 10 blocks. File "SPL1275-3B" failes to complete the loop because the it runs the 9th loop find the END character.

To solve it, you can change the whole of the macro to only run the number of times the character END character appears and use only one loop to do that.

or otherwise use the function below to count the number of rows in the sheet you are processing and then terminate when you reach that row number.
Function GetLastCell(ws As Worksheet) As Range
Dim LastRow&, LastCol%
' Error-handling is here in case there is not any
' data in the worksheet
On Error Resume Next
With ws
' Find the last real row
LastRow& = .Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _
' Find the last real column
LastCol% = .Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _
End With
Set GetLastCell = ws.Cells(LastRow&, LastCol%)
End Function


Your Question:
"I created a macro but cant seem to figure out a few different things
First open the file named SPL1275-3A, next open the files called HLC M, then run the macro. as you can see the macro works fine for this file but when the file does not contain the same number of station the macro continues to loop ... Read more

Read other 2 answers

I created a series of macro's in an excel spreadsheet.

Once all of the macro's functioned correctly I created another macro to run them in a sequence.

This Sequencing Macro contained the macro name to execute but also includes the name of the spreadsheet. When I attempt to create a new spreadsheet the macros will not run because they cannot find the macros. The reason they can't find them is the Macro refers to the spreadsheet where they were created. I attempted to remove the reference to this spreadsheet and just run the macros but it failed with the error message that it cannot find the Macro

How to I go about creating a Macro to run the other Macros in sequence without referring to the spreadsheet where it was create?

Here is an example of the sequencing macro.

( Obviously, 'FEB1953-YABLleagueStatSheets.xls' is a reference to the spreadsheet where it was originally created. )
Application.Run "'FEB1953-YABLleagueStatSheets.xls'!Pitcha"
Application.Run "'FEB1953-YABLleagueStatSheets.xls'!Pitch1"
Application.Run "'FEB1953-YABLleagueStatSheets.xls'!Pitch2"
Application.Run "'FEB1953-YABLleagueStatSheets.xls'!Pitch3"
Application.Run "'FEB1953-YABLleagueStatSheets.xls'!Pitch4"
Application.Run "'FEB1953-YABLleagueStatSheets.xls'!Pitch5"
Application.Run "'FEB1953-YABLleagueStatSheets.xls'!Pitch6"
Application.Ru... Read more

A:Solved: Excel Macros

Read other 15 answers


I have built an Invoice/Delivery Note system in Excel and I'm uploading it to my webserver where it will be run in an Internet Explorer window. Since all the usual commands/toolbars will be unavailable, I am using Macros to insert the basic Print and Save functions.

The print function was easy to create, just creating a form button and then walking through the process however when I tried to achieve this for the Save command, I was unable to click the Macro Stop button while the Save As box was open on screen.

I then came up with the idea of installing a PDF Printer that would allow me to walk through the process as a print out, changing the printer to the PDF printer and then printing as normal. This resulted in a Save As box to allow the user to save the spreadsheet as a PDF but when uploaded to the web; the printer change was ignored and the spreadsheet printed through the default printer.

How can I achieve a Save As box using macros or force Excel to select the PDF printer everytime?


I have found this VB code:

Sub PrintToAnotherPrinter()
Dim STDprinter As String
STDprinter = Application.ActivePrinter
Application.ActivePrinter = "microsoft fax on fax:"
' change printer
' prints the active sheet
Application.ActivePrinter = STDprinter
' change back to standard printer
End Sub

and tried to integrate it with the code I'm already using:

Sub Save_IDN()
' Save_IDN Macro
' Macro record... Read more

A:Solved: Saving/Web Excel Macros

Read other 13 answers

I know it was mentioned on here before, but if someone could either tell me how or point me to the appropriate thread, I'd be appreciative.

Suppose you want to program a macro, but you're not sure how many rows and columns of data you will have.

How do you program the macro to find the end of data?

How do you define variables that will take on the value of the number of rows and columns in your data set (for looping purposes)?

Thanks in advance for your help.

A:Solved: Dynamic Ranges in Excel Macros

There are a couple of different ways to find the last row and columns of data. In my examples I will use vLastRow and vLastCol to represent the variables for the row number and column. As always make sure to declare your variables using Dim statements

To find the last row in a particular column you can use the following. Just replace the letter A with your actual column letter.
vLastRow = Cells(Rows.Count,"A").End(xlUp).Row
To find the last row of data in the book without limiting by a specific column you can use either of the following

vLastRow = Cells.Find("*",SearchOrder:=xlByRows,SearchDirection:=xlPrevious).Row


vLastRow = ActiveSheet.UsedRange.Rows.Count

To find the last column used in a particular row you can use the code below. Just replace the number 1 with the row number you want to use instead.
vLastCol = Cells(1, Columns.Count).End(xlToLeft).Column
To find the last column regardless of the row you can use

vLastCol = ActiveSheet.Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _


vLastCol = ActiveSheet.UsedRange.Columns.Count


Read other 3 answers

I have a question about using macros in Excel 2010. I am creating an invoice template. I would like to use a macro "button" to increment an invoice number in a specific format (100-1000, 100-1001, etc). I would like the same macro to save the file under the invoice number (cell AB2) as the specific file name. However, I would like the file to be saved into a specific and individual folder based on the name of the customer name entered into the text dialogue box (TextBox 1 in the name box bar) I have created. For example, 100-1001 (file) in John Doe's Store (folder) in Customer Invoices (Folder on the Desktop). I would like to keep a blank copy of each template in each customer folder so that I can search for the customer name, open the blank template, enter the necessary info, and save the new worksheet within the file. This is because each individual customer may not receive the exact same rate of payment and I can easily update that information within the formulas of the worksheet if necessary. I have visited a multitude of pages trying to emulate the formulas to no avail. Can this be easily done or is it something that I would need to hire out an IT contractor for? Thank you in advance!

Read other answers

I use a lot of Excel macros at work, often formatting pre-fab reports for aesthetics, etc.

I'd like to be able to insert the current date as a part of the macros. I'm sure this can be done, but I don't yet know VBA well enough to write it out myself.

Any ideas?

I'm using Windows XP w/ SP2 and Excel 2003

A:Solved: Inserting date with Excel macros

See the code below. If you want to also include the time in addition to the date you can use replace the word Date with the word Now
Range("A2").Value = Date
ActiveCell.Value = Date

Read other 3 answers

Hey Guys!

Using "record macro", i created a small table, with different fields that i use to fill information in. On my work sheet, every time i need to fill in information, i run my recorded macro, and it inserts a table where i need it to be, very handy.
What i can't figure out is, how to put a number in that table, that would automatically increase, every time i run this macros and insert a new table?
Let's say, i have a "100-05-00" number in cell A1. my table ranges from B1 to X10. So when i run my macro and insert the next table at B11, how can i have A11 automatically change to "100-05-01", and so on?

Appreciate any help!

A:Solved: Autonumbering in Macros, Excel 2007

Read other 16 answers

I've recorded and combined a few macros into one and - while it is really large - I never thought anything of it until I got the following error while trying to run it:

"Compile Error
Procedure too large"

I can certainly split these up into separate procedures, but it would save time to have them all as one. Is there a way to override this error?

I am using Windows XP w/ SP2 and Excel 2003.

Thanks in advance for any help.

A:Solved: Excel Macros too large problem

It is probably quite possible that you can considerably reduce the size of the Macro by rewriting it. Recorded Macros are notorious for having superfluous code in them.
If you post it I am sure that one of the Excel gurus can rewrite it for you, or at least point you in right direction.

Read other 3 answers

I have an excel file that look like the photo below

I need hyperlink each box (A, A1, A1a...B4) to a new excel file. Therefore if I click on A, a blank excel file will open. I have to hyperlink hundreds of these boxes on the excel file I am working on and is very time consuming to do so.

I was wondering if it was possible to create a macros to automate the creation of a hyperlink and that hyperlink leading to a blank excel file.

I do not care what the title of the new excel file is named. What I care about is that all of the new excel files go to a specific folder.

A:Excel Macros - New to macros. Please help

Read other 6 answers

First of all, great site, wish I would have found it years ago. I often create Excel spreadsheets (often elaborate) that others use and I like to make them as ummm clean and idiot proof as possible . I would like to create an autoexecute macro that when a file is opened, it will remove all toolbars and menus (spreadsheet functions and navigation will be done with macro buttons). I would also like to have a save and close macro button that will restore default menus and toolbars etc. Any help with the auteoexecute & exit macro would be appreciated.


A:(Solved) Excel - Macros to Remove and Restore Toolbars

Read other 10 answers

I have been using these forums for a while, however haven't bothered creating an account until now.

I have had some trouble with an excel document I created in office 2010 on PC.
When i tried it in office 2011, the program freezes as soon as a certain script is triggered.

It may be that i am using an activX feature, however, I do not know how to tell.

The basic part that doesnt work on mac is:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.Intersect(Target, Range("B5").CurrentRegion) Is Nothing Then Exit Sub ' Limits range to B column AND existing customers

End Sub
If you can help me out I would be very appreciative.


A:Solved: Compatibility prob. excel 2011 mac using VBA macros

Read other 6 answers

Hi, I hope someone outthere can give me some advice.

I have constructed a model in Excel which includes some macros - all of which work fine. The only problem is that some of the Macros appear quite messy as they flick through the intermediate steps (populating data sets etc.). I am hoping that there is some way of configuring the Macros so they step from the first screen to the final screen without showing all the intermediate flickering screens.

Any ideas?



A:Solved: Hiding Intermediate Steps in Excel Macros

Read other 6 answers

I would be really grateful if someone could help me out with this because i am very inexperienced with macros!

I currently have this:

Hide operations from user
Application.ScreenUpdating = False
Selection.Insert Shift:=xlDown
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlHairline
.ColorIndex = 2
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlHairline
.ColorIndex = 2
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlHairline
.ColorIndex = 2
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlHairline
.ColorIndex = 2
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.Weight = xlHairline
.ColorIndex = 2
End With
ActiveCell = Application.InputBox("Enter Registration Plate")
If Range("B23") = False Then ActiveCell.ClearContents
ActiveCell = Application.InputBox("Enter Car Make")
If Range("C23") = False Then ActiveCell.ClearContents
ActiveCell = Application.InputBox("Enter Car Model")
If Range("D23") = False Then ActiveCell.ClearContents
ActiveCell = Application.InputBox("Enter Car C... Read more

A:Solved: Validation built into input boxes - Excel Macros

Read other 13 answers

I want to create a shortcut to run Excel from the command line and in that command or batch be able to run a macro from the workbook in my XLSTART folder. This way, the user does not have to run the macro from Excel menus.

I also want to create a shortcut to run Word from the command line or batch to run a macro (a global macro) when Word opens. Again, the user does not have to get inside Word to select a macro from the menus.

I have searched the internet and found that neither program has command line switches to immediately run a macro at the Office program start up.


A:Solved: Run Excel and Word Macros From Command Line Office 2007

Read other 9 answers

Hi All,

I have been given a task by my ops to send automatic feedback emails to user who have called use for IT support. The need is to sent up Macros in excel to do this once i extract the information from CRM. I seriously have no clue what so ever for a complicated macros. The information which i will be extracting is Ticket Number / Agent who handled the call / Users email address / What the issue was. The catch here is that there will be 30 or more tickets created by a Agent per day and the macros should be in such a way that it should send 5 random feedback emails for one Agent per day or may be a week.

Im good at extracting data into Excel but not in Macros which will send automatic feedback emails to users.
The Body of the email will be

Hi (XYZ)

Please take a quick moment to fill in the survey for a call made to IT Support.
Below is the sharepoint link please click on it and complete the survey which would take 5-6mins of your time.
Thank You.

IT support Feedback Team.

A:Excel Macros

Hi, welcome to the forum.
There are several postings about the saem type of questions and the macro's there can be used. I suggest you do a quick search to locate them.
Another important thing to mention is the version of Excel you're using.

Read other 3 answers

Can anyone help?!? I'm quite fluent with MS Excel and formulas and such, but now I'm venturing into macros, and all I can say is.... huh?!?!?!
I've used the help file, and it might as well be written in another language for all the help I've gotten out of it! See the attached file to follow along with my description of my problem.
All I want to do is have a check box (already inserted in cell B4), that when clicked, will turn the cell next to it (C4) yellow to highlight it, and then post a string of text in another cell (A9).
No doubt this is all painfully simple to those familiar with macros, but I'm completely and totally clueless. According to the help files, I need to understand visual basic programming language, and I don't... it gives examples of how to make a macro to highlight the color of a cell, like I'm trying to do, but again... huh?!?! (see below)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNoneSet OldRange = Target
End Sub

Is there anyone who can walk me thru the process of highlighting the cell, and posting my text string? Please!



A:Macros in MS Excel


No offense to anyone here, but there are better places to get these kinds of answers a lot sooner.

1. Go to www.theofficeexperts.com/downloads.htm and download Userform Training. That might help a little bit for some stuff.

2. For many references:


3. Forums:

Read other 2 answers

Is there any info regarding converting Lotus macros into Excel macros? I realize they are 2 different languages, but looking for a miracle to make life easier. Thanks.

A:Excel Macros

There's a translation doc (Word) here -



Read other 1 answers

I have recorded a macro to sort some data using text to columns. Part of the data is time based on a 24hr clock and formatted as (custom) hh:mm:ss. When I run the macro it changes the data to time on a 12hr clock and introduces another column using am and pm.

The next step is to compare the data using an 'IF' statement to find differences of times for certain conditions. The fact that the macro has taken upon itself to change the time from 24 to 12hr clock thereby gives erroneous results.

So; my question is: why does the macro do that?


A:Excel macros

Read other 7 answers

I have recorded a macro to sort some data using text to columns. Part of the data is time based on a 24hr clock and formatted as (custom) hh:mm:ss. When I run the macro it changes the data to time on a 12hr clock and introduces another column using am and pm.

The next step is to compare the data using an 'IF' statement to find differences of times for certain conditions. The fact that the macro has taken upon itself to change the time from 24 to 12hr clock thereby gives erroneous results.

So; my question is: why does the macro do that?


A:Excel Macros

Read other 16 answers

I do not know how to write code - I typically use the Record a Macro function for all my Excel needs; however, I need to create a macro that opens a new email, puts my email address in the To: field, fills in the Subject field and puts specific text in the body of the email... and then sends that email msg.

Anyone provide me with how to accomplish this within Excel?

Read other answers

I have a very large mailing list on Excel 2002 to which I make corrections as address changes come in. This list is used for several different mailings and I'm having a problem keeping track to be sure the most current corrections have been posted. Is there any formula or macro to be placed in a column to automatically insert the current date (and KEEP it that date) whenever a correction is made to an address? I have tried to manually enter the date when a correction is posted but the date keeps changing to whatever the current date is. It has been quite some time since I tired writing a macro and don't really remember how. (Actually, I think the macros I wrote were in Lotus 123 rather than Excel.) Any ideas greatly appreciated.

One other question. I've been entering zip +4 but when I use this list to print labels with Word 2002 Mail Merge Wizard, it will only print "0" for any zip codes with the additional four numbers. Is there any way around this?

A:Excel macros

There are 2 things you can try (& a formula ain't one of them )

1. Use the shortcut to enter current date ( CTRL+; )

2. Use some event code in the worksheet module (rightclick the sheet tab & "View Code" to access the module):

Private Sub Worksheet_Change(ByVal Target As Range)
If Selection.Cells.Count <> 1 Then Exit Sub
If Target.Column = 1 Then
Target.Offset(0, 1) = Date
End If
End Sub

This will enter current date in column 2 (B) when you make a change in column 1 (A).

For the zip codes merge field formatting, try here.


Read other 2 answers

Help with Excel 2007!

I have recently created an Excel workbook but I do not want people deleting certain sheets.

Below is a screenshot of what I am talking about.

Is there any sort of Macros/visual basic code that can do this?

A:Need help, Excel Macros

This link gives somehints

I know there was a link explaining all the commands and where you can either enable / disable them, amongts these are the delete, copy, paste, etc.

I'll see if I can find it and post it but the above link may lead you in the right way and link to other links

Read other 3 answers

I've created a rather large excel vb project that will be available to use by other members of my department. I've locked my code, but I would like to create an exe file so that they can just run it. I assume this is some type of add-in, but if you know the trick please fill me in!


A:Excel Macros exe

its written in VBA.

Read other 1 answers

Hey Friends,

Can anyone help me out? I want to navigate through last populated cell of the spresheet and then want to move one cell down... Macro function requird.

A:Macros in MS-Excel

Are you talking about a particular column or could this last populated cell be located anywhere in the sheet?


Read other 3 answers

Can someone tell me how you copy a macro from a "worksheet"
into a "Personal Macro Worbook", I beleive you do this in Visual Basic? Can't quite figure it out!

A:Excel Macros

hi ibm37....

you can just drag an existing module from any open workbook into the Modules folder of the Personal XLS file.
(and you need to have the Project window open).
This does not remove (or move) the module from the original Workbook (it acts like "copy").

you can just copy the desired Sub (or Subs) from any module and paste them into any existing Modules in the Personal XLS file.

This is all done as follows:
Tools/Macro/Visual Basic Editor

I hope that this is what you were asking.

Read other 2 answers

I'm opening an Excel workbook in Excel for Mac with macros done in Windows. I can't create new macros, is that right? I'd just like to make some changes to multiple sheets without doing it manually and don't understand the help references to using applescript. Help, pease!

Read other answers

Anyone know of how to create Macros using Excel, beyond using the Recorder but without having to learn VB.

A:Excel Macros

Read other 6 answers

I created a macro to extrract some data but when i run it an error occurs and it states that the procedure is to long is there a way to solve this?

A:Excel Macros

Read other 8 answers

Maybe your expertise in Cell Naming procedures can solve this dilemma for me. Let me step you through this simple problem.
Step #1 Highlight a specific cell (?E7?) on the worksheet.
Step #2 Initiate the running of the Macro named ?Next?. (See macro below)

Sub Next()
ActiveWorkbook.Names.Add Name:="Next", RefersToR1C1:="=GENERAL!R7C5"
ActiveWorkbook.Names("charge").Comment = ""
Application.Goto Reference:="Next"
End Sub.

The ?Add Name? command, shown above was learned by using the ?Record Macro? facility. You will note that in addition to naming the ?ActiveCell? as desired, it also adds the exact cell location being named. This works fine for the first running of the macro. Because of the naming of the cell in the Macro?s first run, subsequent runs of this macro always names the same cell. It is apparent that this cell location is written in stone for all duration.
What I am searching for is a ?generic? cell naming command, one that names the active cell without identifying the specific cell being named.
Any thoughts on this problem?

Thanx, Bill

A:Excel macros

MOving thread to the Office section of the Forum for better results.

Read other 1 answers

I have created a macro that makes a number of changes in a workbook including unhide worksheet, changing format etc. It works fine. The problem is when I try to continue by copying the altered worksheet to a new workbook. I want to run this on several hundred files and add the altered worksheet to one file. I get a variety of error messages. I have tried it with both workbooks open or I open the new workbook. I looked at the VB code and think it has something to do with the relative positioning (pathway to workbook) I have tried every variation that I can think of. There maybe a simple solution. I have not worked much with macros in Excel.

A:EXCEL macros?


Can you post your macro so we can look at it?

Read other 2 answers

Hello techsupportguy,

Im not sure how complicated it is to be but its something like this....
x1=x2 ? [] <==== drop down menu. yes or no.

qty=[4] <==== this means x4 slots
[ ][ ][ ][ ]

now when I press run, I want it to generate all the possible ways to combine x1 & x2

basically it generates all the different ways to combine x1 and x2.

All the numbersets output to this sheet.

Im glad to help me....

Read other answers