Answer Questions
Raffaele Rialdi Help with comma separated values in report
Hi! A bit of a stuck-up. It’s no problem in creating a coma separated fields in .txt kind of file. But I have another problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line. If anybody is familiar with the solution just show me the direction and I’ll try to solve it by myself. Thanks in advance This works for me. Option Compare Database Private Sub Odpri_cmrjizafakturo_Click() Dim dbs As Database Dim rs As DAO.Recordset Dim fakture As Form Dim tfakture As String Dim strsql As String Dim firstrec As Boole ...Show All
Jon Stroh Automatically send attachment in email with a submit command button in word
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 As String Set Email = CreateObject("Outlook.Application") 'Assign Outlook application to variable With Email.CreateItem(olMailItem) .to = "<>" 'email address .Subject = "Incident Report" 'Something for the subject Field .body = ActiveDocument .Display = Attachment Options.SendMailAttach = True End Wi ...Show All
notadog Trouble while dealing with Share Point Object Model
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 into the same machine where the SharePoint 2007 is installed). The application was retrieving the Document from the SharePoint 2007 as expected but the trouble raised when it was trying to connect with the SharePoint 2003. The error was The Web Application at could not be found. Verify that you have typed the URL correctly. If the URL sh ...Show All
CACUser MS Office document and image writer print driver
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 the MS Ofc doc and image writer printer. Per our support engineer: Thanks for using ISV Community Forum, according to your problem, I’m wondering whether you can simply log on the machine as administrator and delete the virtual printer (just select the icon and press del key) in Control Panel -> Printer ...Show All
djchapin Adobe Reader 7.0 and VBA
Hello to everyone, I need to know if anyone knows the answer to the following question. Is it possible, using VBA, to open and view a PDF document using Adobe Acrobat Reader 7.0 or is it only possible using DDE I have posted previously with same code which works if the user has Adobe Acrobat Standard 7.0 installed but no replies. If anyone has done this I would be grateful for a link to sample VBA code. A number of sites say yes with Reader 7.0 but I don't know what Type Library/Object Model to use. Hopefully someone out there has done this before. Thanks for any help given Robert, Eduinburgh ...Show All
Sam Johnson can you help ?
Hi, I have an error in my vba application. It occours only in excel 2003, but not in 2000. Its a: "Application-defined or object-defined error" Error code 1004 In the follwoing method the error occurs: Public Function SaveResultsToExcelSheet(RangeOfValues As Range, ValuesArray() As Double) As Boolean On Error GoTo Error: SaveResultsToExcelSheet = True Dim OutputSheet As Worksheet Dim OutputCell As Range Dim Counter As Long Counter = 0 For Each OutputCell In RangeOfValues OutputCell.value = ValuesArray(Counter) Counter = Counter + 1 Next OutputCell Exit Function Error: Err.Clear SaveResultsToExcelSheet = False End Function The error occurs in the line "OutputCell.value = ValuesArray(Counter ...Show All
katykitten04 Converting text file to excel file macro - help needed
I have a text file I need to convert to an excel spreadsheet. I wouldn't have a problem making an array code if it were a straight file but the trick is that each line could be different. For example: Line one is 01330948951000312 eeid jan boerenkamp line 2 is 023330948951000312 00370058274800350010112/01/2002 Line 3 is 05330948951000312 31065327123107533811 any time a line begins with 01 it will follow that format any time a line begins with 02 it will follow the format of line 2 and so on Is there a way to make an array to put into Excel so that if a line starts with 01 it splits it one way and if a line begins with 02 it splits another way and so on Thanks in advance ...Show All
MNJ&#40;m-studio&#41; ERROR RUNNING MARCO
hi can anyone help me with this problem Hi can anyone help me with this problem I have this dos script to pass down a parameter upon opening the excel @echo off start excel "\\136.121.2.1\its helpdesk\ConRisk\RSP Concentration Risk Calculation.xls" /e/8212305557 Is there any code to capture the parameter "8212305557" on the excel macro upon opening here is my code Option Base 1 Private Declare Function GetCommandLineA Lib "Kernel32" () As String Dim CmdLine As String 'command-line string Dim Args As Variant Dim ArgCount As Integer 'number of parameters Dim Pos1 As Integer, Pos2 As Integer Dim sMsg As String Dim Customercode As String CmdLine = GetCommandLineA 'get the cmd-line string Cm ...Show All
nielsvanvliet Office 97 / Windows 2000 Compatability
Im having trouble referencing Office 97 objects in Windows 2000. I'm in Word 97 and trying to set my object appWord to equal a new word application. My code is: Dim appWord As Word.Application Dim docCP As Word.Document Set appWord = New Word.Application Set docCP = appWord.Documents.Open(OutputDirectory & FileName, False, False, False) However on running I get a prompt telling me the document can not be found. This code errors on the line Set appWord = New Word.Application not where the application sets the filepath and name. I get a similar problem when using he same method for Excel only the message I get is around a missing DLL but its doesn't tell me which one. If anyone could shed any light on this id ...Show All
rajesh_batchu Completly Lost with Data Validation Code
I am trying to write a small script which will allow for multiple choices to be selected from a dropdown list, but for ONLY the dropdown list to accept input (ie data protection). I had asked for help before, and the nice people at Contextures sent me to their site to download one of their spreadsheets (dv0017 http://www.contextures.com/excelfiles.html). I have been looking at the code, and I am clearly in over my head. The code is below. Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String Dim newVal As String 'I think this means that if there is more than one cell selected, then exit If Target.Count > 1 Then GoTo exitHandler On Error Resume Next 'Absolutely no clue here. I have read a few di ...Show All
norm at atlas worksheet_change and data validation
Hi there I have an Excel spreadsheet in which one column has data validation set. So the cells in this column have drop-down lists with the pre-set allowed values. Now I want the cell in the neighboring column to be set to some default value when the user selects an item from the drop-down list. This seemed like it would be easy, using the Worksheet_Change event handler. When a cell in the first column is changed, it initiates a function which sets the value in the neighboring column to some default value: Target.Offset(0,1).Value = "default". The problem is that it doesn't work when using the drop-down list. If the user types in the value manually, or if a cell in the first column is deleted, it DOES fil ...Show All
Mazeno Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset
I was working on another problem and reset my advanced options. After all my jpeg and gifs now are fuzzy when displaying in only internet explorer 7.0.5730.11 all other programs display normal. I've been seeing some of the same issues with specific laptop configurations using only IE7. Also the zoom level has no affect worse or better for the problem. You might try checking the zoom level you have set in the bottom right of the status bar of IE. See if setting to 100% fixes the issue. -brenda (ISV Buddy Team) i'm having a similar problem. did you happen to find out the answer zoom change doesn't seem to help me. also had the same problem with new Del ...Show All
Eddie Garcia Adding a command button to the toolbar or menu bar in Excel?
Hi I'm wondering is it possible to add a command button to the toolbar or menu bar in Excel using VBA I came across an excel file before in work that somebody had setup this way but not sure how to go about it! I basically have two buttons that I would like to have added to the toolbar or menu to make the sheet tidier and enable the user to see all the data without having to move the buttons etc. http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_buttons.jpg Any ideas folks Thanks, Scott I actually managed to get it working after many hours of trying! But much more satisfaction when u are able to do it on your own! :) So i added this code into one module... ' ...Show All
Ronaldlee Ejalu Using combobox in Excel
H i there, I'm working on an engineering spreadsheet (Excel) and need some help in manipulating comboboxes / dropdown list. Say i have 2 list, where list A has the list of countries and list B has the list of cities for the country chose. If all the data source (i.e. countries and cities) are to be extracted from the Excel spreadsheet, is it possible to make list B dependant on list A (that is to say when user selects a country in list A, list B will automatically gives the respective cities) WITHOUT creating a userform If so, please advise how. Hope you can understand what i'm trying to ask here. Fyi i have minimum VB knowledge so a "dummyproof" explaination would be really ...Show All
Mart Tapp Updating text in a text box on an Excel Graph
I am automating a spreadsheet, designed by someone else, which has 18 graphs on a worksheet. Most of these graphs have a text box on them which indicates the week commencing that the graph refers to. The text box appears to be a shape object on the chart. I want to loop through each chart on the sheet, then loop through each shape on the chart, and change the text if the shape is a text box. Can anyone put me on the right track, I did try using the macro recorder to get me started but this code does not work in my VBA module. Hi Thanks for the post, the text I want to update is a text box which the user has placed on the charts. It appears to be a shape object. The code that I had from macro rec ...Show All