Search results

maybe try using non pass-through query from the same database as a test? if it works, then you know the problem is in the pass-through query, and not in the connection. i use a few pivot tables in my excel 2007 files linked to access queries. the way i set them up was - 'insert' pivot...

Re: VBA - Save as certain filename when "save" or "save as" is pressed it's been a while since i used excel 2003, but couldn't you create your own toolbar buttons in that version? i vaguely remember making some, and even altering their design.. if this is true indeed, the solution could be...

so basically you want your excel file to be automatically updated when you open it? if so, just go to data->connections->properties (before clicking on 'properties', select that specific connection of yours, there may be more than one), then just check 'refresh data when opening the file'...

looks like i figured it out. or, rather, found the answer online, as usual. basically, all those FieldInfo arrays need to be defined as one array variable. the code is something like this - ... Dim fieldarray As Variant ReDim fieldarray(1 To colstot) For i = 1 To colstot...

try using VALUE function, i think it should do the trick. =VALUE(yourdatecellref) l

hi. i am trying to automate splitting the text file in excel. my data comes as a text file with one big block of data, no delimiters, just one digit per field. i figured that i need to use either Workbooks.OpenText command or Selection.TextToColumns commands to do the job, but in both cases...

i think you just need to define the 'trust target' line dynamically, as you did with the 'sickness %' columns. try this definition - =OFFSET(Sheet1!$C$5,0,0,COUNTA(Sheet1!$B:$B)) l

ok, my final code is - Set rngvis = Intersect(ActiveSheet.Range("A4:AD" & lastrow), _ ActiveSheet.AutoFilter.Range.Cells.SpecialCells(xlCellTypeVisible)) so it does include 'Set', and it is dynamic. i just wanted to share the main idea (Intersect...) immediately, was...

figured it out! or, rather, found this idea online, which worked here. very simple, as usual - RngVis = Intersect(ActiveSheet.Range("A4:Z1000"), _ ActiveSheet.AutoFilter.Range.Cells.SpecialCells(xlCellTypeVisible)) provided row 3 is your header row and A3:Z1000 is filtered range. l

thanks, will look into that.. actually, somewhat related, i still haven't decided how i'm going to handle the rows that were copied (or moved) already - do i just delete them, or clear content and then sort the remaining data, etc.. if i understand your suggestion correctly, it won't matter...

aaah, i knew it was something trivial !! thanks, Brian the savior!.. this is just the beginning, eventually the macro will copy data based on different criteria into different tabs and/or files, and erase them from the ALLORDERS tab.. l

attaching.. i saved it as '97-03 file, so hopefully you should be able to use it.. thanks, l

thanks Brian. it's almost funny at this point. i create a file with two sheets, sheet1 and sheet2, populate sheet1 with some data, try the first of your macros, and it works, smooth as a swiss watch.. i then copy your macro to my original file, change the names of the sheets, and - ERROR right...

thanks. i prefer not to use lastrow = Sheets("sheet1").UsedRange.Rows.Count because the people who will be using this file may start entering random data here and there outside the main data range. is it a valid concern? i add 1 to lastrow now, because (thanks for pointing it out), -2 would...

thanks Brian. (i feel like you alone are manning the shop these days) this worked, but not in a way i needed. i already have a filtered range. i just need my macro to copy the filtered (visible) cells when i 'filter around', so i can paste them into another tab and/or file, but without the...

this code is killing me! i spent hours and hours today again, it still doesn't work and i have absolutely zero idea why.. help please!!! it's almost the same, see below, but now it pastes one row, then gives me 'Application-defined or Object-defined' error, at the point where it supposed to...

it's probably trivial, but i can't get rid of that first row of my filtered range. i have this statement: Set RngVis = ActiveSheet.AutoFilter.Range.Cells.SpecialCells(xlCellTypeVisible) which correctly gives me only the visible filtered cells, but includes the variable names row, which i...

sorry for being mia, and thanks for the suggestions, Brian.. will report with new questions, but i am hoping i can handle this myself now.. it's not that hard.. or is it?... l

hi. i need to copy data from one worksheet to another based on certain criteria. i wrote the following simple initial code to do the job. i now have one problem and one question: 1 - the code works fine when i run it once. if i run it the second time, without any changes to worksheets, i...

i need to create an Excel file (most likely 2007), which will be shared by a few users at different locations. what's the best way to go about it? i've never dealt with anything like this before in Excel format. i've used google spreadsheets before, which worked fine, but this time the file...