-
- Macro to send information when modified
by sree
- 3 Replies
- Last post
by ADG
- Dear all,
I would like to know if we could create a macro, which will send information to a list of email ids, when a particular excel file is modified manually or updated using other macros in it.
This way i wish to save an excel file in a shared folder where authorised people can access - read/write and when they modify, a list of people who would actually be using the information
-
- 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
-
- Need to link two word documents together.
by Lunar Beam
- 3 Replies
- Last post
by Shasur
- Hi,
I have two documents which have roughly similar tables that need to be filled in Microsoft Word.
I would like to have a macro that updates a cell in a 5-by-5 table in B.doc when a cell in a 5-by-5 table in A.doc is updated.
1) A.doc is updated.
2) B.doc is opened, then updated.
3) Both documents save themselves.
It would be best if steps 1-3 are completed with
-
- .mdmp files not being created
by David Ching
- 28 Replies
- Last post
by David Ching
- Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
-
- How to make this pastespecial happen?
by lyp_sj
- 2 Replies
- Last post
by magicalclick
- Hello,
When I try to copy and paste with a multiply function by using below code, it does not work. I guess something I did wrong when I select the range:Range(cells(r, 7), cells(r, lastcolumnCapacity)), while I do not know what's wrong with this Thanks so much for help!
B.regards/Yaping
worksheets("Capacity").Range("B1001").Select Selection.Copy
-
- programming "yes-to-all" functionality
by pacificwaters
- 4 Replies
- Last post
by pacificwaters
- I'm using VB 6.3, and I'm trying to program a Yes-to-All (and No-to-All) button, which doesn't exist in the MsgBox functionality.
Currently trying to use the .doalert method: With Application.Assistant Select Case .DoAlert( _ "Invalid Member", _ message, _ msoAlertButtonYesAllNoCancel, _ msoAlertIconQuery, _ msoAlertDefaultFirst, _ m
-
- ListView in VBA
by Cody Code
- 2 Replies
- Last post
by Cody Code
- Hallo I Just Have One Question in Regards to the Listview Control in VBA. I am trying to fill each column in my listview with data that is from a recordset. i.e rem lstviewItems in the listview control on the form Set list = Me.lstviewItems.Object With list .ListItems.Add , , rec("Desc") .ListItems.Add.SubItems(1) = rec("RetailCost") .ListItems.Add.SubItems(2) = txtQty.Value
-
- Excel VBA - Copying Recordset to Array
by HMote
- 1 Replies
- Last post
by Luiz Claudio - MVP
- I for the life of me cannot figure out how to do, what I figure, should be a simple task; I need help on how to copy the contents of a recordset to an array in VBA. I have my recordset ready to go, but I have no clue on how to copy it's contents to an array.
In my routine, I want to access this array to find out if a date already exists in the db before inserting the new data, so I only ha
-
- Why is my Web Query Refreshing Inconsistently?
by bob135
- 4 Replies
- Last post
by bob135
- I have asked on several other forums (In Mr. Excel, a popular excel forum, my post got bumped to the bottom, I'll try posting it again but yeah...I'm looking everywhere now). Here's the issue: This is the code for my query: WEB 1 http://finance.google.com/finance fstype=ii&q=["Ticker"] Selection=EntirePage Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True
-
- Microsoft Platform Test for ISV Solutions required deliverables
by NRZ
- 3 Replies
- Last post
by KevinKhelawan
- What required deliverables I must send to ISV for Platform Test.
Are "Setup package" and "User Document" Enough
-
- VBA:how to set comment object's author in Excel 2003
by Daniel Yang
- 2 Replies
- Last post
by Andy Pope
- Hi all, How should I set or change the comment author of a cell in Excel 2003 I have looked up in MSDN. It only provides the sample codes of how to get the author value. I use the following codes:
Sub setcomment()
Dim a As Comment
For Each a In ActiveSheet.Comments a.Author = "daniel" Next
End Sub
The error message is wrong number of augm
-
- Script to configure Microsoft Office Document Imaging Printer
by DGB1
- 1 Replies
- Last post
by Cringing Dragon
- I have an application that uses the MODI Printer. I would like to set the properties to Tif and change the print destination folder.
When my program installs I would like to build the script and execute it.
I've seen scripts to install/remove printers, is there anything that can set the MODI printer's advanced properties
-
- Converting access to VB.NET or C#
by fweeee
- 4 Replies
- Last post
by fweeee
- Hello, A friend and I are currently in the process of converting an access database to something a little more powerful. At the moment, we are converting the backend to MSSQL (using a tool we bought from somewhere on the internet - the upsizing tool was only working for 20% or so of it). After this is complete, we will then need to get the frontend into something a little more appropriate - either
-
- Help! Please! dll
by morozx
- 3 Replies
- Last post
by ke wenzel
- I have windows vista and a long time ago I accidently opned a dll file with notepad and now i dont know what to do. A lot of my programs wont run, and i cant find a application to open it with. So i need to restart my computer but how ! !
-
- How to get a control by its name (not in a form)
by Duy Cuong
- 2 Replies
- Last post
by Duy Cuong
- In my presentation I have some controls, which I know their names. The question is how to use their name to change their proper ties... somehow like Dim myControl As control Set myControl = Controls("CheckBox1") myControl.Visible = False End Sub please help !!!
-
- Using VBA macro to locate next free column on worksheet
by rabbitoh
- 14 Replies
- Last post
by magicalclick
- I need a macro that locates the next free
column (i.e. has no data in cells) and then places the cursor in a cell on a
designated row. Would like search to start from column B and to place the cursor
on row 4 on the free column.
<>
My VBA code thus far:
Function NewColNumber(Range1 As Range) As
Integer
Dim j As Integer
For j = 1 To Range1.Columns.
-
- Unable to infopath form in browser
by RagsIyer
- 3 Replies
- Last post
by Sergio otoya
- ERROR:
The form cannot be displayed in the browser because the use of session cookies has been disabled in the current browser settings. In order to load the form, session cookies must be allowed.
Any pointers would be appreciated
-
- VBA EXCEL: How do I subtract two cell values
by UH60
- 2 Replies
- Last post
by magicalclick
- I want to subtract value in A1 from A2 in VBA. This is what I thought, but it doesn't work
Val (Range("A1").Value) - Val(Range("A2").Value)
I hope someone can help
Thanks
-
- Office 10 \ winword.exe runtime error
by Kdean6869
- 14 Replies
- Last post
by Jyh-Cheng Chen
- I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe.
-
- Toggle buttons
by une
- 4 Replies
- Last post
by une
- I need some help programming toggle buttons. I assume a toggle button can have 1 of 2 states and the state alternates when the button is clicked. Is this correct I am thinking about some code as follows;
Private Sub ToggleButton1_Click()
ToggleButton4(changeState)
If ToggleButton1.state = false Then
ToggleButton1.caption = "NO"
Else
ToggleButton1.caption = "YES
-
- 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!
-
- Future of VBA (and VBScript)?
by fiatlux
- 28 Replies
- Last post
by fiatlux
- We developped a number of tools in VBA or VBScript, sometimes using COM objects, and the large compatibility of VB, VBA and VBScript was certainly nice. We would no mind moving to .NET (the framework API being quite interesting), but it is not clear what is going to be the future for VBA and VBScript. Can we expect a VB.NET"A" and a VB.NET"Script"
-
- Select/cut/insert
by Bluzdude
- 4 Replies
- Last post
by Bluzdude
- I need to select all rows in an Excel worksheet in which the value in cell "F" is not blank, cut each of those entire rows and insert them in another worksheet at row "4".
-
- How do I deal with files of more than 65k rows?
by chilehed
- 8 Replies
- Last post
by chilehed
- I need my code to be able to deal with .csv files of well over 65k rows, but haven't the slightest idea how to do it.
I've heard of a technique called "paging", which distributes the data over more than one sheet but processes it as if it's on one.
How is this done
Thanks.
-
- 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