Search:
Type: Posts; User: lilmark
Search:
Search took 0.56 seconds.
-
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...
-
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...
-
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...
-
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...
-
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...
-
Easy solutions are the best...
$val[11]=nl2br($val[11]);
awesome function....
-
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...
-
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...
-
Nvm, I forgot a second ) at the end of line 11.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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)...
-
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.
-
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...
-
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");...
-
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...
-
=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?
...
-
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...
-
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...
-
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...
-
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...
-
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 :...
-
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......
-
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...
-
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...
-
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...
-
Found it..
Worksheets(3).select
-
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...
-
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...
-
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...
-
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...
-
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.
...
-
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...
-
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.
...
-
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...
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|