-
- Can't remember the purpose of these lines of code in my project?
by Scott Boyd
- 2 Replies
- Last post
by Scott Boyd
- Hi, I just can't remember what the following lines of code are here for! Please put me out of my misery...
Code Snippet
Private glb_count As Integer Public Property Get GlobalCount() As Variant GlobalCount = glb_count End Property
Public Property Let GlobalCount(ByVal vNewValue As Variant) glb_count = vNewValue End Property
-
- NEED URGENT HELP
by keilah
- 0 Replies
- Last post
by keilah
- Hi People
I am having trouble with a excel spreadsheet. I am pulling in live data from a MS Access database, that has two data sets of portfolio IDs.
In Col A the Portfolio Id are shown as individual (separated) in Col (say) G, the Same IDs are conbined (as shown below) for example:
ColA ColG
Barclays1 Barclays 1+2 (shown as)
Bar
-
- Converting a string to an Array
by DeathSurfer
- 2 Replies
- Last post
by DeathSurfer
- Duuuudes:
Is there an easy way in vba to convert a string to an array of integers. For example:
I have this particular array of numbers in the element <column_data_types> in a xml file:
<column_data_types> 1, 1, 1, 1, 1, 1, 1, 1, 1, 5, 5, 5, 1, 1, 1 </column_data_types>
I have a function that will grab the array of numbers but the function returns a string. ("1,
-
- where do I start??
by Eyalwu
- 2 Replies
- Last post
by Eyalwu
- Good evening.
Here is the thing.
I am using a Mass spectrometer, which exports data into excel worksheet. What I want to do now, is to process this data while it being exported into the worksheet, i.e: taking avrage value every (let's say) 5 values that being exported, or every once in a time interval, and save it somewhere else (a different worksheet for example).
Now, since I don't know
-
- Learning VBA.... where to begin??
by gregw74
- 4 Replies
- Last post
by NWAprog
- I have some very limited knowledge of VB, but I would like to learn VBA from the ground up, specifically with FrontPage. I just don't know where a good starting point is Do I learn VB and then build upon that by learning VBA, or dig right into VBA Do I learn VB.NET or VB in it's previous form Is VBA much different in Office 2007 than previously Any feedback would be greatly appreciated. Thank yo
-
- Live Communications Server 2005 SP1 Status Unknown
by Bennydojo
- 1 Replies
- Last post
by Heiken
- Hello,
I've been running LCS 2005 SP1 Federation/PIC for over a year now. Recently several users who Communicate with MSN contacts frequently are getting "Status Unknown" for any user@hotmail.com MSN user. This is isolated to about 3 persons, the only commonality is that their username is 9 characters or longer. (Ex. 123456789@domain.com )
I saw another post from a while ba
-
- How to Get Position of Scribble line's Points?
by Sstar
- 4 Replies
- Last post
by Sstar
- I have scribble line object in my Ms Word document.
Shape.Type = msoFreeform
Now I want to get position of the controls points and change it slightly. How can I get the controls points' position in the first place.
I noticed that
Shape.ShapeNodes.SetPosition ( index, x, y)
helped me to set position of each node. However, no ShapeNodes.GetPosition functio
-
- 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
-
- Run time error 1004
by Donald Wm. Johnson
- 11 Replies
- Last post
by Phillb
- I am attempting to delete a range of cells in an Excel spreadsheet using a Macro. The range is one row by 8 columns. However, when the line of VBA code actually doing the deletion is reached I get a "Run-time error '1004': Delete method of Range class failed."
The actual line causing the error is:
Selection.Delete Shift:=x1Up
where I have previously selected the ra
-
- Variable scoping in Excel VBA macros
by Wewake
- 3 Replies
- Last post
by Andy Pope
- Hi All,
I am developing an Excel VBA macro to retrieve the Inventory details from Mainframe sessions and writing the output in the same excel workbook as a last sheet.
I am getting problem in the rowCounter variable, the one I am using it to position the row in the output excel sheet. I am initializing the counter value to 2 because I have my header as my first row.
-
- Macro to Delete Rows
by GB Allan
- 6 Replies
- Last post
by GB Allan
- Hi, I am writing a macro that I want to do the following with:
1-Sort spreadsheet by column J.
2-Search for the first instance of the term "unbilled."
3-From that point and down, delete all rows below.
4-Delete specfic columns.
I'm having trouble with steps 2 and 3 - the search works, but for the deleting of the rows, it's picking a specific row range. I want it to del
-
- vlookup
by Namrata Prashar
- 14 Replies
- Last post
by Namrata Prashar
- Hello
can anyone help me with how to write the excel vlookup function in vba
the function in excel looks like this
VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE)
how can i get something similar working in a macro.
thanks
namrata
-
- How to check if a date exists
by HMote
- 10 Replies
- Last post
by HMote
- Could anyone point me in the right direction I just need a way to see if a date exists...example: "6/31/07" doesn't exist, whereas "6/30/07" does exist. Thanks!
-
- use inputbox to choose cells for plots in excel
by Jonas.S
- 12 Replies
- Last post
by Jon Peltier
- Hi all,
The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that
Grateful for ideas
usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64)
C
-
- 0x62304390 referenced memory
by MishraJitu
- 9 Replies
- Last post
by kingtiger_6
- Hi All,
I am facing this problem while closing internet explorer. I am really frustrated to this problem. Help me
Biswa
-
- Change Input Focus: bring Form to front:Stop Excel from flashing: HELP!
by J678
- 2 Replies
- Last post
by jameswmc
- My Macro doesn't bring my userform to the front because it has just transfered focus to Internet Explorer. Instead the Taskbar flashes repeatedly. the code is simple:
Set MyObject = CreateObject("internetexplorer.application") With MyObject
.Visible = False .Navigate MyLocation
Do While .ReadyState <> 4: Loop End With
Load UserForm1
UserForm1.Show
-
- ACCESS - You do not have exclusive access to the database
by agriff98
- 4 Replies
- Last post
by agriff98
- I have an ACCESS application that is running locally on a user's machine. When they log in, they get the error "You do not have exclusive access to the database", then they have to click "OK" 21 times before the application will open up for them. The .mdw file is named different from the .mdb file, so they aren't locking each other out.
Any ideas
-
- Add a customized Tab in Communicator 2005
by Gabriel M&#233;ndez
- 7 Replies
- Last post
by Ken Kosmowski
- Hi, i'm trying to add a new customized tab in Communicator 2005 to show an html page, i have a document titled "Planning and Deployment" which somehow explains how to do this... I tried to add a new entry on the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Communicator called "TabURL" and also under HKEY_CURRENT_USER\Software\Policies\Microsoft\Communicator wi
-
- How do I configure sharepoint data to point different directory?
by eac022403
- 3 Replies
- Last post
by MS ISV Buddy Team
- I have created 20 GB vhd and install my SharePoint on it. Everything I put as data will be written on that 20 GB vhd. But if I put all my data in shared folder, it will be filled out quickly and I will be out of space. Is there anyway to store the new data other than the vhd and still be shared For example for my shared folder, I want to put the data in another drive but I want them to be shared t
-
- How to check if contacts are already in outlook public folder and disregard
by RhysDavies
- 2 Replies
- Last post
by Cringing Dragon
- Hi i posted this code previously - it imports contacts from an accessquery into an exchange public folder for people to use - i import the unique contact ID from the access dbase into the job title field - i want to add code that will check the job title field against the ID in the query and if it is already there i do not want it to create a duplicate contact as it presently does, but i do want i
-
- Need help with XPath syntax
by DeathSurfer
- 2 Replies
- Last post
by Luiz Claudio - MVP
- Duuudes: Need help with XPath syntax. I'm new to XPath so bear with me. In the following statement, The way I understand XPath so far should recursively look in the xml file below for every <worksheet_name> element whos value is "Fabric Roll Data " then recursively look for the <first_column_header> element no matter how deep it is in the children of <worksheet_name> an
-
- Email data from Access to multiple persons
by DJRave
- 0 Replies
- Last post
by DJRave
- Hey there!
For my work I keep track of things in an Access database. I receive data, edit and regroup it and after that distribute it to other people. Every month I have to mail exported *.txt files to a group of people. And since not everybody gets the same data I need to select the files/emailaddresses manually. I want to automate this procedure to reduce the work and chances of errors.
-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- TypeOf ToggleButton is MsForms.Checkbox returns true !
by Sebastien TANIERE
- 4 Replies
- Last post
by Sebastien TANIERE
- Hello, I am experiencing a curious problem on VBA : ToggleButtons returns true on condition : TypeOf oControl Is MSForms.CheckBox It returns also true on condition : TypeOf oControl Is MSForms.ToggleButton
My problem is that this behavior is due to a recent version of VBA. This bug has appeared on an existing Word application after installing Outlook2003 which installed visual basic 6.3 Ap
-
- Different classes in one collection
by wlwlz
- 6 Replies
- Last post
by Cringing Dragon
- Hello Everyone,
I just recently started to learn VBA so there are quite a few things I'm having trouble with.
When I tried to put multiple classes in a collection and later use For Each <Class> to access them by each class, it would result in an error stating object type does not match.
Just wondering is there a way to implement what I'm trying to do here in VBA Namely,