Search results for query: *

Unfortunately I'm working with a very large dataset so no room for additional columns.

Sorry I did say "This has to be done without altering the raw data or adding additional columns etc." Done some more Googlin' but not having much luck.

Hi, I have an Excel sheet with two columns, DATETIME and BYTES. I'd like to chart this but alter the Y-axis scale to show the values in MB or GB. This has to be done without altering the raw data or adding additional columns etc. So an example row is: 05/05/2013 00:00 742436864 So in the...

Thanks SkipVought, could you post/send the full code?

The To: information extracted by the code in the linked thread above does not always return a full email address, sometimes it only contains a name. For example I'd expect to see "email@domain.com" in the To: column and I get "Jo Blogs" instead. However if you open up the full message header...

Hi, I need to extract information contained within the message header (or "Internet Header") in Outlook 2010. I'd like to pull out the To:, Subject: and Date: information from each email in my inbox and put it in to Excel. The following post thread707-1253839 has almost got me there...

Hi, Is there any way of finding out which version of the firmware maintenance CD (now rebadged "HP Smart Update Firmware DVD") I have installed on my server? I've taken over a box from someone who has left the company and need to understand which CD/DVD he used to update it. I know the CD is...

I have a PC with 2 partitions, XP is installed on the first, nothing on the second. I want to put WinPE on the second partition and be able to boot between the two. I understand I'll have to replace the XP boot mechanism with the Vista Bootloader which comes with the version of WinPE I'm using...

SkipVought, I've found the problem, it was a typo on my part. Thanks everyone for all your input, problem solved! :)

Thanks SkipVought, your solution looks very tidy but I experience a problem when running it. I get a "Run-time error '5': Invalid procedure call or argument" against this line... Set rFound = Cells.FindPrevious(rFound) Can you tell me why this is happening?

Thanks for your input. Maybe I didn't explain what I'm after clearly, let me give you an example. This is what I'm starting with... Year Value1 2008 1 Year Value1 2008 2 Year Value1 2008 3 Year Value2 2008 1 Year Value2 2008 2 Year Value2 2008 3 I'd like to end up with... Year Value1 2008 1...

Hi, I've got the following macro which runs through my spreadsheet looking for the word 'Heading' in column A. It deletes any row which contains the word 'Heading', great. However I would like it to keep the first occurance of 'Heading' and then continue to delete the rest. I'd then like it to...

Sorry. Will do.

Hi, I've got the following macro which runs through my spreadsheet looking for the word 'Heading' in column A. It deletes any row which contains the word 'Heading', great. However I would like it to keep the first occurance of 'Heading' and then continue to delete the rest. I'd then like it to...

Thanks! It was a bit of a noddy question (ashamed). What if a servername already existed in the text? So I would have to delete everything after the "=" first?

Hi, I have a text file called "Params.txt", it contains the following... start Servername = IP Address = end I'm trying to append a server name and IP address on to the corresponding lines. I've got the following code that will happily append the server name but I can't figure out how I can...

I've done some more digging and found that I can check the "Include declared referential integrity" option in properties of an article. This should copy all primary key constraints, reference constraints, and unique constraints to the destination table if they exist on the source table at the...

Hi, I've set up transactional replication between two databases (first time I've tried doing this). ServerA is the source ServerB is the target. I ran through the replication wizard on ServerA and published the articles I wanted. Then I created a new Push Subscription on ServerA that sends the...

Hello, Is there any way around the 8-string limit on the concatenate function within Script Editor?? I have a database from which I need to extract 10 fields and populate a peripheral variable with the result. Does anyone know of a way around this concatenate limitation?

Great suggestion RiverGuy, simple solution. Unfortunately I don't have a datetime stamp in my DB :( Is it possible to do a compare of the tables and then apply the compare to the DB on ServerB?