Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Smoothas
  • Content: Threads
  • Order by date
  1. Smoothas

    Time sensitive hyperlink. Is it possable ?

    Hello, I'm trying to write a webpage that will create a time sensitive hyperlink to a document. Once the time is up, then access to that document via that link is lost ( possably with an error message page instead of the document ). A new link can be requested to the same file ( by going...
  2. Smoothas

    Help: Selections in HTML form to wite .doc

    Hello, I'me trying to find out if its possable for a webpages form ( consising of YES and NO options ) to construct a Word Document for download based on the users selections. I've already had help in contruction something similar ( creating a xml file via PHP code, and a page that displays...
  3. Smoothas

    Post an XML file to a URL via PHP

    Hello again. Please can someone help me with code that will pharse an XML file ( test.xml ) to an URL ( www.testwebsite.com/search.asmx ). Thanks
  4. Smoothas

    Display World Wide Web Consortium time/date in XML file

    Hello, I'm trying to display World Wide Web Consortium time and date into an xml file. I've been trying mktime() and getdate(), but I'm not getting the format i require :- 2009-10-01T16:16:59.0156250+01:00 Can anyone help ? Thanks
  5. Smoothas

    ASP to PHP

    Hello, I new to PHP, but I need to use it as my current ISP dosn't support ASP pages ( and i cannot change ISPs at the moment). I've trying to get web input from a standard HTML form page and convert it into an XML file to past to a datbase to interrogate, which will then supply a result back...
  6. Smoothas

    Terminal server session has no keyboard input

    Hello, recently I've had calls saying that people have been trying to connect to our Terminal Services server, but "nothing is coming out" when they type in there password / username. This is "fixed" by minimizing the TS screen (from Full Screen) and then maximizing again. Nothing has changed...
  7. Smoothas

    Problem with SaveAs function

    Hello again, I have a macro that tries to save an imported RTF file to xls, with the date added to the end. Everything looks ok, but when I run it and click the SAVE button, it dosn't get saved in that location. I've tried other locations, and get the same result ( I have admin access to the...
  8. Smoothas

    SUMPRODUCT formula problem

    Hello again, One of the very helpful Forum Members (Skip) told me how to code a SUMPRODUCT formula to check Column A for one Variable, and another Column for yet another variable, and then sum up yet another different column, ie :- =SUMPRODUCT((A1:A64999="LONLB")*(I1:I64999<>0)*(G2:G65000))...
  9. Smoothas

    error 13 while running MAcro

    Hello, I got pruned this macro out of one I current use. IT traverses the spreadsheet and appends the cell to the one above if eveything else on the row is empty. However, when I runn the pruned version, it completes the sheet, but I then get :- Run time error "13" Type mismatch the macro is...
  10. Smoothas

    Sum of values where another column meets criteria

    Hello I have a spreadsheet were Column A contains peoples names , and column G contains a number. I'm trying to figure out a way of "summing" the cells in column G with the coresponding cell in Column A is NOT blank. I've tried the SUMIF and SUMPRODUCT commands, but all I seem to get is #NULL...
  11. Smoothas

    Excel LookUp (Financial)

    Hello Im having a problem with my lookup formula which i have used for looking up a cell referance to the date plus one cell to the right. for eg. the part im stuck on is when i want it to reference to A1, but bring back data in cell B3 instead of A3. A B C...
  12. Smoothas

    How do I compare 2 cells in 2 spreadsheets,causing conditional format

    Hello, I have 2 spreadsheets ( Spreadsheet A and Spreadsheet B). Spreadsheet A has lots of infromation in it ( one person per row ). There are 2 columns I am intrested in: Column B lists the persons unique ID, while Column G list there cash balance. Spreadsheet B lists the Unique ID ( In...
  13. Smoothas

    Terminal Server - Word 2000 - Startup Folder location change

    Hello, I'm new to Terminal Server, and I was trying to change all Terminal server users Word Startup folder location to point to a shared folder that contains a .DOT file containing AutoText settings, but I'm not have any luck in doing this. Please can someone tell me what I need to do to do...
  14. Smoothas

    Repeat MAcro Till end of File

    Hello, I have written a HUGE macro to import a RTF file and adjust colunms etc, but what I am now looking to do is traverse this spreadsheet, and append the content of certains cells to the cell above, then delete the orignal cell, till the end of the data is reached. I Done part of that(...
  15. Smoothas

    Windows 2003 server and Office 2000 Pro error messgaes on Boot

    Hello, I have recently started a new job, and one of the servers is a windows 2003 server, running as a Terminal Services, that has Office 2000 pro load onto it ( what method they used to itstall it , I do not know ). Everytime the server reboots ( there is a nightly schedualed task that...
  16. Smoothas

    Teminal Services on Windows Server 2003 and Outlook 2000 Hanging

    HI, I'm new to Terminal Services on a Windows 2003, so please bear with me. I have users that save emails as .MSG files so they can attach them to customer program package. Click on the Link opens up Outlook 2000, eventually, but when the message has been read, we get the "Please wait while...
  17. Smoothas

    Word Mail Merge &quot;Too Many Data fields&quot;

    Hello again. I've been writing a word macro to merge 2 excels files into 2 word documents, and it has been running fine with my test spreadsheet. Yesterday however, I get the following message when running the Word Macro :- Record 384 contained to mant data fields In the past, it just wrote...
  18. Smoothas

    Count Merged Records

    Hello, I;ve created a word macro that opens a label template, selects record source, and performs the merge. What I would now like to do , it add a message box that tells me how many records were merged / labels were created. I got it to count the number of pages using :- MsgBox...
  19. Smoothas

    Change Save to Directory depending on Month

    Hello, I've got a set of dir's labeled 07-01 January Stickers 07-02 February Stickers etc and i'm currently using the following code ( thanks to help from Combo ) Sub SaveStickers() Dim strFileB Const sPATH As String = "\\Solaris\Operations\Clients\Stickers\" Const sFILE As String =...
  20. Smoothas

    How to save an Excel File with yesterdays date?

    Hello, I have the following macro that saves the current excel file in a specific location, with todays date in the file name. Great. BUT, I'm trying to get it to save with yesterdays date. I've tried assigning variables and the like, but no luck. Can anyone else shed any light for me. The...

Part and Inventory Search

Back
Top