Answer Questions

• SebaM ftp using vba

  I hope I am posting this to the right place. I am trying to do a save as to an ftp location. The following works ....but... I have to establish the ftp connect each time the computer is started, So somehow I need to establish the Initial ftp connection within the code.. And once the save as is done I need the ftp connection to be stoped so that it does not remain open In short the need is to open an ftp location save the file to the loc ...Show All

• dholt XP style appearance

  hiya this might be the wrongplace to ask this question but on the computer the other day one of my kids deleted the windows xp appearance so all we are left with now is the rubbis windows classic appearance which is very boring i was wondering if anyone knew how you can reinstall or download the windows xp style appearance thanks phill phils right, ur reply was not helpful, i also accidentally deleted the w ...Show All

• wbradney Select line of text in Word documents

  How can I "Select a line of text in Word documents" to futher manipulate it I figured how to do individual Words, but I'd like to select a line ot text containing a certain word. Not too sure how to select a line of text, but this will select the sentence containing the word: Sub SelectSentence() Dim oDoc As Word.Document Set oDoc = Documents.Open("C:\documents and settings\mydocument") With Selection.F ...Show All

• Stan Spotts What is Team Suite Trial Edition?

  I'm looking at the MSDN subscription downloads and I can see a Team Suite Trial Edition as an Empower subscriber.  However there are no details on how long the trial lasts   Anyone enlighten me It takes hours to download these things so I'd rather know first.  Also since we are already saddened to know that empower people won't get Team System and its looking like even if we certify we won't necessarily get it, is it worth prolon ...Show All

• Toby Sharp Macros - Excel

  Hi, I have made a macro for a project which i am working on. I have to run this macro every week on different files. These files have names which include the date of the data. Now without overwriting this file i want to run the macro but want the date of this file to be included in the final file which i have made. Is there anyway to do this for eg: Data file : Name : ABC 10-3-06 i want the final output files name to be : XYZ 10-3-0 ...Show All

• snipexv Architecture - what it is and what it will be

  As an initial discussion which can be helpful to all of us I would like to hear opinions of my colleagues regarding the basic question of just what is Architecture and what we would like it to be in the future. Regards, Behzad Hi there, this is a good question. Architecture to me is like a layered blue print of software. By layered I mean it can have different levels of abstraction. For example the top level could describe how c ...Show All

• WikiServer Guy inputbox method and ranges

  I am having trouble assigning the range given by an inputbox method to the variable targetcells, and subsequently selecting targetcells. any help would be most appreciated. Dim i As Integer Dim CopyCells As Range 'the cells into which links will be copied Dim TargetCells As Range 'the cells that copycells will be linked to Dim CopyAddress As Variant 'the address of the copycells Dim TargetAddress As Variant 'the address of the targetaddress ...Show All

• Julien Gourdet SOPRA Control of graphs and organization charts

  Greetings to all! How can one control properties and methods of graphs and organizations charts For example, I am trying to change the background colour of  a graph in a Powerpoint slide through a Macro command, or modify any kind of object in an organization chart. I am guessing I need to create a reference to the graph object and then access its properties through it, but have been unable to do so. Thanks in advance for any help or s ...Show All

• Orjan Lindberg VBA in Office 12

  Could anyone show some information about VBA in Office 12 Does Microsoft support VBA in Office 12 Are there have any new features or improvements Thank you in advance!   Hi Julian, While we are investing in our VBA support in O12, the VBA IDE has not been a major area of investment for us this release. That said, what “updating” are you looking for Is there something specific -brenda (ISV Buddy Team) I am unclear ...Show All

• karabo Excel memory issues

  Hello everyone, I have been involved in the development in a graphical user interface which is used to sort large amounts of data, (thousands of rows, 30 columns). After sorting the data according to required ranges on column data, the columns can be plotted with any column against any other column. The number of plots can reach the hundreds and are displayed in a half-sqaure fashion. Anyway, I originally needed only 10,000 or so rows of ...Show All

• dirkb Form Requery

  I have a command button on a form to create new records for the data shown on the form. When the code finished I want the form to have the new record available. I have this code at the end of the button code: Forms("frmDocumentDetail").Requery It does not work. The records do not update unless I exit the form or do something like hit the sort records button. TimD Sure, I have a form that displays ...Show All

• nirmal_babu Application in the Task Bar

  Does any one explain why the application is not shown in the task bar if the form is shown modally. Is there a better way of handling the code without showing the form modally Thanks Shasur, I've escalated your question to our support team.  It might be delayed with our Thanksgiving holiday weekend, but I will post their response as soon as possible. If anyone else here can answer this question more quickly, please jump in! -b ...Show All

• Dwayne Schaffarz VBA source code

  Hi all. I need to do my final year project in Excel using VBA. The project is in such a way that i can generate curves using Excel. I have been searching for the samples source code for cosine, sine and FFT source code, but to no avail. Could anyne please advise me on this I am a newbie to VBA, so i'm rather lost now.. Thanks in advance. in the VBA Help Dim MyAngle, MySecant MyAngle = 1.3    ' ...Show All

• N3vik VBA and VB

  Hello I am not not whether VBA can be used to build stand-alone programs, or the programs built using VBA have to be attached to Office product Thx Yuelin You can not write a standalone app without having the related developed Office application. You can create a Add-In or depending on which app, a xla, dot, etc. but you cant do anything without having the Office application unless you just wa ...Show All

• appler Changing chart series

  Hi Can anyone point me in the right direction on working with Charts in Excel. I have a workbork with five pages, each page has many charts, each chart has three series. I had specified a range well beyond the data, the blank cells did not appear on the charts, and the charts updated automatically as data was entered. The data page has changed, now I need to set the ranges each time. I know the final column for each series, how can I scrol ...Show All