-
- Looping the Find Function using VBA
by maverick_abhi
- 1 Replies
- Last post
by Andy Pope
- Hello, I am in a tricky situation. I have two sheets. I want look for each cell in a range of cells in Sheet1(The no of cells may vary each time) in Sheet2. The cells are spread across in Sheet2 and may be followed by comments, "/" and etc. So using Vlookup is ruled out. So am trying to use the find function. If the cell is found in sheet2 I want to be able to probably change the backgro
-
- ADO Parameters inside of MS Access
by wwu-dave
- 1 Replies
- Last post
by Ben McBen
- Hello,
I'm looking for help with parameters using ADO inside of MS Access.
Can anybody see what I'm doing wrong below
(This results in an error that says the object or with variable for .commandtext is not set)
Code Snippet
dim strsql_section_append as string
strsql_section_append = _ "INSERT INTO ... " & _ "SELECT ... " &
-
- VBA macros for Excel
by Josh Ord-Hume
- 1 Replies
- Last post
by Spidermans_DarkSide - MSP, VSI
- 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
-
- when to call Uniscribe api??
by VNAHATA
- 2 Replies
- Last post
by VNAHATA
- Hi, While reading GDI commands from an emf file,when should we be calling Uniscribe functions.Is it for every ExtTextOut command or just when we see the ETO_GLYPH_INDEX set in ExtTextOut.Is ETO_GLYPH_INDEX the only indication that the text'll contain complex scripts or with other options too,we may require to call Uniscribe Itemize function Please help. Regards, Vinay
-
- Closing a Non - Active workbook
by Joe Dawson
- 3 Replies
- Last post
by Joe Dawson
- Howdy, Does anyone know if there is a way to close a workbook that is not the active workbook Currently I activate the workbook I want to close and then use the following code to close it. However, I figure that if there is a way to close a workbook without activating it, that would be marginally faster. ActiveWorkbook.Close False ' closes the active workbook without saving any changes Any idear
-
- Difficulty using the Findrecord Method
by JBNV123
- 5 Replies
- Last post
by JBNV123
- Hi, for some reason if I use the code following (changed for my spefic data of course) I do not get the desired record to display, in fact I get only the record I am currently viewing to display, ie it is as though nothing is happening. This code is supposed to search for the record with "Joe" in the "FirstName" field and display it and also store the record number of interest
-
- Running a macro when Access 2003 exits
by kiloez
- 0 Replies
- Last post
by kiloez
- When opening an Access DB I know I can use a macro named AutoExec to run any code that needs to run before the DB opens. However, I can't find any info on a macro I can used to run code when the DB exits. I've seen that some folks are using hidden forms to get the job done, but I'd rather use a macro. Any help
-
- Calling a function from a DLL
by Douglas Penna
- 6 Replies
- Last post
by Mezhick
- Hello there,
I wrote a DLL in C++, and I'm trying to use it in Excel. When calling the the function, I used the code, at the begginning of the module:
Option Explicit Public Declare Function preco _ Lib "OpcAmericanaDll.dll" _ (ByVal Spot As Double, ByVal strike As Double, ByVal Ks_fixados As Double, ByVal t_dos_strikes As Double, ByVal t_final As Double, ByVal t_inicial As
-
- usb to serial port software for windows vista home premium have the cable but the disk is for older versions of windows xp & 98
by jimborox
- 0 Replies
- Last post
by jimborox
-
- 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
-
- .mdmp files not being created
by David Ching
- 14 Replies
- Last post
by JPSA
- Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
-
- Network Printing from EXCEL VBA - HELP
by Mr Catton
- 1 Replies
- Last post
by ADG
- This will probably be a no brainer for an experienced VBA Programmer.
I can't seem to find out how to print to a shared network printer.
I use the Visual Basic Editor in Excel 2003, and assign my macros to custom buttons.
Heres the method I use to print.
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
(What I want to do is have the print go to a shared
-
- Validation with List drop down?
by Scott Boyd
- 8 Replies
- Last post
by Handyman_994
- Hi
I want to add some simple validation to my Excel sheet but can not for the life of me remember how to do it! Basically i have a drop down list as in the image below and want so that when 'No' is selected, the user is forced to enter the reason in the next cell
http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_list.jpg
I can remember doing this before and used some VBA code but c
-
- Debugging
by une
- 2 Replies
- Last post
by une
- I can watch the execution flow of code in VBA under MS Word 2002 using the F8 key. How do I take a step backwards I want to watch a small section of execution flow again without starting from the beginning.
-
- Live Communication Server 2005 SP1 - Specified backend for the pool is current in use
by Jensan_Ahsay
- 7 Replies
- Last post
by Peter Gu
- Hi,
I have installed the Live Communcation Server 2005 SP1 on my x64 computer with Windows Server 2003 R2 SP2. I found that i have given the wrong name for the DNS, and therefore i am trying to re-install it. However, when doing the step "Create/Upgrade Existing Pool", it gives the error "[0xC3EC78BA] Specified backend for the pool is current in use". The error is unders
-
- *** How can I add module code to a specific module? *** NEED HELP !!!!
by sydney2000
- 4 Replies
- Last post
by NWAprog
- Hi,
I am currently working on an Excel Workbook where I have added a brand new code module called "Calculations2007".
This module (*.bas) file contains several new functions. I have been searching on the web on how to deploy this
new module in my workbook to a group of production workbooks. Basically I need this new code to get to production.
I have gotten to a point wher
-
- How do you remov highlight from a list box
by Quarry
- 0 Replies
- Last post
by Quarry
- Hi, I will keep this simple - In Access I have a form, which has a list box on it. The problem is that when I open the form the list box displays with black highlighting - how do I remove this
-
- ComboBox: VBCode to select first item in the list.
by highNNdry
- 3 Replies
- Last post
by DMan1
- Hi
I have the following VB code, when someone selects the worksheet name from the combo box in the summary page it takes them to the worksheet. However, the problem is that if they select, for example, worksheet "B" it takes them to the worksheet fine but when they are back in the summary worksheet the "B" is still selected in the combo box and you can not select "B&qu
-
- Creating a Pivot Table using Macro's
by Hamptons Kid
- 9 Replies
- Last post
by ssoper
- I am trying to create a macro that will enable me to generate a pivot table from a set of data that will be exported from our management system in .csv format. The data set is variable in size depending on montly activity. How can I get the macro to recogize that I want it to use all of the data on the sheet. When I use "record" to create the macro it uses absolutes to define the range (
-
- Excel Time Help
by MoPatel
- 6 Replies
- Last post
by MoPatel
- Hi all,
This is my first time posting here , hope i will be able to find the answer i am looking for. I'm very new to vba so please bear with me.
Here goes, this is the problem i'm having at the moment with my formulas and vba.
I am currently desinging a roster for my workplace and the problem i am having is to work out the night shifts. these night shift start at 23:00:00 and end at 06:0
-
- Excel 2007 and ADO connection PROBLEM for writing
by Nathalie_fr
- 0 Replies
- Last post
by Nathalie_fr
- Hi everybody,
First of all I'm sorry for my bad "english"...
I have a problem with Excel 2007 and ADO. I have made a small application in excel 2003 VBA and I'try to modify it for Excel 2007 but...it doesn't work. With my procedure, a value is written in cells J1 of my excel file base.xlsx. The value is always written in the first line but normally, it would be in cells J20 !!!
-
- Auto fill on a form in Access
by ACayouette
- 2 Replies
- Last post
by RhysDavies
- I am done wracking my brain on this one, so if anyone has an answer I would be most grateful!
I am trying to format a form in Access where users could check off a box and have an address auto-filled in the fields that follow. Conversely, if the box is unchecked, users can type the correct address into the fields that follow. This would be similar to the "checkout" function on some
-
- Can I run a Sub in an Access Module from a button in Excel?
by ADG
- 3 Replies
- Last post
by Mohamed Shifaz
- Hi all,
Can someone remind me if I can execute a subroutine in an Access module from Excel, and how.
I have a button in Excel which is doing some work with the database, before updating an existing stored query in the spreadsheet. But, I have a need to do further complex processing which is already in a subroutine in the database. I don't want the user in the database as it is a fron
-
- how to use variable to automate selection of a worksheet
by sree
- 6 Replies
- Last post
by sree
- Hi all!!!!!!
Thank you in advance for helping me with this.
I need to know how can i use a variable in VBA to read data in a cell which should be the worksheet name of one of diffrent worksheets in a diffrent workbook.
To simplify- i have two workbooks [Book1.xls and Book2.xls]
i need to run a macro to read A3 in sheet 1 of Book1 and store it in a variable A.
-
- How is Growth calculated in WER?
by Joel Stein
- 2 Replies
- Last post
by Joel Stein
- I'd like to know how "growth" is calculated by the hotlist functionality on the WER website..."growth" in relation to what over what time period
thanks,
-j.