Over 1 million tech questions and answers.

Excel file for storing macros closes when trying to view mac

Q: Excel file for storing macros closes when trying to view mac

My Excel file closes by itself when trying to view macros.

Tech Support Guy System Info Utility version 1.0.0.9
OS Version: Microsoft Windows 10 Enterprise, 64 bit, Build 18363, Installed 20191127182037.000000-240
Processor: Intel(R) Core(TM) i5-8365U CPU @ 1.60GHz, Intel64 Family 6 Model 142 Stepping 12, CPU Count: 8
Total Physical RAM: 16 GB
Graphics Card: VNC Mirror Driver
Hard Drives: C: 237 GB (171 GB Free); D: 931 GB (789 GB Free);
Motherboard: Dell Inc. 0PD9KD, ver A00, s/n /B67Q2R2/TW3207098N0177/
System: Dell Inc., ver DELL - 1072009, s/n B67Q2R2
Antivirus: McAfee VirusScan Enterprise, Enabled and Updated

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Excel file for storing macros closes when trying to view mac

I recommend downloading and running DAP. It can help sort out any driver and firmware related issues on your system

It's worked out well for many of us in the past.

You can download it direct from this link http://downloaddap.org. (This link will open the download page of DAP so you can save a copy to your computer.)

RELEVANCY SCORE 69.6

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 60.4

How can I view a PDF file and an Excel file on the screen at the same same time? Every time I open a PDF file, everything shuts down, excel for the PDF. Whenever I click off the PFD, I see everything else, but the PDF is gone. I'm trying to get some info from the PDF to Excel, but it's really hard to do this in Widows 8. In Windows 7 and previous versions, I could see more than one thing on my screen at the same time. Now, the PDF simply takes over control of everything else, so you see the PDF and that's it and that's all.

Thanks everyone.

A:How to view a PDF file and an Excel file on the screen?

Oh, never-mind. It was some weird Adobe thing that took over control of my computer. I uninstalled that other freaky thing, and now I have the real PDF reader back.

Read other 1 answers
RELEVANCY SCORE 60

Need help inporting xl document into microsoft works spread sheet or source for ex viewer

Jim Leonard
 

A:Works: View Excel file?

Excel viewer:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q273711

Or email to [email protected] and I'll convert it to Works for you.

(I broke your question off of another question.)
 

Read other 1 answers
RELEVANCY SCORE 59.6

Hi
I am using Exel 2010 - when I save my workbook on the server for the rest of the team to look at, my changes do not show up in their version. However, when I pull up the workbook on my system - all my changes are there. Also, I cannot see their changes eventhough we are all using the "same" workbook name.....

Help please.

A:Cannot Save Excel file for others to view on Network

What if you put your file on SkyDrive for all to share, or change permissions as you see fit?

Read other 2 answers
RELEVANCY SCORE 58.8

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 58.8

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 58

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 58

with excel 2002 is there any way of limiting a value to positive numbers?
perhaps in the dim area?
i have a value defined as range - whatever that means!
thanks
 

A:negative view of macros!

Read other 16 answers
RELEVANCY SCORE 57.6

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 57.2

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 54

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.

HTH,
Andy
 

Read other 2 answers
RELEVANCY SCORE 54

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 -

http://support.microsoft.com/default.aspx?scid=kb;en-us;148240

HTH,
Andy
 

Read other 1 answers
RELEVANCY SCORE 54

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 54

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 54

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 54

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 54

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?

Rollin
 

Read other 3 answers
RELEVANCY SCORE 54

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 54

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 54

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

Hi, Thee.

Free Lesson 1, and over 500 macros in a knowledgebase. All free.
www.vbaexpress.com
 

Read other 2 answers
RELEVANCY SCORE 54

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 54

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 54

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 54

Hello techsupportguy,

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

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

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

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

Sheet2
All the numbersets output to this sheet.

Im glad to help me....
 

Read other answers
RELEVANCY SCORE 54

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 54

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 54

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 16 answers
RELEVANCY SCORE 54

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 54

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 54

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

I have to write a Excel Macro to do different checks and do changes
accordingly .

Here are the checks.
1.Filter the data by current month and copy only that data to a new
sheet with current month name.
2.There is a hyperlink in one of the field.Its a file path on the
network.So the macro should check if the file exists at given location and
also check the filename length.If the File doesn't exists or File name
is greater then 56 characters then it should copy these rows to new
sheet called"Exceptions" and mention the Failure reason as
either "File doesn't exist" or "File name is more then 56 Characters"

4.Macro should run automatically.

Is there any way i can send the sample excel data for this Macro.
I am totally new to Excel Macros.Your help would be greatly
appreciated.

Thanks,
Sree.
 

A:Need help with Excel Macros

Read other 12 answers
RELEVANCY SCORE 54

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 54

Im trying to select rows continus until a cell equals a certain value, acting as a select end so to speak then the selected values can be copyed onto another sheet. and sugestions??
 

A:EXCEL macros

Hi, welcome!

Can you explain what you want a little bit more? You need to be as specific as possible. Examples help.
 

Read other 2 answers
RELEVANCY SCORE 54

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 = ""
Command
Command
Command
Application.Goto Reference:="Next"
Selection.ClearContents
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
RELEVANCY SCORE 54

Hi,

Does anyone know a way to put a button or something into a spread sheet that will clear all checked radio boxes?

Thanks,
Dan
 

A:Excel Macros

Read other 8 answers
RELEVANCY SCORE 54

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

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 54

Greetings everyone,

I'm very new to macros in Excel 2007, although I have found codes that work for my purpose so far.This is for a game idea a friend and I came up with. We have 108 character slots; some of which have already exist, but not all. The characters are identified by three traits: number, name and ability. I have a worksheet with the data for the existing characters. For the ones that don't exist, I want them to be randomly generated using a pool of names and traits that my friend and I have compiled. Here's an example of what I'm trying to say:

#1. Tinker -- Wrench
#3. Soldier -- Firearm
#4. Spy -- Knife

How do I copy a list like that above from one worksheet to another, while randomly generating a new character (name and trait) in slot #2?

Thanks in advance!
 

Read other answers
RELEVANCY SCORE 54

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

or...
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.
k
 

Read other 2 answers
RELEVANCY SCORE 54

I would like to do something very simple, but that will affect over a hundred tables.

I would like to automatically, via a macro, place the table heading into the header. The table heading is in cell b5 on all tables. Therefore I need to write a macro that will go through each worksheet (they are in 4 workbooks, but I can do the same macro in each workbook) and perform this action.

I have read masses of help and tried lots of different ways and it WILL not work.

I have used for and next, and other loop arrangements. I have used the worksheets function and the activate.worksheet function. But nothing will work.

This is the line that it does not like:

ActiveSheet.PageSetup.LeftHeader = Range("b5").Value

I have tried different configurations of this line and used different functions within it, but nothing has worked.

Does anybody know what I am doing wrong?

Would appreciate any guidance anyone can give me.
 

A:Excel macros

Read other 6 answers
RELEVANCY SCORE 54

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 54

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!

Thanks,
Ca1Ga1
 

A:Excel Macros exe

its written in VBA.
 

Read other 1 answers
RELEVANCY SCORE 53.6

Hi, my name is Kyle.

I'm having trouble with Firefox, and despite trying multiple times, I can't seem to fix this problem myself.

Whenever I try to watch streaming movies or videos, before the video even loads at all, firefox gets an error that says "Firefox has encountered a problem and needs to close."

I've tried uninstalling and reinstalling firefox and the divx player multiple times, along with the flash program. I don't know what to do!

Someone please help.

Read other answers
RELEVANCY SCORE 53.6

Windows Xp
Dell Dimension 8200

When workign in Word and closing a file, Word closes completely most of the time. I have to reopen Word eveytime to be able to open a new file.

How do I keep Word open after closing a file?
 

A:MS Word closes when file closes

Read other 12 answers
RELEVANCY SCORE 53.6

I have an Excel Workbook that I use a lot. As far as I know, the workbook doesn't contain any macros but I continue to get this message: C:\Users\AccountName\Documents\Spreadsheet.xls contains macros.
Macros may contain viruses. It is always safe to disable macros, but if the macros are legitimate, you might lose some functionality.
Then there are buttons to choose from: Disable Macros...Enable Macros...More Info
The really odd thing is I don't get this warning with other workbooks I've created. This workbook has the same Security Level (medium) as all the other Excel workbooks I've created, so I really don't understand why it's doing this.

How can I get this message to stop?

Thanks in advance!

A:Excel Warnings - Macros

How sure are you that it does not contain macros?

Can you make a copy of the file and then enable macros in that copied file? What then happens, if anything? Does the file change in any identifiable way---file size, for instance--anything that might indicate that a macro had actually run?

I don't know if that message can be turned off or if that message is necessarily incorrect.

I use macros in just one of my many Excel files and don't think I've ever seen that message except perhaps on a new installation.

Is this while logged in as the same user as for all other Excel files?

Is the file known to be virus and malware free?

Read other 1 answers