-
- Undo is not available?
by AussieJames
- 2 Replies
- Last post
by AussieJames
- Hi -
I was wondering if anyone could tell me why the undo command "isn't available" in a form
I'm using it as part of the cancel function on a form. When the form is called from another form to enable the user to add a new record, it is pre-populated with some info from the first form. This of course creates a record in the table using the next autonumber in the sequence. if the u
-
- How to run *.vbs or *.bat in Excel VBS?
by CCpluses
- 3 Replies
- Last post
by MyLady
- Hi
I am new in programming, I'd like to ask a basic question.
How to run *.vbs or *.bat in Excel VBS
I tried the code but it didn't work
Sub Test()
Set ws = WScript.CreateObject("WScript.Shell") ws.Run ("Notepad")
End Sub
thanks~
-
- adding a non-adjacent cell to a named/defined range
by bilo_krewol
- 2 Replies
- Last post
by Andy Pope
- I have a set of data in a spreadsheet that I want to run a macro through that will:
1. test each cell against specified conditions;
2. depending on what conditions are met, add that cell to a specific, named range; and
3. run statistical analysis on the named ranges.
#1 and #3 I am OK on, but #2 - I have not been able to figure out how to resize the range to add a specific, non-adj
-
- Using VBA in Word to slect and print a particular Record (recipient)
by JBNV123
- 4 Replies
- Last post
by JBNV123
- Hi, I am trying to set up Word so that I can get information from Excel and input this data into a form letter. I am using Mail Merge and that part works great. But now I want to be able to search for a particular record (recipient) and print the document only for that record. I know you can search through the "find" button on the mail merge toolbar but I want to make this more user frie
-
- Access and Graph
by AmberMara
- 1 Replies
- Last post
by Andy Pope
- Is it possible to change the Markers than come ready to use in MS Graph . I need to print a chart using this markers: "<" and ">" instead of tiangle, * , - , _ , + etc. does any one can give me any kind of help in this matter .
-
- Macro print actice charts
by hysenlici
- 2 Replies
- Last post
by hysenlici
- I think it would be very simple to set up that macro, but I have no idea in this filed.
This is the problem:
My workbook contains 10 charts and 6 of them are UNHIDDEN. The rest is hidden.
My macro should print ONLY THE ACTIVE (open) CHARTS.
Thank you in advance
-
- VB Error when running Auto_Open macro in Excel
by VirgilC
- 1 Replies
- Last post
by Spidermans_DarkSide - MSP, VSI
- I have created a form and a button in Visual Studio that will call and open Excel. In addition it also run the macro Auto_Open (which resides in Excel) using the Run command (Run("Auto_Open"). The Auto_Open macro calls a form within Excel and allows the user to Exit Excel without going to the normal File->Exit menu in Excel. When I click on the Exit button on the Excel form it gives m
-
- Access 2003 + VBA
by YaelS
- 0 Replies
- Last post
by YaelS
- Hi, I am using code found here http://www.mvps.org/access/api/api0032.htm to allow users to drag and drop files into my Access 2003 application. users to drag and drop files from a variety of sources into the application. The only "Snag" to date is that it refuses to accept attachments dragged directly from Outlook email messages. I don't know how to get Data that drag-and-drop. with th
-
- how to fit charts to eachother in excel
by Jonas S.
- 4 Replies
- Last post
by Jonas S.
- Hi all,
I am creating charts inside VBA code and I wonder how I can make them be located directly under eachother.
The first plot is located with :
Charts.Add ActiveChart.Location = Worksheets("BUS").Range("D27")
But how do I type the location for the other charts that will be created so they get the location under eachother I want it to be controled
-
- VBA Powerpoint - managing events (simple question)
by Peter Caisse
- 1 Replies
- Last post
by Peter Caisse
- Hi, I just wanted to know if it's possible to know when a slide has been edited with VBA. I need to have more events, like firing an event when a textbox within a slide is edited. Thanks, Pete
-
- Cells
by LRFT
- 6 Replies
- Last post
by magicalclick
- I'm really confused as to why I activate a cell:
x = ActiveCell.Row
Yet when I try to select that cell:
Range (Cells(x, 1)).Select
It comes up with an address way out of whack! What am I doing wrong
-
- Problem with passing a Range as an argument to a function
by G. Nelson
- 1 Replies
- Last post
by Andy Pope
- I am putting together a small function to act as a simultaneous VLOOKUP and HLOOKUP, but when I try to pass the range as an argument, I get an error telling me that the range I'm passing is the wrong type .... this is my code Function ARRAY_LOOKUP(column_value As Variant, row_value As Variant, array_area As Range) As Variant For i = 1 To array_area.Width If array_area.Cells(1, i) = column
-
- Updating links in Powerpoint with VBA
by dh273
- 2 Replies
- Last post
by dh273
- I'm having problems with Powerpoint VBA. I have pasted blocks of cells from Excel into Powerpoint using Paste Special -> Paste Links-> Microsoft Excel Worksheet Object, and set the updating to manual. I'm trying to get some VBA code that will update all the links in my presentation. Essentually, the code that would do the same as me going to Edit-> Links, selecting all the links and click
-
- Sharepoint Web Parts for Subsites
by Peter O&#39;Brien
- 4 Replies
- Last post
by AlexArun
- This seems like a simple question but I've trawled the net and not found a simple answer. If I have a site on Sharepoint Server 2007 (Enterprise edition), and I create a few new subsites and workspaces, is there a web part that will show all subsites Or do I have to add individual links manually for each of the subsites to a list and then display the list through a webpart
-
- Is it possible to use a word macro to execute an .exe file?
by vincent90152900
- 2 Replies
- Last post
by vincent90152900
- Is it possible to use a word macro to execute an .exe file How to do that This is discussion is open to suggestions. Many thanks for your replying.
-
- finding index in an array
by Jonas.S
- 2 Replies
- Last post
by Jonas.S
- Hi all,
I want to find out which index in the array that corresponds to the maximum value in a array.
ff = Application.WorksheetFunction.Max(Hist)
finds the value to which I would like to find the index for.
Hist is an array containing several thousands of numbers. So I would like to avoid looping through the array to save time.
Any ideas out there
Grateful for help
\Jonas
-
- Can WER File Mapping ignore application version numbers?
by Chris Peterson &#40;Pe
- 2 Replies
- Last post
by Henrik Hoyer
- My team has just integrated WER into our application. It is working correctly and we have found (and fixed) some surprising crashes! We're very happy about that. :-D Our only problem/complaint is updating the WER File Mapping. Is there any way to tell WER File Mapping to automatically collect crash info for a given .exe filename, regardless of the file's version and linkdate We have daily builds
-
- Returning a custom object from a custom collection
by MikeBos
- 3 Replies
- Last post
by Dick Donny
- Hello,
Am new to VBA object orientated stuff and have hit an early hurdle.
I've created a collection of boat objects with an array of boats and an integer counter. Storing the boats isn't a problem however when I try to retrieve the boats I'm getting Object variable with block '91' not set issues. For e.g.
In Main I'm calling
Dim Boats as New BoatCollection
...Code t
-
- Trying to extract data from one sheet and list it in another...
by Scott Boyd
- 2 Replies
- Last post
by Scott Boyd
- Hi, i have a sheet with lots of employee data on it including the manager name. I want to loop through each employee and make a list of the managers and display this in sheet 2. I only want each manager to be displayed once no matter how many times he occurs. Here is what i have so far - probably very messy but its the best i can come up with!
Code Snippet
Option Explicit
Sub manag
-
- Need urgent help
by envi_ria
- 1 Replies
- Last post
by Andy Pope
- Can i protect and unprotect an excel file in VBA.
I need urgent help in this can any one help me out. I have to open some excel files copy all the names of the excel file from that folder and then a copy a corresponding coloum name also in the new excel sheet. But these files will be protected. i will have to open and the file unprotect it copy a data from a pertucular lable name and then lock
-
- Beginner needs help resonling an error message
by Helen Obomanu
- 2 Replies
- Last post
by Andy Pope
- I am trying to create a simple spreadsheet in excel that can perform a macro that allows me to insert a new row on the existing worksheet and have it formatted with the borders of the cells darkened so that it looks like the rest of the spreadsheet. I recorded the macro, but I recieved an error message that looks like the following:
"Run time error 1004: Unable to set the line style proper
-
- Are these valid bucket ids ?
by DHON
- 14 Replies
- Last post
by Claus Brod
- Hi Jason, Saar,
The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day.
Could you please, confirm whether these are all valid bucket id If not then reason.
Thanks,
DHON
-
- Compact and Repair in Access 2007
by BreezyC
- 1 Replies
- Last post
by Cringing Dragon
- Good afternoon all, I found a difference from 2003 to 2007 version of Access and I am hoping that someone can help. In 2007, the compact and repair functionality renames the compacted database with a new name. The processes that my team users are automated and we want the user to do a compact and repair on exit of the application. I can't find anything online about this, but is there a way to code
-
- Edit the Recordset
by Tantani
- 5 Replies
- Last post
by Tantani
- Hellooo, I use Access VBA 2003 with DAO. Does anyone know how can I move to the first record of an Quantity attribute in order to change or Edit it like this: Quantity 0.50 1.40 0.70 ..... Goto first field (0.50), if it is lower than 1, then change it to 0 Goto second field ( 1.40), if it is lower than 1, then change it to 0, otherwise change it to 1. Thank you in advance!
-
- Protecting formulas in cells
by chrstdvd
- 6 Replies
- Last post
by js06
- Hello,
Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten
Thanks Chrstdvd