-
- 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!
-
- How could I count the last column in row 1?
by lyp_sj
- 5 Replies
- Last post
by Duane in Japan
- Hello,
I'm new for VBA, so I'm wonderring how I can count the # of column in row 1. Thanks so much for help!
B.regards/Yaping
-
- Locking buttons
by une
- 3 Replies
- Last post
by une
- When ToggleButton20 button in my userform is clicked and its value becomes True, I want a few other buttons whose values and captions can usually be changed by clicking to become locked in their current state until ToggleButton20 is clicked again to False. How can I do this
-
- RegEx: Process URL segments
by gregw74
- 2 Replies
- Last post
by Shasur
- I need some help in parsing a URL. I am hoping to at least match and remove the domain name (including HTTP..) and the first two or three segments of the URL.
http:\\www.somedomain.com\segment_a\segment_b\segment_c\page.htm becomes segment_c\page.htm or segment_b\segment_c\page.htm If a loop is possible that would be ideal. If variable x=2, the loop would remove the first 2 segments of th
-
- Different classes in one collection
by wlwlz
- 6 Replies
- Last post
by Cringing Dragon
- Hello Everyone,
I just recently started to learn VBA so there are quite a few things I'm having trouble with.
When I tried to put multiple classes in a collection and later use For Each <Class> to access them by each class, it would result in an error stating object type does not match.
Just wondering is there a way to implement what I'm trying to do here in VBA Namely,
-
- Grabbing image from Clipboard & saving as jpg
by BPurser
- 1 Replies
- Last post
by Andy Pope
- So, I have done a truckload of googling this morning trying to resolve what I assumed would be a fairly easy task: to wit, using Access XP, I'd like to have some VBA that grabs an image from the clipboard (copied there from another application) and save it to a specified location with a generated file name.
I can do everything but the salient point of grabbing the image and telling VBA to s
-
- font substitution issue!!
by VNAHATA
- 1 Replies
- Last post
by orcmid
- Hi I have an issue with font substitution.I have an italic text which uses Arial as its font.I have been combining font's name along with its style to get its PSname which i use for further processing.However there are cases where a glyph might be present in Arial and not present in ArialItalic.Also there are cases where corresponding to same glypid in both the fonts,the glyphs vary.Is there any w
-
- Macro to FInd a Text and pick the next 4 chara of the found text.(or GET THE ACTUAL RESULT in side the macro)
by doshivinod
- 2 Replies
- Last post
by doshivinod
- Hello All,
I want to write a macro which will find a particular text in a word document.
(I know this has been discussed almost 100 times and is very easy)
But i want to access the actual found result inside the macro
or the next four chara of the found text.
e.g. (Document will contain the following text).
Pages : 2-3
Now i want to write a m
-
- Highlighting cells within a worksheet
by pfunkmasterflex
- 3 Replies
- Last post
by Andy Pope
- Several of us in our office have a fantasy golf league and we administrate it off-line using an excel spreadsheet (we haven't found a free website that lets us tailor the rules to the way we like it.) Anyway, it is a salary cap format, meaning that only one golfer can be on one team at a time. To keep track of this, one of our worksheets has a list of all the golfers. That same worksheet also has
-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- Adding VBA code to Excel sheet
by Ad Brandt
- 4 Replies
- Last post
by Andy Pope
- I've made a program that reads an XML data file, and generates an Excel spreadsheet with charts of the data. I'd like to be able to manipulate the scaling of those graphs in Excel. That can be done easily, but requires some VBA, to define a Worksheet_Change(ByVal Target As Range) function. My question is: is there a way to write VBA code into an Excel sheet via OLE, just as you can write data and
-
- Why there is no forum for Microsoft Office Business Scorecard Manager 2005?
by Helen999888
- 0 Replies
- Last post
by Helen999888
- Hi, all here,
Thank you very much for your kind attention.
I am quite wondering why there is no any forum for Microsoft Office Business Scorecard Manager 2005
With best regards,
Yours sincerely,
-
- .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
-
- VB Macros & Office
by Sxar
- 0 Replies
- Last post
by Sxar
- Hi,
A customer who we are working with has requested whether it is possible to move messages automatically based on data inserted in an E-Mail message in Outlook.
Basically the email will be a standard email but will contain somewhere in the body or subject a piece of code ie. <job>Example Job</job> and the email will automatically be moved to the folder specified (Comple
-
- Obtain Unique Work Units via SQL
by AlDeb
- 14 Replies
- Last post
by AlDeb
- Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals.
I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I
have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits.
In the example below on on
-
- Worksheet.Copy causes execution to stop
by pnp
- 11 Replies
- Last post
by pnp
- Hi
I am experiencing an odd behaviour from my VBA code in Excel.
I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way.
My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing.
<CODE>
On Error GoTo ERROR: W
-
- Unbale To Read File
by Karthik Doss
- 4 Replies
- Last post
by Eyal
- Hi ,
I am generating an Excel File using the " Response.ContentType = "application/vnd.ms-excel" after generating the excel file when i tried to open the excel it give me an error "Unable to read file "..... This particuclar error gets only for a case ...
-
- MS Office document and image writer print driver
by GTH
- 14 Replies
- Last post
by Mary3480
- Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to
-
- Reactivate embedded chart and make it the ActiveChart in excel
by Jonas.S
- 2 Replies
- Last post
by Jonas.S
- Hi all,
I can't make this work for embedded charts in excel. It only works for charts that are on an own sheet. Can someone tell me what to do to make it work for embedded charts as well.
Dim Ch As Chart Set Ch = ActiveChart
''' Code that reads in input data...
Ch.Activate
With ActiveChart ''' Fill chart with input data .ChartType = xlXYScatterSmoothNoMarkers .Se
-
- How to retrieve outlook e-mails
by Maxbaviaan
- 0 Replies
- Last post
by Maxbaviaan
- i want to retrieve email text in a access form.
-
- Automatically send attachment in email with a submit command button in word
by Desperately need help
- 3 Replies
- Last post
by ADG
- I have a huge problem if anyone out there is able to help; I have tried to create a submit command button to email off a document as soon as the user hits submit; however i am new to this and my macro does not seem to be working. Does anyone know where i have gone wrong and if possible can you please help rectify the problem. Thank you Sub CommandButton1_Click() Dim Email As Object Dim Attachment
-
- Naming Subs
by une
- 1 Replies
- Last post
by Deepraj_Majumdar_35eaf1
- Consider the following code;
Private Sub Label1_Click() If InStr(1, Selection, "!") Then Label1.Caption = "Found a !" Else Label1.Caption = "Didn't find a !" End If End Sub
What is the significance and meaning of the underscore in the 1st line Are there other options for the name of this Sub such as Label1_xyz() that would make the Sub act in diferent wa
-
- VBA Excel - Getting file Extension
by ajliaks
- 4 Replies
- Last post
by ajliaks
- Hi guys,
I am looking for a VBA Excel function which lets me change the name of a file without oppening it. (any file, not only office).
for example if I have the file "myDocument.doc" I want to call it "myNEWDocument.doc" without oppening it. If there is not such a function, what I will do is:
Opening the file
Saving the file with the new name
Killing the fi
-
- Beginner needs help resonling an error message
by Helen Obomanu
- 2 Replies
- Last post
by Andy Pope
- I am trying to create a simple spreadsheet in excel that can perform a macro that allows me to insert a new row on the existing worksheet and have it formatted with the borders of the cells darkened so that it looks like the rest of the spreadsheet. I recorded the macro, but I recieved an error message that looks like the following:
"Run time error 1004: Unable to set the line style proper
-
- Simple Outlook 2007 Macro Terms
by cal2005
- 1 Replies
- Last post
by Cringing Dragon
- Hi, I'm wondering where I can find a list of oft-used terms when creating macros for Outlook 2007. Specifically, I just want to set up a keyboard shortcut macro to move the selected email(s) to my "saved" folder (from my inbox). So I need to find terms to: 1. refer to the currently selected message(s) 2. procedure to move to a folder Thanks!