Hi
I am trying to write a VB Code to automate creation of Pivot Table
The code starts as below
-----------------------------------------------------------------------
Workbooks.Open "C:\Test1.x ls"
Windows("Test1. xls").Activate
Refresh_Pivot
Application.Dis playAlerts = True
ActiveWorkbook. PivotCaches.Add (SourceType:=xl Database, SourceData:= _
"Sheet1!R1C1:R8 C10").CreatePiv otTable...
Sanket80
Last Activity: Feb 3 '07, 01:16 AM
Joined: Nov 15 '06
Location:
-
Help required in storing a variable
-
spool is a way to record the output of the activity done after the spool command
It generates a file which shows the activities and their results -
Need help in formating the output into excel
Hi,
I am using a sql command to produce outputs having 3 columns
Before running the sql I am spooling the output in .xls format
But when I open the .xls file (i.e. the spooled file) data of all the 3 columns appear in a single column with blank spaces between them
Is there a way by which I can ensure that each output column of the SQL appears in a seperate column in the excel Sheet
Thanks -
Can somebody pls help me on this
ThanksLeave a comment:
-
Help Needed : Output is getting wrapped
Hi,
I am running a SQL Query from SQL Plus. The output has 3 columns out of which the first column is varchar, the second is Number and the third column is Date type.
I am using the following environment before running the SQL
SET LINES 10000
SET LINESIZE 60
SET PAGESIZE 20000
SET SPACE 0
SET FEEDBACK OFF
COLUMN 'ABCDE' FORMAT A15
COLUMN 'ABCDE ATTEMPTS' FORMAT 999999
COLUMN... -
Thanks...The script is worling fine.......Leave a comment:
-
Pls Help: I want to include the date stamp in Subject of mail
Hi,
I am running an UNIX Shell Script and it sends an output to specific mail id's
The mail has a subject like below
cat /path/filename | mailx -s "Here is the List" $MAIL_LIST
Now this command sends the output along with Subject "Here is the List".
My requirement is to populate the date stamp in the subject as well so that the user can know the date when the script was... -
can somebody pls help me on thisLeave a comment:
-
Hi
I guess the conn command will again require me to put the USERID and PWD
My concern is a situatiion when an Unix User Logs on and views the content of the Shell Script
Thanks...Leave a comment:
-
Hi,
The problem is that I am new to shell scripting and does not know how to set the environment variables. Can u pls help me in that......
Also note that we are keeping the sh script in a custom directory and then we are registering a custom programme in Oracle ERP with execution method as HOST so that the programme will call and execute the shell script. So security wise, my concern is only when a UNIX user logs on to UNIX...Leave a comment:
-
Shell Scripting in UNIX environment for Oracle Database
Hi,
I have one shell script which runs a report and sends the output to user.
The shell script has some queries written in it in SQL and hence when I execute a shell script via a concurrent programme, I need to ensure that shell script connects to Oracle Database to execute the SQL written inside it.
Now when I hard code the shell script with User ID / PWD, the scripts run fine.....but I dont want to put the user id and... -
Hi,
Thanks to both of you.
The code worked perfectly
Regards
SanketLeave a comment:
-
Please note that the code deletes in case there is only one file in the directory but does not deletes in case there are multiple files.Leave a comment:
-
Hi,
Thanks for the reply...I tried that before using the following function code
Function delfiles1()
Dim strFldr As String
Dim strFile As String
strFldr = "C:\Results\Rep orts1" ' select the directory
strFile = Dir(strFldr & "\*.*") ' get list of files in folder
Kill strFldr & "\" & strFile
End Function...Leave a comment:
-
Hi..Help Needed for deletion using VB
Hi
I need one small help in VB
I have written a macro which produces some output and stores them in the form of an excel files (about 10 files are generated) in a particular directory in C:\.
The requirement is that each time when the macro runs, it shall first delete the existing files in that directory and rewrite new files.So the problem comes in deletion of existing file...The generation of file is taken care by macro.... -
Hi
I think u can get help from the following link
Since I am very new to this .....its bit confusing for me to understand
http://www.thescripts. com/forum/thread530866.ht ml
RegardsLeave a comment:
-
Hi
No .....I just started to work on this project
RegardsLeave a comment:
-
Hi
Is there any way by which this objective can be achieved...Leave a comment:
-
Hi....Need one help
Hi
I am using MS Access and have some queries written in it (About 10)
I want to write a macro using VB in such a way so that each time when I run the macro, the system shall execute the queries one by one and print the output of each result in seperate excel files.
Can somebody please help me in writing such a macro....M very new to VB
Regards
No activity results to display
Leave a comment: