-
- VBA 6.3 String
by roman rus
- 1 Replies
- Last post
by Andy Pope
- Hi,
My question is how do i access individual characters of a string in VBA 6.3
is there something like myString[0]
thx
-
- IsError function from VBA6.3 to v6.0
by SuzukiBandit
- 8 Replies
- Last post
by SuzukiBandit
- Hi All, I'm having problems with a small VBA script that I wrote in v6.3 but need to implement in 6.0. Excel 2002 -> 2000.
The following code works fine in the later version:
For i = 2 To LastRow ' select the next row based on loop vString = "A" & i If IsError(Application.VLookup(Range(vString).Value, vRange, 31, False)) Then Y = "NEW" Else
-
- 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
-
- VBA macro to replace
by sree
- 5 Replies
- Last post
by sree
- Hi
I have two worksheets in a workbook,
In sheet 1, i have columns Sector level 2 and 3, for some enterprises
In Sheet 2, i have columns sector level 1, for the same enterprises,
I wish to create a macro, which would look for corresponding enterprises which is the only common element in both sheets and then it should replace corresponding sector level 2 with sector level 1
-
- Locking clickable labels
by une
- 1 Replies
- Last post
by Andy Pope
- Can you lock a label like you can a toggleButton I have some code as follows; If toggleButton1.value = True Then togglebutton2.locked = True Else togglebutton2.locked = False End If But I also want to temporarily lock some clickable labels, but there is no ".locked" function for labels. How do I stop a label's click action from being allowable under certain circumstances Thanks.
-
- Error 1004 with Excel 2007 (on VISTA) on Publish method
by LaurentB
- 0 Replies
- Last post
by LaurentB
- Hi, I'm trying to publish a Range in an html file from excel 2007 (OS is VISTA) and I receive an error 1004 on the Publish method. Here is the code I'm using :
Code Block
' temp file name Dim TempFile As String TempFile = Environ$("temp") & "\" & Format(Now, "dd-mm-yy h-mm-ss") & ".htm" ' delete any PublishObjects left
-
- how to get the VALUE of an OUTLINENUMBER (word / macro in VB)
by XiXCal
- 1 Replies
- Last post
by Riquel Dong ¨C MSFT
- Hi,
I am currently working on a VB macro which has to get references in Word documents in order to make a traceability matrix.
My problem comes from a document, in which the references are Outlinenumbers in a column containing this outlinenumber list. I have to get the value of the cells of this column, but these outlinenumbers (auto-incremented numbers) are neither strings nor numbers..
-
- HELP FIX THE CODE..........
by keilah
- 1 Replies
- Last post
by Peter Mo.
- I have somehow managed to put some code together to complete a task that i have found some difficulty with.
Match and delete a row from table. Need some help fixing the code..........
ArrNames = Array("creation1", "creation2", "creation3", "Creation4", "creation5", "creation6", "creation7", "creation8", &
-
- Problems with VB solver code
by Stacy B
- 1 Replies
- Last post
by Jon Peltier
- I am writing visual basic code behind an excel spreasheet and am having difficulty making it work. It involves using the solver function. The code is listed below:
Sub signif_control_pop()
Dim cntlpc Dim pop
'Clear any previous solver settings. SOLVERReset
'Prompt user for population size. pop = Application.InputBox(Prompt:="Population Total:", Type:=1) Range(&qu
-
- New to Visual Basic
by darnold
- 5 Replies
- Last post
by darnold
- Im trying to do the following:
I created some command buttons that has the number 1, 2, 3, 4 on it, like a keypad or a calculator. When I press the button I want it to give a value (variable) of 1, 2, 3, 4, etc. At the same time if I press 1 and 4 on the keypad, Id like it to indicate 14 or 9 and 8 I would get 98.
What I'm trying to do is:
Button 1 = 10 * (number pad syst
-
- Information required : WOW64
by VikasAgr
- 2 Replies
- Last post
by Greg Taylor
- What is WOW64 How it helps to run 32-bit applications on 64-bit processor Where could I get it
-
- MSDN Installation
by uxair
- 0 Replies
- Last post
by uxair
- I've MSDN installed on my system, since i've installed it through MSDN setup (not by VS setup) Visual Studio does not recognize its presence(Ctrl+F1 doesn't work.), Is there a way I could tell visual studio about the presence of MSDN. By the way this behaviour is common in both VS 2003 as well as VS2005
-
- 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
-
- add group to printer ACL
by fkbr
- 0 Replies
- Last post
by fkbr
- Hello,
I have a print server with 200 shared printers. I need to add a group to each printer ACL with an appropriate rights (same for all printers). Is anyway to script it
Thank you
Ali
-
- VBA XML and encoding
by Vsfa
- 0 Replies
- Last post
by Vsfa
- Hello,
Here is my issue. In an excel sheet, I fill in several cells which contain text.
This text can be either in english / french / spanish / italien / german, which means I can have characters like "e" or "e" etc...
In a vba macro I'm trying to put all these data into an XML, this XML is then processed later on by an ASP.net app I have created (using an xm
-
- Increase prompt in message box
by une
- 3 Replies
- Last post
by Jon Peltier
- I have a userform that contains a command button that when clicked displays a message box. This message box contains help notes for the user. However I can't quite fit all the text in. When displayed, the message box cuts off the last couple of sentences. I think this is because my help text is the prompt in the message box and it is too long (> 1024 characters). How can I get a few extra sente
-
- Configuration Failed
by NaveenPN
- 2 Replies
- Last post
by Mica
- Configuration Failed
One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure: Failed to initialize SharePoint Products and Technologies upgrade. An exception of type System.Collections.Generic.KeyNotFoundException was thrown.Addi
-
- Communicator Mobile 2005 and TLS (Using port 4443 possible?) More options
by markm75c
- 1 Replies
- Last post
by markm75c
- Confused on something with CM and CWA:
We have web access enabled/installed, it uses MTLS and certificates on port 4443 to access the site...
I'm assuming when using Communicator Mobile on Windows Mobile 2005, I specify TLS to connect remotely to the server (no vpn)..
Is there a way to specify port 4443 or is the TLS port 443 even with Web Access installed on port 4443 (IE: these are diff
-
- VBA in Excel - organizing charts as objects in a sheet
by jk2880
- 1 Replies
- Last post
by bi-lya
- I am using a macro to create multiple charts from data on a separate sheet in the Excel file. However, the program places each new chart on top of the previous one in the sheet I select. I would like to place these charts apart on the sheet so that they are viewable. 1) Is there an command to order the charts down and across the sheet 2) Alternatively, can I select and move each sheet without us
-
- AutoExec will not execute properly
by Jürgen1234
- 4 Replies
- Last post
by Jurgen1234
- Hello there
I have an .dot file in the Word 2003 start-folder. When opening word, the file is read. The autoexec-macro should make a new entry with a number of commands and subcommands in the standard menubar. On about 300 PC's this works fine. On a few ones only part of the commands appear. All PC's run W2000 and Office 2003.
Any idea
regards
Jurgen
-
- Determine if and where the .NET Framework is installed using VBA
by TU71
- 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
-
- Pivot Table Macro
by GB Allan
- 3 Replies
- Last post
by GB Allan
- Hi,
I have set up a small macro to create a pivot table from a spreadsheet:
Sub CreatePivot() ' ' CreatePivot Macro ' Macro recorded 3/14/2007 by Gary
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _ "Data!R1C1:R656C90").CreatePivotTable TableDestination:="", TableName:= _ "PivotTable1", DefaultVersion:=xlPivotTableVersion10
-
- how can I count # of columns between two specific columns?
by lyp_sj
- 3 Replies
- Last post
by lyp_sj
- Hello,
How can I count # of columns between two specific columns such like, how many columns between column A and column D
Thanks so much!
B.regards/Yaping
-
- Why the do while loop does not work?
by lyp_sj
- 6 Replies
- Last post
by lyp_sj
- Hello,
Below is my code, the lastrowGSVGrowthRate is 101, I expected result is to copy all the "AFFILIATE" items. While with my code, it only copied the first "AFFILIATE" item. I do not know where I did wrong. Thanks so much!
B.regards/Yaping
raffiliate = 1 rowaffiliate = 1
Do While raffiliate <= lastrowGSVGrowthRate If cells(raffiliate, 1
-
- VBA and automated word generation
by Bindhia
- 2 Replies
- Last post
by Bruno Yu - MSFT
- Hi there,
I am currently working on a VBA application.
There is an automated word generation available in the appliacation that serves the reporting process.
If there is any Flash add-in being installed in the user's machine (can be viewed through Tools->Templates and Add-ins in MS Word) ,the applicaiton crashes down when the user tries to generate the report because the flash add-in r