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 wOOdy-Soft 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: paulo33
  • Content: Threads
  • Order by date
  1. paulo33

    Greeting message problems

    Hello, I am trying to connect to a server, but it's on a line that has a greeting message when it answers, and wants you to hold on before starting the connection. My problem is that my modem does not recognize this message, and disconnects before it receives any tone. Does anybody know how to...
  2. paulo33

    Excel 2000: Printing in grayscale

    I am using excel 2000, office 2000, and an HP Laserjet 400 printer. I am trying to print grey chracters, but they come out black. I´ve already tried modyfing many settings, but I can´t make my characters come out grey. I already checked, and I can print a grey box, for example, but not grey...
  3. paulo33

    Cell formatting bug

    Anybody know why a cell in Excel will not want to format?? I have a spreadsheet with data I have imported from a database. The spreadheet is not protected, of course. Either rightclick -> format cells, or Format -> Cells, just do not work, it doesn´t do anything!! Help please, this seems like...
  4. paulo33

    VBA recognizing empty cells in excel

    Does anybody know how to make VBA check for empty cells in excel?? I have a bit of code that searches recursively until it finds the first ocurrence of cell = Null or cell = "" and then assigns this rownumber to a variable. When I refer to this variable r, the first time, it works...
  5. paulo33

    Check for already opened workbook in excel, using VBA

    Is there a way for VBA code to check if a particular excel workbook is already open?? Thanks for any help!
  6. paulo33

    Refering to workbooks using a variable

    Anybody know how to refer to a workbook, using a variable?? My procedure asks the user to input the name of the excel workbook to open, asigns this filename to a variable, and opens it. Then I need to call this opened workbook, from the original procedure, but I don´t know how to refer to it...
  7. paulo33

    Getting a full FilePath from a user

    Does anybody know how to get a valid, full filepath from a user. i.e. Getting the user to browse through the 'SaveAs' dialog box, chose an appropiate file, and that the chosen file is returned as a full-filepath, not just a file name. thanks
  8. paulo33

    Checking valid filepaths

    I have some code in VBA that looks for a file, and then opens it. Does anybody know of a way to check if the file exists/filepath is valid, before trying to open the file, so as to not produce an error? thanks
  9. paulo33

    Referring to Variable Ranges in VBA for Excel

    I am trying to write some code that will count the number of total rows in a particuar sheet, and then delete the data in them, but only for some of the columns. The counting bit was easy just setting a variable equal to: UsedRange.Rows.Count However, when I try to reference a Range wichi...

Part and Inventory Search

Back
Top