Search results for query: *

Any suggestions on how to use VBA to set the Category (X) Axis Lables on using VBA? When creating a line (xlLineMarkers) chart in Excel using VBA I am not able to program the X axis lables. By default my chart just lables the X axis with 1 - n to represent the number of data points. I tried...

Does SAS have the ability to create a view (or query) like you can create within a typical Database application (SQL Server, Access, Oralce, ...)? I have multiple sas datasets all sorted with the same ID that contain similar data (claim_count, total_spend, etc..), but the fields within each...

I am trying to find a way to have SAS identify the computer name where my code is being executed, and then depending on what computer the code is running on I can have conditional statements to setup the correct paths for my libraries. This will allow the same code to be run either on my PC, my...

Is there a way to check for the existance of a required dataset and have two branches of code to handle: a: Input Dataset exist b: Input Dataset does not exist A general outline of what I am trying to do is this: %let fileIn = "c:\temp\filename.txt"; %if FILEEXISTS(fileIN) %then %do...

How do I determine if activesheet.Cells(1,1) has an associated comment object? I am creating a process that will copy formulas from all cells on a worksheet and paste that formula into the comment for that cell. ****CODE Const conEscapeString = "~~" Public Sub CaptureFormulas(wks As...

When importing a workbook from excel I am getting error 3190:"Too many Fields Defined" I have 14 workbooks that all came from the same parent workbook. Each data segment was then broken out into its own spreadsheet and sent out to business areas for review and input. Now that I am...

I want to be able to interface with the DOS Command Window using Access VBA. I have tried using the shell command with the sendkeys function, but have not been able manage the time aspect. I either need long wait times between each send keys command, or access is sending the next command...

I have a dataset that has a list of names and address. The data is in all capital letters. Now when performing the mail merge I use the Propper Case switch ( \*Caps ). This works for most of my records but not all. For instance: JOHN MCDONALD --> John Mcdonald JOHN SMITH III...

I have recently run accross an issue with a Microsoft Word mail merge that I have not been able to explain. My data source is in Excel format and looks like the following: Addrss, City, State, Cstmr1, Cstmr2, ....., Cstmr15 Not all of the Customer fields contain data, some records may...

Using Access 97 I am trying to export a table to a text file. I have setup a fixed width specification, but cannot control the data format for the output. Specifically I want to ensure two decimal places follow the decimal point for data of type double. I have tried setting the format and #...