-
- can I write word macro with visual basic 6?
by nta1
- 5 Replies
- Last post
by Rod Wing
- I have a GUI application written in Visual basic 6.0, is there any to import it into word so that it will be a macro
-
- How do I call for all installed printers....
by MyLady
- 5 Replies
- Last post
by magicalclick
- Hey,
How do I, with vba code, call for all installed printers in my computer and then display them in a ListBox
Best Regards
Cathrine
-
- How could I count the last column in first row? Thanks so much!
by lyp_sj
- 1 Replies
- Last post
by Andy Pope
- How could I count the last column in first row Thanks so much!
-
- Newline in TextBox
by une
- 3 Replies
- Last post
by Andy Pope
- I tried to put some text in a TextBox as follows;
TextBox1.Text = "Text = " & vbNewLine & testtext
However when executed this code diplays the symbol for a newLine character (reversed bold "P" like symbol) between the two strings rather than actually placing the second string on a new line. This method of adding new lines works in a MsgBox, why not in a Te
-
- Excel Application.Calculation in Excel 2003
by GaneshSharma
- 2 Replies
- Last post
by GaneshSharma
- Hi, http://support.microsoft.com/kb/918621/en-us My workbook which is a add-in gets calculated everytime even when the add-in is not used. This is affecting the performance of the other add-ins badly. Is there a way to convert all the formulas in a workbook to values & then convert it back to formulas later. thanks Ganesh
-
- CRM 3.0 Outlook Client
by keithpsft
- 7 Replies
- Last post
by PFLIK
- I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying:
"Your Web browser options are currently set to disable cookies. Mi
-
- Distributing VBA applications
by scott56hannah
- 0 Replies
- Last post
by scott56hannah
- I have developed some VBA applications that I would now like to sell and I want to find a way of securing that VBA application delivered through an excel workbook so that it cannot be simply copied and passed onto another person...Is there some approach that can be included to VBA script to provide that security....
Even if the approach is not perfectly secure at least it may make it diffic
-
- Excel Dialogs
by Keithyboy1
- 3 Replies
- Last post
by Andy Pope
- I have a routine, which calls for the Excel SaveAs dialog box, using the code snippet below:
Code Snippet
Application.Dialogs(xlDialogSaveAs).Show fileName
I am passing the string variable, fileName to the Show method. This variable is created with the code below:
Code Snippet
fileName = "CC " & cmbCostCentre.Value & " - " &
-
- Automating PowerPoint
by Jenise
- 4 Replies
- Last post
by Andy Pope
- I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday.
Can you please suggest how I can automically execute my vba code to run
thank You!
-
- Inserting a row in VBA
by KenCubs
- 8 Replies
- Last post
by KenCubs
- When I insert a row from Excel in my spreadsheet, the formulas (from the columns that have formulas) are copied from the prior row (with addresses properly changed) to the new row. When I insert an entire row from VBA, nothing is copied. Does anyone know what I need to do
Thanks,
KenCubs
-
- Macro called twice on single button click
by Don0531
- 4 Replies
- Last post
by perkinscraig
- Hi,
The macro attached to the excel button is called twice on a single button click.
This happens for the first time, when I click the button after opening the workbook.
When I try to debug, it calls the macro only once.
Its quiet strange. Could any of you help me on this regards.
Thanks
Ron
-
- 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
-
- How to open "Properties" dialog box to "Custom" tab within macro?
by oryan_dunn
- 2 Replies
- Last post
by oryan_dunn
- I'm writing a macro that will, as part of its operation, update all fields within the document. I need all my custom fields filled out prior to running this macro. I'd like to be able to prompt the user to fill out the properties by providing a button that will open directly to the Custom tab of the file properties dialog box. How do I go about programming this
Thanks,
Ryan
-
- Sharepoint Web Parts for Subsites
by Peter O'Brien
- 4 Replies
- Last post
by AlexArun
- This seems like a simple question but I've trawled the net and not found a simple answer. If I have a site on Sharepoint Server 2007 (Enterprise edition), and I create a few new subsites and workspaces, is there a web part that will show all subsites Or do I have to add individual links manually for each of the subsites to a list and then display the list through a webpart
-
- Call Macro in Closed Workbook?
by Joe Dawson
- 2 Replies
- Last post
by Joe Dawson
- Hey Folks, Is it possible to call a macro from a workbook that is closed Joe
-
- Variable declaration + assignment
by une
- 2 Replies
- Last post
by une
- I want to declare a variable and assign a value to it in one line.
I have Option Explicit turned on.
The following line will not compile, I get an error stating;
"Compile error:
Expected: end of statement"
Here is the code causing the problem;
Dim count As Integer = 1
However I found the following code caused no problem;
Dim count As Integer count = 1
-
- Display default values from a function
by DeathSurfer
- 2 Replies
- Last post
by DeathSurfer
- Duuuuudes:
I have a question I'm not sure how to ask but here goes, I was wondering how can I get those pretty default values that get returned when calling a standard method in vba, for example, in excel's vba when you call the pastespecial method it gives you those nice drop downs to choose from for each argument you can pass. I have some functions I have written that can only except cer
-
- 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
-
- Newbie in VBA Drag and Drop..
by den2005
- 8 Replies
- Last post
by den2005
- Hi,
Do not know if this is possible drag and drop effect of items in dropdown control inside a word application
The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done
Thanks in advanced.
den2005
-
- Application-defined or object-defined error
by Joe Marlow
- 3 Replies
- Last post
by Luiz Cláudio - MVP
- Hello All, I'm receiving the error message in subject in the following code: Public Sub Err(ErrorID As Long , _ Optional AddInfo As String = "", _ Optional Source As String = "", _ Optional Log As Boolean = True ) If Log = True Then Me.Log MsgTypeError, ErrorID, AddInfo, Source MsgBox Me.GetErrorDescription(ErrorID), vbCritical + vbOKOnly , "
-
- Append Query Question
by akn112
- 3 Replies
- Last post
by Luiz Claudio - MVP
- My table has columns labelled 1) Item 2)Property 3) Quantity
ie:
Item Property Quantity
Sugar size 1 inch cubed
Sugar weight 10 grams
Sugar Append Yes
Salt  
-
- Cells
by LRFT
- 6 Replies
- Last post
by magicalclick
- I'm really confused as to why I activate a cell:
x = ActiveCell.Row
Yet when I try to select that cell:
Range (Cells(x, 1)).Select
It comes up with an address way out of whack! What am I doing wrong
-
- Excel Userform - Runs fine but other users get a compile error
by suznal
- 7 Replies
- Last post
by suznal
- I have a userform that is called from a keyboard shortcut. It works perfectly fine when I run it, but other users cannot run it on their machines. We all are using Excel 2003 SP3, (only one user has SP2) and all users have changed their security to allow macros. But when they try to load the form they get a compile error.
The code I have for the userform is...
Code Block
-
- setting up pet shop 4.0
by swawin
- 1 Replies
- Last post
by Nathan Anderson - MSFT
- Hi I am a .NET newbie here. I have downloaded petshhop 4.0 from MSDN. How can I get it working please I want to take a look at how the application works My machine is win2k3 with SQL 2005, VS2005 and framework 2.0. I realised that if I use 3.0, it will work straight away but it only works with SQL 2k. I would like to try with SQL 2005, hence I am looking at 4.0. Do I have to rebuild to see the
-
- Spooler error 1068
by Terminator484
- 14 Replies
- Last post
by virginia3443
- I have been all over hell and high water trying to find some way to fix this error, but alas, my efforts have been fruitless; so here I am. The Situation: After moving about a week ago, I just got around to re-attaching my printer (a Lexmark X1185 ). I then discovered that my computer (Windows XP sp2) apparently deleted my printer drivers all by itself, so now I cannot use the printer. I downloa