-
- Problems with using global array in XL 2003
by kiloez
- 1 Replies
- Last post
by Jon Peltier
- Hello, I am trying to declare a global array in an Excel 2003 module using the following code at the top of the module:
Option Explicit
Public strWrkShtName(6) As String
strWrkShtName(0) = "Val1" strWrkShtName(1) = "Val2" strWrkShtName(2) = "Val3" strWrkShtName(3) = "Val4" strWrkShtName(4) = "Val5" strWrkShtName(5) = "Va
-
- Message for display during macro execution
by une
- 3 Replies
- Last post
by une
- I have a macro that takes a long time to execute. While it is running I would like to put an object on screen to inform the user that the macro is running and they should just wait. Otherwise they may think something is wrong. It would also be good if this object had a button on it the user could click to end the macro if they run out of patience. I thought about a message box, but when it is disp
-
- Help please
by jovert
- 3 Replies
- Last post
by envi_ria
- can i control any application or software using only VB program or how can i control any application using VB
for example, i want to control the internet explorer then by using vb i can direct the website i want to go or write the address without manipulating,only the vb program to be used!
Thanks a lot for the help!
-
- 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
-
- 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
-
- Searching / Hilighting OCR text in Office Document and Imaging
by wajhi
- 14 Replies
- Last post
by Prathap
- Hi,
I have been given following Tasks using MS Document Imaging 11.0 API
Read TIF perform OCR on it
Show it in AxMODI.AxMiDocView
Searching / highlighting text in AxMODI.AxMiDocView using MODI.MiDocSearch class in TIFF file and Highlight search result i
-
- Dialogs(wdDialogsFileSaveA) changes default documents path in Word 2007
by Reuven Pardes
- 4 Replies
- Last post
by Reuven Pardes
- The default Documents Path may be defined manually or programatically by options.DefaultFilePath.
If you save a document using Dialogs(wdDialogFileSaveAs) - the default path is changed into the same path as the saved document ( i assume that this is a bug ).
This bug may be bypassed by : options.defaultfilepath(wdDocumentsPath)=anypath , but may I expect that MS will fix the bug.
reuven
-
- MS Access permissions error when creating Table in VBA
by kbondar
- 0 Replies
- Last post
by kbondar
- HI, I have Access DB and I am trying to create temp_table in Access DB using VBA, and I got the following error: "You do not have the necessary permissions to use the 'Temp_table' object. Have your system administrator or the person who created this object establish the appropriate permissions for you." I have full permission to DB, I was trying to change security level in Access, but it
-
- Getting data from other workbooks
by Jeff DigiTech
- 4 Replies
- Last post
by Jeff DigiTech
- I have a master Excel file named (master.xls) and other slave files called ( slave1.xls, slave2.xls, slave3.xls ....salve5.xls and so on. ) master's structure is exactly the same as other of other salves where they all contain a number in cell A1 master will first select the slaves. And master wants to calculate the sum of A1(s) in slaves and have the result put in B1 of master.xls getting A1(s) f
-
- Macro stops running after a certain time, excel limitation???
by blackmamba
- 6 Replies
- Last post
by envi_ria
- Hey guys i have this problem: I have to run a macro for Excel that calculates some values for the entire 2006 year. To do that it has to open 365 daily files check for some circuits and calculate a sum. It opens a file does some checking, writes some values then closes it, opens the next one and so on. For a smaller number of circuits it worked fine and took about 10 minutes. Second time it opened
-
- Format text in MsgBox
by une
- 5 Replies
- Last post
by une
- How do I format text that is presented in message boxes. I have looked for what I know as escape characters, but like a lot of things maybe MS calls these something else. I want to for example add newlines and tabs. Changing font would be handy also, as would the ability to add images. If you can help on the fonts and images fine, but at the moment I really need to be able to add newlines and tabs
-
- Projects, objects & modules
by une
- 14 Replies
- Last post
by une
- I
started learning VBA in MS Word yesterday. I have some programming
experience in C++ and Java. I am trying to understand how the
environment is structured and what Projects, Objects and Modules
represent.
For example I recorded a few macros using the macro recorder and
then opened the VB Editor to see what was created. I notice that under
"Project" are 3
folders. One is named
-
- How do i reference a cell in an unopened workbook?
by Derek at Potters Clay
- 2 Replies
- Last post
by Andy Pope
- I want to get information from a network drive that i have access to and all users will have access to. Would it be something like workbooks("c:/folder/workbookname").worksheets("Sheet1").range("a5") Also, is there a way to shorten things a bit so that I only have to declare the location once then use a variable to reference it after that
-
- Date Trigger
by Arthur Barnes
- 1 Replies
- Last post
by Jayaram Krishnaswamy
- I have developed an application which records data each month, at the end of the month I want to append that months records into a master table automatically. As the database may not be running exactly on the end of month date, how can I it up to ensure that it carries out this action.
Regards
Arthur
-
- Selecting a row in Access DB table, copy it into new table
by Tantani
- 0 Replies
- Last post
by Tantani
- Dear Guys,
I would like to write a code in VBA to select a row in Access DB table (with its data) and copy (put it) that into new table. If the method can read and write the data row-by-row, then is also fine.
If you have any idea, please post it. Your help is greatly appreciated,
Thank you in advance,
Tantani
-
- 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
-
- Winzip A Spreadsheet, Then Send Via Email
by cdun2
- 3 Replies
- Last post
by cdun2
- Hello, I'm a non_VBA coder who has been asked to update the following Function:
**************************
Function EMAILER_REV_BY_ACCTCODE_MACRO()
On Error GoTo RA_EMAILER_Err
DoCmd.SetWarnings False DoCmd.SelectObject acForm, "SalesAssoc", False DoCmd.SendObject acQuery, "Rev by AcctCode", "MicrosoftExcel(*.xls)", Forms![SalesAssoc]![e-mail], "
-
- Assign an array to .values and .Xvalues in an excel chart
by Jonas.S
- 6 Replies
- Last post
by Jonas.S
- Hi,
I'm having trouble with assigning arrays to a chart. Below is how I done. Anyone nowing how to make this work
Set MyDispl = Application.InputBox(Prompt:="Select displ.", Type:=8)
Set MyForce = Application.InputBox(Prompt:="Select force.", Type:=8)
Do '''Collects Displ data
-
- Error When Using Range(Cells()) to Paste in Excel
by Joe Dawson
- 2 Replies
- Last post
by Joe Dawson
- Hi, I get a "Method Range of Object Worksheet Failed" when I run code below. The error points to the last row of code. What I am trying to do is determine the number of the last row in Column A that has data, and then copy some cells with formulas in them from row 2 of a couple of columns and then paste them down as far as the last data in column A. 'shtCurrent_Portfolio.Activate LastRo
-
- Routine to open file/point to url
by GB Allan
- 4 Replies
- Last post
by GB Allan
- Hi,
I have the following routine as part of a larger macro, to open and work with a file:
MsgBox ("Please open the new ABC File.") ABCFile = Application.GetOpenFilename("Excel Files (*.xls), *.xls") Workbooks.Open Filename:=ABCFile ABCFile = ActiveWindow.Caption
Right now, I ask the operator to save this file on their computer, then open it when promp
-
- Timer on macro execution run time
by une
- 8 Replies
- Last post
by Andy Pope
- I have written some text analysing code that takes a long time to execute if the text selection made by the user for analysis by the macro is too large. Therefore I would like to add the following functionality to the macro;
If after 15 seconds of execution the macro has not completed, I would like execution to halt and output a message to the user asking them to reduce the size of the sele
-
- Track InternetExplorer Object firing new windows
by Ragnar Moller
- 3 Replies
- Last post
by Ragnar Moller
- After stubbornly searching I found how to use an InternetExplorer object to start up IE and to fill in a form which was displayed in the browser. I sort of figured I have to use newwindow or newwindow2or newwindow3 event but I've got a few holes to fill in. I'm programming in vba for Outlook under windows NT and I'm trying to figure out - how do I program the event oe make outlook to take it into
-
- Digital Signature of Macro Project invalidated after saving Excel Workbook
by Dave Hary
- 4 Replies
- Last post
by Robo Coder 1
- I am having a problem loosing the digitial signature I have applied to the macros in Excel 2003. This also applies when using Excel 2000 to open the workbook.
Quite often and for no obvious or traceable reason the digital signature I applied to the macro project is rendered invalid after the workbook is saved. As a result, the next time I open the workbook I get the error indicating that &
-
- Check Boxes
by jtminqc
- 2 Replies
- Last post
by jtminqc
- I am a self taught newbie in Excel VBA, so my question could be very trivial. I have a UserForm that, among other things, has a CheckBox in it. Say CB1. I would like CB1 to show its last state, whenever I open the UserForm. If it was TRUE last time, I want it to show the check mark, in full black, when I open the form. How do I do that JtmInQc
-
- Run-Time Error 1004 : The Text you have entered is not a Valid reference or defined name
by Christopher Zinger
- 1 Replies
- Last post
by Christopher Zinger
- Alrighty So this seams like a really simple line of Code...
I am using Excel 2007
I have narrowed my error down to this silly line of code. The Error i am getting is 1004: The text you have entered is not a valid reference or defined name...
Sheets("Items").Range("ItemNumberHeader").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= (