-
- never ending loop
by JS
- 0 Replies
- Last post
by JS
- I have fixed it so don't waste any time on this.
Hi,
I have a code that is supposed to loop through all open workbooks to perform some action. But for some reason my for each loop never ends. Anyone out there who sees what I have missed The code is like below,
ThisWorkbbok:
Option Explicit
Dim AppClass As New EventClass
Private Sub Workbook_Open()
Set App
-
- Microsoft Access 2465 Application Defined Error - Form control code reference/Compile issue.
by Jamie Clayton
- 1 Replies
- Last post
by Jamie Clayton
- G'day,
One of the problems we have faced recently with an Access application that our company has written and supported for the last 11 years (Access 2 originally and now in Acccess 2003 ) is global variables and the VBA compiler. We had some significant development, debugging issues with global variables going out of scope. So in a crude solution to this problem we have move them all to fo
-
- Microsoft Word application fails to close quickly.
by CDO-user
- 0 Replies
- Last post
by CDO-user
- Hi,
I have a VBA application that opens a document in read-only mode and prints the document. The following Code Snippet is a sample, which we compile to .EXE and run on a DOS prompt. After sending the document to the Printer, it closes the document using:
wDoc.Close wdDoNotSaveChanges.
Our observation is that Microsoft Word has finished printing in about 5-10 seconds, but the
-
- 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
-
- HELP! Please solve this problem...
by alexthian
- 1 Replies
- Last post
by Shasur
- I already make an exe of my VB6 project. My project contains 'user-password' form, 'key-in data' forms and data reports. I only copy the exe file and access file to test the program (exe) in other pc, i run the program and i get this error message: run-time error '713'. class not registered. looking for object with CLSID:{00000010-0000-0010-8000-00A006D2EA4}. So how to make this message 'disapp
-
- Determine if and where the .NET Framework is installed using VBA
by
- 6 Replies
- Last post
by vtortola
- I have an Excel spreadsheet that needs to determine if the .NET Framework is installed as well as the path to that install. How can this be acomplished in VBA code
-
- Move cursor to the end of cell for data entry
by potain
- 4 Replies
- Last post
by potain
- Hi I would greatly appreciate your help please. I use an Excel spreadsheet to keep a record of conversations for telemarketing. I have a formula : =TEXT(NOW(),"ddd dd mmm yy h:mm ") in B1 which reflects the current date & time. I run a simple macro which fills the date value into the active cell : ActiveCell.Value = Range("B1").Value & " - " to record the dat
-
- Database Development Checklist
by ram121
- 0 Replies
- Last post
by ram121
- Is anyone aware of an Access database development checklist that would assist in developing a database, making sure that integrity, scalability, optimization, and security are considered
-
- How do I call for all installed printers....
by MyLady
- 5 Replies
- Last post
by magicalclick
- Hey,
How do I, with vba code, call for all installed printers in my computer and then display them in a ListBox
Best Regards
Cathrine
-
- Run-time error 3085 - Undefined function 'Nz' in expression.
by Adam Watkins
- 1 Replies
- Last post
by Adamus Turner
- I'm sure I'm not doing this the best way, but I get this error and need to find a workaround.
I'm building a large Access database with many queries that calculate metrics on several levels of our company - the total for the company, the division level, and the retail location. All of these calculations are then done for each week of data available.
In the course of these calculation
-
- Application-defined or object-defined error
by Joe Marlow
- 3 Replies
- Last post
by Luiz Cláudio - MVP
- Hello All, I'm receiving the error message in subject in the following code: Public Sub Err(ErrorID As Long , _ Optional AddInfo As String = "", _ Optional Source As String = "", _ Optional Log As Boolean = True ) If Log = True Then Me.Log MsgTypeError, ErrorID, AddInfo, Source MsgBox Me.GetErrorDescription(ErrorID), vbCritical + vbOKOnly , "
-
- How do I open CSV using Excel without deleting leading zeros?
by magicalclick
- 8 Replies
- Last post
by OmegaMan
- Hello,
Whenever I open up a CSV file or a Text file, Excel treats string like 05710 as a number and turn it into 5710. How do I open up a CSV file and still keep the leading zeros
Thank you very much.
-
- Replication of PivotTable Fields.
by Muralidhar M S
- 1 Replies
- Last post
by ADG
- Hi,
I have multiple Pivottables connected to OLAP data. All the pivot tables are in the same worksheet. All of them have Time as the only page level field. When this page field of the first pivot table is changed, i want to change all the other pivot tables so that the Time page field for all the other pivot tables is set the same as the Time page field for the first pi
-
- Format text in MsgBox
by une
- 5 Replies
- Last post
by une
- How do I format text that is presented in message boxes. I have looked for what I know as escape characters, but like a lot of things maybe MS calls these something else. I want to for example add newlines and tabs. Changing font would be handy also, as would the ability to add images. If you can help on the fonts and images fine, but at the moment I really need to be able to add newlines and tabs
-
- How to configure CER with no dialog?
by John Brown
- 14 Replies
- Last post
by Claus Brod
- I just tried to configure my XP SP2 workstation to send crash reports to a CER file share such that no dialog box would be presented. It didn't work as expected. ReportFault returned frrvErrNoDW and no crash report showed up in the file share. I have the 'Configure Error Reporting' policy enabled and a corporate file path entered. This works fine when I elect to 'send report' through the dialog bo
-
- Installing VBA6.0 on XP
by scottmac
- 7 Replies
- Last post
by Bob Shaw
- Good morning and hello. Ages ago I received a SDK 6.1 containing the latest release of VBA 6.0. I happily and without problem installed this on my laptop running Windows ME and all was well. I have since updated my laptop to one running Windows XP Home and when I went to install the SDK I was confronted with an error stating that "....You first must install Microsoft Visua
-
- Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional
by vab
- 13 Replies
- Last post
by N_Horden
- This problem has been mentioned by many other users (in a different thread subject), so I wanted to start a new thread. I have tried many suggestions, but none have worked for me.
My MODI has been a print option for me until just recently. It disappeared from my printers folder. I have repaired, removed, and re-installed Microsoft Office. The MODI will still not appear in the printers folder.
-
- How much delay to get an answer for Microsoft Office Marketplace?
by Joannes Vermorel - MSP
- 2 Replies
- Last post
by MS ISV Buddy Team
- I have submitted several weeks ago this application (sales forecasting for MS Office Accounting) http://www.lokad.com/docs/MicrosoftOfficeAccountingSalesForecasting.aspx To the Microsoft Office Marketplace at http://office.microsoft.com/marketplace I think I have followed very rigorously all the MS submission guidelines. During submission process, MS says that a answer for the submission will be
-
- Obtain Unique Work Units via SQL
by AlDeb
- 14 Replies
- Last post
by AlDeb
- Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals.
I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I
have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits.
In the example below on on
-
- Subtract a date
by F&#225
- 6 Replies
- Last post
by Fábio Nobre
- Hi, I'm creating a aplication whith Visual Basic and I need to subtract dates, now I'm using a simple method: Subtract a Month: ---------------------
If optmes.Value = True Then
(DateValue(Now) - 30) & " " & TimeValue(Now) Subtract a Year: ---------------------
If optano.Value = True Then
(DateValue(Now) - 365) & " " & TimeValue(Now) But this met
-
- calling sub within function. works fine as sub, but not in function
by pacificwaters
- 11 Replies
- Last post
by pacificwaters
- Using VB 6.3.
Trying to call a sub within a function, and when I call it in Excel via User-Defined-Function, it doesn't work.
But when I do 'F8' to step into the code of the sub, it works fine: Public function functionEXE(...) call cellref end function
Sub cellref() ' If I 'F8' and step into the code from here, it works fine. But when I execute the functionEXE on sheet.x
-
- How can I show the formula result in my cells?
by lyp_sj
- 2 Replies
- Last post
by lyp_sj
- I assigned a formula to Range(D2 10), but I cann't see the formula result in the spreadsheet, what I can do is only show the result by using msgbox. So how can I show my formula result in the spreadsheet Thanks so much!
Private Sub CommandButton1_Click() Worksheets("MMS_RSP_Tonnes").Range("D2 10").FormulaR1C1 = "=MMS_RSP_GSV!R[0]C[0]*1000/GSVperTonne!R[0]C[0]&qu
-
- Problems displaying VBA Help
by twaltz
- 2 Replies
- Last post
by twaltz
- Within all of my Office products (Excel, Access) and VB6, the HELP within VBA is not displaying properly (graphics do not display and I am seeing boxes with a red X) and I am continually getting Internet Explorer Script Errors. I think that I first noticed this occuring just after I installed VB 2005 Express.
Has anyone else noticed this problem And more importantly can anyone tell me how to co
-
- Microsoft Platform Test for ISV Solutions
by Eli Gazit
- 2 Replies
- Last post
by EliGazit
- Hi.
My company is getting ready for the "Microsoft Platform Test for ISV Solutions".
Can I find more detailed directions and resources to set the designated application for the test
i.e. to pass "managed code" tests- I know that the application is free from 'DllImport', but I'm not sure that:
This is enough.
One of the components I'm using works with unm
-
- help extracting sharepoint document paths using VBA
by ExcelPro
- 3 Replies
- Last post
by AndyHill
- writing an excel application that needs to connect to a sharepoint server & look for other excel books with a certain string in the name. Matching books will then be opened, and data will be copied into the application. I've figured out how to open a workbook from sharepoint & extract data from it, however, I can't figure out how to read through the directory & look for files that ma