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!

Register Log in
  • Congratulations derfloh 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: *

  1. paulo33

    Greeting message problems

    Thanks for your response Pansophic, could you help me in extending my dial timeout? Should that be a normal setting in my modem? Thanks again!
  2. 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...
  3. paulo33

    Excel 2000: Printing in grayscale

    Already tried printing in 25 different colours, but it doesn´t work. It seems very strange to me that, using other prorgrams, not excel, the printer prints in grayscale no problem. It seems to be a problem with excel itself. thanks for the help anyway!
  4. 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...
  5. paulo33

    Cell formatting bug

    I am just trying to apply a number format to the cells, but the fact that not even the formatting window opens up, really bugs me!! Thanks anyway.
  6. 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...
  7. 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...
  8. 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!
  9. 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...
  10. 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
  11. 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
  12. paulo33

    Referring to Variable Ranges in VBA for Excel

    Sorry, the tags didn't seem to work???? I'm sending the code again, to make it easier to read. Sub CopyData() 'Copies data from "Data" sheet, into "ConversionCosts" sheet Dim ConversionRows As Integer Dim DataRows As Integer ConversionRows =...
  13. paulo33

    Referring to Variable Ranges in VBA for Excel

    Again, thanks for all the help!! However, now its not working again in another part of the code. I'm sending it all over, hope you can help. Sub CopyData() 'Copies data from "Data" sheet, into "ConversionCosts" sheet Dim ConversionRows As Integer Dim DataRows As Integer...
  14. paulo33

    Referring to Variable Ranges in VBA for Excel

    RobBroekhuis, thanks The code is now working. I wasn't using the value returned by UsedRange.Rows.Count, but I was using a value from a loop I did, that just went through all the rows, until it found an empty one, assiging a 'counter' to it. Although, like I said, my code is now working, why...
  15. 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