The code below is listing the Outlook path for all my Outlook Folders but only two levels deep.
e.g., \\Douglas.Markham@thecompany.com\Inbox\01) doug's jobs\completed jobs
I've tried to nest a third For loop into the code to pull out the next level of folder e.g...
I have a DB that culminates into 4 export queries. I would like to create a macro to export the 4 queries into one workbook per Business Unit. There are 10+ Business Units. A single Business Unit workbook would contain the output of from each of the export queries for the respective Business...
Hi I hope some one can help me with this problem.
I have created a user form to log sales records in to an excel spreadsheet. The form I have created will copy keyed informtion in to the next available row on a worksheet using the follwoing code.
Private Sub cmdExport_Click()...
Currently, I am aggregating metrics across multiple facilities where each facility putting their information into their respective workbook and emails their files to me. I then have to move the information into a master workbook.
I would like to establish a simple data input option on the web...
I am using following code to open the UTF-8 encoded .csv in excel:
m_excel.Workbooks.OpenText(newPath, Comma: true);
And that works fine. Can anyone tell me how to open UTF-16(Unicode) encoded .csv file in excel using similar code or some different approach. Please help me i urgently...
Dim CONNECT As New ADODB.Connection
Dim zapytanie As New ADODB.Recordset
Dim path As String
Dim name As String
Dim a As Integer
Dim sheetValue As String
Dim QueryString As String
path = "SOME PATH...."
name = Dir(path)
a = 1
sheetValue = "sheet" & a
All, I have the following code which worked in 2010 and I believe was prior to me upgrading my MS Office suite from 2007 to 2010. Might this be an issue between the application versions? When running the program, I get "Bad File Name or Number" run-time error which occurs on the second iteration...