-
- Why does (VBA Excel) Solver becomes slower when executed in a for next loop more than 1000X?
by jenskkk
- 0 Replies
- Last post
by jenskkk
- Problem: Solving problems becomes slower the more often I call the SolverOK function in a VBA Excel 2002 code. I am using the solver add in my program and I was wondering if that will use up a lot of memory and I want to make sure that I release the memory properly. The solver is called several 1000 times in this routine and it could possibly produce a big mess if it does release the memory cor
-
- 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
-
- What is the VBA code to insert an Object into an Excel File
by amanda_m_wilson
- 8 Replies
- Last post
by amanda_m_wilson
- Hi,
I have recently been requested to create a button on an Excel spreadsheet that will insert an Object (usually a MS Word Document but not always) into the Spreadsheet as as Object. The user would need to browse for the document and select the file, then the file would attach and be displayed as an icon.
In short, the smae as using the Insert > Object >Create From File (Display a
-
- Excel VBA open/select text in Word?
by sdbenner
- 1 Replies
- Last post
by Peter Mo.
- I'm trying to use Excel VBA and open a word document and select a few fields of a table to paste into Excel. Is there a way to search for a certain string and copy the adjacent table fields in Word so I can assign them to a variable for pasting into Excel
-
- Read data from excel through VB.NET
by Prasanth.P.P
- 12 Replies
- Last post
by Srini111
- Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim
-
- Vba - Directories / Folder tree
by ajliaks
- 1 Replies
- Last post
by João Rodrigues
- Hi,
Is there any way to show a directory / folder tree
In order to move a file from "myFolder01" to "myFolder02" I need to let the user to select the folders myFolder01 and myFolder02.
Thanks in advance,
Aldo.
-
- Null Value Error in recordset
by Roborean
- 2 Replies
- Last post
by Roborean
- I have encountered a problem when returning a record set which contains a Null value. Please can any one help
I am trying to determine if a date field against a client is empty but if it is empty, when I try to get the value, I get an error message when it gets to dteDateCreated - "Invalid Use Of Null"
Dim SQLText As String Dim rs As Recordset Dim strClientCode Dim
-
- LCS 2005 SP1 Server-Side Contact Lists Not Populating within Communicator 2005
by KCrockett
- 1 Replies
- Last post
by MS ISV Buddy Team
- I am having trouble creating server-side contact lists for my employees using Communicator 2005. We have an LCS 2005 SP1 SE virtual test environment. All my users are LCS enabled (right-clicked on OU within AD to enable).
Background knowledge... Contacts.txt looks like... msRTCSIP-PrimaryUserAddress
sip:u ser1 @domain.local sip:u ser2 @domain.local sip:u ser3 @domain.local
ACESFile l
-
- run an exe file in excel using VB
by mambo5
- 5 Replies
- Last post
by mambo5
- Hi,
I want to run an exe file in excel using VB, any simple coding for that
Thanks.
-
- Some questions about WER
by Nikolai Bochkarev
- 5 Replies
- Last post
by Jason Hardester - MSFT
- Hi!
I'm integrated WER support in my Delphi 7 Application and now get some results
1) I'm register winqual account
2) Integrate WERAPI support in my application (Delphi program has own exception processing)
3) Map my .exe and upload xml file
procedure TForm1.ApplicationEvents1Exception(Sender: TObject;E: Exception);
var eventType : PWideChar; begin
if
-
- public variable between sheet code and userform
by class11
- 1 Replies
- Last post
by Andy Pope
- Hey,
I created a public variable in sheet code and assigned a value to it. Now I want to be able to call a userform from the sheet code and use the value I established in the Userform code.
Is there a way to do this
-
- Help Deploying VBA changes across hundreds of Word Temlates
by SiobhanO
- 1 Replies
- Last post
by Derek Smyth
- I have been asked to "clean up" existing Word templates that have VBA code in them. Basically what I need to do is to remove the old code that is currently in the ThisDocument class module of the template and replace it with the new code.
I've exported the "good" code to a .bas file and I have worked out how to import it back into the Word Template but the only problem I hav
-
- A question from a beginner...
by meisaka
- 6 Replies
- Last post
by meisaka
- Hi all:
I am new to the programming world, and I am interested in learning VBA. So, please provide some tips where should I start
Thanks in advance.
-
- About iexplorer 7 error.
by Gilga.
- 2 Replies
- Last post
by MS ISV Buddy Team
- "The instruction at 0x66869bc7 referenced memory at 0x00000050 . The memory could not be read."
I keep getting this message whenever I close the internet explorer 7.
Can anyone help me out on this matter
-
- Excel Pivot Table
by Vamsi025
- 0 Replies
- Last post
by Vamsi025
- Hi,
I am populating the Excel Pivot table from the sql OLAP cubes . I am having 2 items in the Data Field list and I dragged and droped those two in the pivot table and every thing is working fine .But the problem is when i am selecting two rows and asking to group by right clicking the Data field , It is grouping the rows but it is showing only one column insted of two and the 2nd column i
-
- VBA Word Can't find project or library
by Paulnz
- 5 Replies
- Last post
by Andy Pope
- I have wrote a VBA macro and in the macro I use visual basic functions such as "RTRIM$( )" and "STR$( )". When running the macro on a client's computer the error "Compile error Can't find project or library" comes up and it stops at the "Rtrim$( )" function.
What is missing on the client's computer.
Please help
Thanks
Paul Seo
-
- Excel: Public variable doesn't work
by My_Head_Hurts
- 2 Replies
- Last post
by My_Head_Hurts
- I have a routine that needs to sometimes display a form to get user input, then hand the result back to the caller. I use a Global variable to do this but the value is not returned. When I use Option Explicit, I get a run-time error, "Variable Not Defined" in the form. The code is like this: In the calling module...
Code Snippet
Public PsResult as String private sub Module
-
- Inserting Comments in Excel...from a Beginner
by sg549
- 5 Replies
- Last post
by Keithyboy1
- Hello everyone. I'm new to VBA programming, but I have done a little. I have a new project at work that I'm trying to accomplish via VBA, but I'm not sure how to get it done. Thanks in advance for your feedback.
My goal is to take data from a cell on Sheet2 of a workbook, and place that data in a comment field in the exact cell on Sheet1 in the same workbook (data in A10 on sheet 2 will be
-
- Time Addition
by MoPatel
- 1 Replies
- Last post
by sjoo
- Hi all,
I am facing such a horrible problem, i have tried everything and cannot find a way to solve it and it is now driving me insane. What i am trying to do is to calculate the amount of hours a member of staff has worked for the whole week, this is done through VBA on a userform and i just cannot do it. the main problem i am facing is how to add hour and minutes together to give me a val
-
- Excel/Word VBA IDE - Additional Controls Dialog Box refuses to display
by Herbert Schroder
- 0 Replies
- Last post
by Herbert Schroder
- I have a problem trying to add additional controls to the Controls toolbox The two methods I've tried
1. Right click on the controls toolbox , click Additional controls
2. Menu, Tools, Additional controls
Neither of the above produce a dialog box containing the list of additional controls to choose from.
Things I have tried so far....
Office Update, Reinstalling Office 2000, uninsta
-
- 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 import
by Rod Wing
- 3 Replies
- Last post
by Rod Wing
- I have a working Excel vba that imports about 50,000 cell values from a variety of different text files into numerous worksheets. The problem is it is painfully slow, taking over an hour to run.
The main time killer is populating each individual cell using the format: Worksheet.Cells(row,col).Value = strValue
Commenting out these lines of code the program runs in under a minute. I've
-
- Use of InStr() function
by une
- 3 Replies
- Last post
by Andy Pope
- Can you use InStr() to determine the position of the next character in a string that is not equal to one of a number of options. If so, how
For example, what would be the syntax of an expression that returned the position of the next character that was not either a "t", space, tab or return character Would you have to use ascii representations of some or all of these characters in th
-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- Importing excel spreadsheets over time into Access using a module in Access
by Nakli
- 1 Replies
- Last post
by Bruno Yu - MSFT
- Hi,
I am trying to create an access database that will allow to import excel spreadsheets at the click of the button on a switchboard.
I have been trying for hours to create a module in access that will import excel spreadsheets that contains a table with 12 columns and a different amount of rows for each spreadsheet.
I was able to create an almost complete macro in excel that