Search results for query: *

Here's the code so far... With Workbooks("PERSONAL.XLS").Worksheets("Sheet3").QueryTables.Add( _ "ODBC;DRIVER=SQL Server;SERVER=ugh07;UID=abc123;PWD=abc123;APP=Microsoft® Query;WSID=A2854A" _ , Sheets("Sheet3").Range("A1")) .Sql = Array( _ "SELECT...

Hallo I'm trying to import some external data, and my query for it is that it needs to be a specific date. I've og the macros for importing it down, but I was wondering if i could write a macros so, when i run it there will be a inputbox that pops up asking which date i would like to query for...

Hi, I'm importing data and running a query before transferring it to excel - this is all done in macros . One of the criteria is that it has to be on a certain date. However, I want, say, a inputbox to pop up and ask for which date it should limit the results by before it imports it to excel. I...

Thanks

Was just wondering how many drives I can have on my PC before my computer decides not to work? thanks

myself, hehe...just figured it... in case anyone else was looking for something like this

try this code: Option Explicit Sub testme01() Dim myCell As Range Dim delRng As Range Dim wks As Worksheet Dim NumberOfRowsToDelete As Long NumberOfRowsToDelete = 12 Set wks = Worksheets("sheet1") With wks For Each myCell In .Range("a1", .Cells(.Rows.Count, "A").End(xlUp)) If...

My last 8 rows of the spreadsheet have some data, sub totals and totals in them. No gibberish. I was thinking of making the macros search for the gibberish and delete it instead... but i'm not quite sure how to write that. Or perhaps there's a way of deleting the data before i import it into...

Sorry i did mean 28 rows... and the rows contain some gibberish which i want to get rid of. oops...

When i open a file there is certain data that repeatedly appears. My current method is to type in each row individually and making macros to delete it for me Is there an easier way? I believe the rows i want to delete occur every 28 rows or so and i want to delete the 4 rows after that. What...

Yes thank you...just what i needed.

I am running a macros that somwhere along the lines merges some cells together. When i run it, a warning pops up telling me that the cells i'm merging will only display data in the cell in the top left-hand corner. It comes up mulitple times because i'm merging multiple groups of cells. I just...

Just realised I typed something wrong, What i mean was: I need a formula that works out the total cost depending on the code of the item. and so far i've got this formula: =IF(E5="e35","A",IF(E5="a89","E","")) Sorry and thanks again

Hi all, I have the following data: Code Quantity Total Cost E35 100 A89 300 E35 150 etc... I need a formula that works out the total cost depending on the formula. So far i've got this code: =IF(E5="e35","A",IF(E5="a89","E","")) if anyone could help me find out...

Hi, I have some data which is sorted by a code (usually comprises of a letter of the alphabet followed by two numbers), e.g. E80. The code refers to an item. I have imported the data into and Excel spreadsheet. I need a formula, or macros, so that it will calculate the price of the item...