Using VBA to open a new web page
Fri, 15 Feb 2008 16:04:50 +0800
Hello,
I use the following code in Word VBA for firing up the default browser and
opening the Google web site:
Dim objshell As Object
Set objshell = CreateObject("Shell.Application")
objshell.Open "http://www.google.com"
However, if the default browser is already running, the above VBA code will
open ...
|
Date Format
Mon, 11 Feb 2008 07:50:49 -0700
I am using a Macro Public Function in Excel which format the date:
Optional Formato As String = "dd mmmm yyyy" _
) As Variant
this display by example 11 Febrero 2008,
but I need to display 11 de Febrero de 2008
It's possible to change to this format?
Thanks for your help
...
|
Parsing a txt file into Word
Mon, 11 Feb 2008 05:30:00 -0800
Hello!
I've been asked to create a word document that parse a txt file and draw out
the needed information.
Does anyone have any handy resources or usefull ideas on how to do this with
the least amount of problems?
The txt file is a report that is exported from a Cisco router / firewall or
the likes and ...
|
Cutting and copying a list in Word 2003 (posted in General)
Sat, 09 Feb 2008 01:50:38 -0800
I originally posted this in the microsoft.public.word.vba.general
newsgroup and received an answer, but unfortunately I was unable to get
it to work. I'll post the link to the original post below.
Here's my question:
In Word 2003, how can I cut a list that is under my cursor and copy it
using VBA? The li ...
|
Our new website
Fri, 8 Feb 2008 15:41:34 -0800
This website is for artist, freelancers, programmers, writers, translators. All who is looking for work.
If you are a skilled professional use page "Add profile" to create your profile.
Also this website is for those who is looking for skilled professional.
If you are looking for a professional use page "Pr ...
|
running macro
Thu, 7 Feb 2008 09:44:01 -0800
I have a code in Document_Open, but it does not run the code.
I use debug and set break point and realized that code even not fired.
Are there any places need configure to triggle the code?
Your help is great appreciated,
...
|
Date Adjustments and Document Editing
Thu, 7 Feb 2008 09:03:44 -0500
Hello all. I am having a little bit of trouble with MS Word 2003. I have a
document for work that requires consecutive dates in it for a week. I would
like to be able to enter the first date in the first field and Word
automatically adjust the dates for the next six fields. Is this possible?
Also, I know it ...
|
|
|
Passing criteria for queries in macros
Wed, 6 Feb 2008 06:16:36 -0800 (PST)
I use Excel Macros to search databases using ODBC. I have a macro I
wrote that performs queries on 4 different databases with the same
search criteria. Currently, the macro runs each query separately and
prompts the user 4 times to enter the same start and end date and
salesman number. How can I save the valu ...
|
Invest smart
Sat, 2 Feb 2008 14:42:08 -0800
How much profit can you make with one dollar?
Check out this website www.forbuck.com
Without any obligation, registering or other ties make cash!
...
|
Include Target attribute of hyperlink
Fri, 1 Feb 2008 13:33:15 -0500
A Word guru was nice enough to provide me with this snippet that makes Word
hyperlinks HTML ready (find text that's a hyperlink, and wraps said text in
the <a href> tags for export to a text file that's web-ready (and before you
suggest Word's save as html, I can't use that because of the pages and pages
of ...
|