-
- Attaching Contents of a Folder
by Chin13
- 6 Replies
- Last post
by Andy Pope
- Hi all,
Using a macro running on excel, I am trying to attach the contents of a folder in Outlook. The files contained in the folder change, so it is not as simple as writing the code to attach a specific file. I need it to attach all the files regardless of the file name. Is this possible
Thanks in advance
-
- WER wish list for developers 8-)
by Claus Brod
- 14 Replies
- Last post
by Joel Stein
- Jason Hardester posted today about some of the decisions made at Microsoft around WER, and concluded with a call to action to collect requirements for WER from a developer point of view. I'm glad to oblige (And thanks, Jason, for your helpful post.) My main issue with the current implementation of WER, particularly on Vista, is that it makes it hard for a developer to find out whether a crash rep
-
- vb.net certification
by Ralph_Ai2x
- 1 Replies
- Last post
by MS ISV Buddy Team
- where can get the reference and guide to vb.net because im going to take vb.net certification. please help thanks..
-
- 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
-
- Can you use VBA to access a spread sheet embedded in a word doc?
by Trisped
- 13 Replies
- Last post
by Trisped
- I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
-
- Get data from web using VBA in Excel
by stsa
- 0 Replies
- Last post
by stsa
- Dear all,
I'm getting data from various webpages using VBA in Excel.
I have a long list of webpages in excel which I use in order to collect the data from these webpages and insert in Excel. However, some of these webpages contains special characters and for those it doesnt work. Anyone that knows what I need to do
Many thanks!
-
- Searching for a string value and copying the first row and colum entries.
by NeilNeil
- 3 Replies
- Last post
by AussieJames
- I have a spread sheet that gets data from a data logging software and puts it into my spread sheet. The first colum contains the name of the tags for the data ("On" or "Off"), the top row contains the time when the data was sampled. What I am trying to do is write a macro to search the data for "On" entries and if it finds a cell that contains "On" it will t
-
- CRM 3.0 Outlook Client
by keithpsft
- 9 Replies
- Last post
by DavidJennaway
- 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
-
- Excel Macros Loop Help
by Thundermocos
- 3 Replies
- Last post
by MyLady
- I am trying to figure out how to create an Excel Macro that will loop through worksheets and stop running when there are no more worksheets. I need to collect data from each tab "worksheet", so I want it to collect the data move to the next worksheet, collect the data.. etc until there are no more worksheets and stop.
Thanks
-
- Running Remotely
by Darko28
- 0 Replies
- Last post
by Darko28
- I've been trying for a very long time to come up with a way to run a bat file on a remote computer. The bat file is located on a network drive so psexec doesn't work, I've also tried rexec and runremote freeware with the same problem of only being able to connect to absolute drives. I just tryed using Microsoft's Remote Desktop Connection which enables users to login and launch programs upon start
-
- dynamic creation of userform
by jiml27
- 10 Replies
- Last post
by Andy Pope
- I am trying to create a userform dynamically. I am having limited success, and have a few questions. For early binding, I use this code:
Code Snippet
Public UserForm1 as UserForm The question, then, is how to instantiate the userform The code that I use for late binding does not work:
Code Snippet
set UserForm1 = ThisDocument.VBProject.VBComponents.Add(3) and nei
-
- 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
-
- Merry Christmas and Happy New Year
by Derek Smyth
- 3 Replies
- Last post
by RhysDavies
- This is the forum I've maybe spend the most time in, although not so much recently but that can't be helped. To everyone who posts here often enough to know my name, and to anyone else to happens to read this... have a great Christmas and New Year... and even if you don't celebrate them I hope you enjoy the holidays.
-
- Getting The Conten Of A Word Document?
by KAMACI
- 7 Replies
- Last post
by KAMACI
- How can i get my ActiveDocument's content
-
- WER wish list for developers 8-)
by Claus Brod
- 14 Replies
- Last post
by Joel Stein
- Jason Hardester posted today about some of the decisions made at Microsoft around WER, and concluded with a call to action to collect requirements for WER from a developer point of view. I'm glad to oblige (And thanks, Jason, for your helpful post.) My main issue with the current implementation of WER, particularly on Vista, is that it makes it hard for a developer to find out whether a crash rep
-
- messageBox not showing in current window
by Bajrang
- 1 Replies
- Last post
by Bajrang
- Hi,All I want to show a message box when user click my custome send button to sending a Mail Item. Everything is working fine but Messagebox in not showing in current window (that is Mail Item), but it is showing in parent window of OUTLOOK. To see this message I have to move into OUTLOOK's main window. There in no much coding , I don't know where the problem is Please help me out. my code is here
-
- Display a value in a looping status
by Victor_TanTW
- 1 Replies
- Last post
by Jade_Emeperor
- Hello. I am working on a program that requires me to generate a status of the program I am writing. Up to now I can display every string values out onto the txtDisplayText box but except that last one which the value was generated from the serial port
Code Snippet
Dim sRx_Buffer As String
Dim sRx_Msg As String
commSerial.Output = stringValue
sRx_Buffer = commSer
-
- API and OpenGL in VBA for Excel
by Spinor
- 7 Replies
- Last post
by @sanya
- How to use in VBA for Excel such API functions like, SetPixel, GetPixel, LineTo, PolyLine or ArcTo acting on the new created standard UserForm or in the special new window opened by appropriate API function. I know that it is trivial within VB applications, whereas VBA makes troubles (handle address of UserForm). I would be grateful for some simple examples (which have been tested and work well).
-
- TextBox height
by suznal
- 8 Replies
- Last post
by suznal
- Excel 2003 - TextBox
What would the code look like to have a text box maintain a specific width and a minimum height but increase in height as data is entered
-
- MSCOMM
by rikstick
- 4 Replies
- Last post
by rikstick
- Hello,
How do I use MSCOMM with VBA I can't find a reference to it in the object browser.
Txs
-
- Strange Outlook 2007 POP3 Behavior & Slowness
by Ring0
- 1 Replies
- Last post
by jttaynton
- Outlook 2007 is sending "AUTH "<crlf> as the first command to POP3 servers.
This confuses the server and on some, causes a 3 second delay! Thus:
2007.01.02 13:04:47 POP3 (mira.net): Connected to host 2007.01.02 13:04:47 POP3 (mira.net): +OK POP3 Ready mailproxy2 0001bff0 2007.01.02 13:04:47 POP3 (mira.net): Authorizing 2007.01.02 13:04:47 POP3 (mira.net): [tx] AUTH
** note 3 seconds
-
- Worksheet Object - Update cells
by GB Allan
- 4 Replies
- Last post
by GB Allan
- Hi,
I have the following routine to update cells H5 and O5, depending on the content of cell A5:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim MyVal As String
MyVal = Range("A5")
Range("H5,O5").FormulaR1C1 = MyVal
End Sub
It works great. The only problem is, I want it to work as well with each of the other cells. In other words, if
-
- TextBox height
by suznal
- 8 Replies
- Last post
by suznal
- Excel 2003 - TextBox
What would the code look like to have a text box maintain a specific width and a minimum height but increase in height as data is entered
-
- need help writing a vbscript to open a spreadsheet and run a subroutine in a macro
by ronald cole
- 2 Replies
- Last post
by Shasur
- Actually, I need help coding the "running a macro" part. I have a spreadsheet with a macro called "snafu" on sheet2 that contains a private subroutine called "runme" tied to a button. I just need to script up something that opens the spreadsheet and runs that subroutine and closes the spreadsheet. Sounds simple, huh Six hours of googling and reading the Microsoft Exc
-
- Can't find Office Image Writer on Office 2000. Can the driver be added or is there a free upgrade?
by detravel
- 1 Replies
- Last post
by Harpreet Singh Khandiyal
- I can't seem to get Microsoft Office Image Writer loaded on my PC as a printer option. I have Office 2000. Does anyone have suggestions or know where to send me to look for help Thanks.