Search:

Type: Posts; User: lilmark

Page 1 of 10 1 2 3 4

Search: Search took 0.56 seconds.

  1. Replies
    0
    Views
    857

    Access website and grab cookie

    I've never really worked with VBscript, but I was asked to see if I could write a script that would run on a schedule on a PC to access a website and grab the cookie in order to send it to another...
  2. PrivateKey Passphrase scripting for VB Script?

    I currently have a process setup with Task Scheduler on my PC which uses WinSCP to connect to a server and grab a file. My PC is almost always on with Pageant running (already having put in the...
  3. Replies
    1
    Views
    686

    Find Owner of File/Folder

    Ok, so I'm using VBScript. I'm trying to print out the owner of a file or folder. However it seems to be failing when scanning through the files/folders if it comes to a shortcut or other similar...
  4. Replies
    1
    Views
    714

    Re: Path Not Found

    After surfing the web for awhile I found the cause of my problem. Microsoft has a 260 character limitation for the path. Exceeding it causes you to receive the Path Not Found error.

    After more...
  5. Replies
    1
    Views
    714

    [RESOLVED] Path Not Found

    I'm using VBscript.

    I have written a script to scan through all the files in a drive to delete old files. You simply put in the location at the top along with the timeframe and let it run.

    It...
  6. Re: Keeping Line Breaks from Oracle Table?

    Easy solutions are the best...

    $val[11]=nl2br($val[11]);

    awesome function....
  7. [RESOLVED] Keeping Line Breaks from Oracle Table?

    In my oracle table the value stored for one of the records is as seen below. I originally had this value copied from an excel spreadsheet and stored on to an oracle table.



    BD:
    CASE When P.id...
  8. Replies
    1
    Views
    2,421

    FolderExists function

    I'm brand new to writing in vbscript, so I apologize for my lack of knowledge as I was asked to write this out of the blue.

    I basically have to write a vbscript that will check every file (and...
  9. Replies
    1
    Views
    1,354

    Re: Accessing Oracle Tables?

    Nvm, I forgot a second ) at the end of line 11.
  10. Replies
    1
    Views
    1,354

    [RESOLVED] Accessing Oracle Tables?

    I'm just getting into this, so I am first trying to do a simple select of data from a table on our oracle server and printing it to the screen. Below is the code I have so far, but I can't see to...
  11. Re: Capture Value from System Command in Perl

    Found some online sources that said to use the backtick to get the return value, but I still couldn't get it to work. However, I cam across another solution.

    @arr = stat...
  12. [RESOLVED] Capture Value from System Command in Perl

    I'm new to the whole Perl, Unix, PHP thing, so bear with me, please.

    Using the below code i'm basically trying to find the size of the file and store that value into $sret. However, it doesn't...
  13. Replies
    3
    Views
    1,096

    Re: Referencing Drop Down Box Value

    Sorry, I am using excel 2010. Everyone using this report should have 2007-2010.

    And, yes, I was using the combo box from the Form Control. I don't recall why I did that. I know I had a reason...
  14. Replies
    3
    Views
    1,096

    [RESOLVED] Referencing Drop Down Box Value

    I have a bunch of formulas on one of my excel tabs using IF and SUMIF formulas. One of the criteria is the region (North, South, East, West, All).

    I have a Drop Down box referencing A3:A7 in...
  15. Replies
    3
    Views
    4,197

    Re: Clearing Excel Resources?

    I looked for over a day online and I could not find anything simple for clearing the excel cache/resources to avoid the excessive use of memory causing the macros to fail mid-way.

    1)...
  16. Replies
    3
    Views
    4,197

    Re: Clearing Excel Resources?

    No, they like to use their pivot tables unfortunately. The report works fine. I just wanted to give them that extra functionality of turning the report into a .xlsx.
  17. Replies
    3
    Views
    4,197

    [RESOLVED] Clearing Excel Resources?

    I am using Excel 2010.

    I have a .xlsm file which imports a .txt file posted to the web and updates 9 pivot tables.
    This all works good.

    Now the problem occurs with I click on my "Create...
  18. Replies
    1
    Views
    1,036

    How do you append files to one another?

    I'm trying to append one file to another. What am I doing wrong?



    //this just appends the file location to the original file and not all the data
    $orig = fopen("$path/$fo", "a");...
  19. Replies
    0
    Views
    1,497

    How to add a confirmation box to PHP?

    Just a warning that I am new to PHP (even more so Java), so I appreciate the help and the ability to be as hand-holding as possible. :bigyello:

    My PHP page allows the user to upload their files...
  20. Replies
    4
    Views
    626

    Formula for Number Format?

    =SUBTOTAL(109,D4: D1000)

    The above formula gives me the total for the listed range. Is there a formula for setting a cell's format to be #,##0 so it includes a comma and removes any decimals?
    ...
  21. Replies
    3
    Views
    1,139

    Re: Quick Perl question on reading a file

    Sorry, I posted here since the forum had Perl in the ().

    I know how you feel. Perl is confusing to me too. I honestly feel like the person that created it was face-rolling their keyboard and...
  22. Replies
    3
    Views
    1,139

    Quick Perl question on reading a file

    My boss is easing my way into PERL to give me additional work aside from my current SQL/VBA, so I am a Perl newbie.

    A file is created every day, and the below code is supposed to read all the...
  23. Re: Excel importing cache file instead of new data

    I can't post the information to the web, and I can't replicate the problem in .xlsx as it only occurs during the .xlsm macros. In addition, not everyone has the issue.

    It's basically importing...
  24. Re: Excel importing cache file instead of new data

    Well, that didn't work. When my coworker opens the .xlsm file and it imports the .txt file from the web it's pulling in 4/8 - 4/13 when it should be pulling in 4/8 - 4/27 right now. The same file...
  25. Replies
    1
    Views
    697

    Re: Pivot Table Formula

    Ah, I figured it out. I love Eureka moments.

    In my above formula at the the very end where it says "Multiple Items" I just changed the (B5+C5)/$F$3 to...

    (B5+C5)/SUMIF(A:A,"=Grand Total",D :...
  26. Replies
    1
    Views
    697

    [RESOLVED] Pivot Table Formula

    I am using Excel 2007.

    I have a .xlsm file which imports data to auto-fill the report. This report has a Pivot Table and the column next to it, Column F, has a calculation that basically says......
  27. Re: Excel importing cache file instead of new data

    I've been searching the web for an answer and I think I found what I needed at the below link which happens to be in this forum as well.

    http://www.vbforums.com/showthread.php?t=440508

    As I...
  28. Re: Excel importing cache file instead of new data

    I could be wrong on my fix by going to Tools >> Internet Options >> Browsing History Settings >> Every Time I Visit The Webpage.

    I have a coworker who .xlsm file was pulling the same data from...
  29. Excel importing cache file instead of new data

    I am using Excel 2007.

    Using another program I have .txt files being posted to the web
    (ex. http://www.workfile.com/data.txt).


    Now, in my excel .xlsm file I have it set to automatically...
  30. Re: Selecting a worksheet by tab location/number

    Found it..

    Worksheets(3).select
  31. [RESOLVED] Selecting a worksheet by tab location/number

    Excel 2007

    I'm almost 100% positive I've done this before, but I can't remember for the life of me.

    I know you can select a tab by using code such as...
    Sheets("Sheet1").select

    However, I'm...
  32. Re: Changing Field Captions in a Pivot Table

    The simplest solutions are often the best.

    The header/title for the column in the pivot table is what I was trying to change. A simple...Range("B3").value = "$100 offer" is all I needed to do...
  33. [RESOLVED] Changing Field Captions in a Pivot Table

    I am using excel 2007.

    Basically, I have a button that can update the spreadsheet and pivot tables to display whatever offer ($100, $200, $300) they choose from the drop-down box.

    While the...
  34. Replies
    1
    Views
    370

    Re: Referencing Cell Issue

    The error was on my part.

    When I was assigning the value as such...

    Range("C1").value = "='address_list$36_$46'!B1"

    ...the worksheet address_list$36_$46 did not exist yet. It was still...
  35. Replies
    1
    Views
    370

    [RESOLVED] Referencing Cell Issue

    I am using Excel 2007.

    I am having issues referencing a cell from another tab.

    Initially the macro copies the worksheets from workbook A and then pastes it onto the worksheets in workbook B.
    ...
  36. Replies
    3
    Views
    663

    Re: Save As New Question

    That did it! Thanks a lot! I was putting it inside the With statement which explains why it never worked. The Dialog is started from the first line of code and it just didn't occur to me until you...
  37. Replies
    3
    Views
    663

    [RESOLVED] Save As New Question

    I am using Excel 2007 and the below code is working as I wanted for the most part which is to give the Save As Dialog box and allow the user to change the location/name of the file being saved.

    ...
  38. Replies
    2
    Views
    1,867

    Re: Save As

    Thanks, I looked up the function you mentioned and I was able to piece together the below code which gives the "Save As" dialog pop-up and allows the user to manually choose a location and name the...
  39. Replies
    2
    Views
    1,867

    [RESOLVED] Save As

    I am currently using Excel 2007 and I have a question regarding the SaveAs capabilities in VBA.


    Set XLBook = Workbooks.Add
    With XLBook
    .SaveAs Filename:="ALL_REGIONS.xlsx"
    End...
  40. Thread: [RESOLVED] Sql

    by lilmark
    Replies
    3
    Views
    555

    Re: Sql

    That works. I tried it before and I got 303k. To make sure it was adding correctly I decided to add a group by CNT so I could list them all and when I added them all up it came out to 12k. It...
Results 1 to 40 of 370
Page 1 of 10 1 2 3 4



Click Here to Expand Forum to Full Width