-
- Remove Spacing
by tclaus8
- 2 Replies
- Last post
by Duane in Japan
- Ok, i need to check to see if there is a space at the end of a word like, "hello " instead of "hello". I know there is code to take off the spaces at the end if they exist. Can any1 help me out here
-
- is it possible to write a function that returns a list of items?
by Maximus
- 2 Replies
- Last post
by Maximus
- I wonder if it's possible to do something like this: on cell A1 user writes =getList() and to get a list of numbers between 1..10 (on cells A2...A12, or A1..A10). In other words, the function returns some a list of numbers that are not in one particular cell. thank you!
-
- 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
-
- GroupBoard Workspace 2007
by AnhVu
- 1 Replies
- Last post
by MS ISV Buddy Team
- Hi I'm using GroupBoard 2007 and I feel it great application. But I can't modify some function if my customer require. In page Newform.aspx, I don't want "OK" button allow submit if time user choice coincide with time in free/busy board. Please help me! thanks
-
- Need help writting a script similar to...
by jdwilliams543
- 5 Replies
- Last post
by Derek Smyth
- Sub CommandButton2_Click Me.Textbox7.Text = My.Computer.Filesystem.ReadAllText("C:\info.txt") End Sub I'm a newbie at VB all around, thought that the My namespace was part of the VBA build. I have no clue how to write this kind of script in VBA. Basicall, I have a file (C:\info.txt) that I need to copy all of the info in this file into a textbox (textbox7 to be exact) on the form when
-
- Problem with converting numbers stored as text in excel.
by Mr T
- 6 Replies
- Last post
by MyLady
- Hi,
I'm trying to make a macro that converts numbers that are stored in textformat for example "1.987,00 kr" to normal numbers so I can process them further. To accomplish this I am trying to replace the . with nothing.
When doing this manually in excel it all works fine but when I let the macro do it for me I a get really wierd outcome. when doing it manually the above example tur
-
- is it possible to write a function that returns a list of items?
by Maximus
- 2 Replies
- Last post
by Maximus
- I wonder if it's possible to do something like this: on cell A1 user writes =getList() and to get a list of numbers between 1..10 (on cells A2...A12, or A1..A10). In other words, the function returns some a list of numbers that are not in one particular cell. thank you!
-
- How to change part of an array value in Excel
by Gnanaprakash
- 1 Replies
- Last post
by MS ISV Buddy Team
- Hi ,
Pls any body can tell me How to change part of an array value .If i try to change array value "Microsoft Excel" popups a dialog stating "You cannot change part of an array."
Somebody have mention to use "Ctrl+Shift+Enter" but this will change entire array value.So I need a change a specific cell value.
Code:
Function parseArrayData(arrayData As String
-
- Projects, objects & modules
by une
- 14 Replies
- Last post
by une
- I
started learning VBA in MS Word yesterday. I have some programming
experience in C++ and Java. I am trying to understand how the
environment is structured and what Projects, Objects and Modules
represent.
For example I recorded a few macros using the macro recorder and
then opened the VB Editor to see what was created. I notice that under
"Project" are 3
folders. One is named
-
- calling sub within function. works fine as sub, but not in function
by pacificwaters
- 11 Replies
- Last post
by pacificwaters
- Using VB 6.3.
Trying to call a sub within a function, and when I call it in Excel via User-Defined-Function, it doesn't work.
But when I do 'F8' to step into the code of the sub, it works fine: Public function functionEXE(...) call cellref end function
Sub cellref() ' If I 'F8' and step into the code from here, it works fine. But when I execute the functionEXE on sheet.x
-
- Macro to convert text to hyperlink
by uma_unnikrishnan
- 1 Replies
- Last post
by Shasur
- Hello All,
I have some text that I export from a tool into Word..however this tool does not export hyperlinks as hyperlinks and hence I would have to convert the text in Word to hyperlinks.. I realize that this can possibly be done with macros..however am not in to macros and do not have much time to meddle with it.. so was just wondering if I can hold of a macro that I can use to search fo
-
- calling sub within function. works fine as sub, but not in function
by pacificwaters
- 11 Replies
- Last post
by pacificwaters
- Using VB 6.3.
Trying to call a sub within a function, and when I call it in Excel via User-Defined-Function, it doesn't work.
But when I do 'F8' to step into the code of the sub, it works fine: Public function functionEXE(...) call cellref end function
Sub cellref() ' If I 'F8' and step into the code from here, it works fine. But when I execute the functionEXE on sheet.x
-
- Microsoft Office Document Imaging Printer Missing in Office 2007 (RFP) (86)
by rjo2
- 11 Replies
- Last post
by andria72
- Can anyone tell me how to install Microsoft Office Document Imaging Printer in Office 2007 (RFP). Although the Imaging program installs, the Printer does not, and the Microsoft Office 2007 Professional (86) Installer say that it is not an available feature.
-
- Why my AddIns runs only once!?
by Awsok
- 3 Replies
- Last post
by bi-lya
- Hi All,
I made 6 VBA Excel macro using Visual Basic Editor from within Excel, but after deploying the AddIns, my AddIns run only once and stop!!
Here are the details:
I made 6 macros and wanted to share them with my colleagues at work, in what I call it Add In library.
I assigned shortcuts to the 6 Macros as follows
Lnk2DB() (" Ctrl+Shift+a ")
CHS
-
- Copying and Deleting the duplicate records in an excel sheet and Copying the same Deleted records into another sheet
by bharat baradia
- 4 Replies
- Last post
by magicalclick
- hi,
i want to delete the duplicate rows in the excel sheet and copy the same deleted records into another excel sheet by using Macro's . This should be possible even when i am selecting two columns for checking duplicates and even if one of the column is repeated ( is duplicate) it should be considered as a duplicate.
-
- How can I activate worksheet when open a user form?
by lyp_sj
- 3 Replies
- Last post
by Andy Pope
- Hello,
I used a user form to control several macro command. While after I poped out this user form, I could not activate any worksheets and modify my data. Do you know how I can activate worksheet when opening a user form
Thanks so much!
B.regards/Yaping
-
- BSM 2005 Server Installation Failed
by Jayaprakash Lingamaneni
- 1 Replies
- Last post
by MS ISV Buddy Team
- Hi All
We are trying to install Business Scorecard Manager 2005 Single Server Installation. We are getting error "Failed Microsoft Sharepoint Extended Site".
We can able to create a new website and extend another web site from Central Administration.
Please help me how to fix this error
-
- Using DCount function in a Report group footer
by LizF@RMIT
- 6 Replies
- Last post
by Cringing Dragon
- Hi,
I'm having trouble getting a DCount function to work on an MSAccess 2003 report.
I'm using a text box in a group footer - I want it to show a count of the number of distinct records in the group.
Here's what I'm using - which produces the result of '#Error' with no further help.:
=DCount("Task ID","Tasks","TaskID IN (SELECT DISTINCT TaskID FROM
-
- Macro running slowly when run from button
by Gus the Snail
- 4 Replies
- Last post
by Gus the Snail
- Hi there
I have a curious situation. I have written a macro in VBA for excel 2003 which, from a master workbook scrolls through 46 other workbooks, opening each one in turn and copying/pasting a number of ranges. It then saves and closes the workbook and moves on to the next. When I execute this macro from within the VBA editor, it runs quite quickly (about 5 seconds per sheet, which is acc
-
- Bucket ID 8, event type
by Claus Brod
- 14 Replies
- Last post
by DHON
- Hi all, on my Vista system, I generated a lot of crash reports using WER-aware code (i.e. code which explicitly uses WerReportCreate() and WerReportSubmit()). When I look at those crash reports in the Problem History window, I find that many of those crash reports have a bucket ID of 8. This doesn't look like a bucket ID as it would be assigned for a crash report which makes it to the Winqual site
-
- 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
-
- Setting properties
by une
- 4 Replies
- Last post
by une
- It seems that there are two ways to set a property. Using the example of a label on a userform, the property for it's initial caption and colour can be set by editing the appropriate fields in the properties window. That is easy, but these initial settings do not show up in any code on the userform. How could the initial settings for the caption and colour properties of the label be set via code i
-
- Copy spreadsheet data to csv format
by YYeung
- 1 Replies
- Last post
by Shasur
- How can I want to export the spreadsheet data to the csv format by using vlookup function. For instance: When vlookup "AA", 1,2,3,4,5 in spreadsheet will be extracted to 1,2,3,4,5 in cvs.format. Thanks
-
- Powerpoint VBA ¨C Animate Text ¨C Seconds delay between letters
by NME1963
- 0 Replies
- Last post
by NME1963
- IĦŻm trying to set up an interactive sequence item that displays characters one letter at a time. The code below works well to achieve this, but does anyone know how to set Ħ° seconds delay between lettersĦħ (or words - or % delay between letters if another msoAnimEffect is chosen). I seem to be able to set every timing/animation feature except this one!!!
Any help would be very much apreciat
-
- Word 2003 AutoOpen Macro doesn't run if Outlook 2003 is open.
by aliank
- 5 Replies
- Last post
by bi-lya
- Good day experts, I written a word template with AutoOpen macro in order to load an object that will update footnote of the word document when user save the document. It works well when outlook is not loaded. But once outlook is loaded, the AutoOpen macro did not run anymore. If I open the document without opening outlook first, then automacro is working fine. But if I open the Outlook and then o