Search results

sorry one more question, if i had 2 queries that i wanted to export out to two tabs, i know i can do 2 transferspreadasheet commans however how would i format the second tab? reason why i am asking is because until now i was trying to learn how to format the excel, but i have more complex...

nevermind, i figured it out...i had to reference the Microsoft Excel under tools> reference menu... wow i am getting good at this...lol... again thank you sooo much Mr.B!!! your help much appreciated!!!

wow you're genius!!! thank you.... ok so i i tried copying ur modifed code and first i get a compile error "sub or function not defined" then i click ok and it highlights "Set xlRange = Range("A2", "L18")" i see that xlsheet is not there so i put this in "xlSheet.Range" which gets rid of the...

ok so i think i may know this one... on office 2007 i get this warning up at the top of navigation bar that says "Security Warning" certain content in the database has been disabled" then a button that says "Option" - when i click on it it bring another window and it has the follwing 2 options...

i just downloaded office 2007 do you think it has anything to do with that? the code looks right and the transferspreadsheet command has no error (at least from what i see) so not sure what else it can be??

sure here you go... i removed the extra code...since it wasnt working.. do i really need to call a module when we want to format? cant i just call the spreadsheet under the command button? thank you very much for your help on this one... its been crazy i know and i am being a pain at this point...

sorry didnt read your post earlier... but i went back to the following and it doesnt import the query data into excel like it did before.. Option Compare Database Function FN() As String FN = "C:\Workspace\SCF DB\trial\test" End Function Function SN() As String SN = "testsheet" End Function...

i went back to my basic code and still doesnt generate the spreadsheet...there has to be something wrong here..please help...it seems like i am going backwards instead of the other way around...

Hello Mr.B thank you for your response. I see your point on running with it slow... i did copy your modified code and replaced mine with it but when i click the button, no spreadsheet is generated and nothing happens...am i doing something wrong?

how are u exporting to excel? and how are you calling this code to export to excel?

ok so this is what i have so far, there are no errors but it does not format the spreadsheet either...whats wrong here???? i have created a module for formatting and called it in the comand button code... am i doing something wrong here? my module Option Compare Database Public Sub...

Hello Mr.B, one quick question when you say "On thing you will certainly have to do is set a reference to Excel from your VBA cdoe window. " can you please advise as to what you mean? Again i am very new at this and dont know much about VBA, learning as i go though...

Thank you Mr. B! I will go ahead and work on this and get back to you if I have any question... I really appreciate ur assistance!!!

can someone please assist with my question??? i am very new to this and hope anyone can assist with my issue

hello i am running into similar issue but when i use ur code it give me an error stating "9-subscript out of range".. what is this for?? my form has one button only and here is what i am doing in the onclick function and then created a module to incude your code that u have posted above ghudson...

Hello, I am new to VBA and I have simple form with a button, which i have used to export out a query to excel spreadsheet. It works perfectly however when i open the spreadsheet it is not formatted correctly. my question is, is there a way to format the excel spreadsheet? I've seen threads on...