Need help with VB code Post: 302930197

Sponsored Content

Top Forums Programming Need help with VB code Post 302930197 by bbbngowc on Wednesday 31st of December 2014 12:45:36 PM

12-31-2014

Registered User

Need help with VB code

Hello All,

I need a little help with a piece of Visual Basic coding. I have the following code:

Code:

Sub Assign_New_DB_Report()
Sheets("Main Dashboard Summary").Visible = True
Sheets("Main Dashboard Summary").Select
pdfName = ActiveSheet.Name
    ChDir ActiveWorkbook.Path & "\"
    fileSaveName = ActiveSheet.Name
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="Report.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False
Sheets("Report").Visible = False
Sheets("Sheet").Select
Range("S6").Select
Dim olLook As Object
Dim olNewEmail As Object
Dim strContactEmail As String

As you may already know, it takes the default folder location configured in my Excel options and saves the file there. I would like to send the file to D: instead of the default C:. I've tried simply changing "\" to the path where I would like the file saved, but it doesn't work.

Any help offered would be appreciated.

Thanks.

---------- Post updated at 12:45 PM ---------- Previous update was at 09:24 AM ----------

Used the ChDrive instead. It works now.

Thanks.

bbbngowc

View Public Profile for bbbngowc

Find all posts by bbbngowc

6 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Return code from PL/SQL Code

Hi Guys, I was just wondering if anybody can help me with this problem. OK, how we can get a value back from PL/SQL Script (not stored procedure/function) See the below example: (for example aaa.sh) #!/bin/ksh VALUE=`sqlplus -s user/password@test_id <<EOF @xxx.sq EOF` echo $VALUE ...

2. Programming

how i prepare a c++ code(c code) for implementing my own protocol format

helo my protocol format is given below { destno,mode,no.of packet,pktsize,,pktno,textsize,CRC} description:- { is starting flag destno - 4bytes mode - 1 byte no.of pkt - 4byes pktsize - 6 bytes ...

3. Shell Programming and Scripting

translate ksh code to csh code

hi all, Can any 1 help me translate this korn shell code to C shell code : email=$(grep "^$1" $folder/config_2.txt | awk '{print $2'}) In config_2.txt the content is : which mean in korn shell , $1=groupname and $2=email address. Now i need to write in C shell script,when i set the...

4. UNIX for Dummies Questions & Answers

If �922� Code does not exist on �03� Record, �901� Code will be there instead, move �03� R

01,011600033,011600033,110516,0834,2,90,,2/ 02,011600033,011103093,1,110317,0834,,2/ 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+000000 00354,,/ 03,113806,,015,+00000559618,,,901,+00000000096,,,922,+000000 00621,,/ 88,902,+0000000025218,,/...

5. Shell Programming and Scripting

Block of code replacement in Java source code through Unix script

Hi, I want to remove the following code from Source files (or replace the code with empty.) from all the source files in given directory. finally { if (null != hibernateSession && hibernateSession.isOpen()) { //hibernateSession.close(); } } It would be great if the script has...

6. Linux

Go to a line of code , skip few lines of code

Hi , I have a code where i am using a infinite while loop . some thing like below while do if then #go to line 20 fi command 1; command 2; #line 20: sleep 34;

LEARN ABOUT X11R4

xtissensitive

XtSetSensitive(3)						   XT FUNCTIONS 						 XtSetSensitive(3)

NAME

       XtSetSensitive, XtIsSensitive - set and check a widget's sensitivity state

SYNTAX

       void XtSetSensitive(Widget w, Boolean sensitive);

       Boolean XtIsSensitive(Widget w);

ARGUMENTS

       sensitive Specifies a Boolean value that indicates whether the widget should receive keyboard and pointer events.

       w	 Specifies the widget.

DESCRIPTION

       The XtSetSensitive function first calls XtSetValues on the current widget with an argument list specifying that the sensitive field should
       change to the new value.  It then recursively propagates the new value down the managed children tree by calling XtSetValues on each child
       to set the ancestor_sensitive to the new value if the new values for sensitive and the child's ancestor_sensitive are not the same.

       XtSetSensitive calls XtSetValues to change sensitive and ancestor_sensitive.  Therefore, when one of these changes, the widget's set_values
       procedure should take whatever display actions are needed (for example, greying out or stippling the widget).

       XtSetSensitive maintains the invariant that if parent has either sensitive or ancestor_sensitive False, then all children have ances-
       tor_sensitive False.

       The XtIsSensitive function returns True or False to indicate whether or not user input events are being dispatched.  If both core.sensitive
       and core.ancestor_sensitive are True, XtIsSensitive returns True; otherwise, it returns False.

SEE ALSO

       X Toolkit Intrinsics - C Language Interface
       Xlib - C Language X Interface

X Version 11							    libXt 1.0.5 						 XtSetSensitive(3)