-
- macro for automatically creating data labels in excel chart
by Erik Houtriet
- 8 Replies
- Last post
by hysenlici
- Hi all,
I'd like to write a macro in for excel to create automatically a chart, i have no experience in this field.
I use the following code:
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8-6-2006 by CTW ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R2C
-
- Visual Studio Installation Problem
by Ron Hall
- 2 Replies
- Last post
by MS ISV Buddy Team
- I got my new ISV software bundle just in time to load it on my new computer. Office went on without a hitch, but when I tried to load Visual Studio I had a problem.
I am running Vista Ultimate.
The DVD has a Disk 1, Disk 2 and Setup Directories. I tried running the setup from the setup directory. It gets started and asks for Disk 1 to be inserted and doesn't allow any navigational ai
-
- How to rename worksheet without installed Excel?
by Perry Choy
- 5 Replies
- Last post
by Andy Pope
- I want to rename worksheet but haven't installed Excel
-
- MODI Port
by riph
- 4 Replies
- Last post
by semsem2005
- I have some questions:
1.- How to distribute MODI Port with my application
2.- Found MSM (module merge)
3.- How to install "Microsoft Document Imaging Writer Port", without CD office
4.- That files use the MODI
5.- The files .MDI is better of PDF !
Tks a lot,
-
- Enable and Disable text boxes on a sub-form
by ADG
- 1 Replies
- Last post
by ADG
- Hi
I am trying to enable and disable textbox controls on a subform when a field on my parent form changes. It appears that the subform textboxes are not visible to VBA when I am trying to write the code. Can anyone give me an example of enabling and disabling controls on a subform
Regards
ADG
-
- Linked Tables
by entrylevel26
- 1 Replies
- Last post
by entrylevel26
- I want to write a vba script to change all the links in the linked tables in an mdb file to link sql server database.
Also, if you think of a better way to do this than writing a vba script, tell me.
If you know how to do this using the upsize wizard (which mean using the same data that in the mdb files) , I will be interested to hear too. I think this is similar to the question here
htt
-
- VBA - Accessing files in a folder
by raja.rkannan
- 3 Replies
- Last post
by raja.rkannan
- Evening Ppl,
I am working on a Excel VBA assignment which involves accessing a directory which has around 2500 files and displaying the filename, date created & date modified based on a search criteria.
To be more clear, i have well formed file names in that folder and the last 4 characters in the file name are DDMM (date and month)
TEST0806.csv
TEST0803.csv
TEST
-
- Auto code indent tidying
by une
- 3 Replies
- Last post
by une
- I have finished a large program and the indentation is a little messy and is too aligned vertically, its a big rectangular block. Is there tool on VBA under MSWord 2002 that will automatically indent all statements nicely in a chunk of code For example, nested loops will be progressively indented and then "outdented" so vertical alignment of related statements is attained and the nesting
-
- Getting Access Data into Excel
by TwoHoot
- 1 Replies
- Last post
by TwoHoot
- I need to get a large number of Access 2000 Recordsets into Excel 2000 for evaluation. I have no problem setting up the connection and getting the entire table into Excel for testing by modifying the examples at
http://support.microsoft.com/kb/247412/EN-US/
using either the QueryTable or ADO code outlined there.
The tables I need to access have over 200,000 records so ge
-
- Associated Toolbar Button with Add-In
by PSandekian
- 1 Replies
- Last post
by Cringing Dragon
- I have created an Excel 2000 VBA project that I need to distribute to others. I would like it to have a toolbar button linked to it. I was thinking an Add-In would be an easy way to go for distribution. I can get it to work with a shortcut key but the button doesn't appear on the toolbar when the Add-In is selected. Does anyone know how I can do this The code is specific to Office 2000 Excel.
-
- Searching down a column?
by Blinocac
- 1 Replies
- Last post
by Shasur
- I have created an inventory spreadsheet, and want to be able to search down a particular column to match up part numbers. Once I have found the correct cell, I want to edit the value of the corresponding cell in the next column. I'd really like to find a good tutorial for using VBA in Excel, but barring that, a push in the right direction for this code would be handy.
-
- Display a TextBox or Non-modal Message Box
by sg549
- 6 Replies
- Last post
by Andy Pope
- Hi all. What I'm trying to do is put up a user form with a text box while a process is running. I don't need a progress bar, as the process is not that long. I have created a userform that includes a textbox, but only the userform comes up when I ".show" it. Why won't the text box portion of the userform show
Alternatively, is it possible to put up a "non-modal" system
-
- 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
-
- 1004 Runtime error/Password Protected
by NWPaco
- 1 Replies
- Last post
by ke wenzel
- Sorry - I'm relatively new to this but here's the situation.
I have a macro that works without the sheet being password protected, but once I protect the sheet, it does not work.
Any ideas on how to fix this The highlighted area is what seems to be causing the problem.
Range("A9:U10").Select Selection.Copy ActiveWindow.ScrollColumn = 10 ActiveWindow.ScrollCol
-
- sending emails from MS Word with variable subject line
by gve2002
- 9 Replies
- Last post
by Andy_F
- Hi,
I've searched these forums but have not been able to find exactly what I need.
I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code ( .Subject = "New subject" )
What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in
-
- extract pivot table data
by NICOBASE
- 1 Replies
- Last post
by Swade
- Hello, I have a pivot table in Excel and I want to extract the data in it. I need the source tables, the tables that where used to create the pivot table. Help
-
- Vlookup in VBA
by crainsworth
- 3 Replies
- Last post
by mnptl
- Hey eveyone,
I'm have a lot of difficulty using a vlookup in a macro I'm creating. If anyone could help it would be greatly appreciated.
Here is the code:
'**********************************************************************
Sub proScoreCard1()
Dim rng As Range Dim tradeDate As Date Dim confirmDate As Date Dim t1mDate As Date Set rng = Range(
-
- Problem passing a range as argument
by Douglas Penna
- 3 Replies
- Last post
by Douglas Penna
- Hello there,
I'm developing a macro do do some calculations on a worksheet, but I always get a problem when I pass a Range as an argument to my function.
My code is simple, and here it is:
Sub Main() Dim Range_do_Comeco As Range Set Range_do_Comeco = Worksheets("Plan1").Range("AD2") MyFunc(Range_do_Comeco ) End Sub
Sub MyFunc(ByR
-
- Order by in select statement not working
by RhysDavies
- 5 Replies
- Last post
by RhysDavies
- Hi there - i have a select statement that runs on form load that allows selection of appropriate company names from a combo box based on if the user is the owner of a company, which works great, syntax is below;
Me.companyname.RowSource = "SELECT [companyname] FROM [qryactivity] WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'"
However i want to sort them alphabetically by
-
- DoCmd.OpenReport for report based on a query
by starspike
- 2 Replies
- Last post
by starspike
- I've used the DoCmd.OPenReport with the WHERE-clause for some time now. My reports where all based upon a table in my database. But now I have a report that's not based on a table but on a query. The problem is that my report opens, but it just doens't seem to hold my WHERE-clause in account. For example: I have two (linked) tables: Locations (two fields: LocationID & LocationName) Transaction
-
- Macro To Delete Spreadsheet Columns if no data in column
by GB Allan
- 8 Replies
- Last post
by AussieJames
- Hi,
I need a routine that will go across and delete any columns in a spreadsheet that don't contain any data. The spreadsheet will always be from columns A:BB. There are column headings on row 1 going across.
Thanks for your help - I very much appreciate this forum. It has helped me out greatly!
Gary
-
- SaveAs
by jwp3
- 0 Replies
- Last post
by jwp3
- Hi, I can't resolve problem how to save spreadsheet in any format: xls or xlsx. I use office2007, but some of people in my office still use excel2003. They must decide in which format save excel.
I wrote: Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet ... and ... xlApp.Dialogs(Excel.XlBuiltInDialog.xlDialogSaveAs).Show("xxx")
all is ok, d
-
- Is there a way to abort during runtime
by ke wenzel
- 5 Replies
- Last post
by JoAnNaT
- Hi, If I am running a VBA program in MS Access 2003 that has a programming error such as an infinite loop, is there a way to abort the program without killing Access from the task manager (and losing any unsaved changes) KW
-
- error 1004 - unable to get insert property of the pictures class
by suznal
- 2 Replies
- Last post
by suznal
- I have some code that works behind a command button to insert a selected image file into a cell on a worksheet. If the user clicks the 'Cancel' button on the 'getfilenamesaveas' window an error message displays...
"Error 1004 - Unable to get Insert Propeerty of the Pictures Class"
Am I missing something in the code (see below)
Private Sub CommandButton1_Click() Range("A
-
- Changing the color of cells in a worksheet using VBA
by brt1980
- 3 Replies
- Last post
by MyLady
- I need some help with some code to select cells in a worksheet that have a certain color, and change only those cells to a different color. The key problem I'm having is that I don't want it to matter which cells I've colored, I would like the code to select any such colored cells and change the color. I'm not a programmer, so I don't really know how to write the code.
As an example, if I