retrieve data

Hello everyone, Apologies English is not my first language and I am very new to writing VBA codes. So far, I have only copied and adapted parts of the codes to fit my needs. Recently, I have created a workbook, each tab has the name of a treatment site. Daily, I receive data about these...

Looking for help with why the vba code that is currently running to retrieve data from SQL server is not displaying all of the data that is being retrieved. I have 28 programs in the columns which I am retrieving data for 15 categories in the rows. The data has been retrieving fine for the...

Hello all, This is my first post and I'm writing it because I couldn't find what I'm looking for anywhere else. I need this: In sheet 1 (which I called TEMPLATE) cell C3 I put a ticket number eg (T007) and in sheet 8 (TICKET_TRACK) all the tickets are being recorded. The record...

Hello, I have a chart containing 5 columns (A to E) and 10 rows (1 to 10). Row 1 contains the column headlines: A = Dates, B = Currency1, C = Currency2, D = Currency3 and E = Currency4. Column A, row 2 to 10, contains dates, 2009-01-01, 2009-01-02 etc. Column B to E, row 2 to 10, contains...

I work for a non-profit community housing agency and created a workbook that has multiple tabs. One of the tabs is a spreadsheet that contains 22 columns (scope assumptions). On another tab I want to pull data from this large spreadsheet. There are usually at least a 100 rows, each room in...

Recalling data in userform from excel saved data, data works and image (Saved in cell) also works if I refer Set CopyImage1 = Worksheets("Data").Range("QW14") I don't want to refer a particular cell the range should be variable like Set CopyImage1 =...

Attached a sample code need help in retrieving the images from worksheet to Userform https://www.dropbox.com/s/nvghhjp8o83jwt0/Retrieve%20iMAGE.xlsm?dl=0 Please help Trying for more than a week time.

Sub MyQuestion() ' First populate the scripting.dictionary Dim d Set d = CreateObject("Scripting.Dictionary") d.Add "a", "Athens" d.Add "b", "Belgrade" d.Add "c", "Cairo" Debug.Print d.Item(1) ' Why does this return blank? ' How can I retreive items from this dictionary? ' I am very...

Hey everyone, my very first post (of many)!! Hoping someone can help me come up with a macro that will time stamp a sheet upon the retrieval/refresh of essbase smartview? thanks, Brent

I'm not much of VBA Guy, but I need some HELP. I need to retrieve a record from one worksheet into a user form, then change that data and post if back to the same worksheet with the changes, hopefully just updating the original data. Could someone out there share some code to do this, I'm pretty...

I have made a form to enter the details to save in database. I want to recall the data for editing. Using web help, used the below code, but showing error when i press the findnext or findprevious command and highlighting in Set LastFind = Where.Find(Me.NO, LookIn:=xlValues, LookAt:=xlPart)...

I want to create code to retrieve the data (complete row) for editing or deleting from worksheet, where the data is stored using the userform in the same worksheet. My sheet name is "Data" and column "A" in the "Data" (sheet) is the reference to retrieve the data. Userform is named...

Hi All, I am trying to retreive share prices from the following page http://www.asx.com.au/asx/markets/pr...Codes&asxCodes= AMP I can navigate several pages and searches to get there but I can't seem to get the specific piece of data I want to extract. I want to extract the last share price...

Hello, I am a novice in terms of Excel and VB and am trying to make a macro retrieve information from a particular line in one worksheet and insert it into the appropriate cells in the form worksheet. Currently I am using the following and it works but after having used it for 234 lines, you...

Hi everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm new using VB and I'm having some troubles to get data from a closed wb in Excel 2007, I found a code which I tried to use but doesn't work:<o:p></o:p>...

Hey I've got a sheet in a workbook that I need to populate using named ranges from another (schedule sheet) w/in the same book. I have A1 as "week Number" and put the date in A2. my goal is to populate the range below it (b1:w13) with the appropriate week from the schedule. Each named ranges...

Using the Template Wizard Add-in, I have created a form/template and have successfully sent inputs to an excel database. Is it possible to retrieve data from the database back into the template? The purpose of this would be to provide a copy of the details to each client.