-
- Is Office2003 still does not support passing command line arguments to VBA?
by Aleksey Nagoga.
- 2 Replies
- Last post
by Aleksey Nagoga.
- Hi All,
Back in the Office 97 days I tried passing command line arguments to VBA code within a doc file and it didn't work. In the end I found a workaround that was a bit of a hassle to implement but did what I needed.
Today, I found myself in a need of accomplishing a similar task in the Office 2003, plus the solution must also work in the Office 2007.
I was wondering if MSFT finally a
-
- Sort rows within a range
by NewToVba
- 6 Replies
- Last post
by Andy Pope
- Hi
My problem is the following.
I have a (100rows x 10columns) range to which some numerical output is written. I need to access each row in this range and sort it descending. Any suggestions Any help is much appreciated. Thanks.
Thomas
-
- Automate the Excel Camera Tool
by jrc1378
- 2 Replies
- Last post
by jrc1378
- I'm dashboarding with Excel and have everything finished except for programmatic placement of camera objects. Here's the gist:
My dashboard selects an image to copy with the camera tool based on the results of various lookup and choose functions applied to data pulled from an ODBC query embedded in a worksheet. The Camera object is placed on a display worksheet so that the dashboard is noth
-
- Licensing the NTFS sepcifcation
by Ben Parks
- 0 Replies
- Last post
by Ben Parks
- Hi,
We're writing an embedded application that reads and writes data to removable media via USB. I have successfully implemented a FAT driver for our arhcitecture and now we would like to support NTFS.
We understand that the specification for NTFS is privatly held within MS. So I'm wondering how to start the process of licensing the specification. Where do we start Who is the best pe
-
- SpeedUp a Macro in Excel - Disable Functions
by PYA_Ferro
- 8 Replies
- Last post
by PYA_Ferro
- Hi all, In my macro I used this sentences to speed it up:
Application.ScreenUpdating = False Application.EnableEvents = False
But I've also created some functions and they are beeing recalculated every time my macro do a change in a worksheet.
Is there any way to disable the calculation of functions
Thanks and really sorry for my English.
-
- Ex 2002 VBA, Activate First Available Cell in "A"
by Duane in Japan
- 3 Replies
- Last post
by Duane in Japan
- I need to please know how to call the first unused cell in Column A, activate it and put it at the top of my view area. If I have 7,369 rows of data populated, tomorrow it will be even more, each day I would like to do some work in VBA, which I know how to do, without referencing specific cells. Once complete I need to put my cursor (highlight) in the next unused "A" cell and put it in t
-
- Using VB in MS Access
by elitts
- 2 Replies
- Last post
by Toblerone
- Ok, I have no knowledge of VB. I am attempting to co-opt a bit of someone elses database. I am using 2 combo boxs in a form header to search for a specific record using 2 different fields. If the record exists than the fields in the detail section of the form are filled in. If it isn't located then nothing happens. One of the two fields is a key field with a numberic autonumber. This search works
-
- Why is it so ?
by DHON
- 3 Replies
- Last post
by Jason Hardester - MSFT
- Hi,
I uploaded a product map file recently, and one of the exe was having version 7.31.0.0
But, when I go to the Product Rollup page, I can see an event for that exe having
version 7.20.0.0 .
As I understand, mapping process considers the version of that file also.
Can anybody explain why 7.20.0.0 is listed instead of 7.31.0.0. In other
words how come version 7.20.0.0 event
-
- vlookup
by eds000
- 2 Replies
- Last post
by Peter Mo.
- I am using vlookup and I want to obtain the value in column B for the second occurance of the lookup value This code comes up with error
DestCity = WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0) _ And WorksheetFunction.VLookup(" Line#1 CITY ", Range("CPARSdata"), 2, 0)
If I use the first part before the "And" it wi
-
- Error when adding axModi to Windows Form.
by Genaro Sanchez
- 1 Replies
- Last post
by dineshkrishna108
- I added the COM Component for MODI (V.12.0) Using Office 2007 version and Visual Studio 2005
When i try to add the control to the form. I get an error: "Failed to import the ActiveX control. Please ensure it is properly registered."
How can I add this control Is there a patch for this problem
Also I try with MODI (v.11.0) Office 2003 and VS2005, and the same problem.
T
-
- Blue Star Infotech Offering on SharePoint for ISV and End User Organization
by Siddharthatripathi
- 0 Replies
- Last post
by Siddharthatripathi
- Hi All,
As a quick introduction I represent Blue Star Infotech, part of Blue star limited a $300 Mil group. We are based in USA & Europe. We are Microsoft Gold Certified Partner.
I wanted to discuss and offers our expertise in building products around SharePoint to ISV community. My Company can help ISV's using SharePoint Build products on SharePoint technology faster and more effici
-
- Autoexecuting macros
by rodcon
- 1 Replies
- Last post
by MyLady
- How do you make a macro run as soon as the Excel file it is attached to is opened The version is Excel 2000. I have searched the help files and some forums already.
Does anyone have any advice
-
- Making an array in Excel with the file names of a particular folder
by Bartyb
- 5 Replies
- Last post
by Peter Mo.
- Hello, could anyone help me, I already have a macro in Excel that uses an array of filenames to process data, but so far I have to enter the filenames manually.
Basically, I want the macro to simply create an array in Excel with the files names and their extension (which will always be the same) located in a particular folder, sucha as:
Filename1.ext
Filename2.ext
...
Filename13
-
- error message when closing ie7
by syjon
- 3 Replies
- Last post
by metalmarvin
- The computer administrator profile is not having this problem only the other users on my home computer.
Upon closing the browser this pops up:
iexplore.exe Application error The exception unknown software exception (0x0eedfade) occured in the application at location 0x7c812a5b
We have ie7.
Can someone help
-
- Newbee - Insert previous cross-ref from the dialog box
by FerrellRamey
- 0 Replies
- Last post
by FerrellRamey
- I would like to have a template that users can work on, and then later go through and select a paragraph or a word to be designated as a cross-reference.
I would then like to create a macro that would pop open the cross-reference dialog box (type set to "numbered items", and type set to "paragraph text" as defaults), and have the items list already highlighted so the us
-
- Need Help on how to use library file (Win32 API)
by SenSoft
- 1 Replies
- Last post
by João Rodrigues
- Hi All, Can any one help me on how to use Library files in Excel VBA. I have pasted here some sample. If possible which website can i refer to know about more about this. How to declare and use the constants Private Declare Function WNetAddConnection Lib "mpr.dll" Alias "WNetAddConnectionA" (ByVal lpszNetPath As String, ByVal lpszPassword As String, ByVal lpszLocalName As Stri
-
- Easy msgbox Query
by jaxgev
- 8 Replies
- Last post
by Andy Pope
- Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi
-
- Cannot read Office 2007 DVD
by KRFournier
- 4 Replies
- Last post
by KRFournier
- Has anyone experienced the problem of not being able to read the Office 2007 Enterprise installation DVD in a DVD R/RW drive. So far, three drives I've tested cannot read the disc. No error message. Nothing. The drive spins a little, but never sees it. I cannot access the drive through Explorer either. I've even updated the firmware. My drive's are all Lite-On drives, so I don't know if that has a
-
- 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
-
- Word: How to you determine the current cursor position
by KatKen
- 2 Replies
- Last post
by KatKen
- For one of my macros to run, I have to ensure that the cursor position is not in a table or in a frame when the user activates the macro.
How can I find our the current cursor position Once I can determine that the cursor is positioned in a table or a frame, I can then code a message box to instruct the user where to put their cursor to run a certain routine.
-
- duplicating VBA objects
by gilad_gy
- 2 Replies
- Last post
by gilad_gy
- Hi all,
on a form, i've got 10 textbox in a row. lets say that i've got x rows. the user need x+1 rows. how do i add the last row thanks.
-
- Copying and Deleting the duplicate records in an excel sheet and Copying the same Deleted records into another sheet
by bharat baradia
- 4 Replies
- Last post
by magicalclick
- hi,
i want to delete the duplicate rows in the excel sheet and copy the same deleted records into another excel sheet by using Macro's . This should be possible even when i am selecting two columns for checking duplicates and even if one of the column is repeated ( is duplicate) it should be considered as a duplicate.
-
- Using C# Events over COm-Interop in VBA
by DavidLiebeherr
- 1 Replies
- Last post
by nobel_1101
- Hi, i am trying to write a DLL with Code writen in .NET / C# that can be acces in VBA Applications via COM-Interop. Everything seems to work so far, but: I have an Event in my C# Class that i want to acces in the VBA code: --- Public Class VBATest { public event EventHandler OnLogin; public void Test() { ... if (this.OnLogin != null) { this.OnLogin(this, EventArgs.Empty)
-
- Excel VBA - Best way to SQL Insert if SQL Update fails
by HMote
- 3 Replies
- Last post
by ADG
- What would be the best way to do this Try/Catch
I was trying to check all the records to find the date/hour key but I thought there might be a better/quicker way to check if the record exists...or rather, if the update fails. Would this work Is there a better way to do this or is my thinking wrong Is there a way to check if an update fails...would it throw an exception
Thanks for
-
- Using DCount function in a Report group footer
by LizF@RMIT
- 6 Replies
- Last post
by Cringing Dragon
- Hi,
I'm having trouble getting a DCount function to work on an MSAccess 2003 report.
I'm using a text box in a group footer - I want it to show a count of the number of distinct records in the group.
Here's what I'm using - which produces the result of '#Error' with no further help.:
=DCount("Task ID","Tasks","TaskID IN (SELECT DISTINCT TaskID FROM