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?

RELEVANCY SCORE 200
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
RELEVANCY SCORE 145.6

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
RELEVANCY SCORE 138

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?

thanks
 

A:Solved: excel 2003 macros

Read other 16 answers
RELEVANCY SCORE 137.6

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

Thanks!
 

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

Read other 9 answers
RELEVANCY SCORE 136.4

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
RELEVANCY SCORE 134.8

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
RELEVANCY SCORE 133.6

hi,

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.

thankyou

Yankeebean
 

Read other answers
RELEVANCY SCORE 133.6

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
Patrick
 

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

Read other 8 answers
RELEVANCY SCORE 128.8

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
RELEVANCY SCORE 127.2

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
D E
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
RELEVANCY SCORE 127.2

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
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90
 

Read other 3 answers
RELEVANCY SCORE 124.8

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
RELEVANCY SCORE 118

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
 

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
RELEVANCY SCORE 117.6

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
RELEVANCY SCORE 117.6

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

thanks
 

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
http://personal-computer-tutor.com/personalxls.htm
 

Read other 3 answers
RELEVANCY SCORE 117.6

Hi!

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
Range("A1").Select
Selection.Copy
Range("E1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
Application.CutCopyMode = False
Selection.ClearContents
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!
Paddy
 

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.
Code:
Private Sub Worksheet_Calculate()
If Me.Range("A4").Value = "1" Then
Application.EnableEvents = False
Me.Range("E1").Value = Me.Range("A1").Value
Me.Range("A1").ClearContents
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
RELEVANCY SCORE 117.6

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

Hi

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, _
SearchOrder:=xlByRows).Row
' Find the last real column
LastCol% = .Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _
SearchOrder:=xlByColumns).Column
End With
Set GetLastCell = ws.Cells(LastRow&, LastCol%)
End Function

Enjoy!!

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
RELEVANCY SCORE 116.4

Hi

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?

[EDIT]

I have found this VB code:

Sub PrintToAnotherPrinter()
Dim STDprinter As String
STDprinter = Application.ActivePrinter
Application.ActivePrinter = "microsoft fax on fax:"
' change printer
ActiveSheet.PrintOut
' 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
RELEVANCY SCORE 115.2

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
RELEVANCY SCORE 115.2

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.
Code:
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
Code:

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

'or

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.
Code:
vLastCol = Cells(1, Columns.Count).End(xlToLeft).Column
To find the last column regardless of the row you can use
Code:

vLastCol = ActiveSheet.Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _
SearchOrder:=xlByColumns).Column

'or

vLastCol = ActiveSheet.UsedRange.Columns.Count



Regards,
Rollin
 

Read other 3 answers
RELEVANCY SCORE 115.2

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
Code:
Range("A2").Value = Date
or
Code:
ActiveCell.Value = Date
Regards,
Rollin
 

Read other 3 answers
RELEVANCY SCORE 115.2

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
RELEVANCY SCORE 115.2

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
RELEVANCY SCORE 115.2

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
RELEVANCY SCORE 114

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.

Thanks
Wildheart
 

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

Read other 10 answers
RELEVANCY SCORE 114

Hi,
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:
Code:

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

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

Cheers,
Tom.
 

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

Read other 6 answers
RELEVANCY SCORE 114

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?

Regards

Kevin
 

A:Solved: Hiding Intermediate Steps in Excel Macros

Read other 6 answers
RELEVANCY SCORE 112.8

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
Rows("23:23").Select
Selection.Insert Shift:=xlDown
Range("B23:F23").Select
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
Range("B23").Select
ActiveCell = Application.InputBox("Enter Registration Plate")
If Range("B23") = False Then ActiveCell.ClearContents
Range("C23").Select
ActiveCell = Application.InputBox("Enter Car Make")
If Range("C23") = False Then ActiveCell.ClearContents
Range("D23").Select
ActiveCell = Application.InputBox("Enter Car Model")
If Range("D23") = False Then ActiveCell.ClearContents
Range("E23").Select
ActiveCell = Application.InputBox("Enter Car C... Read more

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

Read other 13 answers
RELEVANCY SCORE 111.6

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.

Thanks
 

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

Read other 9 answers
RELEVANCY SCORE 108.4

Excel macros, I tried to create a very simple macro in Excel, that would
> change a credit number to a negative for addition, 1.32cr to -1.32,
> after recording the macro, I ran it, the macro changed the credit to the
> negative number that was used when I created the macro, this is a very
> simple Macro & I ran it in Lotus, F2(Edit)Home,-,End,BKSPC 2, Visual
> Basic does not show these keystrokes and I can't seem to correct, I get
> Syntax error. Pls help. Lloyd
 

A:macros in Excel

Lloyd:

Put a -1 in a blank cell somewhere, then copy that cell. Then select the credit number cell(s), and hit Edit-Paste Special, select multiply and hit okay.

Record that.

Or replace your macro code with this:

Selection.NumberFormat = "-#.##"
Or, if you already know where the credit numbers will be, just format that area:

Format-Cells-Special and type in -#.##

That's for 2-decimal numbers. If you can't figure this out, email me file and details.
 

Read other 3 answers
RELEVANCY SCORE 108.4

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?

Hello,

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

Read other 2 answers
RELEVANCY SCORE 108.4

Hello, I'm trying to open a spreadsheet that I know has macros within it. I can open it successfully in MS Excel, but my question is:-

Does anyone know of an alternative to Excel that will still run the macros, I've tried 602Tab but it won't run them, unless I'm missing something of course.

PP
 

A:Excel Macros

Read other 8 answers
RELEVANCY SCORE 108.4

I was wondering if anyone could help me out with a problem I am having.
Here is an example of what I need:

Main Sheet of which we will be pulling information from is
Gross Log
Then numerous sheets for employee numbers

If cell c5 = "244" then
that number 244 will have the cells from Gross Log go to the number of which the cell has in it.
A5, B5, C6, C7 for example will go to 244's sheet

Else if c5 = "723" then
that number 723 will have the cells from Gross Log go to the number of which the cell has in it.
blah blah blah

If you would like to see the file, I am willing to send the attached file to you if you provide me with your email.

Mine is: [email protected]
Thanks!!!!!
 

A:Excel Macros

Not an Excel kind of guy, but welcome to the team! A word of warning: if you go in random you WILL get hooked Sorry I couldn't help.
 

Read other 2 answers
RELEVANCY SCORE 108.4

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?

Xtech
 

A:Excel macros

Read other 7 answers
RELEVANCY SCORE 108.4

In Lotus 123 you can "step" a macro enabling you to run the macro line by line - is it possible to do this in Excel?

If so can somebody point me in the right direction please?

Thanks in advance,

Moll
 

A:Excel Macros

Read other 6 answers
RELEVANCY SCORE 108.4

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
RELEVANCY SCORE 108.4

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
RELEVANCY SCORE 108.4

Hi all,
I am needing to write macros in Excel -
and was wondering if anyone out there could direct me to
an easy way to wtite them - templates, software, free tutorials on line - anything.

Any help is appreciated.
Thanks,
Thee

A:Excel Macros

Thee Ox,Is this the sort of thing, you're looking for? If not please let us know. Hope this is of some assistance.Be (macro) SafeDa Animal

Read other 1 answers
RELEVANCY SCORE 108.4

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
RELEVANCY SCORE 108.4

Is it possible to use "if" formulas in the macro code? If so, where is a good place to begin learning about these?
 

A:Macros in Excel

The two things that VBA uses more than anything to control how they run is if/then and loops.
There is lots of code on this forum and also on the VBAX forum as well.
Or you could buy a book of course.
 

Read other 2 answers
RELEVANCY SCORE 108.4

Hi,
I am trying to write a simple macro, where it unlocks the protected sheet and unhice the spreadsheet which is protected by a password. Below is the script of the macro but it doesnt work and come up with following error.

Run-time error '1004'
The passowrd you supplied is not correct. the password is POAFD. i acan notice in the macro that it is not recording the password at all may be that is the reason.

Can some body help?????


Sub POUNLOACK()
'
' POUNLOACK Macro
'
' Keyboard Shortcut: Ctrl+u
'
ActiveWorkbook.Unprotect
Sheets("PO").Select
Sheets("Upload").Visible = True
End Sub
 

A:Excel Macros

Read other 7 answers
RELEVANCY SCORE 108.4

I have made a number of maths worksheets/games in excel. I have never learned programming, but I have picked up bits of visual basic from friends and from the "record macro" function.
I'm attaching an example of the type of structure I'm using. I really like the way I can make buttons to click for the kids to enter their answers, so that everything is done with a mouse. I often put timers on so that they're working against the clock.

I would like to write something similar for multiplication table practice. I would need a number pad of answers from 1 to 100. There must be an easier way to do this than to write 100 short macros equivalent to the 4 answer macros in my example.

Can anyone help?
thanks
 

A:please help with my excel macros

Read other 16 answers
RELEVANCY SCORE 108.4

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
RELEVANCY SCORE 108.4

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
http://msdn.microsoft.com/en-us/library/aa141022(office.10).aspx

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
RELEVANCY SCORE 108.4

I need help...

I need to create a macro that imports a text file, but the text file name changes daily (ie 05092007.txt for the file polled on May 9, 2007).
Ideally, the user would input the date to load and the macro would import the corresponding file.

When I set up the macro using the recorder, based on the file I click I get this:

Cells.Select
Selection.ClearContents
Selection.QueryTable.Delete
Range("A1").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\sam7000\stores\townsqr\poll\05092007.TMP", Destination:=Range("A1"))
.Name = "05092007"

I would like to change date part (05092007) based on information entered in an input box.

Any help is appreciated
 

A:Excel Macros

Read other 11 answers
RELEVANCY SCORE 108.4

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!

Steve

 

A:Macros in MS Excel

Stevrford:

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:

http://j-walk.com/ss/excel/index.htm
http://www.cpearson.com/excel/topic.htm
http://www.bmsltd.co.uk/Excel/SBXLPage.asp

3. Forums:
http://www.theofficeexperts.com/forum/
http://www.ozgrid.com/forum/
http://www.mrexcel.com/board/
 

Read other 2 answers