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: *

  • Users: SimonPetherick
  • Order by date
  1. SimonPetherick

    Populate Excel using VBA

    Thanks for your help.
  2. SimonPetherick

    Populate Excel using VBA

    Check if DataMonitor.xls is open or not; if not, open it. - Nah, I'd prefer to manually open this file and have a button located within to activate the rest of the code Check if folder "C:\Reports" is valid or not; if valid, loop through all csv files in it. - Correct Loop through all values...
  3. SimonPetherick

    Populate Excel using VBA

    Hi Zack. In answering your questions.... What is the file that contains the imported information? It is a csv file with a format: MIRN,MIRN_CHECKSUM,GAS_DAY,CONSUMPTION_HR01,CONSUMPTION_HR02,....,CONSUMPTION_HR24,TOTAL_DAILY_CONSUMPTION,TYPE_OF_READ And a file name similar to...
  4. SimonPetherick

    Populate Excel using VBA

    Basically, what I'd like to try and do is: - Have a folder (ie C:\csvReports\) where I can place the csv reports being generated each day. - Have a button within my excel model. - Each time I press the button, the csv reports that are stored within that folder are processed and the data is...
  5. SimonPetherick

    Populate Excel using VBA

    The vlookup formula that I use is: =VLOOKUP(L7,SAGAS_INTMR_ENVSA_REMCO_20060315091008.CSV!$A$1:$AC$250,28,FALSE) where: L7 = the MIRN (this will never change) SAGAS_INTMR_ENVSA_REMCO_20060315091008.CSV = the report name (this will change) $A$1:$AC$250 = the lookup range within the report (this...
  6. SimonPetherick

    Populate Excel using VBA

    OK, here goes... My model (an excel spreadsheet) is called DataMonitor.xls The format of my model is as follows: Gas_Day,Calendar_Day,ReportName,TotalSites,Actuals,Estimates,Substitutes,MIRN1,MIRN2,....MIRN194,Total Gas_Day = the date listed in the daily report Calendar_Day = the date the...
  7. SimonPetherick

    Populate Excel using VBA

    Hi, I have an excel spreadsheet (model) that contains a big table of information. Every day I populate this table with data obtained from a daily csv report. My current procedure is to open my “model” as well as the daily generated csv file – I then use a simple vlookup function to populate my...
  8. SimonPetherick

    Word Wrap in Crystal v10

    Thanks. I entered the formula but crystal says there is an error in the formula - the keyword 'then' is missing Am I correct in saying 'then' should be placed after: If Counter < BreakPoint THEN?
  9. SimonPetherick

    Word Wrap in Crystal v10

    I tried manually resizing the columns in preview mode and saving the report, but it still didn't wrap the text. I've now rotated the text 90 degrees and it seems to wrap ok. The problem I face now is that I'd like the text to be aligned right. However when I click the right align button, since...
  10. SimonPetherick

    Word Wrap in Crystal v10

    The 'Can Grow' button is greyed out so I cannot select it using a cross tab. For some reason, when I select the borders of the label and manually resize, the text still does not wrap. Any other ideas????
  11. SimonPetherick

    Word Wrap in Crystal v10

    Hi, I have set-up a basic crystal report in v10. It contains a cross-tab. In the columns along the top, some of the headings are too long for one line so I'd like them to wrap onto the next line. Does anyone know whether I can do this? Cheers.
  12. SimonPetherick

    Frames do not align

    Hi, I have developed a website that uses two frames, topFrame and mainFrame. The topFrame does not use scroll bars, whereas the mainFrame does. Within each frame, I have used a table which is centered in each frame. However, when the webpage is viewed in a browser, they do not align. I assume...
  13. SimonPetherick

    Frames Appear in IE

    Hi, I'm developing a webpage that has two frames (topFrame and mainFrame). When I view the webpage in Firefox, the frames are non existant. However when I view it in Internet Explorer, the frame is visable in a white colour and is movable by the user. How do I prevent this from happening? I...
  14. SimonPetherick

    Exporting to .CSV from ePortfolio

    I am running Crystal Reports v8.5 and Enterprise v8.5, and currently have a report published online via ePortfolio. My problem is that I need to be able to export a published report from ePortfolio in the .CSV (Comma Separated Values) format, but it does not appear as an option in the Export...
  15. SimonPetherick

    Eport to .csv

    what it's exporting at the moment is as follows: "abcbirkenhead","1023","1054","1032","3845
  16. SimonPetherick

    Eport to .csv

    Yeah - I mean double quotes. For example, the following is contained in the report: abcbirkenhead 1023 1054 1032 3845 and I want it to export as .csv like the following: "abcbirkenhead",1023,1054,1032,3845
  17. SimonPetherick

    Eport to .csv

    Hi, I'm using Crystal Reports v8.5 and need to schedule my report through Enterprise to export as .csv When I export to .csv the numbers are exporting within inverted commas as if they were a string. Does anyone know whether the export can to .csv can be done properly (ie text within inverted...
  18. SimonPetherick

    Crystal SQL Designer

    We're using an Oracle database.
  19. SimonPetherick

    Crystal SQL Designer

    This is the SQL query: Select dp.dty_id, dp.sit_id, dv.reading_date, (Select dvs.report_value from data_points dps, data_values dvs where dps.dpt_id = dvs.dpt_id and dps.dty_id = 60 and dvs.reading_date = trunc(dv.reading_date+0.74999)+0.25 and dps.sit_id = 1) HV6AM...
  20. SimonPetherick

    Crystal SQL Designer

    Kurt Is there any way I can do this myself as most people are away on holidays? SP

Part and Inventory Search

Back
Top