Over 1 million tech questions and answers.

Solved: Bizarre Issue // Excel 2003 & 2007 Macros

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

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

RELEVANCY SCORE 200
Preferred Solution: Solved: Bizarre Issue // Excel 2003 & 2007 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: Bizarre Issue // Excel 2003 & 2007 Macros

Read other 8 answers
RELEVANCY SCORE 105.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 95.6

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 94

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?
 

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

Read other 8 answers
RELEVANCY SCORE 84.8

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 84.4

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 84

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 81.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 77.2

Running Windows Vista Premium Home Edition.

I have an Excel 2003 spreadsheet.that I originally created on Excel Office Professional Edition 2003. Also, have Excel 2007 Home and Student Edition installed. I uninstalled the Excel 2003 software, but now when I clik on this created Excel 2003 spreadsheet with Excel 2003 it will not open. It says there is an invalid path. I reinstalled Excel 2003 and it opens. I tried to save this as an .xlsx extension and then uninstalled Excel 2003. It wouldn't open. So something is occurring here. On other Excel 2003 created spreadsheets, they open without issue.

Then I have a program with an .exe extension. It needs to open using Excel 2007. With both Excel 2003 and Excel 2007, it will not open. It freezes and then I get an error message saying it cannot open with another Excel other than 2007. If I right clik on the .exe program, there is no "Open with". I even tried opening a blank Excel 2007 spreadsheet and then cliking on "Open". but it is a bunch of gibberish. My IT person says you can't open the program that way, You have to launch it as an .exe program using Excel 2007.

Any ideas on what is going on? By the way, I have both Excel versions on my laptop running Windows XP and I do not have these issues at all.
 

A:Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista

Hi there,

If I said I was confused that'd be an understatement I think. You cannot open executable files (*.exe) with Excel. Recognized file types are things like .xls, .xla, (for 2007) .xlsx, .xlsb, .xlsm, etc. I don't know what your exe file is and I'm not sure I wanna know, but it certainly doesn't open in Excel. What is it exactly? If you don't know I wouldn't open it. Or if someone told you to open it with Excel then it's probably a virus. Unless I'm missing something here.

With the file in question which won't open, assuming it's not this strange and unknown exe file you're talking about, sounds like the file may have been corrupted. Does it open on any other machine? And if you uninstall Excel 2003, did you re-install 2007? It seems strange. I would try cleaning out your application and reinstalling 2007 fresh. You can't install 2003, then 2007, then take off 2003 and put it back on, you're gonna get things screwed up. I bet your registry doesn't know which way to turn here. Some good info on it can be found here...

http://officearticles.com/misc/best_install_procedures_for_microsoft_office.htm

Also, I would highly recommend you completely uninstall all versions, and I'm talking a deep cleaning, then reinstall. For that deep cleaning, take a look at this article (which I'd highly recommend you do) and then reinstall...

http://officearticles.com/misc/remove_microsoft_office_from_your_pc... Read more

Read other 2 answers
RELEVANCY SCORE 77.2

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

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

Read other 7 answers
RELEVANCY SCORE 76.8

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
Application.Quit
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled
 

A:Solved: Excel 2003 vba code not working in Excel 2007

Read other 16 answers
RELEVANCY SCORE 75.6

I received the following from a user creating and saving macros in her personal macro workbook. I have been unable to duplicate the problem when creating macros in my Excel program, but when I copy her macros into my own personal macro workbook folder, I then have the same problem:

"I use macros in Excel, and have somehow created multiple templates because Excel asks me to create a new template every time I record a new macro. I recorded the latest macro yesterday. Now whenever I launch a new file in Excel, it goes through a series of steps where it shows each of my 3 personal templates opening, and then I don't even get a new blank file of Excel open, and I have to hit new file."

I have googled this and didn't find anything like this - may not have used good search terms. Anyone have an idea what may be going on here?
 

A:Excel 2007 Macros

Read other 7 answers
RELEVANCY SCORE 75.2

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 74.8

I am using Win7 MS Office 2007(Home/Student). I have activated the developer in Excel but the record macros option is greyed out - is this a problem with this version of Excel?
 

Read other answers
RELEVANCY SCORE 74.8

I am in the process of trying to write a macro that includes inserting pictures on the spreadsheet in a specific place with a specific size depending upon specific things happening. I tried recording a macro in Excel 2007 to start the ball rolling, but it won't record anything to do with the pictures. I went back to Excel 2003 and did it successfully, and then copied the macro over to 2007 and it ran fine. What the heck? Does anybody know if this is an inherent problem with Excel 2007? What's going on?

Thank you

A:Recording Macros In Excel 2007

What are you trying to do, exactly?

Read other 4 answers
RELEVANCY SCORE 74.8

Based on what I learned using Oulook 2007, in Excel 2007, I created a list of macros in a Module1 which each one adds certain words or points to any number of cells I select. I created a Module2 which identifies all the macros of Module1, and in Userform1, it is connected to Module2 to show the macros.
But when I run the Userfomr1, it shows the Commbobox of Macro Names, and when I select the macro and click on the commandbutton in the Userform1, it does not run the macro.
This did it in Outlook 2007...so what do I change to these codes so it works in Excel please?
MOdule 1

Sub End_Cell_Colen()
Set yrange = Selection.Cells

For Each cl In yrange

If Len(cl.Formula) = 0 Then
Else: cl.Value = cl.Formula & """"
End If
Next cl
End Sub
Sub Front_Cell_Colen()
Set yrange = Selection.Cells

For Each cl In yrange

If Len(cl.Formula) = 0 Then
Else: cl.Value = """" & cl.Formula
End If
Next cl
End Sub

Sub JoinAndMerge()
Dim outputText As String
Dim inputRange As Variant
Const delim = " "

On Error Resume Next

For Each cell In Selection
outputText = outputText & cell.Value & delim
Next cell
With Selection
.Clear
.Cells(1).Value = outputText
.Merge
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlCenter
.WrapText = True
End With
End Sub

Sub EndCellSemmiColen()
Set yrange = Selection.Cells

For Each cl In yrange

If Len(cl.Formula) = 0 Then
Else: cl.Value = cl.Formula & ";"
End If
Next cl
End Sub
S... Read more

A:Excel 2007 CommboBox With Macros

Read other 16 answers
RELEVANCY SCORE 74.8

Is there a way to clear, and add Fill color to an Excel spreadsheet? Please see the attached file.

I need this to be compatible with Excel 2003 & 2007.
 

A:Solved: Excel 2007 & Excel 2003

Read other 16 answers
RELEVANCY SCORE 74.4

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 74.4

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 74

Hi all,

I am new to the forum and to troubleshooting computer issues, but this one is driving me insane. I have noticed that my desktop is very slow at running Excel 2007 macros, when I believe that it should not be. I decided to do a test, and run it on my machine and then on my friend's machine.

The test the following: I run a loop of 100,000 iterations of putting the i'th number on the i'th row, and time it. Here are my results (in the first column) and my friend's in the second:

1.___3.84___6.14
2.___3.80___6.14
3.___3.82___6.14
4.___4.57___6.14
5.___5.93___6.12
6.___7.77___7.15
7.___10.23__6.09
8.___10.90__6.14
9.___11.83__6.46
10.__12.58__6.17
11.__13.17
12.__13.90
13.__14.03
14.__14.73
15.__14.09
16.__14.09
17.__14.08
18.__14.12
19.__14.14
20.__14.05


Can anyone explain why mine starts out so quickly (the speed I expect, given the computer specs) and climbs to 14 seconds and hangs out there?

The real issue is that I'm writing code that should normally take on the order of 15-20 minutes to run through all the operations, but instead is taking 2-3 hours. Running several iterations of that is extremely slow and time-consuming.

Here is the code that I used. I don't think that it's relevant, as the exact same code generated the two sets of results on the two computers, but here it is anyway:

Private Sub CommandButton1_Click()
Dim time1, time2, time3
Dim i, n As Integer

For n = 1 To 20
time1... Read more

Read other answers
RELEVANCY SCORE 73.2

Help needed please? I just installed Office 2007 over Office 2002 Running XP win PRO. the Macros in one main column in my workbook (the onlu Macros in that book) that was working perfectly 10 min ago won't work???
All the Dropdowns I installed are there with there Lists and working perfectly! But the one Column with VBA which is activated by these Dropdown's wont work since I installed 2007 and yes I have vallidated it etc! It is NOT a Pirated edition. Can somone help please Dasha
 

Read other answers
RELEVANCY SCORE 73.2

I am at my wits end. I have been creating an addin for Excel 2007. I am using the Custom UI editor. Everything was working ok until yesterday. Then none of the new macros that I added would run. I would get the following message.

"Cannot run the macro 'RibbonXOnAction'. The macro may not be available in this workbook or all macros may be disabled."

All my security settings are wide open. I have searched the web high and low and cannot find a solution to this issue. Please help me.

Thanks
Gregg
 

A:All Ribbon Macros quit functioning in Excel 2007

Hi there, welcome to the board!

Is this something you can post, so we can take a look at it and test it? If sensitive material, we can find alternatives. Can you post your code, both VBA and XML? Can you describe to us how your VBA code is setup? Have you tried it on another machine? With this very little information I'm going to take a stab in the dark and point the finger at your XML, it's very touchy, and just one wrong character could render your project unusable (i.e. the error you're receiving). Since we have no idea what you're using your RibbonXOnAction for, we can't really help at all. The more you post, the better we can help you. Please, be very, very specific.
 

Read other 1 answers
RELEVANCY SCORE 72.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 72

Hi People!

I need help fast! I have a table as shown;

Date TC1 TC2 TC3 TC4 TC5 Min LOC Max LOC
4/12/12 9.3 9.5 9.1 8.3 9.0
4/13/12 9.5 9.9 9.3 7.3 8.0
4/14/12 9.3 8.3 7.1 9.3 9.0
4/15/12 7.3 9.0 9.7 8.3 8.0

What I need:
I need to find the location (LOC) for the occurrence of the Max & Min value in each row.

Question:
Is there a way in Excel 2003 or 2007 where I can obtain the top header title for each occurrence?
If there are multiple occurrences at the same row; can I get them too?
 

A:Solved: How to get an occurrence location in Excel 2003/2007

Read other 11 answers
RELEVANCY SCORE 72

Hello. I'm having an issue with formulas not working in Excel 2003. I've created a spreadsheet with about 1200 rows in Excel 2007. There are two tabs, one contains all the data, and the other has my working formulas. When I save, I make sure that I save with compatibility to 1997-2003. This works fine when I initially open the spreadsheet in Excel 2003, but if I filter any one column once, my formulas on a separate tab all change to #NAME?

Is there something I can do to keep this from happening?

Mario
 

A:Solved: Losing Formulas from Excel 2007 to 2003

Read other 8 answers
RELEVANCY SCORE 72

For some reason, one of our users suddenly cannot reposition the cursor in emails by using the arrow keys. The delete key does not work, either. If he wishes to reposition the cursor, he has to use the mouse. The backspace key DOES work. He says that this problem is exclusive to outlook, and thinks he inadvertantly changed a setting, but I can't seem to find one that applies. Any ideas?

Thanks in advance!!
 

Read other answers
RELEVANCY SCORE 72

Hi, currently have the final Windows 7 on two machines and Office 2007. My outlook works great on one machine and cannot connect with the pop3 or smtp servers on the other. They are setup identically. I tried a repair and Outlook said it could not connect with either. Tried this on both of my email accounts on different providers (Yahoo and XO). Again, works fine on one machine but not on the other. I have my data (pst) files on an external 500GB drive that I use between different machines.

Any clues.
 

A:Bizarre Outlook 2007 and Win 7 issue

Are you trying to share this same PST file between both machines?

If so, does the PST file open OK, on the second machine when the other machine does NOT have the PST file open?
 

Read other 3 answers
RELEVANCY SCORE 71.2

I am having a problem in Excel 2007 opening an Excel-2003 created workbook that contains links to other workbooks. I have no problem in Excel 2003 opening this file with the "Don't Update" option - the value of the formula displays even though the other workbooks are not accessible.

In Excel 2007, when opening this file it prompts that the workbook contains links that cannot be updated. Selecting the first option of the prompt "Continue" retains the workbook references in the cells and displays the "#VALUE" error message. If I click on one of those error cells, the smart tag show the message "A value used in the formula is of the wrong data type." The cell type is numeric and the cell contents should be numeric.

The second option when opening is "Edit Links". According to Microsoft, breaking the link to these other sources should replace the formula with the formula value. My does not do that.

Neither option works for me. I've tried adjusting the error checking and update options under "Excel options". I've tried copy & paste special w/ values with the referencing cells. I've tried changing the cell format. Nothing seems to allow me to open the 2003 workbook in Excel 2007 and see the values of cell that reference an inaccessible workbook.
 

A:Solved: Excel 2007 Link Problem to 2003 Worksheet

Can you upload a sample spreadsheet?
 

Read other 2 answers
RELEVANCY SCORE 70

I have an Excel macro which runs fine on any XP machine using Excel 2003 or 2007. The same macro will not run to completion on a Vista machine. Without getting into too many specifics, the macro simply processes data contained on two worksheets of a XLS workbook and places the results on a third worksheet of the same workbook. There are no external dependencies in the workbook such as add-ons or data. The percentage of data processed on the Vista Machine varies each time the macro is run, but rarely exceeds 50%, and tends to slow down markedly just prior to halting. The total processing time on a specific XP machine (Intel quad core Dell T3400) is approximately 10 seconds . The Vista machine is a Gateway Intel duel core ML6720, which will typically halt in less than 2 minutes when approximately 50% of the data is processed. Has anyone had similar issues with Vista and Excel? If anyone is interested, I will gladly provide the workbook with the data and macro in question.

Thanks,
Richard
 

Read other answers
RELEVANCY SCORE 68.4

I'm trying to autofill some cell range references in Excel 2003, and having some issues with what Excel thinks I want.

As a simplified example, I have:

In cell A10, I have =SUM(A1:B2)
In cell A11, I have =SUM(C12)

When I autofill (across or down, doesn't matter to me), it gives me =SUM(A3:B4). If I make the numbers absolutes, it's equally worthless, giving me =SUM(A$1B$2).

Is there a way for it to see that I want the column reference - the letters - to change, and not the numbers? I know you can change the letters doing a row (horizontal) autofill, but that still doesn't solve this problem; it doesn't increase each letter by one.

Thanks!
 

A:Solved: Excel 2003 autofill issue

Read other 16 answers
RELEVANCY SCORE 68

Hi,
I transferred all my old Excel (2003 and before) files to my new notebook which has Vista HP and Excel 2007. I open an old Excel file and it looks OK but when printing or print previewing, every line appears double-spaced and the document runs over to a second page.
If I change the row height it prints the squeezed up text but still double-spaces. If I copy the whole content of the spreadsheet into a new blank spreadsheet it prints normally.
Is there any setting in Excel 2007 that I might have missed ?
Thanks.
RB
 

A:Printing Excel 2003 files with Excel 2007 give double spacing

Read other 7 answers
RELEVANCY SCORE 67.2

I understand in excel 2007 -- when you build a macro and save it to a personal workbook it saves the file in the xlstart menu and automatically opens behind the scenes when you open an Excel workbook---- My problem is when I build a macro and it asks if I want to save changes to the personal,xlsb file if I click on yes -- from than on, when I open Microsoft excel the standard blank sheet one does not open but the personal.xlsb which is supposed to open but behind the scene. Any suggestions... J.T.
 

A:Solved: issue with excel 2007 personal.xlsb file

I don't know 2007. But in previous versions you have to hide personal.xls, then close Excel (it'll probably prompt you to save), then re-run Excel & it should stay hidden.

HTH
 

Read other 2 answers
RELEVANCY SCORE 67.2

I purchased Excel 2007 to take advantage of the larger number of rows and columns. My SS applications are very large and I run out of columns. But after trying my Excel 2003 in the new 2007 software, I find that 2007 runs 10-20 times slower, making it completely unusable. Googling the problem shows it's a widespread issue. MS help desk essentially no help. Any suggestions?
 

A:Excel 2007 Runs MUCH Slower than Excel 2003

The biggest thing that slows Excel 2007 is also what you wanted it for - the greater number of cells. If your formulas have cell references like A:A or $1:$1, then that is a lot more cell references for it to process.
Read this http://msdn2.microsoft.com/en-us/library/aa730921.aspx and maybe you will get some ideas on how to make your files process faster.
 

Read other 2 answers
RELEVANCY SCORE 67.2

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!
 

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

Read other 1 answers
RELEVANCY SCORE 67.2

I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The interesting thing is that if I try to open the same file that I have saved within the last year (before I got 2007) then I can do it? That is, I have a cache folder of files that I go get to do calculations then save in a new job folder. The ones in the new job folder will open (also 2003), but the ones in the original cache will not? I would truly appreciate any suggestions. Thank you.

A:Can't open 2003 Excel Files in Excel 2007?

Have you attempted to set them up in 'Compatibility Mode." Not sure if this will help, just hoping it will. I have been testing the new Microsoft Office 2010 Beta 64 bit, and have yet to have this problem, and like you I have a great deal of files in 2003 (never used 2007)'

I think you can still download MS Office 2010 beta from Microsoft's download site. Good Luck.

BTW, Welcome To The Seven Forums.

Read other 9 answers
RELEVANCY SCORE 65.6

Why does the second line of the code shown below produce an error in Excel 2007 and not in Excel 2003? The error is:
Run Time Error Ď1004í, Unable to set the Text Property of the Characters class

ActiveSheet.Shapes("btnJobSummary").Select
Selection.Characters.Text = "Prepare Job Summary" & Chr(10) & "for " & CurrentJob

CurrentJob is defined as: Public CurrentJob As String

In this case it equals: RockMont Rev 7-9-04

No problem at all in Excel 2003 and earlier. If CurrentJob is something shorter (e.g. MyFile), there is no error. I don't think the spaces are a problem either because I still got the error after adding Chr(34) before and after CurrentJob in my code. Any ideas? Thank you.
 

A:Error in Excel 2007 but not in Excel 2003

Hello, welcome to the board!

The text is too long. Use an ActiveX control instead of a Forms control. Then you can use similar code...
Code:
Public Const strCurrentJob As String = "RockMont Rev 7-9-04"
Dim btn As CommandButton

Sub FooTest()
Set btn = Sheet1.CommandButton1
btn.Caption = "Prepare Job Summary" & Chr(10) & "for " & strCurrentJob
End Sub
HTH
 

Read other 3 answers
RELEVANCY SCORE 65.6

Hi there.

I'm trying to open an Excel 2007 document with Excel 2003. I thought that I had downloaded what I needed to be able to do that, but I guess not. Is there a way to do this? I suppose I could upgrade to newer version if I need to. If so, should I go ahead and get the newest version and get it over with?

Thanks for your help and time. Have a good day.
 

A:Open an Excel 2007 doc with Excel 2003?

Have you tried the office 2003 compatibility pack https://www.microsoft.com/en-us/download/details.aspx?id=3
 

Read other 5 answers
RELEVANCY SCORE 65.6

Does anyone know the best way to setup a Macro in Excel 2007 that will work in Excel 2003 as well?

I have an Excel 2007 workbook that I am using a macro to change the "Fill Color" and "Font Color" of cells. However, I will get everything working in Excel 2007, but when I open the workook in Excel 2003 I get many debug errors.

If I change the code in Excel 2003, and then re-open in Excel 2007 I get debug errors.

There must be a way to setup teh workbook to work on both Excel 2007 & 2003.
 

Read other answers
RELEVANCY SCORE 64.4

Hi guys,

Im currently undertaking tertiary education and have to start at the beginning unfortunetly. This post is for part of a project:

Sam wants some information on recording macros in Microsoft Word. Find an internet forum and ask if anyone knows any good tutorials on recording macros in Word."

Thanks guys!

-Steel
 

A:Solved: Recording Macros in 2007 Word

Read other 9 answers
RELEVANCY SCORE 64

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 64

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 64

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 64

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 64

I am converting an old MS Word template we have for our office to install properly on 64 bit systems which basically just inserts some small preformatted .doc files into a template which you can save as a new file. All I did was change the lookup for the file location to grab the program files environment variable so it would go to Program Files or Program Files (x86) when it should.

Now the issue I'm seeing is that the toolbar it places provides shortcuts for 10 or so of these inserts and 9 of them work. The last one gives the error "The macro cannot be found or has been disabled because of your Macro security settings". This error popped up on all these shortcuts before I dropped macro security settings down to medium, after which the rest of them worked just fine. If I go to tools->Macros->Macros to see the list of available macros I can run it directly from there and it works just fine.

The problem insert has no different code at all (except for the filename which it inserts), but is the only document to have a picture within it if that helps. I'm not very familiar with word or the macro editor within it but I was not able to find a way to edit the toolbar that appears in 2003 (Which is not present in 2007).

Some extra info: I am seeing this issue on a win8 64 bit laptop running office 2003. On my other laptop I have office 2007 and do not have the toolbar shown in 2003 at all. The toolbar issue may be present there but I have no idea how to e... Read more

Read other answers
RELEVANCY SCORE 64

I converted a excel 207 file to 2003 and it changed in size from 6MB to 31MB. How do I find the key reasons for the massive size and how to reduce it?

A:Excel 2007 to 2003

It happens in both versions when saving a file created with the other version and it will occur for almost all files. Basically it's because the data within the file gets saved twice. Once in the original format in which it was saved, and then again in the format you are saving it to.

Read other 3 answers
RELEVANCY SCORE 64

I have designed a small program in both excel 2003 and 2007, both are set up identically, users can only enter data in 3 unlocked cells, all other cells on the sheets are locked, my problem is as follows

in the excel sheet 2007 the user can use the tab key, the enter key or the arrow keys to move between the 3 unlocked cells c1,c2,c3, if the user has entered data in c3 and then use's one of the above keys c1 is highlighted, but in excel 2003 the arrow keys and tab key works to move between c1,c2 and c3, but if thre user has entered data in c3 and press's the right arrow or tab key the excel sheet stops responding, the enter key doe's not work either

any idea's please
 

A:excel 2003 & 2007

Read other 13 answers