-
- Manually halting macros
by une
- 2 Replies
- Last post
by une
- How does a user manually (not via any code) halt a macro while it is running if they decide it is taking too long or they just want to stop it It seems you can't use Ctrl-c or Ctrl-z. If you use Ctrl-Alt-Del and bring up the task manager to end the task, Word halts completely and all changes to the document are lost. This is not of much use. Is there another key sequence to halt the macro that wil
-
- Using Inet to download an FTP File
by Dudeman
- 4 Replies
- Last post
by Jack_II
- I am creating a macro in Access VBA where I need to retrieve a text file from an FTP site and store it on my c drive. The code seems to be working fine but it does not do anything. It should be creating a file on my local computer, but no file ever comes back. Please advise with any suggestions that could get this code to work.
Sub FTPCheck() Const cHost = "ftp://ftp.xxxxxx.com/xxx/xxxxx
-
- Vertical scrolling in VBA
by FWR
- 2 Replies
- Last post
by FWR
- Dear all,
Vertical scrolling using the mouse wheel does not work in the code window (the window where I write program code) of my VBA.
In other cases, vertical scrolling using the mouse wheel works just fine (for example, there are no problems scrolling in the project explorer or properties window of VBA). So, I don't think there is anything wrong with my mouse or the way it is insta
-
- Wording of Response web pages is different to specified text
by Marcus Ogden
- 1 Replies
- Last post
by Jason Hardester - MSFT
- Hello,
I'm working on a prototype application using Windows Error Reporting, and right now I'm trialling Responses. I'm trying to understand why the wording on the web page I see (after submitting an error report for an event that I've registered a Response for) is completely different from the wording I've specified on the Winqual website's Response Management page.
Two examples:
-
- How do I count only the worksheets from the ActiveSheet to the last sheet?
by MyLady
- 4 Replies
- Last post
by MyLady
- Hey,
Case: Let¡¯s say I have a workbook with ten sheets and have selected a sheet somewhere in between the ten sheets.
How do I count only the worksheets from the ActiveSheet to the last sheet
Can anyone show me how to do it with a code
Regards
Cathrine
-
- Are these valid bucket ids ?
by DHON
- 14 Replies
- Last post
by Claus Brod
- Hi Jason, Saar,
The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day.
Could you please, confirm whether these are all valid bucket id If not then reason.
Thanks,
DHON
-
- GET.CHART.ITEM
by Jonas.S
- 3 Replies
- Last post
by Jonas.S
- Hi all,
Anyone having a list over point_index which is used in GET.CHART.ITEM()
Regards
\Jonas
-
- Cannot read Office 2007 DVD
by KRFournier
- 4 Replies
- Last post
by KRFournier
- Has anyone experienced the problem of not being able to read the Office 2007 Enterprise installation DVD in a DVD R/RW drive. So far, three drives I've tested cannot read the disc. No error message. Nothing. The drive spins a little, but never sees it. I cannot access the drive through Explorer either. I've even updated the firmware. My drive's are all Lite-On drives, so I don't know if that has a
-
- adding text to cell with vba script
by Derek at Potters Clay
- 5 Replies
- Last post
by magicalclick
- I've done this before but I am completely blanking on what I am doing wrong with adding text or in this case a formula to a cell. The line I have and am getting an error on is
Workbooks("DSL Annual Rollup").Worksheets("DSL Annual Rollup").Cells(i, 3)="January!D"&i&"February!D"&i&"March!D"&i&"April!D"&i&a
-
- Using Paste in the File Save as window
by smith69085
- 4 Replies
- Last post
by Andy Pope
- Hi all I only know a little about VB but have made a form on word that copys a word from the document saves itself to a folder prints a copy and then exits word. it all works fine except i cannot get it to paste the word from the document in the fileName when it saves. The script is below with red showing the problem. Any help on this would be much apreciated
Mark
Sub Process() ' ' Process j
-
- Compile rrror: syntax error
by gibger
- 5 Replies
- Last post
by gibger
- Hi,
When I run the following code:
Code Snippet
Private Sub btnClickMe_Click() Dim intrandom As Integer Dim index Dim person Dim match As Boolean Dim personx Dim persony Dim n Dim birthday() Dim counter match = False ReDim Preserve birthday(23) intrandom = (Rnd * 364) + 1
Randomize
counter = 0
For n = 1 To 100 For persony = 1 To 23 birthday(person) = in
-
- Access Forms
by PC Geek
- 4 Replies
- Last post
by stlarmon
- hi, Ive got a form, in MS Access and its a group control, which means it can only output integers. I need a little code to attach to the form, so that the text field which its bound to, actually gets the text. eg, if i select "before 2000" on the field, then the database would get "before 200" instead of somethign like 6 etc. i hope im explaining this clearly. Im wondering if s
-
- need help for an array macro in word
by crazyfisherrr
- 2 Replies
- Last post
by crazyfisherrr
- Dear all, I am a beginner of VBA programming and I have some problems with an array macro,plz help !!! the array stores student ID and student Name and the macro will enable me to enter the student ID and student Mark in a form, and it will show up " student *** has a mark of ***". this is my script: Public arStuID(8) As String Public arStudMark(8) As Integer Sub startit() arStuID(1) =
-
- include crm3.0 accounts page in an IFrame
by einish
- 8 Replies
- Last post
by einish
- I have a web solution developed in framework 1.1 and using crm 1.2
I'm migrating from crm 1.2 to crm 3.0 and I faced the following problem.
I used to display this page http://<server name>/SFA/home_accts.aspx in an IFrame in my website to display all accounts same for contacts i used http://<server name>/SFA/home_conts.aspx In CRM 3.0 I cant find the corresponding pages. o
-
- 2 Small Macro problems.
by GB Allan
- 6 Replies
- Last post
by GB Allan
- Hi all,
Problem 1:
I am trying to delete a sheet within a workbook, as part of macro. Here's the code:
Sub DeleteInstructions() ' ' DeleteInstructions Macro ' Macro recorded 3/13/2007 by Gary Beckwith '
' Sheets("INSTRUCTIONS").Select ActiveWindow.SelectedSheets.Delete Sheets("DATA").Select End Sub
When I run it, I get the prompt "Data may exist in the
-
- Trouble while dealing with Share Point Object Model
by Moim Hossain
- 14 Replies
- Last post
by WebDev2000
- Hello everybody,
I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application int
-
- inserting row in excel
by Cammyr
- 2 Replies
- Last post
by Cammyr
- I'm using vb.net express to call excel with this code
Private Sub Button3_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim XL As Excel.Application
Dim xlwb As Excel.Workbook
Dim xlsheet As Excel.Worksheet
XL = New Excel.Application
xlwb = XL.Workbooks.Open( "C:\Documents and Settings\S. Ross\My Docume
-
- 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
-
- Sorting cells in a spreadsheet by colour
by Josh Ord-Hume
- 7 Replies
- Last post
by crainsworth
- My apologies if I am asking this question in completely the wrong forum. I am trying to create a VBA macro that will order data in an Excel spreadsheet according to colour (so that like colours are all grouped together). I wonder if somebody would be kind enough to spend some time explaining how to do this to a more or less complete VBA novice! Many thanks...
Josh Ord-Hume
-
- MS Exchange Migration
by keithpsft
- 1 Replies
- Last post
by MS ISV Buddy Team
- I am currently working for a small business (~20 ppl), and we are attempting to do an Exchange migration in order to upgrade the server running Exchange. Both of the servers will be running Windows Small Business Server 2003 Premium.
We have tried using NTBackup and NTRecover. However, we cannot get the databases to mount.
I have several questions regarding this migration. When the database
-
- Get Current Slide Number And Insert a New Slide
by paradigm918
- 2 Replies
- Last post
by paradigm918
- I've recorded a macro to perform certain formating to slides in a ppt 2003 show.
I would like to enhance it by having it insert a new slide after the current slide (as the standard action with CTRL+M)
When I record the macro, however, the slide number being inserted is
hardcoded - I want the macro to insert after the now current slide.
When I record inserting after slide #2, the ap
-
- VBA In Excel - AD scripting
by You Chun
- 0 Replies
- Last post
by You Chun
- Hi guys,
Just a quick question, hope I'm in the correct area.
I'm doing VBA in excel, pulling data from the Active Directory to check and populate certain data.
All my querying was fine, except for this particular query, which has above 1500(probably about 3000-4000) members in it.
When i use:-
For Each Group In objComputer.GetEx("member"), it only man
-
- Display a TextBox or Non-modal Message Box
by sg549
- 6 Replies
- Last post
by Andy Pope
- Hi all. What I'm trying to do is put up a user form with a text box while a process is running. I don't need a progress bar, as the process is not that long. I have created a userform that includes a textbox, but only the userform comes up when I ".show" it. Why won't the text box portion of the userform show
Alternatively, is it possible to put up a "non-modal" system
-
- randomizing the contents of Excel cells
by Josh Ord-Hume
- 6 Replies
- Last post
by PYA_Ferro
- I am trying to create an Excel macro that will look at the contents of cells A1, B1 and C1 and 'randomize' their order. So, if the contents of A1, B1 and C1 are "1", "2" and "3" respectively, they might end up as " 2 ", " 3 ", " 1 " or " 1 ", " 3 ", " 2 " once the macro has been run. Any ideas gratefully rece
-
- Creating a dynamic hyperlink to a worksheet cell in Excel using VBA
by Justus Beek
- 6 Replies
- Last post
by Cringing Dragon
- I would like to add a hyperlink that refers to a cell within a worksheet and I would like to do this dynamically.
As an example:
Sheets("Sheet1").Hyperlinks.Add Anchor:=Sheets("sheet1").Cells(1,2), Address:="", SubAddress:= _ "'sheet2'!A1", TextToDisplay:="Back <<"
This works.
But now I would like to assi