Dear Sandeep, follow a link to an example of integration excel + access.
And excel working with front-end
Link: http://www.4shared.com/rar/z6j4vQEO/Excel-Access.html
tks. regards.
Basole.
Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar
Baranwal escreveu:
>
> Hi
>
> K
Hi Basole
I am glad you understood my requirement.
Kindly share the models that use excel to ms access with tables and indexes
at your convenience.
Looking forward to your generous help once again.
Thanks & regards,
*Sandeep Kumar Baranwal*
Assistant Manager
Credit Risk Methodology & Wholesale
Dear Sandeep, it seems to me that this code was used in excel 2003 with
connection via the "ODBC" nowadays use more connection "ADO" "DAO" etc..
Well I have some models use excel to ms Access with tables and indexes,
which I will share with you.
Regards,
Basole.
Em quarta-feira, 17 de j
Rupesh Patil:
Hi Expert.
How generate PDF file using VBA.
Thanks
Hi Rupesh Patil, try this:
Sub Creati_PDF()
Dim Filepdf As String
Filepdf = "C:\Temp\FileName.pdf"
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=MyFullName, _
Quality:=xlQualityMinimum, IncludeDocPropertie
Hi Basole
Though not observing the literal difference between recordset and
querytables, I wanted to see if the same requirement be worked out using
querytables in VBA code.
In Plan1 (Sheet1) you made use of ADODB.Recordset. I would like to make use
of querytables(index)
Kindly refer to a piece o
Hi Expert.
How generate PDF file using VBA.
Thanks
On Fri, Nov 8, 2013 at 8:10 AM, Basole wrote:
> Dear Sanddep, thank you for your kindness!
> Sorry, but what is the difference between recordset and querry tables?
>
>
>
>
>
>
> Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep
Dear Sanddep, thank you for your kindness!
Sorry, but what is the difference between recordset and querry tables?
Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar
Baranwal escreveu:
>
> Hi
>
> Kindly note that sql.request is functional in MS Excel 2007 but not in MS
>
Hi Basole
Please accept my thanks for the links.
I will go through them and would let you know if I have any issue and see
their applicability in my risk domain.
For the time being, the VBA code is running well so far. I want to work on
a variant of it. Could it be possible for you to work on the
Thank you. when you need to let me know. Take a look at this link, and has
several good choices of courses and tutorials VBA:
http://www.mrexcel.com/forum/general-excel-discussion-other-questions/698256-online-visual-basic-applications-course.html
another option this great book:
http://www.4
Hi Basole
Thanks a lot for your guidance and help. It's really appreciated.
So far, I have not come across any error. Will try this VBA code on some
more systems.
Will let you know if I come across anything related to this or otherwise.
Could you please suggest on the courses or study material th
hi Sandeep,try it now with the attached
I added a function that checks if the file path exists, the module 1
also added to check the file type Access (mdb) or (accdb) for use with the
provider Microsoft.ACE.OLEDB.12.0.
If there is any related error, it is recommended to download the file:
Data
Hi Sandeep, I did some tests and did not check any problem with
"cx.connectar".
also made some changes to make the sheet cleaner.
changes path and table name can make in the code.
as the extension "mdb" and "accdb" - this code works perfectly. Just change
the file name in the path.
Any questions
Hi Sandeep,
what is the error message that appears?
Basole.
Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar
Baranwal escreveu:
>
> Hi
>
> Kindly note that sql.request is functional in MS Excel 2007 but not in MS
> Excel 2010. Could you please let me know any VBA code t
Hi Basole
Thanks for the file.
Just wanted to continue with the discussion. Actually , I am trying on an
another version of this VBA using worksheet_calculate, just to, do away
with the shape "Import" and use dropdown list in MS Excel (based on Primary
key of MS Access) and import data from MS Ac
Hi Sandeep, has to do with what you need.
I need to know:: The database access is within the SQL server?
tks. and rgs.
On Wednesday, July 17, 2013 11:48:43 AM UTC-3, Sandeep Kumar Baranwal wrote:
>
> Hi
>
> Kindly note that sql.request is functional in MS Excel 2007 but not in MS
> Excel 201
Hi Basole
Suppose MS Access has a table containing two columns X & Y where
X(1,1,1,2,2,3,3,3) and correspondingly Y(23,34,45,67,34,56,67,87) and
dropdown in MS Excel is created as per based on X values (1,2,3). I wanted
to know if there is a VBA code on the basis of which if I select say, 1
from t
Please can attach example
tks.
Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar
Baranwal escreveu:
>
> Hi
>
> Kindly note that sql.request is functional in MS Excel 2007 but not in MS
> Excel 2010. Could you please let me know any VBA code that would be a
> substitute f
Hi Basole
Thanks for sharing the VBA code for importing data from MS Access to MS
Excel . I need an another favor from you.
Kindly re-modify the VBA code so that only selected data is imported from
MS Access to MS Excel , based on the variable value selected from the
dropdown created in the excel
Hi
I am not able to access the ImportAccess.zip folder that you have send
across. Please look into the issue.
Thanks & regards,
*Sandeep Kumar Baranwal*
Business Analyst
Credit Risk Methodology & Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
On Wed, Jul 17, 2013 at 8:59 PM, Basole
19 matches
Mail list logo