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 Chriss Miller 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: jlf81
  • Order by date
  1. jlf81

    Powerpoint Update Links No Excel Error Messages

    I could replace the powerpoint bit with that (and yours is a better way than I was doing it, and I will change it to that), but it's the excel asking for me to click 'continue' and 'ok' that I am having problems as I want to be able to just leave it run with no intervention from me
  2. jlf81

    Powerpoint Update Links No Excel Error Messages

    I am trying to wrtie a Macro to update all the links in a PowerPoint (2003) file to excle sheets where there are various messages regarding updating links which need to have 'continue' or 'Ok' clicked on due to issues regarding the source files not being on drives I have access to. I need to...
  3. jlf81

    Problem getting Access to open visible Excel

    Thanks, That all looks to have got it working, I have port the marco, but out of interest why was it worth doing this? Thanks Josh
  4. jlf81

    Problem getting Access to open visible Excel

    Thanks for the help I have managed to get the second bit in no problem, but the first bit "Set xlbook = xlapp.Workbooks.Open Filename:=(ExcelLocation & ExcelName), UpdateLinks:=1" is throwing me back the error "Complie Error: Expected: list separator or )" Not sure why as it looks correct...
  5. jlf81

    Problem getting Access to open visible Excel

    Hi, I am having problems with Access opening an excel file and running a macro, it seems to open excel in a non visible format but I have no idea why?, I am sure I am missing something simple, and would appreciate it if some one could point me in the right direction. Thanks Josh This is the...
  6. jlf81

    Excel IF Statement

    try =SUMIF(C2:C6,"Y",B2:B6) for the example, then just alter the 2 ranges to suit your data (remember they need to cover the same number of rows)
  7. jlf81

    Date Format in User Defined Forms Text Box in Excel

    Thanks for your help I will look into the date picker you sugguested, as I normally want to return todays date, it's only in exceptional cases I wish to change it.
  8. jlf81

    Date Format in User Defined Forms Text Box in Excel

    I can't see any function for the format in the properties window for the object, or should I be looking to use format () in the code somewhere? Thanks Josh
  9. jlf81

    Date Format in User Defined Forms Text Box in Excel

    Hi, I am trying to change the format of the date in a text box within a user defined form in excel, currently it is showing as mm/dd/yyyy, I need it to show as dd/mm/yy. If anyone could point me in the right direction it would be helpful as I can't see where the settings for this are held...
  10. jlf81

    Complex Number Formatting

    I have had a look at it this morning and was struggling to get it working so I ended up going down the route of creating a text field formated as required (eg >1 Fee& "%") in the query, this has worked fine apart from the colour which is not a problem as this will always be printed in black and...
  11. jlf81

    Complex Number Formatting

    ah, I understand what you mean now, I will have a look at that monday. Thanks
  12. jlf81

    Complex Number Formatting

    how would I change the properties on the fly as there are going to be all the diffenerent formats used each time the report is ran, and the only way I know of to change it on the fly would be to code it do one format (which could change based on some parameters) per run. Sorry if this is a...
  13. jlf81

    Complex Number Formatting

    Hi, I am trying to return a value which will be formated as a #,##0.0% above 0 and below 1, £#,##0 above 1, "No Fee" at 0, [RED](#,##0.0%) below 0 and above -1, and [RED](#,##0.0%) below 0 and below -1 I have tried looking everywhere and tried using =iif([Fee]...
  14. jlf81

    Paste Values on copied sheets

    I have tried it this morning and it looks to be working perfectly. Thanks again Josh
  15. jlf81

    Paste Values on copied sheets

    Thanks, I will give that a go Monday when I am back in work. I knew I jmust be missing something Thanks Josh
  16. jlf81

    Paste Values on copied sheets

    Hi, I wondered if anyone could help me I am trying to copy some sheets into a new workbook, and then paste them as values (basically leaving me with the originals as they where, and the new copies as just values in a new book) I keep getting runtime error '-2147217848 (80010108)' Method 'Value'...

Part and Inventory Search

Back
Top