Recent content by tubbsy123

Hi, I was wondering whether its possible to save the log to a specific folder, eg D:\SAS-Log, after a process has completed. Is this possible and do you know how to go about it? Thanks for any help provided. Regards tubbsy123

Hi, I've been using some code to dynamically create a button in an excel worksheet based on the output of a case statement. The code is as follows: Sheet1.OLEObjects.Add ClassType:="Forms.CommandButton.1", Left:=0, Top:=0, Width:=126.75, Height:=25.5...

Hi, I need to populate a macro variable, filedate, with the following saturdays date. It needs to be formatted as yyyymmdd. The following code is how far I've got. The &filedate. variable doesn't work correctly when run using %put. I get todays date and part of the code, eg 20100223+(7-2). I...

Thats great. Thanks Tubbsy123

Hi, I have some very large datasets (roughly 35 million records in each) and need to count the number of records present within them and store it as a macro variable. I currently use either proc sql or proc freq to do this. This takes a long time run. Is it possible to take the rows value in...

Hi Chris, This is really good but seems to only allow me identify the location of the file rather than the actual file name, eg Data20090301.txt Can this code be adapted to allow for the actual filename to be output. Regards Tubbsy123

Hi, I'm having problems with some code. I read in 6 text files using a wildcard. There are many more files in the root folder that are not read in. I need to write the filename of each of the files that are read in into a new column in the dataset. Any help would be greatly received. The...

Thanks dblan this code works really well. kdt82 using the x command and 'shutdown' doesn't seem to work. Thanks for the post though. Regards Tubbsy123

Hi, I am having trouble writing some code that shutsdown my PC after completing an automated piece of code. The idea is that once the code has finished the PC shuts istelf down. Does anybody know how to do this. Any help would be greatly received. Regards Tubbsy

Hi, I have two Access 2003 databases. The master is Export_Process.mdb and the other is DBExport.mdb. I need to delete the table, tblCampaign, from DBExport. But the initiation must come from the database, Export_Process.mdb. The deletion will be run as part of some other code. The location...

Hi, I have an excel spreadsheet with 9 fixed columns but a variable number of rows. I have written some code that changes the formating of each cell and this works for the variable number of columns. I am having problems trying to get the code run for the 9 columns instead of the one where the...

Thanks Everybody Thats Great tubbsy123

Hi, I have a very basic query which turns the visibility of items in a form on or off depending which button has been pressed. The query fires on click. A condensed version of some of the code reads: Private Sub btnElecBack_Click() picGas.Visible = True btnElecTotal.Visible = True...

Excellent, thanks very much Tubbsy

Hi, Someone in our office added to a database password to my Access Database. Now I cannot open it. Is there any way to get past this password and turn it off? Thanks for any help you can give Tubbsy