Over 1 million tech questions and answers.

Excel Macro runs fine..then excel crashes

Q: Excel Macro runs fine..then excel crashes

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

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

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

Does anyone have experience with similar questions?

Thanks

RELEVANCY SCORE 200
Preferred Solution: Excel Macro runs fine..then excel crashes

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: Excel Macro runs fine..then excel crashes

Read other 11 answers
RELEVANCY SCORE 92.8

Hi all,
I have written the a macro to replace certain Telugu words in the sheet by new set of words.

The macro is in the attatched excel sheet

The macro has two sheets.
Sheet1 is the sheet in which words are to be replaced

telugumeanings sheet has two coloums
coloum A has words which are to be replaced from
coloum B has the words which are to be replaced by

The macro doesnot do any thing when run in f5 mode.
But when i run it in F8 mode it works some times and keeps quiet some times.
I am not sure what is happening. Can some one help.
Regrds
Kamalakar

Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 7 Home Basic, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz, Intel64 Family 6 Model 58 Stepping 9
Processor Count: 4
RAM: 3971 Mb
Graphics Card: Intel(R) HD Graphics 4000, 1793 Mb
Hard Drives: C: 232 GB (8 GB Free); E: 219 GB (26 GB Free);
Motherboard: Dell Inc., 085M0K
Antivirus: Quick Heal Total Security, Enabled and Updated
 

Read other answers
RELEVANCY SCORE 92

Hi,
I have a monthly report I run which outputs single sheet "Invoices" from my workbook that is populated by a months worth of sales. The macro goes through a list of names, pulls the details for that person, populates the pivot table on the invoice,
then saves as both a single excel sheet and a pdf. up until today it has worked fine. the code is, and the error occurs when it reaches the date line. It states "Compile error, can't find project or library":
Sub Save_Sheets_To_New_Books() 'INVOICES
Const strWbPath As String = "D:\Accounts\EA Letters\2020 09 September\"
Dim strDate As String 'todays date
'save the sheets to new books within the active folder and print them
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
strDate = Format(Date, "yyyy.mm.dd")     '(Date, "yyyy.mm.dd")
THIS IS WHERE THE ERROR OCCURS the word DATE is highlighted
ActiveSheet.Copy
Call DeleteNamedRanges
Call PrintAreaAndPasteSpecial
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=strWbPath & Name_of_Artist & "_" & strDate & ".pdf" _
        , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False         
ActiveWorkbook.SaveAs FileName:=strWbPath & Name_of_Artist & "_&quo... Read more

Read other answers
RELEVANCY SCORE 90

Hello everyone,

I'm trying to create a macro that will run one set of commands if someone changes a drop down menu from YES to NO, and run a different set of commands if the drop down menu is changed back from NO to YES. I've found macros that will run when a cell is changed, but I'm not sure how to write an if statement on the macro, that will run it one way or the other, based on the cells value.

The option defaults to YES. If they change it to NO, I want it to unhide the rows and enable overwriting of the unhidden cells. If they change it back to YES, I want it to automatically hide the rows and put the formulas back in. Here is the file.

Any help is greatly appreciated!
 

Read other answers
RELEVANCY SCORE 88.8

Hi,

I am having a problem when I try to run an excel macro addin (ie vba functions) that calculates some statistics, it doesn't work. Shows permission denied.
When I turn off UAC, It works.

Is there any fix for this?
Turn UAC on and off is too annoying...cos u need to reboot each time.

A:uac crashes excel macro

First thing I would do is to check the access permissions on the folder containing the macro - It could simply be a case that the macro is located in a folder that requires elevated rights to access - this is the case with anything in the Program Folders Tree.

If you give the actual user full rights to either the folder or the file It may cure the issue.

It may of course be something else depending on the actual macro code but this is worth an initial investigation

Read other 2 answers
RELEVANCY SCORE 83.6

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

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

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

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

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

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

Dim c As Range

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

Does anyone have a better solution?
 

Read other 1 answers
RELEVANCY SCORE 83.6

Hello again,

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

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

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

Sample form attached, thank you
____________________________
 

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

Read other 7 answers
RELEVANCY SCORE 83.6

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 83.6

Hi,

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

Thanks for reading!
 

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

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

Read other 1 answers
RELEVANCY SCORE 83.6

Hello,

I need help to create an Excel macro that would

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

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

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

Looking forward to your help!

Thanks a lot.
Mzz
 

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

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

Read other 1 answers
RELEVANCY SCORE 83.2

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

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

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

Any help will be much appreciated.
Thx
 

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

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

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

Read other 3 answers
RELEVANCY SCORE 83.2

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

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

Hello, and welcome to the board!

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

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

Option Explicit

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

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

Read other 1 answers
RELEVANCY SCORE 82.8

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 82.4

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

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

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

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

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

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

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

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

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

Read other 13 answers
RELEVANCY SCORE 82.4

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 82.4

Hi guys,

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

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

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

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

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

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

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

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

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

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

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

Apologies again
 

Read other 1 answers
RELEVANCY SCORE 80.8

I have an equation that I need help with putting into an excel Macro. The equation is as follows:
=IF(AND(ISBLANK(E2),ISNA(F2)),"XXXXXX",IF(AND(ISBLANK(E2),ISNUMBER(F2)),"ASSIGN LAN ID",IF(AND(E2="XXXXXX",ISNUMBER(F2)),"ASSIGN LAN ID",IF(AND(E2="XXXXXX",ISNA(F2)),E2,IF(AND(OR(ISBLANK(E2)="FALSE",E2<>"000000",E2<>"111111",E2<>"999999",E2<>"IOIOIO",E2<>"XXXXXX"),OR(ISNUMBER(F2),ISNA(F2))),E2,"No Criteria Met")))))

I need this put into a macro as either an if then else statement or a case statement. If anyone could help me out i would appreciate it
 

A:Excel Equation converted to an excel macro

Not sure if this will work for you or not, untested...
Code:
dim e as range, f as range, c as range
set e = range("E2"): set f = range("F2"): set c = activecell
if e = "" and worksheetfunction.isna(f) then
c.value = "XXXXXX"
elseif e = "" and isnumeric(f.value) then
c.value = "AS SIGN LAN ID"
elseif e = "XXXXXX" and isnumeric(f.value) then
c.value = "ASSIGN LAN ID"
elseif e = "XXXXXX" and worksheetfunction.isna(f) then
c.value = e.value
elseif (e <> "" or e <> "0000 00" or e <> "111111" or e <> "999999" or e <> "IOIOIO" or e <> "XXXXXX") and (isnumeric(f) or worksheetfunction.isna(f)) then
c.value = e.value
else
c.value = "No Criteria Met"
end if
HTH
 

Read other 3 answers
RELEVANCY SCORE 80.8

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 80.8

A macro I wrote in VBA for Excel 2004 won't run in Excel 2011 (alas...). Upon opening the spreadsheet an "on open" routine runs, and bombs out on the following command:
Code:
Set cmdbar = Application.CommandBars.Add _
(Name:="Sort", _
Position:=msoBarTop, _
MenuBar:=False, _
temporary:=True) 'msobartop docks the menu at the top

Does anyone know if the VBA structure ("CommandBars.Add") has been removed or altered?

Is there another way to accomplish the same thing in 2011? I want to create a custom command bar (I populate it later in the module).
 

Read other answers
RELEVANCY SCORE 80.8

Excel '07 won't open an "excel 4.0" macro (i.e. *.xlm file). I am one of a few users at work using excel 2007, I believe this file was made with excel 2000 or similar. When I had excel 2000 it opened fine, it's a common file on the network that everyone should be able to access, and everyone with excel 2000 can easily. So I know it's not the file. When I try and open it with excel 2007 I get that stupid error about the file being different to the extension.

I've tried registry edits and workarounds after scowering the net but nothing seems to fix it. All it does is display the error, then opens excel in the background without even a new worksheet. Excel isn't hanging, it just does nothing. Any ideas?
 

A:excel 2007 won't open excel 4.0 macro

XLM was long ago replaced by VBA (with Excel 5 in 1993) and MS no longer really supports it (although I think they claim that they do, kinda, sorta.) So the only thing you can do, I think, is to make a copy of the xlm file and convert the xlm code in the copied file to VBA. Fortunately, I found a link that tells you how to do that:
http://blogs.msdn.com/b/excel/archive/2010/02/16/migrating-excel-4-macros-to-vba.aspx
(Look at the link at the bottom, too. But you will need to download that to an older PC, possibly.)
Now, assuming all goes well, this will give you two versions of the same file, but if everyone else has Excel 2000 (or later) then they will all be able to use the new VBA-based file, so you won't end up with two files that would lead to confusion.
Still, it looks to be a lot of work, so good luck!

On a final note, if you need this file done in VBA and you can't figure out how to redo it, make a post describing your needs - there are some amazing VBA coders on here.
 

Read other 1 answers
RELEVANCY SCORE 77.2

Hello,

I've been working on a certain workbook and everytime a try to save it an error occurs:

Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience.

AppName: excel.exe AppVer: 9.0.0.2719 ModName: excel.exe
ModVer: 9.0.0.2719 Offset: 002aa2b3

HELP !!!

Thanks

Mark R

A:Excel 2000 .. When saving a certain workbook excel crashes

Hi, try running a repair from control panel>click on MS office and run change or repair if I remmber correctly.

Read other 1 answers
RELEVANCY SCORE 74.8

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

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

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

Regards,
Rollin
 

Read other 1 answers
RELEVANCY SCORE 74.8

I've tried both firefox and IE. They run along fine for maybe 15 minutes at the most then stop loading any page fully. I have to restart the system to "fix" it.

I have run Avast, CWShredder, Ad-aware, Spybot-- even did online scans from Panda and Housecall. There was nothing much on any of them. I tried removing programs from the startup menu that might be slowing it down. Now I'm at a loss. I ran Hijackthis, but don't really know what is needed (it is my son's PC)

ANY help would be GREATLY appreciated!

By the way his usual browser is Firefox..I only checked IE to see if it did the same thing (which it did) thereby ruling out a browser problem.

here is the log:

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 10:05:49 AM, on 9/9/2008
Platform: Windows Vista SP1 (WinNT 6.00.1905)
MSIE: Internet Explorer v7.00 (7.00.6001.18000)
Boot mode: Normal

Running processes:
C:\Windows\system32\Dwm.exe
C:\Windows\system32\taskeng.exe
C:\Windows\Explorer.EXE
C:\Windows\System32\nvraidservice.exe
C:\Program Files\Creative\Sound Blaster X-Fi\Volume Panel\VolPanlu.exe
C:\Program Files\Winamp\winampa.exe
C:\Windows\System32\rundll32.exe
C:\Program Files\Microsoft Xbox 360 Accessories\XBoxStat.exe
C:\Program Files\Zone Labs\ZoneAlarm\zlclient.exe
C:\Program Files\Alwil Software\Avast4\ashDisp.exe
C:\Windows\ehome\ehtray.exe
C:\Program Files\Windows Media Player\wmpnscfg.exe
C:\Windows\ehome\ehmsas.exe
C:\Windows\System32\CTxfispi.exe
C:\Windows\system3... Read more

A:browser runs fine then crashes

The log looks fine.

How much ram do you have?
 

Read other 3 answers
RELEVANCY SCORE 74.8

Beginning about a month go, my Vista 64 system has been experiencing random system instability. I fear that it has something to do with a fairly severe infection, as I have repeatedly cleaned with system with Securty Essentials and Malwarebytes.

Today, I installed the free trial of Malwarebytes' live scanning, and I have received continuous notifications that the program is blocking access to a potentially insecure website.

Attached are my DDS and HijackTHis! Log files. Thanks you for your help.

A:System Runs Fine, Then Crashes

Hello , And to the Bleeping Computer Malware Removal Forum. My name is Elise and I'll be glad to help you with your computer problems.I will be working on your malware issues, this may or may not solve other issues you may have with your machine.Please note that whatever repairs we make, are for fixing your computer problems only and by no means should be used on another computer.The cleaning process is not instant. Logs can take some time to research, so please be patient with me. I know that you need your computer working as quickly as possible, and I will work hard to help see that happen. Please reply using the Add/Reply button in the lower right hand corner of your screen. Do not start a new topic. The logs that you post should be pasted directly into the reply. Only attach them if requested or if they do not fit into the post.Unfortunately, if I do not hear back from you within 5 days, I will be forced to close your topic. If you still need help after I have closed your topic, send me or a moderator a personal message with the address of the thread or feel free to create a new one.You may want to keep the link to this topic in your favorites. Alternatively, you can click the button at the top bar of this topic and Track this Topic, where you can choose email notifications. The topics you are tracking are shown here.-----------------------------------------------------------If you have since resolved the original problem you were having, we would appreciate you... Read more

Read other 2 answers
RELEVANCY SCORE 73.2

My specs:

* Windows 7 x64 Ultimate
* Intel i5 760 @ 2.8GHz
* 8.00 GB RAM (2x4 Crucial Ballistix)
* GTX 470
* Gigabyte GA-P55A-UD3 Motherboard
* Samsung EVO SSD 250GB MZ-7TE250BW
* Antec EarthWatts EA650 650W

I've had this problem for a couple of days now, and here's what I've noticed:
1. When I run a full-screen game (CS:GO, LoL) the computer crashes after running for a couple of minutes, sometimes immediately.

2. When I try to move a large amount of files from my external storage drive to my internal storage drive (not my main SSD), the computer crashes after about a minute. I had the taskbar performance tab open during this, and the CPU is barely put under stress, while the RAM steadily increased little by little until it crashed (around the 1.8gb mark, I have 8gb total).

3. If I'm watching a 1080p stream on twitch, or watching a high quality video file located in my storage drive, it runs completely fine. But if I run multiple tabs of 1080p streams, it will probably crash.

4. It does not seem to be an overheating problem. My GPU rests at around 60 degrees Celsius, my CPU rests at around 40 degress Celcius. I had recently cleaned out my tower using compressed air.

5. Considering #2 (a process that requires little graphics power), it does not seem to be a GPU problem.

6. I ran the Intel CPU test, as well as MemTest86, and no errors were found.

7. My suspicions are that its a RAM problem, but perhaps the experts have a different idea on what migh... Read more

A:Solved: Computer runs fine, but crashes when it is put under a bit of stress. Help me

Did you overclock the cpu?

Also note that memtest needs to run overnight to find errors.
 

Read other 1 answers
RELEVANCY SCORE 73.2

My specs:

* Windows 7 x64 Ultimate
* Intel i5 760 @ 2.8GHz
* 8.00 GB RAM (2x4 Crucial Ballistix)
* GTX 470
* Gigabyte GA-P55A-UD3 Motherboard
* Samsung EVO SSD 250GB MZ-7TE250BW
* Antec EarthWatts EA650 650W

I've had this problem for a couple of days now, and here's what I've noticed:
1. When I run a full-screen game (CS:GO, LoL) the computer crashes after running for a couple of minutes, sometimes immediately.

2. When I try to move a large amount of files from my external storage drive to my internal storage drive (not my main SSD), the computer crashes after about a minute. I had the taskbar performance tab open during this, and the CPU is barely put under stress, while the RAM steadily increased little by little until it crashed (around the 1.8gb mark, I have 8gb total).

3. If I'm watching a 1080p stream on twitch, or watching a high quality video file located in my storage drive, it runs completely fine. But if I run multiple tabs of 1080p streams, it will probably crash.

4. It does not seem to be an overheating problem. My GPU rests at around 60 degrees Celsius, my CPU rests at around 40 degress Celcius. I had recently cleaned out my tower using compressed air.

5. Considering #2 (a process that requires little graphics power), it does not seem to be a GPU problem.

6. I ran the Intel CPU test, as well as MemTest86, and no errors were found.

7. My suspicions are that its a RAM problem, but perhaps the experts have a different idea on what migh... Read more

A:Solved: Computer runs fine, but crashes when it is put under a bit of stress. Help me

Read other 10 answers
RELEVANCY SCORE 68.4

hi evbody,
I frequently need to use cut copy function in microsoft excel.Is it possible to create a Macro in excel using VB so that i could avoid the repetitive tasks.
I need to copy data from my excel sheet into a software application?(live server)
Is there any ready macro available in excel or i need to write the VBA code for it
Rgds
Ojas Nafday
 

A:excel macro

Read other 7 answers
RELEVANCY SCORE 68.4

Hi,
I need some somewhat simple excel macro/scripting help.

Say I export a report from our database program into excel, basically, it is a 100+ page report with headings on each page. When we export to Excel, it shows the headings throughout. It is something like:

:BLANK SPACE:
:BLANK SPACE:
:BLANK SPACE:
Database: XYZ PAGE 2
USER ID: BLAH
:BLANK SPACE:
:BLANK SPACE:
:BLANK SPACE:

:Actual Data:

:BLANK SPACE:
:BLANK SPACE:
:BLANK SPACE:
Database: XYZ PAGE 3
USER ID: BLAH
:BLANK SPACE:
:BLANK SPACE:
:BLANK SPACE:

Etc.

What's an easy way to strip out that information so we have have concise spreadsheet? My guess, is: Search for the word "Database" and delete 4 lines above it and 5 lines below it.

Also,

When the report is exported to Excel, all the font formatting is stripped. So if we have lines like:

Office Supplies $300 (This is a total line, but doesn't state the word total)
Pens $100
Paper $200

Is there a way to search for a specific string, say I insert the word "total" to the certain lines, so it searches for that word "total" and it bolds entire land? Thanks for the help in advance, you guys rock!
 

A:More Excel/Macro help :)

Read other 16 answers
RELEVANCY SCORE 68.4

I don't know anything about visual basic, and have no programming experience, but am skilled with computers in general.

Would someone please help me with a Macro for Excel?

All I want is for it to send an email with an attachment (same email address, same attachment) every Monday-Saturday at 10:00 PM

Thanks!

(My email is [email protected])
 

A:Excel Macro Help

Read other 10 answers
RELEVANCY SCORE 68.4

I'm working on creating a macro in Excel to automate some of my daily tasks. For the most part, I was able to make a successful macro using only the record function. However, I ran into a snag when I tried to get the macro to record my Ctrl + F function. I don't have too much (read: any) experience working with either VBA or macros, so I was wondering if someone here could help me out. This is what I would like for the macro to do
1. Search for cells with the value "12345"
2. Highlight all of the cells with the value "12345"
3. Delete all of these cells, and shift the remaining cells up
Any help would be greatly appreciated!
 

A:Excel Macro Help

Hi and welcome to TSG

Here's a little macro for you:

Code:
Sub Delete_12345()
Dim Rng As Range, WS As Worksheet, DummyString As String

'this DummyString is just necessary, you will see why :)
DummyString = "gibhu, etho et&#337;zohketok&#337;u&#337;ou&#337;(=%/HN "

'modify the sheet and cell range as needed
Set WS = Sheets("Sheet1")
Set Rng = WS.Range("A1:J10")

'changing/comuflaging the empty cells by filling them with a dummy string
Rng.Replace what:="", replacement:=DummyString, lookat:=xlWhole

'clearing the cells we look for (change all "12345" values into empty string)
Rng.Replace what:="12345", replacement:="", lookat:=xlWhole

'deleting the new empty cells (note: they were 12345 values just a moment ago)
Rng.SpecialCells(xlCellTypeBlanks).Delete Shift:=xlShiftUp

'recreatig the original empty cells by replacing the dummy strings by empty strings
Rng.Replace what:=DummyString, replacement:="", lookat:=xlWhole
End Sub
I'm sorry for leaving out Step 2., but highlighting the cells with the value "12345" doesn't make much sense, if they are all to be deleted anyway...

Jimmy
 

Read other 1 answers
RELEVANCY SCORE 68.4

I am creating a report for work and have stumbled upon a snag. Each month, we track the number of sales that each rep has, their volumes, etc. My boss wants me to create what is basically a report card for each rep. Each month I must resort the master report based on the three month total of each sales rep (column U); therefore, the data is never in the same order month to month (ie For May, John Doe could be #1 for the team [U5], but in June, he could be ranked #3 [U7]). Short of having to copy and paste each individual entry into the report card form, is there a macro of some sort or something that could make my life a little easier?

Thanks,
 

A:Excel Macro (?) Help

Welcome to TSG.

Without knowing your data layout it's difficult to say much ... BUT it's unlikely you'll need a macro to get what you want. You can probably get away with some basic functions, e.g. MATCH and INDEX.

The attached file should give you some idea of what you can do.

HTH,
Andy
 

Read other 2 answers
RELEVANCY SCORE 68.4

_____ A_____ B______ C

1 ___ 888___ Apple___ Blank
2 __________Orange__ 888
4 __________Orange__ 888
5 __________Orange__ 888
6 ___999____Apple____Blank
7 __________Orange __999
8 __________Orange__ 999
9 __________Orange__ 999

Please advise how to write a macro or VB in excel using above table.
The given table data contant in A and B column. The result is in C column where it search in B column for "Apple" will be blank and "Orange" will be the value of A1 and A7.

I have try Vlookup and IF then statement but no luck. I can not get the value on the left of "Apple" to display in C column.

Please advise,
Thanks
 

A:Excel macro help

Read other 12 answers
RELEVANCY SCORE 68.4

I am trying to copy selected cells from a source worksheet into a seperate woksheet in the same workbook.

Each record in the source worksheet (named 'master') starts with a transaction number (column A), Bank name (Column B), Amount (C),Booking unit (D), confirmation date (E), and various different fields with the last field in column AF.

When I go to column A of a particular record (in my 'master' worksheet)and press ctrl+t (my shortcut to the macro) I want all the cells in that particular row, from column A to column AF to be copied into the other worksheet called 'slave'. I want this to be pasted starting from column BB row 2 in the slave worksheet.

When I go to another record in my master worksheet and press ctrl+t I want the same thing to happen, BUT NOW i want this pasted in the slave worksheet in coloumn BB row 3.

I want this to happen every time I select a record to be transfered.

I know this may be asking for a lot of help, but would really appreciate any kind of help on this as it is an urgent requirement for my work.

Thanks in advance
 

A:excel macro help

Read other 6 answers
RELEVANCY SCORE 68.4

Hi I have been tasked at work with setting up a Vehicle Service reminder spreadsheet for our 8 vehicles,

I would like it to send an email to certain addresses when vehicles reach a certain mileage,

I have the Licence Plates in Column A, Service Interval in Column B (12500, 20000 miles etc), Last Service Mileage in C, Next service mileage in D (last service + service interval), Next service mileage alert in E (NExt service mileage minus 2000 miles), and most recent Mileage in G.

I need a macro that sends an email when the value of G is equal to or greater then E, with the Licence plate in the subject dependant on which vehicle it is, and a short message saying it is nearly due a service,

I have managed to get an email sent, but am stuggling to get the criteria into VBA as i am a complete newbie.

Please help.
 

A:VBA/Macro Excel help please

Read other 7 answers
RELEVANCY SCORE 68.4

i would really appreciate your help!

I would need a macro that can do the thing described in the attached file. so basically its a search tool on sheet2 of a workbook that gives back a specific value of the table on sheet1. so for ex. i write in row 6 and column C and it returns me the content of cell C6. Its an abstract thing so the purpose would be illustrating and easy search without typing in functions or manually go through the tables., so as like a user interface...
is there such a thing or is there a better software for a quick illustration?
 

A:excel macro

I added a form and some code, try and see.

You will have to program some more if you wish other actions or extend the data

This will work even if you add rows or columns without having to change the code.

I use the tips form the following site: http://www.xlpert.com/partH.htm
It's the first one that poped up when I searched in Google.
I hope it helps you
 

Read other 2 answers
RELEVANCY SCORE 68.4

I have the following code on a sheet:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
If Target.Cells.Count > 1 Then Exit Sub
On Error GoTo EndMacro
If Not Target.HasFormula Then
Set rng = Target.Dependents
If Not Intersect(Range("A1"), rng) Is Nothing Then
If Range("A1").Value < 4800 Then XXX_Order
End If
End If
EndMacro:
End Sub

Which then spurs the following code:

Sub XXX_Order()
'Working in 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim sh As Worksheet
Dim cell As Range, FileCell As Range, rng As Range

With Application
.EnableEvents = False
.ScreenUpdating = False
End With

Set sh = Sheets("List_XXX")

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon

For Each cell In sh.Columns("B").Cells.SpecialCells(xlCellTypeConstants)

'Enter the file names in the C:Z column in each row
Set rng = sh.Cells(cell.Row, 1).Range("C1:Z1")

If cell.Value Like "?*@?*.?*" And _
Application.WorksheetFunction.CountA(rng) > 0 Then
Set OutMail = OutApp.CreateItem(0)

With OutMail
.To = cell.Value
.CC = ""
.Subject = "XXX Stock Replacement Order"
.Body = "Hi " & cell.Offset(0, -1).Value

For Each FileCell In rng.SpecialCells(xlCellTypeConstants)
If Trim(FileCell) <> "" Then
If Dir(FileCell.Value) <> "" Then
.Attachments.Add FileCell.Value
End If
End If
Next FileCell

.Send �... Read more

A:Excel macro help please...

Read other 10 answers
RELEVANCY SCORE 68.4

I have started recently to mess around with macros but I can't quite figure out how to do this one.

I have this list of songs with three columns (artist, title and track #) but what i want to do with it is to insert a row between each artist while dropping down the track #. But when the artist is the same i want to add these track numbers.
Attached is what i have and on sheet 2 is what I am trying to figure out if my explanation is not too clear.

Any help would be greatly appreciated
Thanks a lot.
T.
 

A:Excel Macro Help

Why not apply a Pivot Table?
I did it in your sample,
The total column is necessary or else it won't show anything but I think this is waht you want?
 

Read other 1 answers
RELEVANCY SCORE 68.4

Hi guys, i was wondering if you could help.

I simply cannot get my macro working,

I need the macro to take the value from a cell, e.g. "D9" and search for it in a data set which is in A5 to A9, once found it then needs to offset by two collums and enter a number 1 into the column.

I know this sounds simple, but i have given up hope

Please help

Thanks in advance

Jon3sey
 

A:Excel Macro help

Read other 6 answers
RELEVANCY SCORE 68.4

Hi,
I have been working on getting multiple files to open in excel and maybe even organise the data in the format i want. A number friends have helped and here is what I have:

Public Sub open_files()
Dim intIndex As Integer
Dim fsSearch As FileSearch
Dim fsoFile As FileSystemObject
Dim tsmContents As TextStream
Dim strPath As String
Dim wksSheet As Worksheet
Dim intCount As Integer
Dim fdDir As FileDialog

Application.ScreenUpdating = False
Application.DisplayAlerts = False
Set fdDir = Application.FileDialog(msoFileDialogFolderPicker)
fdDir.Show
fdDir.AllowMultiSelect = False
strPath = fdDir.SelectedItems(1)
Set fdDir = Nothing

Set fsoFile = New FileSystemObject
Set fsSearch = Application.FileSearch
fsSearch.LookIn = strPath
fsSearch.Filename = "*"
fsSearch.Execute
If fsSearch.FoundFiles.Count > 0 Then
For intIndex = 1 To fsSearch.FoundFiles.Count
intCount = 0
Set tsmContents = fsoFile.OpenTextFile(fsSearch.FoundFiles(intIndex))
Set wksSheet = ActiveWorkbook.Worksheets.Add
wksSheet.Name = fsoFile.GetFileName(fsSearch.FoundFiles(intIndex))
Do
Call Import_Contents(tsmContents.ReadLine, intCount)
intCount = intCount + 1
Loop Until tsmContents.AtEndOfStream
Next intIndex
End If

Set fsSearch = Nothing
Set wksSheet = Nothing
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub

The trouble is the code is not really working in my worksheet as I keep getting compile errors.

AS I described before, I want the... Read more

A:Help with Excel macro

What does the Compile error tell you?
 

Read other 3 answers
RELEVANCY SCORE 68.4

Hi,
Everyday, I get a file with a list of items and thier prices.How would i create a macro in EXCEL to automatically copy the same data to four regions. This can be anywhere in the sheet and the item and price need to be in the same columns.For example:
item# price
5555 10.00
6666 20.00
7777 30.00
8888 40.00

I would have to do the same with regions 1,2,3,and 4
item# region price
5555 1 10.00
6666 1 20.00
7777 1 30.00
8888 1 40.00
5555 2 10.00
6666 2 20.00
7777 2 30.00
8888 2 40.00
5555 3 10.00
6666 3 20.00
7777 3 30.00
8888 3 40.00
5555 4 10.00
6666 4 20.00
7777 4 30.00
8888 4 40.00
 

A:excel macro

Read other 6 answers
RELEVANCY SCORE 68.4

I have values entered in the C column that look like the following

'MAK, REP'

I need to find a way to make the values like the following:

'MAK','REP'

Any suggestions would be very much appreciated.
 

A:Excel Macro

Read other 14 answers
RELEVANCY SCORE 68.4

does anyone know a macro code line to move to the next row...for instance i am in a4 and i want it to move to a5 then a6

thanks
doug
 

A:excel macro

Read other 8 answers
RELEVANCY SCORE 68.4

hi.

I have an excel sheet with many rows and columns. the headings for the columns contain an expiry date, who the agreement is with (hyperlinked to a pdf), type of agreement, time until expiry and type (7 different types). I need a macro that will -
search each row and look for when 'time until expiry' = "less that 2 months" and 'type' = (one of the seven)
then send an email to a person whose email is in a different cell off to one side of the worksheet.

After it has done this, i need to run another macro which checks the same thing but with a different type (and email address)

Once all this is done, i need a macro to do all of the above but with "7 days" as the 'time until expiry'.

I also need a macro to run and search the rows for "unsigned" in the comments and again go through each type and send an email to the respective person.

Can this be done?!?!? It would be great if the macro could run automatically when the workbook is open.

Thanks so much in advance!!!
 

A:Excel macro

welcome to TSG, jenrowlands
while this is indeed a "do it yourself" problem, we have a forum much better suited to a business application problem....it's called "business applications

i'm moving your thread there.
 

Read other 3 answers
RELEVANCY SCORE 68.4

I bought a 50,000 name phone fax list from experian. The list came with the phone numbers in the format of: 9092248212.

Winfax, my fax program, does not work with that format and experian will not change it for me. I need to build a macro that will strip the first 3 numbers (the area code) and either put that in a separate column or change the format to: 909-224-8212 (preferably instruction to do both if that is not WAY too much to ask)....

I am getting kind of desperate! Any help given will be (GREATLY) appreciated. I have used Excel since it was invented but this kinda throws me....

Regards,
Jim K
[email protected]
 

A:Excel Macro Help

Read other 6 answers
RELEVANCY SCORE 68.4

Hey all,

just made an excel macro and when i run it the worksheet turns blue and the row/column headings turn black and nothing happens. Any suggestions?

thanks
shiva d
 

A:Excel macro

Read other 8 answers
RELEVANCY SCORE 68.4

Excel macro

A friend has a spread sheet he receives every week. He has to copy info from that sheet and past it into a new Excel sheet in a different order and then save the new sheet as a "prn" file.

He wants to create a macro (or two) that will do as much of the following as possible.

The following cells are always the same.

He wants to copy the following cells and then paste each cell area below the previously pasted cell area with one blank cell between each cell area.

The "pasted" info is then saved as a "prn" file.

Here's the cell info he's coping.

D7-F18
D21-F32
H7-J18
H21-J32
L7-N18
L21-N32

I can create a macro but this is out of my league.
Questions? Solutions?
 

A:Excel macro

Read other 7 answers