-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- Does Winqual accept WER reports from Vista systems?
by Claus Brod
- 14 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
-
- ListView in VBA
by Cody Code
- 2 Replies
- Last post
by Cody Code
- Hallo I Just Have One Question in Regards to the Listview Control in VBA. I am trying to fill each column in my listview with data that is from a recordset. i.e rem lstviewItems in the listview control on the form Set list = Me.lstviewItems.Object With list .ListItems.Add , , rec("Desc") .ListItems.Add.SubItems(1) = rec("RetailCost") .ListItems.Add.SubItems(2) = txtQty.Value
-
- How to open "Properties" dialog box to "Custom" tab within macro?
by oryan_dunn
- 2 Replies
- Last post
by oryan_dunn
- I'm writing a macro that will, as part of its operation, update all fields within the document. I need all my custom fields filled out prior to running this macro. I'd like to be able to prompt the user to fill out the properties by providing a button that will open directly to the Custom tab of the file properties dialog box. How do I go about programming this
Thanks,
Ryan
-
- Code to save Office 2007 Word or Powerpoint as Office 2003
by jchau
- 1 Replies
- Last post
by Andy Pope
- How can I use vba to save Office 2007 Word or Powerpoint as Office 2003 counterparts
-
- Excel - VBA - Users having major problems
by suznal
- 11 Replies
- Last post
by Roosey
- I NEED HELP!
I have a workbook with a decent amount of VBA, and there are users who are experiencing severe difficulties with it. I have no problem on two of my machines with the file, but here is what others are experiencingˇ
They can open and access all of the controls and feature of the workbook ¨C the first time.
Once the save and close the file, they cannot re-open it!
They ge
-
- Cann't kill excel.exe with Access VBA coding
by mrtaktak
- 3 Replies
- Last post
by mrtaktak
- Hi I use the below coding to quit Excel application 2003, but Excel.exe is remain in the Task Manager. Can anybody give me an idea. Thanks!
objExcel.quit
Set objExcel = nothing
-
- Why is my Access database becoming HUGE!!!
by Agent Dagnamit
- 1 Replies
- Last post
by Shasur
- I'm running this code to allocate a random number to a field called [rnd100] to each row of a table containing around 350k rows.
Problem is, the code runs, but rapidly increases the size of the database to well over 1Gb (from under 100Mb).
What is going wrong
If I removed the row that allocates the random number, it runs fine. If I replace this with a line to simply update eac
-
- Compile rrror: syntax error
by gibger
- 5 Replies
- Last post
by gibger
- Hi,
When I run the following code:
Code Snippet
Private Sub btnClickMe_Click() Dim intrandom As Integer Dim index Dim person Dim match As Boolean Dim personx Dim persony Dim n Dim birthday() Dim counter match = False ReDim Preserve birthday(23) intrandom = (Rnd * 364) + 1
Randomize
counter = 0
For n = 1 To 100 For persony = 1 To 23 birthday(person) = in
-
- FindNext returns "Nothing" when doing iterative lookups, though data to find is in the cells
by damienm38
- 5 Replies
- Last post
by Andy Pope
- Hello,
I am implementing a lookup Method to find translation matches in XL tables.
For example, if I call the Method: Translate("world") in the following cells:
A | B
--------------------------------------------------------------------------
hello world | bonjour le monde
world | monde
-
- VBA Word Can't find project or library
by Paulnz
- 5 Replies
- Last post
by Andy Pope
- I have wrote a VBA macro and in the macro I use visual basic functions such as "RTRIM$( )" and "STR$( )". When running the macro on a client's computer the error "Compile error Can't find project or library" comes up and it stops at the "Rtrim$( )" function.
What is missing on the client's computer.
Please help
Thanks
Paul Seo
-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- VBA Excel short Macro Ending in 1st Open Cell
by Duane in Japan
- 3 Replies
- Last post
by AussieJames
- I recorded an actual Macro and it looks like this. Application.CommandBars("Web").Visible = False Range("A28").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Range("A29").Select ActiveWindow.SmallScroll Down:=3 What I actually have is thousands of rows populated, Three rows are visible with data in the top three rows of my active sheet, 26,
-
- vlookup
by Namrata Prashar
- 14 Replies
- Last post
by Namrata Prashar
- Hello
can anyone help me with how to write the excel vlookup function in vba
the function in excel looks like this
VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE)
how can i get something similar working in a macro.
thanks
namrata
-
- Excel Userform - Runs fine but other users get a compile error
by suznal
- 7 Replies
- Last post
by suznal
- I have a userform that is called from a keyboard shortcut. It works perfectly fine when I run it, but other users cannot run it on their machines. We all are using Excel 2003 SP3, (only one user has SP2) and all users have changed their security to allow macros. But when they try to load the form they get a compile error.
The code I have for the userform is...
Code Block
-
- Send Outlook message via VBA Macro in Excel
by Maplesoft
- 11 Replies
- Last post
by Sohail Ch.
- I have some macro code in an Excel workbook. It has been working fine for several years under various combinations of Excel 97, Excel 2000, Excel 2002(XP) and Excel 2003 along with Outlook 97, Outlook 2000, Outlook 2002(XP) and Outlook 2003. We have one new computer that has Office 2003 (SP2) that was recently setup and the macro generates the following error:
Run-time error '-2147024770(
-
- ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista
by Claus Brod
- 12 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where
-
- how can I set all the items' subtotal as False in pivot table?
by lyp_sj
- 4 Replies
- Last post
by lyp_sj
- Module per Plant
Category
Y03
Y04
Y05
Y06
Y07
Y08
Y09
Y10
Y11
Y12
CLV Export
Demand
1092
757
879
977
970
1176
1188
1200
1212
1224
CLV Export Total
1092
757
879
977
970
1176
1188
1200
1212
1224
CLV FN
Demand
11520
12710
11524
12392
14807
15554
15843
16
-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- Why the do while loop does not work?
by lyp_sj
- 6 Replies
- Last post
by lyp_sj
- Hello,
Below is my code, the lastrowGSVGrowthRate is 101, I expected result is to copy all the "AFFILIATE" items. While with my code, it only copied the first "AFFILIATE" item. I do not know where I did wrong. Thanks so much!
B.regards/Yaping
raffiliate = 1 rowaffiliate = 1
Do While raffiliate <= lastrowGSVGrowthRate If cells(raffiliate, 1
-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- VBA macro for Excel for extracting and 'depositing' text between brackets...
by Josh Ord-Hume
- 5 Replies
- Last post
by MyLady
- I am trying to create an Excel macro that will 'look' at the text contents of a given cell (say A1), copy any text that occurs within brackets, and then deposit this text into an adjacent cell (B1). For example, if A1 contained the following: "This is <just> a test", the word "just" would be extracted and deposited into B1. Ideally, I would like to be able to run such a m
-
- Command for insert picture
by cooldlkk
- 1 Replies
- Last post
by Andy Pope
- Hi , could someone pls advise the command for to insert picture to excel using vb command. Dim img as image how to mention location of file name , path directory . what if the file name and path...
pls advise
-
- Run-time error '13': Type Mismatch
by whateveritis
- 2 Replies
- Last post
by whateveritis
- i always get this error when i try to run...does anyone know what's the problem
Code Snippet
Option Explicit
Private Sub UserForm_Initialize() UpdateData cbxDept.AddItem "Marketing & Sales" cbxDept.AddItem "Supply Chain" cbxDept.AddItem "Purchasing" cbxDept.AddItem "Technical & Production" cbxDept.AddItem "R
-
- Sorting cells in a spreadsheet by colour
by Josh Ord-Hume
- 7 Replies
- Last post
by crainsworth
- My apologies if I am asking this question in completely the wrong forum. I am trying to create a VBA macro that will order data in an Excel spreadsheet according to colour (so that like colours are all grouped together). I wonder if somebody would be kind enough to spend some time explaining how to do this to a more or less complete VBA novice! Many thanks...
Josh Ord-Hume