Search results for query: *

I Right-mouse click on the CSV file and select open with "Excel". Or as an alternative I can select import text file in excel. In both cases I have hit save as and selected xls. This worked well with the importer.

If I manually convert the file to XLS then I can run an Import/Export spreadsheet function in my macro. I have tested this process and it works well. The trouble is getting Excel to convert the file first. I have Googled this issue and I have found a few threads where people are passing...

Every month we have to process a very poorly formatted CSV file for use in reporting. This CSV has commas in some of its values (ex. column1, 34,000, column3). From my perspective this is a retarded export format, I think you should let the end user's program format the values. Unfortunately...

OK it looks like I was able to figure it out on my own. I used the code below. dst = (rs.Fields(pth) & "\" & rs.Fields(Fname)) If Len(dir(dst, vbDirectory)) = 0 Then MkDir (dst) Debug.Print End If Thanks to everyone for the help.

@Aceman1 Thanks for the help. I have to admit I'm not quite certain what your suggestion was. Is that like a wild card? I tried it exactly as you ordered, And I am getting a Compile error: Expected list separator or) It looks like it just dislikes the last quotes. Please advise if possible.

I have changed the logic block to: If dir(rs.Fields(pth) & "\" & rs.Fields(Fname)) = vbNullString Then MkDir (rs.Fields(pth) & "\" & rs.Fields(Fname)) Debug.Print End If (changed variable names to be unique from conventional function names. This logic is still not working...

I have a monthly report that is exported for each of the sales reps, detailing their advertisers activity. I have an access report which compiles all of these reports into a single multipage PDF. Which I must then use Acrobat to break into individual PDF's. These PDF's must then be placed in...

@Skip thanks for your quick reply. It looks like COUNTIF is what I should use, but there is a problem, it looks like the COUNTIF function uses a specific criteria to count, but I need it to count dynamically. Is this possible?

I have a spreadsheet which contains survey results. I need to use excel to tally the results from each column and tell me the which text value occurs the most in each column. Can this be done in excel?

Where I work we are about to finish a user survey that we used Survey Monkey to deliver. This surevey is absolutely non-scientific, but we do have to be able to tally the results. At first we were expecting something like 100 responses so downloading it into Excel and hand counting the entries...

Wow Geoff, your script worked beautifully! It executed quietly and next thing I know my CSV started with the header at the top. Thank you very much! One more question, again I'm sorry for the noobishness of this question. This code needs to be in a macro that actually does the import. How do...

Im sorry for the late reply it was a pretty hectic end of the week last week. So the path variable is the field on my import form that stores the path to the file to be imported. The import form is called "import" and the text field on that form that stores the path is called "path" (...

I could pretty easily just edit the CSV that I get monthly. The end users though will get frustrated with that and likely stop using the app. I found a page where someone asked pretty much the same question but due to my inability with compiled code I was not able to make it work...

To preface I know nothing about VBA, my primary position is a web developer using Adobe ColdFusion and some PHP. This gives me a little confidence with VBA, but I am still a complete noob and know pretty much nothing I am trying to use MS Access 2010 to create a tool that will import a monthly...