Excel with Macro - TransferSpreadsheet

[astharaj]

Hi,

I am using TransferSpreadsheet to transfer data from excel to access. Everything seems to be working - but I have one question.

I have a Excel template which gets populated with certain query and then can be saved as another .xls - I have created a button on the template which when clicked should transfer the updated data to access.

Is there a way to tell TransferSpreadsheet filename option to take the current opened excel file (the file with the button and data)

Let me know if my question is not clear.

Thanks,
Astha

[Kelly again]

I only work in Excel and Word (and one time in AutoCAD), so I have never ever used - or even heard of - TransferSpreadsheet.

However, I ran a google search and got many hits. But i'm not the best person to evaluate which hits are the really good ones since obviously I don't use TransferSpreadsheet.

Does this site help:

http://forums.aspfree.com/archive/t-29599

A possibly relevant web page (http://forums.aspfree.com/archive/t-29599)

Otherwise, assuming TransferSpreadsheet is a macro written in VBA, then it seems like you should just be able to insert "ActiveWorkbook.FullName" into the macro in some key places and get the results you are looking for.

I apologize profusely if my answer is totally unhelpful!!!!

[astharaj]

Hi Kelly,

Thank you so much for your help on my all questions posted on the board. The ActiveWorkbook.FullName worked fine for me and that was what I was looking for all the time.

Thanks again,
Astha