Answer Questions

• ajpurkiss Using Paste in the File Save as window

  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 jobsheet macro ' Macro recorded 09/01/2007 by Mark Smith ' ActiveDocument.Shapes("Text Box 6").Select Selection.WholeStory Selection.Copy ChangeFileOpenDirectory _ "E:\Global Internet Learning Ltd Files\Duplication Centre\Client Job Sheets\" ActiveDocument.SaveAs FileName:= , FileFormat:= _ wdFormatDocume ...Show All

• jhassing Argument syntax problem

  I have a problem with the syntax of my code. I first have a loop that checks if an object in the selection is a chart. If it is a chart then it passes that chart on to a sub as an argument. In that sub changes are made to the chart in therms of style, size etc. My code: Sub arrayLoop() Dim obj As Object For Each obj In Selection If TypeName(obj) = "ChartObject" Then Call linjeDiagramKnapp(obj.Chart) End If Next End Sub Sub linjeDiagramKnapp(argChart As Object) Dim mySize As Double With argChart.Chart .ApplyCustomType ChartType:=xlUserDefined,TypeName:="Standard" With argChart.Chart .Height = 150 .Width = 150 .Top = 100 .Left = 100 End With My problem is that I do not know how to write the part of the code referring ...Show All

• sarika How do I open CSV using Excel without deleting leading zeros?

  Hello, Whenever I open up a CSV file or a Text file, Excel treats string like 05710 as a number and turn it into 5710. How do I open up a CSV file and still keep the leading zeros Thank you very much. Thanks. But the thing is I don't want to change the CSV file before I open it. I have a loop that populate each cell one by one from the CSV file. But it is not effecient. Thank you for the help. I did that on my current appraoch. I set all cells to Text and populate the cell one by one. So, it is pretty slow compare to Excel default file loader. Excel open up a CSV file in one second. Mine takes a long time depends on number of cells I am populating. I think 10K ...Show All

• ramirogh Creating and Editing Microsoft Access Reports using Visual Basic

  Hi, I am trying to create a report based on the selection from a combo box in a form. i have some data, of which one of the fields is callled "projects". the combo box selects selects a project, and i would like to be able to open a report showing the data that belongs to the specific project on the click of a button. i have written the code below, but the report is only ever blank. i can create a query based on the same sql statement, and it works fine. can someone help Dim thisDB As Database, strSql, projID As String, rpt As Report Set thisDB = CurrentDb projID = existingProjSelector.Value strSql = "SELECT * FROM MyTable WHERE ([PROJECT ID]='" & projID & "') ...Show All

• ffokcuf [Access 2000] Error when importing text files of certain extensions

  Hi all, encountered a problem when converting a Access 97 database to Access 2000. When running functions in certain forms that do importing or exporting of text files, via the Transfertext command, the following error message occurs: "Can't update. Database or object is read-only" This only happens when I import text files that do not have the extensions txt, csv, tab, asc, htm or html. ( http://support.microsoft.com/ kbid=247861 ), including files with no extensions. I've tried to resolve the problem by editing the relevant registry entries mentioned in the MS support page, but it didn't work. Updating to the latest MS Jet 3.5 service pack didn't work also. Has anyone encountered the same problem, and managed ...Show All

• softcon Projects, objects & modules

  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 "Microsoft Word Objects". Within this folder is what looks like a file named "This Document". What does "Project" represent What does "This Document" represent What is the difference between "This Document" and the "Project&q ...Show All

• Khin User form issue

  I am trying to launch a user form from a word document using a command button, but I am getting the following error "Sub or Function not defined." The code for the user form is listed below: Private Sub frmSegment_Initialize() With ListBox1 .AddItem "RNA" .AddItem "ISMC" .AddItem "MHS" End With End Sub Now like I stated earlier I want to be able to launch this userform when a user selects the "launch" command button. And to do that I entered this code for the command button: Private Sub cmdLaunch_Click() frmSegment_Initialize frmSegment.Show End Sub However I am getting that error message. This code happens to be in the "ThisDocument" section while the userfr ...Show All

• Chrisull iexplore.exe - Application Error

  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 I discovered the problem. It was because of Yahoo Toolbar add on. I uninstalled it and now it works fine. Marty I don't use the Yahoo tool bar and I get a similar message when I close Ie 6.. "The instruction at "0x02653812" referenced memory at "0x0277bb2c". The memory could not be read. (All XP updates installed.) Hello bennett1016, You are probab ...Show All

• Michel Racicot Table or Array in the header of an excel sheet

  Hi everyone! I'm trying to add a table or something like this in the header (right part) of an excel sheet in order to align datas ,there are 2 columns with 3 lines. I'd like to have something like that: Name Mr XXX Function Blah Blah Age 24 When I add these as a string, I get something like : Name Mr XXX Function Blah Blah Age 24 Does someone know if it's possible and if it is, how Regards, Christophe. Seems like the alignment is not set correctly Chas ...Show All

• Radith what is wrong with this formula? *9 Views & no one knows?*

  =IF((Weeks!D(B1+6))="",1,2)   whats the error with this D(B1+6) is ment to respresent a cell with D    = the value of B1+6   what am i getting wrong If This Helps The Cell Forumla is Going to Be used this way Sub NamesDropDown_Change() ' check for already inputted data For x = 1 To 7 Cells(x + 2, "K").Forumla = "=IF((Weeks!D(B1+6))="",1,2)" Next x End Sub But currently this formula is not working Hello Milkshake, What I was trying to say was, suppose you had these two bits of code: Code version 1 f Sheets("Weeks").Cells(B1Value + 6, i).Value = "" Then Sheets("Add Details").Cells(x + 2, "G"). Value = 1 ...Show All

• Monah84 Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional

  This problem has been mentioned by many other users (in a different thread subject), so I wanted to start a new thread. I have tried many suggestions, but none have worked for me. My MODI has been a print option for me until just recently. It disappeared from my printers folder. I have repaired, removed, and re-installed Microsoft Office. The MODI will still not appear in the printers folder. Please Help! For the second month running I have noticed MODIW disappearing from Printers and Faxes after using Windows Update With Office 2003 I found that uninstalling the MODIW feature and reinstalling it did not make MODIW return to Printers and Faxes I also found that both the script ...Show All

• Pseudocode Live Communications Server 2005 SP1 - no login accepted from MSN 5.1

  I have installed Live Communication Server 2005 Standard Edition and the SP1 on my win2003standard domain controller and i cannot login from messenger 5.1 as i used to in my old server (win 2003standard + live coomunication server 2005 se sp1). I have check the ports in firewall and with the help of network scanner seems ok . Port 5060/TCP is open. The authentication fails! The message i get is Signing in to SIP Communications Service failed because the sign-in name, username, or password is incorrect, or the authentication service is not compatible with this version of the program.... But when i try to login from the server console itself or with terminal services using the same user/password combination everthing seems ok and ...Show All

• wadnerk Searching / Hilighting OCR text in Office Document and Imaging

  Hi, I have been given following Tasks using MS Document Imaging 11.0 API        Read TIF perform OCR on it        Show it in AxMODI.AxMiDocView    Searching / highlighting text in AxMODI.AxMiDocView using MODI.MiDocSearch class in TIFF file and Highlight search result in the view. 1,2 are Ok but I have not been able to do point 3. Following Is the code I wrote to searching text in the document and but it is not working Can anyone comment on this   Loading File   MODI . Document _MODIDocument = new MODI . Document (); _MODIDocument . Create ( filename ); axMiDocView1 ...Show All

• EtherealSky Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following: Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039) as well, the Alerts won't install because of the message: Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components I understood that this version was compatible with SQL 2005. Any idea how to bypass these checks and install the software properly I got past this hurdle by uninstalling Analysis Services, going through the PTS installation, and reinstalling AS plus SP4. Hi, I've installed all the pre-requisites, including PSTLite.exe, and still ...Show All

• Saiboro Access 2002 Error 2455 - invalid reference to the property Form/Report

  How can I refer to ControlSource property of textbox control of a subreport The reference below ended with the error 2455 - invalid reference to the property Form/Report. It was written in Report_Open event of the main report. or, cannt we refer to the control in a subreport Reports![report_name]![subreport_name].Report![textbox control_name].ControlSource Original object was to set ControlSource of a textbox in a subreport at runtime . When I tried to set ControlSource in Report_Open event procesure of sub report, I received "2191" error - you cannot set the control source property in print preview or after printing has started. Where and when could I set this property Yuko   I h ...Show All